A few weeks ago we released MySQL Connector/Python v1.0.12. Bugs were fixed, and LOAD DATA LOCAL INFILE should now work correctly. The announcement can be read on the MySQL forums.

Some useful links:

• Documentation: http://dev.mysql.com/doc/connector-python/en/index.html
• Release Notes: http://dev.mysql.com/doc/relnotes/connector-python/en/index.html
• Downloads: …

I was searching looking for the PRIVILEGES that comes with the primary MySQL account on RDS, but it looks like this is not documented anywhere nor blogged about yet. So for the sake of other users, here it is:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'revin'@'%' IDENTIFIED BY PASSWORD '*xxxxxxxxxxxxxxxxxxx' WITH GRANT OPTION

In case you ask, for what, I was looking for what privileges I can grant other users via the primary account.

MySQL Connect 2013 is coming up with several interesting new sessions. Some sessions that I am participating in got accepted for the conference, so if you are going there, you might find the following sessions interesting. For your convenience, the sessions have hCalendar markup, so it should be easier to add them to your calendar.

MySQL Sharding, Replication, and HA (September 21, 5:30-6:30pm in Imperial Ballroom B)

This session is an opportunity for you to meet the MySQL engineering team and discuss the latest tools and best practices for sharding MySQL across distributed server farms while maintaining high availability.

Come …

I am working on a customer’s system where the requirement is to store a lot of timeseries data from different sensors.

For performance reasons we are going to use SSD, and therefore there is a list of requirements for the architecture:

• Provide high insertion rate
• Provide a good compression rate to store more data on expensive SSDs
• Engine should be SSD friendly (less writes per timeperiod to help with SSD wear)
• Provide a reasonable response time (within ~50 ms) on SELECT queries on hot recently inserted data

Looking on these requirements I actually think that TokuDB might be a good fit for this task.

There are several aspects to consider. This time I want to compare TokuDB vs InnoDB on an initial load time and space consumption.

Let’s …

Following my blog on InnoDB sessions, let's focus today on what you will have the opportunity to learn from MySQL users sharing their real-world experiences along with best practices they've developed.

You should obviously not miss our exciting panel on "Current MySQL Usage Models and Future Developments" featuring Davi Arnaut from LinkedIn, Daniel Austin from PayPal, Mark Callaghan from Facebook and Calvin Sun from Twitter.

The conference sessions will include:

MySQL at Twitter - Calvin Sun and Liang Guo, Twitter
Saturday, 11.30 am, Imperial Ballroom A

…

MySQL Enterprise Backup team is excited to announce the new release of MySQL Enterprise Backup (MEB) 3.9.0.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Overview

MEB 3.9.0 focusses more on the ease of use of the product and addresses some of the challenges faced currently by database administrators.  With growing data the need for hardware for database backups has significantly increased. Keeping that in mind MEB 3.9.0 has extended the product capability to save disk space during backup and restore.  MEB 3.9.0 has also enhanced some of the existing features helping MEB users to perform their tasks in a more user friendly way without much overhead. 

Product Enhancements

 MEB 3.9.0 is a major release with the following valuable features.

·         Single …

Those who regularly read this blog knows how much I am excited about Percona Live London each year. Now, it is time for me to take part in the organization of this event as a member of the committee and chairman of the conference.

I am really proud to join the committee this year and very happy to share this role with Ivan, Ben, David, Todd and Kenny.

You can imagine that I am honored that Percona has made me this beautiful gift.
Now, we face the challenges!

I am also very pleased to introduce myself as a member of this committee as an employee of Dailymotion. ‘Cause Dailymotion offers me an incredible chance to do my job with passion and fun, like never before.

When I started this blog I wanted to do it as honestly as possible and as humbly as possible.
And I wanted to keep the …

As a first step to developing your websites with MySQL and PHP, take the MySQL and PHP: Developing Dynamic Applications training course where you will learn to:

• Describe the LAMP architecture
• Use the basic components of PHP to build a foundation for more complex web applications
• Understand the basic components of MySQL
• Use SQL query commands to retrieve data from the MYSQL database
• Change table data using the SQL Data Manipulation Language (DML) commands
• Retrieve data from multiple MySQL tables using Joins
• Create web based forms that interact with the end user and the data within MySQL
• Use session handling to authenticate and monitor user identities
…

Being a fanboy of Spider for a long time. Hoping to see in shipped with MySQL. Now Im glad to see Spider shipping with MariaDB 10.0.4. It is not activated/installed per default, so as it is a SE plugin just do a

mysql> INSTALL PLUGIN spider SONAME 'ha_spider.so';

As Spider provides some funcitions and does some accounting in his own tables you also have got to

# cat /usr/share/mysql/install</em>spider.sql| mysql -u root

There you go. There is an older (german) presentation about Spider from me.
Frederic did on too :)

Let the Spider begin \o/

Sometimes, we need to search specific data available in compressed MySQL backup files. Tools are avaiable to perform normal operation on compressed files, using the powerful Linux Z commands. It's not possible to uncompress n number of huge files. Even after uncompression, the file size goes beyond 100+ GB.

Senario 1: Searching months of compressed mysql backup files for a specific data.

[root@centos4 data]# zgrep -i innodb category.sql.gz
) ENGINE=InnoDB AUTO_INCREMENT=165124728 DEFAULT CHARSET=binary;
[root@centos4 data]#
[root@centos4 data]# zegrep -i innodb category.sql.gz
) ENGINE=InnoDB AUTO_INCREMENT=165124728 DEFAULT CHARSET=binary;
[root@centos4 data]#

Senario 2: Viewing master log file and log position in a compressed file.

[root@centos4 data]# ls -ltrh
total 22M
-rw-r--r--. 1 root root 22M Jan  2  2013 category.sql.gz
[root@centos4 data]# zcat category.sql.gz | less …