MySQL Forums
Forum List  »  General

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

Options: ReplyQuote


Subject
Written By
Posted
CPU usage, need some help.
April 30, 2009 04:00PM


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.