Duh.. udah sore di telp pula dari client.. katanya a** monitoringnya gajalan, selidik punya selidik ternyata mysql keluarin error “Got error 127 from storage engine” gw pikir cuma tablenya aja yang rusak, so tinggal repair table aja. Tapi setelah dijalanin lagi applikasinya masih tetap mysqlnya keluarin error “Got error 127 from storage engine” dan akhirnya mendapatkan jawabannya kalo mysql default rowsnya terbatas. So harus ditambahin.. Caranya sbb:
[henry@gateway ~]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 300833 to server version: 4.1.7
Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the buffer.
mysql> use bank****_a**
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> ALTER TABLE pinglog MAX_ROWS=1000000000 AVG_ROW_LENGTH=15000;
Query OK, 2672 rows affected (0.04 sec)
Records: 2672 Duplicates: 0 Warnings: 0
Great writing, been waiting for something like that!