View All Products
Compute
Storage
Networking
Databases
Services
Developer Tools
Industries
Pricing
Community
Engage With Us
Community ▶ Questions ▶ Performance problems with mysql
Log in to Ask a Question

Performance problems with mysql

performance

Hi, added the Lamp stack (from stackscript) and everything working fine except Now I uploaded all my entries into my site which is a directory site with more than 100k listings and its running like a dog.

free -m

total used free shared buffers cached

Mem: 348 343 4 0 7 241

-/+ buffers/cache: 93 254

Swap: 255 0 255

Looks ok to me although 'top' shows mysql using anything between 10-30% of memory and similar amount of cpu at any one time.

Played around with the my.cnf settings but nothing affects this performance.

Mysqltuner reports that more ram is required but I don't understand this if their is a fair amount free?

5 Replies

Oh and it averages about 20k i/o on the disk with around 60k peak.

I use Binarycanary as a site monitor which is mailing me telling me the sites down about every hour.

Theres nobody on it really except for Googles robots et al.

Are there indexes on the tables?

Yes, the script provides caching which is turned on though.

@caleb2003:

Yes, the script provides caching which is turned on though.
FYI caching ≠ table index in SQL.

Sorry, did not mean to indicate the same, yes there are indexes on the tables.

thanks

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Log in to Reply
Community Code of Conduct