Giovanni
31.05.2012, 17.30
Se l'avevi corretto con 512 probabilmente non ha letto bene perchè la sintassi non è totalmente corretta.
Metti
512M
Metti
512M
tmp_table_size= 6G
[mysqld] query_cache_limit = 1M query_cache_size = 100M innodb_buffer_pool_size=1G key_buffer_size =516M tmp_table_size= 6G read_buffer_size = 32M max_heap_table_size =512M thread_cache_size =12
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 4412 mysql 20 0 2133m 399m 4012 S 218.3 2.5 40:36.56 mysqld 5202 tomcat 20 0 4349m 119m 9.9m S 0.3 0.8 0:14.51 jsvc
-------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.0.95-community [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB +Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 1G (Tables: 691) [--] Data in InnoDB tables: 208K (Tables: 13) [!!] Total fragmented tables: 45 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 12s (2K q [229.500 qps], 32 conn, TX: 7M, RX: 515K) [--] Reads / Writes: 89% / 11% [--] Total buffers: 2.1G global + 34.6M per thread (100 max threads) [OK] Maximum possible memory usage: 5.5G (35% of installed RAM) [OK] Slow queries: 0% (0/2K) [OK] Highest usage of available connections: 9% (9/100) [OK] Key buffer size / total MyISAM indexes: 516.0M/453.7M [OK] Key buffer hit rate: 96.8% (2M cached / 80K reads) [OK] Query cache efficiency: 81.5% (2K cached / 2K selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 1% (1 temp sorts / 82 sorts) [!!] Joins performed without indexes: 47 [OK] Temporary tables created on disk: 6% (10 on disk / 150 total) [OK] Thread cache hit rate: 71% (9 created / 32 connections) [OK] Table cache hit rate: 92% (79 open / 85 opened) [OK] Open file limit used: 3% (145/4K) [OK] Table locks acquired immediately: 98% (855 immediate / 869 locks) [OK] InnoDB data size / buffer pool: 208.0K/1.0G