… the Meta Data Locking behavior prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL 5.5… different order to the binary log breaking locking semantics and contrary to serialization concepts. For example take a look at the following… I have reported a bug: http://bugs.mysql.com/bug.php?id=67647 Metadata locking behaves differently for queries that are serviced from…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…MySQL and LAMP Consuilting Services. 2. Not using auto_increment functionality This is right. With some exception however. For example Innodb tables do internal full table lock if auto_increment…start to crawl. So developing you PHP applications use test database with …
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
… exact line of code in PHP which is running but can give you some good ideas – for example in this case I could find stack trace originated from php stream functions not from libmysql… helpful to debug sleeping connections with MySQL but many other cases when you see web application locking up or starting to runs…
Comment: How much memory Innodb locks really take ?
May 19, 2012 By 11 Comments
… to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user to lock records for edit/update, so the transaction is not interrupted until the transaction is finished/committed? A example of…
Page: Consulting for MySQL
July 31, 2006 By
… issues lie outside of MySQL. We’re ready to work with you on PHP code optimization, Server Side caching… Storage Engine Running transaction applications with MySQL ? Need help with deadlocks, understanding how Innodb locking works or having Innodb …us and we can probably help. These are just examples…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… some > exception however. For example Innodb tables do internal full table > lock if auto_increment …traditional database background. > Things are different with MySQL. Good design will help dictate how … start > to crawl. > So developing you PHP applications use test database with reasonable > …
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
… with oranges. For example “mysql and memcache” block would not be helpful. Even further I would prefer to split “mysql time” in the… with attributed response time. For example I’d like to see number of mysql calls in addition to MySQL response time. This helps… query from PHP application side, but we can’t say why it has taken so long. Was it row level lock ? waiting…
Comment: Pitfalls of converting to InnoDB
February 26, 2007 By 16 Comments
… it did not support transactions and used only table level locks which had to be taken all at the same time… this is other story. No there is no option on MySQL level to solve this problem because only application knows what… you actually can handle it on mysql wrapper you’re using or even for example in php extend mysqli class so it masks…
Comment: Why do we care about MySQL Performance at High Concurrency?
February 27, 2013 By 9 Comments
…, As http://bugs.mysql.com/bug.php?id=49169 explains, for InnoDB not only the number of… but also the number of currently open transactions. So, for example, with a 16-threads pool one can still have … the increased list of transactions, a metadata/row/user lock) and is then put to the queue by the …
