MySQL
Beyond MySQL GA: patches, storage engines, forks, and pre-releases – FOSDEM 2010
Kristian Nielsen presented “Beyond MySQL GA: patches, storage engines, forks, and pre-releases”. This included a history of current products: Google Patches (5.0 & 5.1) included improvements in : statistics/monitoring lock contention binlog malloc() filesorts innodb I/O and wait statistics SHOW …STATISTICS statements smp scalability I/O scalability semisync replication many more Percona Patches (5.
Read moreMulti-Master Manager for MySQL – FOSDEM 2010
The next presentation by Piotr Biel from Percona was on Multi-Master Manager for MySQL. The introduction included a discussion of the popular MySQL HA solutions including: MySQL Master-slave replication with failover MMM managed bi-directional replication Heartbeat/SAN Heartbeat/DRBD NDB Cluster A key problem that was clarified in the talk is the discussion of Multi-Master and this IS NOT master-master.
Read more10x Performance Improvements in MySQL – A Case Study
The slides for my presentation at FOSDEM 2010 are now available online at slideshare . In this presentation I describe a successful client implementation with the result of 10x performance improvements.
Read moreState of phpMyAdmin – FOSDEM 2010
Following the opening keynote “Dolphins, now and beyond”, Marc Delisle presented on “State of phpMyAdmin”. phpMyAdmin is an DBA administration tool for MySQL available today in 57 different languages. This is found today in many distributions, LAMP stack products and also in cpanel.
Read moreDolphins, now & beyond – FOSDEM 2010
I had the honor of opening the day at the MySQL developer room at FOSDEM 2010 where I had a chance to talk about the MySQL product and community, now and what’s happening moving forward.
Read moreBe sure to know your my.cnf [sections]
The MySQL configuration file, e.g. /etc/my.cnf has a number of different section headings including [mysql], [mysqld], [mysqld_safe]. It is important that you ensure you put the right variables into the right section.
Read moreProblem of the day, DESC gives error.
I hit this interesting problem last night on 5.0.51a. mysql> use information_schema; mysql> desc routines; ERROR 1 (HY000): Can't create/write to file '/home/tmp/#sql_fea_1.MYD' (Errcode: 24) mysql> show create table routinesG *************************** 1.
Read moreSpeaking at MySQL UC 2010
My talk on 10x performance improvements – A case study has just been approved for the <a href="2010 MySQL Conference . This will be my 5th straight year speaking at the MySQL conferences.
Read moreEurope conference options for MySQL Developers
For those in the US the annual MySQL UC is taking place again in April. For those in Europe we have dedicated room for MySQL and MySQL related products/variants/branches at FOSDEM 2010 being held in Brussels, Belgium on 6-7 Feb.
Read moreMonitoring the right MySQL slow queries
When looking at a set of SQL statements in isolation with tools such as the slow query log, processlist and tcpdump/mk-query-digest it is easy to identify queries that are slow.
Read moreWhat do MySQL staff think of the acquisition?
It finally dawned on me while reflecting on the year past this Sunday that the missing voice since the announcement of the Oracle acquisition of Sun Microsystems (and therefore MySQL) has been the MySQL employees.
Read moreUnderstanding installing MySQL rpm versions
I have a problem with an easy way to install MySQL via rpm without resorting to specifying the exact point release of MySQL. Presently my local yum repository has versions of 5.
Read moreThe Oracle EU statement on MySQL – What’s missing
Many providers embedd MySQL with their commercial products including Adobe, Macfee, Nokia, Symantec and ScienceLogic just to name a few. In addition most commercial third party storage engines have for years been forced to provided very customized versions of MySQL due to limitations in the storage engine API.
Read moreCouldn’t load plugin named ‘innodb’
As part of reviewing storage engines for my work on the upcoming Expert PHP and MySQL book, I finally had an excuse to try out the InnoDB Plugin for MySQL which is now conveniently included with MySQL 5.
Read more