From: Sebastian Mendel (listssebastianmendel.de)
Date: Wed Jan 09 2008 - 03:58:16 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]