June 19, 2013

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

… simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables are not supported inside… – It is not possible to mix non-transactional tables (such as MYISAM) with innodb tables within the same transaction. The same issue…

Comment: MySQL Performance Forums

… 300 seconds and because the resultset is huge, it eventually starts creating a temp table on disk. Now during those 300 second…’ queries which perform small insert or updates into completely different table (unrelated to the select query) also get hang up. If… as ‘null’ and Info says ‘commit’ The ‘Table_locks_waited’ remains zero while the ‘Table_locks_immediate’ keeps increasing I have disabled…

Post: Private, custom Percona MySQL Training

…”] Alexei Rodriguez presenting at PLMCE13[/caption] During the Percona Live MySQL Community Event this year we had the pleasure of Alexei Rodriguez discussing why Evernote uses Percona’s Private Custom MySQL Training. Alexei is VP of operations there and you can…

Post: Summertime Percona MySQL training update

… course. Percona has a packed summer MySQL training schedule. In June we have: Moving to MySQL 5.6 – Austin, TX Begins Monday… Begins Monday, June 17, 2013 , 9am – 5pm Eastern Moving to MySQL 5.6 – Manchester, UK Begins Monday, June 17, 2013 , 9am…, FL Begins Monday, August 5, 2013 , 9am – 5pm Moving to MySQL 5.6 – Minneapolis, MN Begins Thursday, August 8, 2013 , 9am…

Post: Percona XtraBackup 2.1.3 for MySQL available for download

… to faster restore time XtraBackup makes MySQL hot backups for all versions of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts include support for XtraBackup. We…

Comment: INSERT INTO ... SELECT Performance with Innodb tables.

… InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row lock(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table t as…) group by ld.label_id, cai.inventory_id All 4 tables in the query are locked!

Post: Percona MySQL University @Portland: June 17

…, free, fast-paced and very technical MySQL educational event for wide range of people interested in MySQL – Developers, System Administrators, DBAs, etc… speaking opportunities available – if you would like to share your MySQL story at this event please email Matthew Dowell by Tuesday…

Comment: Derived Tables and Views Performance

…/simple-mysql-and-php-prodcuts-and-cart.html create dynamic main menu and sub menu using php and mysql TABLE `menu… KEY (`id`)) —————————————————————————————————— $mysql=mysql_connect(’127.0.0.1′,’root’,”); mysql_select_db(‘test’,$mysql); function display_menu($parent, $level) { $result = mysql_query(“SELECT a…

Comment: Sphinx search performance optimization: attribute-based filters

… use sphinx to our website where we have about 1200 tables each with hundreds of thousands of records, for we use…

Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)

MySQL can be deployed in several ways, and that means you …