browser icon
You are using an insecure version of your web browser. Please update your browser!
Using an outdated browser makes your computer unsafe. For a safer, faster, more enjoyable user experience, please update your browser today or try a newer browser.

mysql : Got error 127 from storage engine

Posted by on October 24, 2008

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



3 Responses to mysql : Got error 127 from storage engine

  1. affordable medical insurance

    Great writing, been waiting for something like that!

Leave a Reply

Your email address will not be published. Required fields are marked *

:)) :) :D (LOL) :-P (woot) ;-) :-o X-( ;-( :-& (angry) (annoyed) (bye) B-) (cozy) (sick) (: (goodluck) (griltongue) (mmm) (hungry) (music) (tears) (tongue) (unsure) (highfive) (dance) (doh) (brokenheart) (drinking) (girlkiss) (rofl) (money) (rock) (nottalking) (party) (sleeping) (thinking) (bringit) (worship) (applause) 8-) (gym) (heart) (devil) (lmao) (banana_cool) (banana_rock) (evil_grin) (headspin) (heart_beat) (ninja) (haha) (evilsmirk) (bigeyes) (funkydance) (idiot) (lonely) (scenic) (hassle) (panic) (okok) (yahoo) (blush) (fish_hit) (muhaha) (muscle) (taser) (beer) (coffee) (banana_ninja) (goal) (fireworks) (smileydance) (dance_bzz) (rusian)