…allow you to stripe a TCP connection over multiple ports, and with a two-NIC bonded … EXCEPT a specified set of databases and tables. With this method, every event is still …MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL…’t modify data on multiple cluster nodes simultaneously. You …separate tables and there also exists a users_groups table to define…The other transactions will lock wait until the lock(s) they need…
Post: Innodb Table Locks
July 31, 2012 By 4 Comments
…table is being locked explicitly 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 Level locks…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
…of using Multiple Tables to solve Table Locks problem you can also use multiple …TABLES table: mysql> select table_schema,table_name,index_length from information_schema.tables where table_schema=’test’ and table_name in (‘a’,'b’); +————–+————+————–+ | table_schema | table…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
….02 sec) node2 mysql> show create table autoinc\G *************************** 1. row *************************** Table: autoinc Create Table: CREATE TABLE `autoinc` ( `i` int(…locking. So, when is this really a problem? Really whenever transactions across multiple nodes can take the same write locks…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
One of the big “Selling Points” of MySQL is support for Multiple Storage engines, and from the glance view it is indeed… MySQL allows you using multiple storage engines in the query you need to test all kinds of combination such as running multi-table… Innodb specifics well. We could get rid of SQL level table locks and using Innodb internal data dictionary instead of Innodb files…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…MySQL. There are many successful applications, using tens of thousands of tables per host and archiving great performance by doing so. Using multiple tables gives some very important benefits – your data becomes managable, your ALTER TABLE or OPTIMIZE TABLE now locks small table for…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…January I have created the outline of improvements available in MySQL 5.6 which I thought was worth sharing to …issues – Reduced Innodb Memory Fragmentation – Reduced Locking for Partitioned tables – Reduced Contention for LOCK_open – Support for multiple table_open_cache instances – Large (over 4GB…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
… system it used MyISAM and the system was built using multiple tables. Using multiple key caches was the good solution at that time… has good suggestions on tuning MySQL 5.5 and this is what I used for start. Using multiple buffer pools with innodb… – Partitioning. Unfortunately MySQL 5.5 leaves the huge bottleneck for write workloads in place – there is per index rw lock, so only…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… load. sysbench –test=oltp –mysql-user=root –mysql-password=”" –oltp-table-size=1000000 –num-threads=32…multiple nodes. There is an option you can enable to get fully synchronous replication behavior: mysql…_storage_engine=InnoDB innodb_autoinc_lock_mode=2 innodb_locks_unsafe_for_binlog=1 wsrep_…
