MySQL Forums
Forum List  »  General

Advanced Search
New Topic

CPU usage, need some help.
Posted by: Tristan Foureur
Date: April 30, 2009 04:00PM

Hi,

I'm having a lot of troubles. Let me explain :

I made a facebook application using PHP/MySQL which allows user to know who from their friends removed them.

It's quite simple, it just records every friendship that a user has, and the next time he comes on the application, it just compares the friends in the DB with the friends he has.

But that's making some problems, because, the users usually have like 200 friends, and right now I only have like 7000 registered users but that's like 1,400,000 entries in my database, and even if I'm on a dedicated server, I'm having problems like timeouts...

I'd like to know how to optimize the mysql default configuration, or even how to optimize my queries...

And by the way, how can I know which queries are taking most time to execute ? :\

Thanks,

Tristan

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
CPU usage, need some help.
Tristan Foureur
April 30, 2009 04:00PM
Re: CPU usage, need some help.
Vince Gatto
April 30, 2009 08:42PM
Re: CPU usage, need some help.
Tristan Foureur
May 02, 2009 03:29PM
Re: CPU usage, need some help.
Vince Gatto
May 02, 2009 09:26PM
Re: CPU usage, need some help.
Michael Priest
May 13, 2009 02:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.