…/local/mysql socket=/var/lib/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…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read … Also, instead of having 1 or 2 spare drives per controller, I have 2 for the whole setup. …ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb…requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… ms per/cmd 0.3208 ms min per/cmd 0.4159 ms max per/cmd 0.0951 ms range per/cmd InnoDB MySQL Select (same table): Fetching [1,000,000] items: 441573 ms total 0.441573 ms per/cmd 0.4327 ms min per…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… expect is modifying a given row once per RTT, it could get slower if apply … are maintained in separate tables and there also exists a users_groups table to define the relationship between … we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not think …
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… = 1 innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io…_instances=256 innodb_buffer_pool_instances=16 # MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… an option: Table was dropped and innodb_file_per_table is ON Frm file corrupt, zeroed out, lost or SHOW CREATE TABLE crashes MySQL There is yet another source of information about the table structure – InnoDB dictionary. Let’s review tables from the…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… The base MySQL configuration (configuration A) appears below: #####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_method = O_DIRECT innodb_log…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… your FRM file, you instead get some bunch of bytes per 19 columns). create_fields.elements*FCOMP is just number of… and just says “Can’t create table ‘test.t’ (errno: 139)”. This is because InnoDB has a hard limit of 1,000…’s right folks, in MySQL 5.6 you can create a table with a few more columns in InnoDB! This led me on…
