…storage engines It works with MyISAM and Innodb and BDB, It also should work with Solid, PrimeXT and Falcon storage engines…to do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL…could have accomulated – especially if you use slave_skip_errors…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
…MySQL Shutdown is unexpected and there could be various inconsistences. And this is not only problem as we’ll see. MySQL…connections…storage engines it can be done by issuing large index scan queries. Full table scan queries allow to preload table data ether in storage engine…
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
…to the mysql error…to connect to their master and collect the output so we could confirm if Innodb really did have all the indexes or not…storage/innodb_plugin/dict/dict0load.c: line 226, and again in: storage…
Comment: Add an option to Fail on Innodb Initialize failure, Please ?
October 18, 2007 By 9 Comments
…not even start accepting connections until storage engines are initialized which is better. Accepting them but refusing queries to…to check. In your case I guess you need to check MySQL Error logs as well to see if you need to…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…not the main performance problem, also benefit from persistent connections…to Innodb storage engine or using innodb_file_per_table option in particular. 4. Not…Not using Join. This is typical error. On other hand in MySQL…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…in the error log after a crash: “It is possible that mysqld could use up to key_buffer…)*max_connections“. This was never true — not even when ISAM and friends were the only storage engines, …); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) …
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
…mysql> optimize table test; +———–+———-+———-+———————————-+ | Table | Op | Msg_type | Msg_text | +———–+———-+———-+———————————-+ | test.test | optimize | error | Got error -1 from storage engine…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…storage-engine‘ ‘–with-federated-storage-engine‘ ‘–without-bench’ ‘–with-zlib-dir=bundled’ ‘–with-big-tables’ ‘–enable-assembler’ ‘–enable-local-infile’ ‘–with-mysqld-user=mysql…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 4 Comments
… MySQL to report some more reasonable error message, something like Storage Engine could not open table or something like it. So what we can do is to… 1 row affected (0.00 sec) mysql> select * from test_innodb; ERROR 2013 (HY000): Lost connection to MySQL server during query Recovering CREATE TABLE …
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
…to MySQL database directory. This way accesses to non-checked tables fail with table does not exist error rather than wait forever. Hidden corruptions. If could be bad memory OS or MySQL bugs but corruption may happen and go for long unnoticed with MyISAM storage engine…
