June 20, 2013

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

June 7, 2013 By Leave a Comment

… anything quite like that in the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external… the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple…

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

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

… #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not innodb options (fixed… bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair…

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , ,

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

…fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush…_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover…

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , , , , , ,

Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL

May 1, 2013 By 10 Comments

… PXC, wsrep_replicate_myisam allows you to do so. However, if you can, you should consider moving to InnoDB altogether. There are very few reasons to stay with MyISAM nowadays i.e. if you… internally within the cluster, this is to avoid collisions when INSERTs are happening on not only a single node. However, this…

Filed Under: Insight for DBAs, MySQL, Percona Software, XtraDB Cluster Tagged With: , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… the default InnoDB list, but there are 543 stopwords in the default MyISAM list. What happens if we take the MyISAM stopwords, insert them…_table=’test/innodb_ft_list2′; Query OK, 0 rows affected (0.00 sec) mysql: INSERT INTO innodb_ft_list2 SELECT * FROM innodb_myisam_stopword; Query…

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

Post: How innodb_open_files affects performance

November 18, 2009 By 4 Comments

… variable – innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mode. Unlike MyISAM Innodb does… even in case table it fully in Innodb data dictionary the operation is slower than MyISAM tables. Though the difference can be… innodb_open_files does not affect performance a lot on reads – what is about writes ? I tried again very simple test inserting…

Filed Under: Insight for DBAs, MySQL Tagged With:

Post: Fix of InnoDB/XtraDB scalability of rollback segment

January 18, 2009 By 9 Comments

… about InnoDB scalability on 24-core box, and we made research of scalability problems in sysbench write workload (benchmark emulates intensive insert…=MYISAM innodb_buffer_pool_size=6G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb…

Filed Under: Benchmarks, Percona Software Tagged With: ,

Post: Recovering Innodb table Corruption

July 4, 2008 By 22 Comments

…_INCREMENT, -> PRIMARY KEY (`id`) -> ) ENGINE=MYISAM; Query OK, 0 rows affected (0.03 sec) mysql> insert into test2 select * from test; Query… because Running in innodb_force_recovery mode Innodb becomes read only for data operations and so you can’t insert or delete any… simple Innodb Table Corruption. In more complex cases you may need to use higher innodb_force_recovery modes to block purging activity, insert…

Filed Under: Insight for DBAs Tagged With:

Comment: MySQL File System Fragmentation Benchmarks

July 9, 2008 By 28 Comments

… inserted) I got 1121, 1133, and 1166 inserts per second into that one table. using autocommit for innodb inserts I got 1125, and 1158 inserts per second into the table using myisam I got 1186 and 1177 inserts per second…

Filed Under: Benchmarks Tagged With: ,

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

February 26, 2013 By 1 Comment

… to using MyISAM are far outweighed by the potential disadvantages and the strengths of InnoDB. However, up until MySQL 5.6, MyISAM was… that the engine is MyISAM rather than InnoDB. Loading the data was done via a simple Perl script, inserting one row at a….00 sec) mysql> insert into dir_test_innodb (full_name, details) SELECT reverse(full_name), details FROM dir_test_innodb WHERE id < 500000…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts