Tag Info

New answers tagged

0

Sounds like MISSION: IMPOSSIBLE. Just kidding. I just cringe when I see MyISAM. I can tell you what the MySQL Documentation says. Please note what it says: You are using a MyISAM table and the space required for the table exceeds what is permitted by the internal pointer size. MyISAM permits data and index files to grow up to 256TB by default, but this ...


0

This seems to be an age-old problem How To Repair MySQL Replication MySQL replication: "Houston, We've Got a Problem" ERROR Cannot find or open table? Some recommend skipping the error and continuing. Personally, you should handle stopping replication differently. Run STOP SLAVE;. This will freeze the IO Thread bytes ahead of the SQL ...


2

One of the biggest problems with MyISAM is the low write concurrency. In the most general case, a single write (update, delete or insert) to a single MyISAM table will block all other writes and reads. Multiple reads, however, can happen concurrently. You can force MyISAM to perform concurrent inserts at the end (not for updates and deletes), but it ...


1

These files are related to the new FULLTEXT index support in InnoDB (starting with MySQL 5.6). Removing them is not a good idea for sure. Unlike with MyISAM, where FULLTEXT indexes are stored in the tables .MYI file together with all other indexes fulltext indexes in InnoDB are implemented using several internal helper tables which show up as separate .idb ...


0

It is a brave soul indeed that still uses an all-MyISAM database. Why are writes being quietly discarded instead of being queued, as they would be for a regular table lock? Look at the error message again [20-Nov-2014 01:41:56 UTC] Wordpress database error The MySQL server is running with the --read-only option so it cannot execute this statement ...


0

This answer is kind of late, but it might help others. If you are afraid to mess something up on the MySQL server, you can change the default engine when creating a table from phpMyAdmin. The default select creator for MySQL engines is this function under StorageEngine.class.php in libraries folders (in phpMyAdmin 3.5.8.2): <?php /** * returns HTML code ...



Top 50 recent answers are included