Hi,
I have a HP rp3410 with 4Gb RAM running HPUX 11.11. This is running,
Version: '5.0.26-pro-log' socket: '/tmp/mysql.sock' port: 3306 MySQL
Pro (Commercial)
When this machine is put under load (i.e, a lot of database activity),
the clients are receiving "Error 12" errors and the MySQL log has a lot
of errors as follows,
070327 8:24:20 [ERROR] mysql_ha_read: Got error 12 when reading table
'XLDEFN_IN'
070327 8:54:51 [ERROR] mysql_ha_read: Got error 12 when reading table
'XLDEFN_IN'
070327 8:55:19 [ERROR] mysql_ha_read: Got error 12 when reading table
'XLDEFN_IN'
In addition, I see at MySQL startup (in the mysql err log), a number of,
/usr/local/mysql/bin/mysqld: Out of memory (Needed 368389120 bytes)
/usr/local/mysql/bin/mysqld: Out of memory (Needed 276289536 bytes)
My /etc/my.cnf is set as,
[client]
port=3306
socket=/tmp/mysql.sock
[mysqld]
port=3306
socket=/tmp/mysql.sock
set-variable = key_buffer_size=400M
set-variable = max_allowed_packet=15M
default-table-type=InnoDB
datadir=/data/mysql
The machine is indicating it is under any ram pressure, which makes me
think it may be kernel tuning (of course, I may be wrong). Are there any
recommendations for HPUX kernel tuning with MySQL?
--
Regards,
Ian Collins
Systems Manager
KIWIPLAN Group
Tel: +64 (0)9 2727622
Mob: +64 (0)21 761144
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
