Re: MySQL hangs each relative poor time

2005-12-15 Thread Johan
Roberto Rodriguez Garrido wrote: MySQL hangs every 30 minutes, it start to make a big process and when I make a show variables I get that values: I don't use Linux myself but I read a post on the Postgres list a while back about the Linux Out-of-memory Process Killer. This needs to be

MySQL hangs each relative poor time

2005-12-12 Thread Roberto Rodriguez Garrido
MySQL hangs every 30 minutes, it start to make a big process and when I make a show variables I get that values: +-+-+ | Variable_name | Value |

Re: MySQL hangs each relative poor time

2005-12-12 Thread Danny Stolle
Well Roberto, it could be anything... analyzing your my.cnf file and variables would be looking through spagetti (i like spagetti ... but not in this flavour). the time your database hangs, are the intervals random minutes/seconds/hours? or is there a constant interval like precise on 30

Re: MySQL hangs each relative poor time

2005-12-12 Thread Gleb Paharenko
Hello. What system load do 'top' and 'free' show? Use 'SHOW PROCESSLIST' to determine what queries are running on the server if you're able to connect to it. Check that mysqld isn't swapping. Roberto Rodriguez Garrido wrote: MySQL hangs every 30 minutes, it start to make a big