….frm’ (errno: 150) May make you to think you have some kind of strange file system/OS error until you run perror: [pz@sl1 ~]$ perror…: Warning: cannot find a free slot for an undo log. Do you have too InnoDB: many active transactions running concurrently? I hope with pluggable storage engine interface Sun/MySQL spends…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…INNODB STATUS can also be used as debugging tool. Next section you will find in SHOW INNODB STATUS is information about currently active transactions: ———— TRANSACTIONS…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…you better have binary log flushed on commit too. MySQL also has broken group commit (which we have partial fix for) meaning concurrent transaction…active-passive clusters for availability purposes and they look to do the same with MySQL. This works though I do…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…innodb_log_buffer_size Default for this one is kind of OK for many workloads with medium write load and shorter transactions. If you have update activity spikes however or work with blobs a lot you might want to increase it. Do not set it too…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…activity is another activity which will happen in parallel even if you have single running query. Though this one is specific to write requests – if you have…you will not benefit of this parallelization. Of course another thing update query needs to do is to flush transactional log. In case innodb…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 31 Comments
…too many MySQL server connections. Some people simply do not realize you can increase max_connections variable and get over 100 concurrent…Innodb tables throughput may drop dramatically – you may see it to be 1/100 of what you get with just few queries concurrently. If you have…
