June 19, 2013

Post: 10 years of MySQL User Conferences

April 11, 2013 By 6 Comments

… recall one of them saying something like, “12 full-time engineers are working on MySQL server.” The MySQL Certification program was announced. MySQL 4.0… MySQL Enterprise, just certain features available only in Enterprise edition as plugins. Early preview of plans for MySQL 5.6 more in the form of a code drop than promises what the final version will contain. MySQL 5…

Filed Under: Events and Announcements, Insight for DBAs, Insight for Developers, MySQL, Percona Live Tagged With: , , ,

Post: Is Synchronous Replication right for your app?

May 14, 2013 By 18 Comments

… inflight in the form of deadlock errors.  (This is actually a form of Eventual Consistency where … MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL … error. This is not implemented for full BEGIN … COMMIT multi-statement transactions since…

Filed Under: MySQL, Percona Software, XtraDB Cluster Tagged With: , , , , , ,

Post: Is there room for more MySQL IO Optimization?

January 3, 2013 By 11 Comments

… prolonged period of time, so it reflect natural state of the table as it would be in the production over time: mysql> show… as well as more information MySQL has about data which will be accessed next – in case of full table scan, index scans etc… operating system logic while RAID controller may be doing some form of read-ahead on its, making OS read ahead help unneeded…

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…of that sort, and we were looking for queries containing the word “MySQL” – odds are that an article which has 10 instances of “MySQL…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Full Text Search Webinar Questions Followup

August 24, 2012 By 5 Comments

… webinar this week to give an overview of several Full Text Search solutions and compare their performance…._DOC_ID` primary key column properly, MySQL crashed with an out of memory fatal error, and the …DataImportHandler to import the result of any SQL query, and if you can form a SELECT query …

Filed Under: Events and Announcements, Insight for Developers, MySQL

Post: Using Sphinx as MySQL data retrieval accelerator

October 30, 2006 By 25 Comments

…MySQL. MySQL Make it so one would not need to use sphinx to get great performance for such kind of queries. This includes parallel processing, fast count(*) and bitmap indexes to help non selective clauses. Also some form of…

Filed Under: Insight for Developers Tagged With: ,

Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks

August 17, 2012 By 17 Comments

…, both incremental and full restores The ability …form of deadlock errors to the clients of affected transactions.  Technically these aren’t necessarily deadlocks, but instead a cross-node locking conflict of… affected (0.02 sec) node2 mysql> show create table autoinc\G *************************** 1….

Filed Under: MySQL, XtraDB Cluster

Post: Using Flexviews - part two, change data capture

March 25, 2011 By 26 Comments

…full binary log parser. Instead, it invokes the ‘mysqlbinlog’ utility and it processes the predictable output of this program. mysqlbinlog will always be able to read the binary logs of the version of mysql…

Filed Under: Insight for DBAs, Insight for Developers, MySQL

Post: Why you should ignore MySQL's key cache hit ratio

February 28, 2010 By 28 Comments

…all the information you need to form an opinion, right? Instead of asking the same annoying question, … key_buffer_size until, when the buffer is full, Key_reads/Uptime reduces to a number …end-all of MySQL performance, and people frequently obsess over it far out of proportion. But again, 99% of the…

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

Post: Implementing efficient counters with MySQL

July 1, 2007 By 16 Comments

… some form of caching, ie memcache you end up reducing number of reads from database dramatically but writes still have to happen at full… real-time counters very efficiently pushing few updates back to MySQL server. If you rather use existing solutions you can use memcache + another mysql instance (or simply the database which is not replicated) to…

Filed Under: Insight for Developers Tagged With: ,
« Older Posts