…you to stripe a TCP connection over multiple ports, and with a two-NIC …, a set of databases, or specific tables; you can also configure the slave …keep an eye on to prevent a problem before it occurs. For example, if … 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
…client is forced to correct the problem before it can commit. It … you can’t modify data on multiple cluster nodes simultaneously. You can. … in separate tables and there also exists a users_groups table to define the …RTT). The other transactions will lock wait until the lock(s) they need are …
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
… well – two main things stopping you is table locks and global mutex on the KeyCache. Table Locks are not the issue for Read Only workload and write intensive workloads can be dealt with by using with many tables… you have chosen a way of using Multiple Tables to solve Table Locks problem you can also use multiple Key Caches to reduce or virtually eliminate…
Post: Innodb Table Locks
July 31, 2012 By 4 Comments
…. Similar to IS lock IX is rather lose – I can have multiple update queries running on the table each locking it in IX mode… level table locks for most queries. Summary: MySQL Table level locks and Innodb Table Level locks are two separate beings. You almost never will run into problems…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…so. Using multiple tables gives some very important benefits – your data becomes managable, your ALTER TABLE or OPTIMIZE TABLE now locks small table for few …problems with many tables some are OS and File System dependent, others correspond to Innodb storage engine or using innodb_file_per_table…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… cause things breakage Table Locks – Table locks are not cleared until you fetch whole result set if you’re reading from tables directly (if you… scalability. Using FEDERATED Tables can work for some cases in others script can be more efficient especially when multiple servers are involved… at once. It is rather efficient bur can cause problems with table locks and other issues plus if script aborts it may be…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… as it currently does which can be multiple orders of magnitude faster for large tables. There is fair number of questions about… known Innodb problem is table locks which are taken for statement duration for Inserts with auto-increment column. This starts giving you problems if… statement is started instead of handling auto increment lock for full statement duration. The problem with multi value inserts however is the…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… TABLE LOCK table `test`.`autoinc` trx id 83B lock mode IX RECORD LOCKS space id 0 page no 823 n bits 72 index `PRIMARY` of table… with optimistic locking. So, when is this really a problem? Really whenever transactions across multiple nodes can take the same write locks. Whether or…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… many times wrote about InnoDB scalability problems, this time We are faced with one for MyISAM tables. We saw that several times… executed without exclusive table locking. Even on 16 threads we’re getting performance worse than with single query. The problem in this case… Request. This lock is per key cache so if you have contention while multiple indexes are used you can create multiple key caches…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…so. > Using multiple tables gives some very important benefits – your data > becomes managable, your ALTER TABLE or OPTIMIZE TABLE > now locks small table for few seconds…which > requires queries to do full table scans. Funny enough this is often > not the problem in the beginning – if application is…
