Hi List Been trying to help out with this problem on a SunOS5.8 box running 3.23.56
It experiences periodic lockups of mysql. It does not seem that this server has a my.cnf file for mysql, and I'm not sure if that matters (what are the defaults mysql use when it cannot find the .cnf file?) Anyway, I have asked for any help in making a my.cnf file in other threads, but it seems everyone is on 4.x already, or they cannot help in that regard. Below is some feedback from the server 1st : top last pid: 11217; load averages: 0.00, 0.00, 0.00 07:54:43 17 processes: 16 sleeping, 1 on cpu CPU states: 85.2% idle, 10.2% user, 4.4% kernel, 0.2% iowait, 0.0% swap Memory: 2048M real, 667M free, 2065M swap in use, 3403M swap free PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND 22435 xxxxxxxx 21 58 0 89M 32M sleep 2:43 0.58% caspeng 11210 xxxxxxxx 1 58 0 2896K 1664K cpu 0:00 0.54% top 9961 xxxxxxxx 31 58 0 15M 6600K sleep 0:13 0.27% mysqld 11139 xxxxxxxx 1 58 0 5608K 1752K sleep 0:00 0.01% sshd 18642 xxxxxxxx 5 58 0 2312K 936K sleep 0:20 0.00% caspd 491 xxxxxxxx 5 58 0 3768K 2016K sleep 0:10 0.00% httpd 9948 xxxxxxxx 1 40 0 1048K 760K sleep 0:00 0.00% safe_mysqld 11141 xxxxxxxx 1 48 0 2384K 1904K sleep 0:00 0.00% tcsh 9228 xxxxxxxx 3 58 0 4000K 2576K sleep 0:00 0.00% httpd 10999 xxxxxxxx 4 58 0 3920K 2472K sleep 0:00 0.00% httpd 10510 xxxxxxxx 3 58 0 3888K 2448K sleep 0:00 0.00% httpd 11001 xxxxxxxx 4 58 0 3888K 2440K sleep 0:00 0.00% httpd 11081 xxxxxxxx 4 58 0 3880K 2432K sleep 0:00 0.00% httpd 11075 xxxxxxxx 4 58 0 3872K 2424K sleep 0:00 0.00% httpd 11076 xxxxxxxx 4 58 0 3872K 2408K sleep 0:00 0.00% httpd and 2nd is xxxxxxxx.xxxxxxxx.xxxxxxxx% mysqladmin -u root -p -v pro Enter password: +-----+--------+-----------+--------------------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+--------+-----------+--------------------+---------+------+-------+-----------------------+ | 187 | root | localhost | Users | Sleep | 278 | | | | 190 | root | localhost | Boards | Sleep | 278 | | | | 191 | root | localhost | Users | Sleep | 278 | | | | 192 | root | localhost | Boards | Sleep | 278 | | | | 193 | root | localhost | Boards | Sleep | 278 | | | | 194 | root | localhost | Boards | Sleep | 278 | | | | 226 | root | localhost | Boards | Sleep | 278 | | | | 227 | root | localhost | Users | Sleep | 123 | | | | 228 | root | localhost | Boards | Sleep | 123 | | | | 229 | root | localhost | Boards | Sleep | 123 | | | | 230 | root | localhost | Users | Sleep | 11 | | | | 231 | root | localhost | Boards | Sleep | 123 | | | | 232 | root | localhost | Boards | Sleep | 123 | | | | 233 | root | localhost | Users | Sleep | 271 | | | | 237 | user1 | localhost | Philosophies | Sleep | 113 | | | | 238 | user1 | localhost | PhilosophiesCustom | Sleep | 133 | | | | 239 | user1 | localhost | Countries | Sleep | 133 | | | | 240 | root | localhost | Debatabase | Sleep | 123 | | | | 241 | root | localhost | Debatabase | Sleep | 123 | | | | 242 | root | localhost | Debatabase | Sleep | 123 | | | | 243 | root | localhost | Debatabase | Sleep | 123 | | | | 244 | root | localhost | Debatabase | Sleep | 14 | | | | 245 | root | localhost | Debatabase | Sleep | 14 | | | | 246 | root | localhost | Debatabase | Sleep | 14 | | | | 248 | root | localhost | | Query | 0 | | show full processlist | +-----+--------+-----------+--------------------+---------+------+-------+-----------------------+ xxxxxxxx.xxxxxxxx.xxxxxxxx% and this is the error reported by the browser on such lockups. ADODB.Recordset.1 error '80004005' SQLState: S1000 Native Error Code: 2013 [TCX][MyODBC]Lost connection to MySQL server during query /main/home.asp, line 48 PS, the output of both top and the entire process list are as the system is now, after a restart of mysql, ie, unfortunately it does probably not reflect anything that is prevalent during a lockup. Any ideas. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
