Here is the info : my.cnf : [mysqld] performance_schema = off datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql symbolic-links=0 #bind-address 127.0.0.1 max_connections= 8 max_user_connections=30 wait_timeout=45 interactive_timeout=50 long_query_time=5 log-queries-not-using-indexes log-slow-queries=/var/log/log-slow-queries.log #log-bin=/var/log/log-binary.log innodb_use_native_aio = 0 default-storage-engine = innodb innodb_file_per_table = 1 innodb_use_sys_malloc = 0 innodb_buffer_pool_size = 600M innodb_log_file_size = 128M innodb_log_buffer_size = 4M innodb_lock_wait_timeout = 15 innodb_flush_method=O_DIRECT innodb_flush_log_at_trx_commit = 2 innodb_thread_concurrency = 5 innodb_buffer_pool_instances = 4 innodb_additional_mem_pool_size = 10M innodb_file_io_threads=4 max_heap_table_size = 16M tmp_table_size = 16M key_buffer_size= 64M query-cache-type = 1 query_cache_size = 4M thread_cache_size= 16384 query_cache_limit = 1M [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid SHOW ENGINE INNODB STATUS\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 150320 12:44:57 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 46 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 2771 1_second, 2497 sleeps, 244 10_second, 354 background, 330 flush srv_master_thread log flush and writes: 3274 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1769, signal count 1661 Mutex spin waits 480, rounds 6940, OS waits 176 RW-shared spins 6202, rounds 148612, OS waits 1292 RW-excl spins 0, rounds 1861, OS waits 62 Spin rounds per wait: 14.46 mutex, 23.96 RW-shared, 1861.00 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 93D5B4 Purge done for trx's n:o < 93D5B0 undo n:o < 0 History list length 1672 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started 0 lock struct(s), heap size 488, 0 row lock(s) MySQL thread id 933, OS thread handle 0x7f7d00484700, query id 93124 localhost root SHOW ENGINE INNODB STATUS -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 41684 OS file reads, 4767 OS file writes, 2296 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 179, seg size 181, 9 merges merged operations: insert 9, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 1245187, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 15311627281 Log flushed up to 15311627281 Last checkpoint at 15311627281 0 pending log writes, 0 pending chkp writes 1781 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 698968867; in additional pool allocated 10485760 Dictionary memory allocated 1202203 Buffer pool size 38399 Free buffers 0 Database pages 38398 Old database pages 14154 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 32677, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 68503, created 18, written 3250 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 38398, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 24868, id 140173939197696, state: waiting for server activity Number of rows inserted 123, updated 900, deleted 98, read 3786888 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.15 sec) ps -aux | grep mysql Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.8/FAQ root 14262 0.0 0.0 103248 860 pts/0 S+ 12:46 0:00 grep mysql root 24313 0.0 0.0 106196 72 ? S Mar19 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql mysql 24868 0.0 53.2 1963444 558592 ? Sl Mar19 0:28 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock free -m total used free shared buffers cached Mem: 1024 945 78 34 0 276 -/+ buffers/cache: 668 355 Swap: 512 221 290 mysqltuner >> MySQLTuner 1.2.0 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.5.40-log [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 0B (Tables: 5) [--] Data in InnoDB tables: 1G (Tables: 186) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [!!] Total fragmented tables: 11 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 17h 33m 34s (93K q [1.473 qps], 939 conn, TX: 744M, RX: 10M) [--] Reads / Writes: 66% / 34% [--] Total buffers: 698.0M global + 2.8M per thread (8 max threads) [OK] Maximum possible memory usage: 720.0M (70% of installed RAM) [OK] Slow queries: 1% (1K/93K) [OK] Highest usage of available connections: 62% (5/8) [OK] Key buffer size / total MyISAM indexes: 64.0M/103.0K [OK] Key buffer hit rate: 100.0% (30 cached / 0 reads) [OK] Query cache efficiency: 94.5% (39K cached / 42K selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 1% (3 temp sorts / 253 sorts) [!!] Temporary tables created on disk: 32% (424 on disk / 1K total) [OK] Thread cache hit rate: 99% (5 created / 939 connections) [OK] Table cache hit rate: 95% (400 open / 420 opened) [OK] Open file limit used: 3% (37/1K) [OK] Table locks acquired immediately: 99% (3K immediate / 3K locks) [!!] Connections aborted: 6% [!!] InnoDB data size / buffer pool: 1.1G/600.0M -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate When making adjustments, make tmp_table_size/max_heap_table_size equal Reduce your SELECT DISTINCT queries without LIMIT clauses Your applications are not closing MySQL connections properly Variables to adjust: tmp_table_size (> 16M) max_heap_table_size (> 16M) innodb_buffer_pool_size (>= 1G) tuning-primer.sh -- MYSQL PERFORMANCE TUNING PRIMER -- - By: Matthew Montgomery - MySQL Version 5.5.40-log x86_64 Uptime = 0 days 17 hrs 48 min 11 sec Avg. qps = 1 Total Questions = 94140 Threads Connected = 1 Warning: Server has not been running for at least 48hrs. It may not be safe to use these recommendations To find out more information on how each of these runtime variables effects performance visit: http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html Visit http://www.mysql.com/products/enterprise/advisors.html for info about MySQL's Enterprise Monitoring and Advisory Service SLOW QUERIES The slow query log is enabled. Current long_query_time = 5.000000 sec. You have 1845 out of 94161 that take longer than 5.000000 sec. to complete Your long_query_time seems to be fine BINARY UPDATE LOG The binary update log is NOT enabled. You will not be able to do point in time recovery See http://dev.mysql.com/doc/refman/5.5/en/point-in-time-recovery.html WORKER THREADS Current thread_cache_size = 16384 Current threads_cached = 4 Current threads_per_sec = 0 Historic threads_per_sec = 0 Your thread_cache_size is fine MAX CONNECTIONS Current max_connections = 8 Current threads_connected = 1 Historic max_used_connections = 5 The number of used connections is 62% of the configured maximum. Your max_connections variable seems to be fine. INNODB STATUS Current InnoDB index space = 17 M Current InnoDB data space = 1.06 G Current InnoDB buffer pool free = 0 % Current innodb_buffer_pool_size = 600 M Depending on how much space your innodb indexes take up it may be safe to increase this value to up to 2 / 3 of total system memory MEMORY USAGE Max Memory Ever Allocated : 695 M Configured Max Per-thread Buffers : 22 M Configured Max Global Buffers : 682 M Configured Max Memory Limit : 704 M Physical Memory : 1.00 G Max memory limit seem to be within acceptable norms KEY BUFFER No key reads?! Seriously look into using some indexes Current MyISAM index space = 112 K Current key_buffer_size = 64 M Key cache miss rate is 1 : 0 Key buffer free ratio = 81 % Your key_buffer_size seems to be fine QUERY CACHE Query cache is enabled Current query_cache_size = 4 M Current query_cache_used = 322 K Current query_cache_limit = 1 M Current Query cache Memory fill ratio = 7.86 % Current query_cache_min_res_unit = 4 K Your query_cache_size seems to be too high. Perhaps you can use these resources elsewhere MySQL won't cache query results that are larger than query_cache_limit in size SORT OPERATIONS Current sort_buffer_size = 2 M Current read_rnd_buffer_size = 256 K Sort buffer seems to be fine JOINS Current join_buffer_size = 132.00 K You have had 5 queries where a join could not use an index properly You should enable "log-queries-not-using-indexes" Then look for non indexed joins in the slow query log. If you are unable to optimize your queries you may want to increase your join_buffer_size to accommodate larger joins in one pass. Note! This script will still suggest raising the join_buffer_size when ANY joins not using indexes are found. OPEN FILES LIMIT Current open_files_limit = 1024 files The open_files_limit should typically be set to at least 2x-3x that of table_cache if you have heavy MyISAM usage. Your open_files_limit value seems to be fine TABLE CACHE Current table_open_cache = 400 tables Current table_definition_cache = 400 tables You have a total of 232 tables You have 400 open tables. Current table_cache hit rate is 44% , while 100% of your table cache is in use You should probably increase your table_cache TEMP TABLES Current max_heap_table_size = 16 M Current tmp_table_size = 16 M Of 1685 temp tables, 23% were created on disk Created disk tmp tables ratio seems fine TABLE SCANS Current read_buffer_size = 128 K Current table scan ratio = 1412 : 1 read_buffer_size seems to be fine TABLE LOCKING Current Lock Wait ratio = 1 : 1249 You may benefit from selective use of InnoDB. If you have long running SELECT's against MyISAM tables and perform frequent updates consider setting 'low_priority_updates=1' If you have a high concurrency of inserts on Dynamic row-length tables consider setting 'concurrent_insert=ALWAYS'. THANKS IN ADVANCE!!!