… the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…’ll have to start the snapshot while holding a “flush tables with read lock” and the flush operation will take some…
Comment: MySQL VIEW as performance troublemaker
May 23, 2013 By 57 Comments
just to add. i am thinking of working with temporary values getting posted immediately after a transaction eg customer balance on the customers table. Then i wont need a view.
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… enlighten me here. – audit_record_objs : List of database objects (tables, according to the docs) for which you want events written…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap… handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table t as SELECT ld.label_id, cai.inventory_id…) group by ld.label_id, cai.inventory_id All 4 tables in the query are locked!
Comment: What Are Full, Incremental, and Differential Backups?
May 22, 2013 By 9 Comments
… of the weeks. Can you give an example in a table? I am doing a project with Open university, and would…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… the filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For the MyISAM tests I… innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd… innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… outperforms FlashCache by over 2x, on average. Looking just at sysbench reads, vCache with time-based flushing consistently hit about 27000… conducted with the following: sysbench –num-threads=32 –test=tests/db/oltp.lua –oltp_tables_count=32 \ –oltp-table-size=10000000 –rand-init…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…. When a player makes an achievement, your application updates this table with a statement like this: UPDATE achievements SET count = count… application. These are maintained in separate tables and there also exists a users_groups table to define the relationship between them. When… deadlock error. This is not implemented for full BEGIN … COMMIT multi-statement transactions since it cannot be assumed that those are…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… performance win of TokuDB is indexes. If you add multiple multi-column indexes the difference with InnoDB will be even more… 3.x and 4.x). It really shines on large tables and index scan like queries.
