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/my***********...ie.nctu.edu.tw
