… pwd’ at line 1 It would be much better if MySQL would give error give exact position of error (with complex auto generated… – storage engine which is specified in .frm file is not available and give user friendly error message. Another great set of errors is Got Error XYZ from storage engine…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… | Op | Msg_type | Msg_text | +———–+———-+———-+———————————-+ | test.test | optimize | error | Got error -1 from storage engine | | test.test | optimize | status | Operation failed | +———–+———-+———-+———————————-+ 2 rows…
Post: Innodb row size limitation
April 7, 2011 By 11 Comments
… ocassionally get this error: ERROR 1030 (HY000) at line 1: Got error 139 from storage engine What’s going on? Innodb gives you this error when it can’t… be chosen for off page storage. This means it is possible that you hit this error after converting from a native language character…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…ERROR 1031 (HY000): Table storage engine for ‘test2′ doesn’t have this option Strange error…1 Changed: 1 Warnings: 0 Session2: mysql> select * from test2 where id=2; +—-+———-+ | id | names | +—-+———-+ | 2 | SolidDB1 | +—-+———-+ 1…under sysbench and got next (1 client): mysql> …
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
… the 4.1 manual), and is from a time when… innodb_table_monitor (a INT) ENGINE=INNODB; This, primitively, tells… dictionary to the mysql error log, which looks something like this… to explain it, I got an email explaining that…1 in: storage/innodb_plugin/dict/dict0load.c: line 226, and again in: storage…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… the one in the error log after a crash:…and friends were the only storage engines, which was before most…temporary tables: select * from ( select * from ( select 1 as a ) as b…1); +—————–+ | get_lock(@a, 1) | +—————–+ | 1 | +—————–+ 1 row in set (3.63 sec) Now I’ve got…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…logs_at_trx_commit=1 and only using Innodb… soft crash. Unless you got into one of these…caused by user or application error or security breach. What…reclone slave from the master, another slave or restore from backup…. partial replication, replication to different storage engine, add some tables beyond…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
…larger. Results I got from my envinronment are:…from table (Unix Socket) 7400 Note: The test measures peak performance so I did not do much of error… (ie on shared storage). Query Cache is…and other requirements: 1) for file cache …) default NULL, PRIMARY KEY (`k`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; …
