MySQL Forums :: Performance :: small DB, big problems


Advanced Search

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


Subject Views Written By Posted
small DB, big problems 2983 SweeT EviL 09/08/2009 12:57PM
Re: small DB, big problems 1441 Rick James 09/09/2009 08:26PM
Re: small DB, big problems 1437 SweeT EviL 09/10/2009 10:39AM
Re: small DB, big problems 1494 Rick James 09/10/2009 07:15PM
Re: small DB, big problems 1500 SweeT EviL 09/11/2009 08:52AM
Re: small DB, big problems 1436 Rick James 09/11/2009 09:53AM
Re: small DB, big problems 1490 SweeT EviL 09/11/2009 10:16AM
Re: small DB, big problems 1655 Rick James 09/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.