MySQL Forums
Forum List  »  Performance

small DB, big problems
Posted by: SweeT EviL
Date: September 08, 2009 12:57PM

I have DB less then 50m that makes my a lot of problems.
I have all the right indexes, PK, FK, queries etc..

But still I get lot of big runtime variable values:

Slow_queries 1,914
Innodb_buffer_pool_reads 13 M
Innodb_row_lock_time_avg 44
Innodb_row_lock_time_max 1,955
Innodb_row_lock_waits 627
Handler_read_rnd 142 M
Handler_read_rnd_next 733 M
Qcache_lowmem_prunes 2,521 k
Created_tmp_disk_tables 4,217 k
Delayed_errors 5
Select_range_check 174
Sort_merge_passes 3,795
Opened_tables 1,270 k
Table_locks_waited 13 k

And I think thats the reason it makes my web pages load so slowly.(so thats my problem)

Is it possible according to this values that my web pages take so much time to load(some times minutes..)..?
If so what can I say to the hosting administrators so it'll be fixed?

Options: ReplyQuote

Written By
small DB, big problems
September 08, 2009 12:57PM
September 09, 2009 08:26PM
September 10, 2009 10:39AM
September 10, 2009 07:15PM
September 11, 2009 08:52AM
September 11, 2009 09:53AM
September 11, 2009 10:16AM
September 11, 2009 06:20PM

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.