List:General Discussion« Previous MessageNext Message »
From:Sebastian Mendel Date:January 9 2008 9:58am
Subject:Re: MySql CPU 100%
View as plain text  
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
Thread
MySql CPU 100%Nik8 Jan
  • Re: MySql CPU 100%Barry Newton8 Jan
  • Re: MySql CPU 100%Sebastian Mendel9 Jan