Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: High load - queries take long time

Started 1 month ago by Prova Test
Hi, I have a problem with my mysql database, I dont know if it's a configuration issue or the server is not able to handle my database, please I need your advice. I have 8 databases, the biggest one is about 5Gb (with 3 big tables about 2Gb and 16 millions records) here's the info: sqldata1:/ # uname -a Linux sqldata1 2.6.27.7-9-default #1 SMP 2008-12-04 18:10:04 +0100 x86_64 ...
Site: MySQL AB - MySQL Forums  MySQL AB - MySQL Forums - site profile
Forum: Performance  Performance - forum profile
Total authors: 2 authors
Total thread posts: 3 posts
Thread activity: no new posts during last week
Domain info for: mysql.com

Other posts in this thread:

Prova Test replied 1 month ago
>>>>> CONTINUATION >>>>> mysql> show processlist; +----------+-----------------+------------------- --------+----------------------+---------+------+- ----------------------------+--------------------- -------------------------------------------------- -------------------------------+ | Id | User | Host | db | Command | Time | State...

Rick James replied 1 month ago
This is possibly excessive: innodb_log_file_size = 1500M and may cause hiccups when it is flushing it. To assist in analyzing slow SELECTs, please provide * SHOW CREATE TABLE tbl\G -- engine, indexes -- works better than DESC * SHOW TABLE STATUS LIKE 'tbl'\G -- sizes * EXPLAIN SELECT ...\G -- clues of inefficiencies * SHOW VARIABLES LIKE '%buffer%'; -- cache size * SHOW ...

 

Top contributing authors

Name
Posts
Prova Test
2
user's latest post:
Re: High load - queries take...
Published (2009-11-05 13:26:00)
>>>>> CONTINUATION >>>>> mysql> show processlist; +----------+-----------------+---------------------------+----------------------+---------+------+-----------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info |...
Rick James
1
user's latest post:
Re: High load - queries take...
Published (2009-11-06 21:04:00)
This is possibly excessive: innodb_log_file_size = 1500M and may cause hiccups when it is flushing it. To assist in analyzing slow SELECTs, please provide * SHOW CREATE TABLE tbl\G -- engine, indexes -- works better than DESC * SHOW TABLE STATUS LIKE 'tbl'\G -- sizes * EXPLAIN SELECT ...\G -- clues of inefficiencies * SHOW VARIABLES LIKE '%buffer%'; -- cache size * SHOW VARIABLES LIKE 'innodb%'; -- various...

Related threads on "MySQL AB - MySQL Forums":

Related threads on other sites:

Thread profile page for "High load - queries take long time" on http://www.mysql.com. This report page is a snippet summary view from a single thread "High load - queries take long time", located on the Message Board at http://www.mysql.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity