Nik schrieb: > [...] > > The server never uses all the Memory, at least 10% always free, and > there's loads of free disk space. Just the CPU max's out, causing > problems. > > I've posted below the output of STATUS and SHOW GLOBAL STATUS. Any > and all comments would be much appreciated as to how we can get > performance back on track. > > Thanks. Here's the output; > > [...] > | Created_tmp_disk_tables | 159267 | > | Created_tmp_files | 4085 | > | Created_tmp_tables | 262915 |
try raising your tmp_table_size > | Handler_read_rnd | 270199887 | > | Handler_read_rnd_next | 3334259467 | enable your slow query logging and check your indizes > | Open_tables | 511 | > | Opened_tables | 7045 | try raising your table_cache > | Qcache_free_blocks | 1533 | > | Qcache_free_memory | 3624048 | > | Qcache_hits | 1198322 | > | Qcache_inserts | 1446965 | > | Qcache_lowmem_prunes | 22914 | > | Qcache_not_cached | 262103 | > | Qcache_queries_in_cache | 2117 | > | Qcache_total_blocks | 9264 | possible, raising qcache size could help too > | Sort_merge_passes | 2040 | try raising the sort_buffer > | Threads_cached | 44 | > | Threads_connected | 12 | > | Threads_created | 78 | > | Threads_running | 3 | possible this too -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
