Tweet
Whenever someone tries to post a new thread of topic it takes ages to post. I'm assuming this could be a performance issue with the database so I started to investigate.
Running MySQLTuner i get the following.
Inside my.cnf I have
Any suggestions on what I can do? Keep in mind that I've made changes recently to my.cnf that might not be reflected inside MySQLTuner.
The memory usage appears to be very high but I can't figure out what's taking up so much memory.
Running MySQLTuner i get the following.
Code:
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.70-cll
[!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 1009M (Tables: 435)
[--] Data in InnoDB tables: 2G (Tables: 96)
[--] Data in MEMORY tables: 0B (Tables: 1)
[!!] Total fragmented tables: 100
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 4m 55s (13K q [45.569 qps], 410 conn, TX: 271M, RX: 13M)
[--] Reads / Writes: 86% / 14%
[--] Total buffers: 2.5G global + 2.8M per thread (151 max threads)
[!!] Allocating > 2GB RAM on 32-bit systems can cause system instability
[!!] Maximum possible memory usage: 2.9G (50% of installed RAM)
[OK] Slow queries: 0% (2/13K)
[OK] Highest usage of available connections: 3% (6/151)
[OK] Key buffer size / total MyISAM indexes: 512.0M/334.9M
[OK] Key buffer hit rate: 98.4% (639K cached / 10K reads)
[OK] Query cache efficiency: 73.2% (8K cached / 11K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 175 sorts)
[OK] Temporary tables created on disk: 5% (6 on disk / 117 total)
[OK] Thread cache hit rate: 98% (6 created / 410 connections)
[OK] Table cache hit rate: 87% (128 open / 147 opened)
[OK] Open file limit used: 11% (120/1K)
[OK] Table locks acquired immediately: 99% (4K immediate / 4K locks)
[!!] InnoDB data size / buffer pool: 2.6G/2.0G
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries
Variables to adjust:
innodb_buffer_pool_size (>= 2G)
Code:
[mysqld] query_cache_size=16M tmp_table_size=16M max_heap_table_size=16M innodb_buffer_pool_size=2G table_cache=128 thread_cache_size = 4 query_cache_limit=1M key_buffer_size=512M join_buffer_size = 262144
The memory usage appears to be very high but I can't figure out what's taking up so much memory.
Comment