Re: all SQL query extremly slow
Thank you for your advice, I add those two lines to my conf file:
innodb_buffer_pool_size = 700M
key_buffer_size = 10M
And i restart mysql server but it still the same issue. Here is my conf file: Anything strange in it???
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
innodb_use_native_aio = 0
innodb_buffer_pool_size = 700M
key_buffer_size = 10M
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
query_cache_limit = 1M
query_cache_size = 16M
expire_logs_days = 10
max_binlog_size = 100M
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql] #no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M
!includedir /etc/mysql/conf.d/
[isamchk]
key_buffer = 16M
!includedir /etc/mysql/conf.d/
Subject
Written By
Posted
December 01, 2014 08:25PM
December 01, 2014 09:02PM
December 01, 2014 09:44PM
December 01, 2014 10:36PM
December 01, 2014 11:53PM
Re: all SQL query extremly slow
December 01, 2014 11:59PM
December 02, 2014 02:34AM
December 02, 2014 10:12AM
December 02, 2014 04:44PM
December 02, 2014 05:55PM
December 03, 2014 10:48AM
December 03, 2014 12:06PM
December 03, 2014 01:44PM
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.