… slave is to write all batch jobs to use Gearman MySQL UDF interface to apply update transactions to the master (but… Gearman Worker to take update transactions to apply and pace MySQL transactions to the real master db. You can configure multiple… and allow the client to enable Update Pacing using a MySQL session variable.
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… this statement about replication? I’ve observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs… it’s probably a good idea to turn off the session‘s binary log in general. But if it’s left…
Post: Win Free MySQL Conference Tickets!
March 14, 2012 By 2 Comments
… favorite #MySQL conference session” with a link to your favorite “Like” your favorite conference session with Facebook +1 your favorite conference session via Google Plus To Tweet, “like,” or +1 a session, just browse to the session…
Post: BOFs and Lightning Talks Announced for Percona Live MySQL Conference & Expo
March 22, 2012 By Leave a Comment
… enthusiastic crowd of MySQL users ensure this is going to be a great event. The conference features 72 breakout sessions, keynotes by… announce the conference Birds of a Feather sessions and Lightning Talks. Birds of a Feather sessions will be Tuesday and Wednesday nights… tutorial sessions, which require preregistration, are filling rapidly. Don’t miss out on this great opportunity to connect with the MySQL community…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… sessions have created which temporary tables (both in memory and not): mysql> select * from information_schema.global_temporary_tables \G *************************** 1. row *************************** SESSION…_LENGTH: 0 CREATE_TIME: NULL UPDATE_TIME: NULL *************************** 2. row *************************** SESSION_ID: 7234 TABLE_SCHEMA: test TABLE_NAME: tmp ENGINE: MEMORY…
Post: Community events around Percona Live MySQL Conference and Expo 2012
March 26, 2012 By 1 Comment
… support for Percona Live MySQL Conference and Expo. We’ve got wonderful speakers providing content of phenomenal session lineup for the conference…) whenever you’re attending MySQL Conference and Expo or not. Furthermore Birds of the Feather sessions on Percona Live MySQL Conference and Expo…
Post: Early Bird Pricing Ends Today for Percona Live MySQL Conference & Expo
March 12, 2012 By Leave a Comment
Early Bird Pricing for the Percona Live MySQL Conference and Expo ends today, March 12th. Hotel room rates … registering now. The conference features 72 breakout sessions, an optional day of 16 tutorial sessions, a bustling exhibit hall, and numerous opportunities…, Eucalyptus Systems, Percona, and more. This is the “must attend” MySQL event of the year. Already planning to attend? The calls…
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
… in years.” Darren Cassar called it “one of the best MySQL conferences since I started attending four years ago,” while Marco… Oracle for their new development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and…. Sheeri Cabral also recorded some of the breakout sessions, so watch Planet MySQL for an announcement when she posts those online. Presentation…
Post: Free ticket to MySQL User Conference on SF Meetup with talk "Percona XtraDB Cluster"
March 16, 2012 By Leave a Comment
… San Francisco MySQL Meetup, next Wednesday, March-21, 2012. Along with talk I will give away one full ticket (tutorials + sessions + expo hall) to Percona Live MySQL User Conference 2012 and three copies our new book “High Performance MySQL, 3rd edition…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
… same query twice, you get the same result, regardless other session modifications on that table. This makes reads consistent and therefore…. Then, we try to insert another value on the second session: transaction2 > START TRANSACTION; transaction2 > INSERT INTO t VALUES(26); ERROR…/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation level so it…
