June 18, 2013

Post: MySQL Upgrade Webinar Questions Followup

June 28, 2012 By 7 Comments

… really need all tables changed to Innodb and character set set to utf8? No. MySQL 5.5 continues to support MyISAM tables, so you can… be depreciated in future MySQL versions also MyISAM tables are essentially at the state they were in MySQL 4.1 while Innodb storage engine got… Innodb in MySQL 5.5, meaning you might need to set storage_engine=MYISAM if you’re relaying on tables to be created as MyISAM…

Filed Under: Insight for DBAs, MySQL

Post: Innodb Table Locks

July 31, 2012 By 4 Comments

… MyISAM table locks. Let me start with some examples. First lets run SELECT Query: —TRANSACTION 12303, ACTIVE 26 sec mysql tables…Innodb “converts” table lock to “no lock” hence eliminating conflicts on MySQL level table locks for most queries. Summary: MySQL Table level locks and Innodb Table…

Filed Under: Insight for DBAs, MySQL

Post: Is there room for more MySQL IO Optimization?

January 3, 2013 By 11 Comments

…, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which …Innodb_data_reads | 54561 | | Innodb_data_reads | 38277 | | Innodb_data_reads | 25895 | | Innodb_data_reads | 31363 | | Innodb_data_reads | 170816 | | Innodb_data_reads | 207432 | | Innodb…

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Post: Migrating several single standalone MySQL server to one Percona XtraDB Cluster... MariaDB to the rescue !

December 18, 2012 By 3 Comments

…I had to migrate some independent MySQL servers (some standard MySQL masters, and some just standalone) … there was one major issue, the tables where MyISAM and this is not really recommended with … will be the dedicated slave convert the table in InnoDB configure and start the replication finally …

Filed Under: MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… mysql mysql 14766080 Feb 20 16:11 seo_test_myisam.MYI I also observed that if I simply load the data into an InnoDB table… happens: mysql> set global innodb_ft_aux_table=’test/dir_test_innodb‘; mysql> set global innodb_optimize_fulltext_only=1; mysql> select * from information_schema.innodb_ft_config…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: ANALYZE: MyISAM vs Innodb

September 3, 2008 By 9 Comments

… the table) It is worth to note if you do ALTER TABLE Innodb, same as MyISAM will internally run analyze as soon as table is rebuilt and values will be more sensible: mysql> alter table antest_innodb type=innodb…

Filed Under: Insight for DBAs Tagged With: ,

Post: Recovering CREATE TABLE statement from .frm file

December 17, 2008 By 5 Comments

…: mysql> show tables; +—————-+ | Tables_in_test | +—————-+ | queue | | test_innodb | +—————-+ 2 rows in set (0.00 sec) mysql> show create table test_innodb; ERROR 1146 (42S02): Table ‘test.test_innodb… sec) mysql> select * from test_innodb; ERROR 2013 (HY000): Lost connection to MySQL server during query Recovering CREATE TABLE from .frm file for MyISAM Table We…

Filed Under: Insight for DBAs Tagged With: , ,

Post: MySQL Server Variables - SQL layer or Storage Engine specific.

June 8, 2006 By 14 Comments

… have Innodb tables in your system does it mean MyISAM variables are not important ? Not really. You still have some tables in MyISAM format in “mysql… variable which affects all tables but it was designed for MyISAM tables. It makes little sense to use it with Innodb tables for example. Note…

Filed Under: Insight for DBAs Tagged With: ,

Post: A recovery trivia or how to recover from a lost ibdata1 file

June 3, 2011 By 8 Comments

…/tables# perl -p -i -e ‘s/ENGINE=InnoDB/ENGINE=MyISAM/g’ schema.sql root@domU:/mnt/tables# cat schema.sql | mysql -u root test The MyISAM table recording the space ids of the tables mysql…

Filed Under: MySQL

Post: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

…innodb_status_fileblogpercona.commanual innodb_strict_modeblogpercona.commanual innodb_support_xablogpercona.commanual innodb_sync_spin_loopsblogpercona.commanual innodb_table_locksblogpercona.commanual innodb_thread_concurrencyblogpercona.commanual innodb…

Filed Under: Insight for DBAs, MySQL
« Older Posts
Newer Posts »