June 18, 2013

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

May 22, 2013 By Leave a Comment

…mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb…engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_…

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

Post: Percona Server for MySQL 5.5.31-30.3 now available

May 24, 2013 By Leave a Comment

… introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory … MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server for MySQL …

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

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

June 7, 2013 By Leave a Comment

… the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables; you… the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL… get 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: ZFS on Linux and MySQL

May 24, 2013 By 17 Comments

….  Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read lock” and… ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will… together, ZFS on Linux is a very interesting solution for MySQL backup servers.  All backup solutions have an impact on performance…

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , , ,

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

June 10, 2013 By 8 Comments

…simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables are not supported inside… – It is not possible to mix non-transactional tables (such as MYISAM) with innodb tables within the same transaction. The same issue can arise…

Filed Under: MySQL Tagged With: , ,

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

…: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max…_min_word_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options key_buffer_size…

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

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

May 1, 2013 By 10 Comments

… XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users …who wants to, but still have MyISAM tables. You can still try by filtering MyISAM tables though if you can leave … you should consider moving to InnoDB altogether. There are very few reasons to stay with MyISAM nowadays i.e. if…

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

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

…mysql­-user=root –mysql­-socket=/tmp/mysql.sock ­­–mysql­-table­-engine=innodb ­­\ –oltp­-read­-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb… myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…

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

Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE

April 4, 2013 By 17 Comments

… drupal, and i converted databases from MyISAM to InnoDB, mysql tunning script gives below results for temp table , server has 4G ram, which almost…_heap_table_size & tmp_table_size) , what values you experts are recomended ? TEMP TABLES Current max_heap_table_size = 128 M Current tmp_table_size…

Filed Under: Insight for DBAs Tagged With: ,

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

March 4, 2013 By 7 Comments

… *InnoDB* table with a single VARCHAR column named “value”. OK, sounds easy enough: mysql: SHOW CREATE TABLE innodb_myisam_stopword\G *************************** 1. row *************************** Table: innodb_myisam_stopword Create Table: CREATE TABLE `innodb_myisam_stopword` ( `value` varchar(18) NOT NULL DEFAULT ” ) ENGINE=InnoDB DEFAULT CHARSET…

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