Don’t forget to Register for the March 12 Virtual Developers Day. Two training tracks — one for beginners and the second is a MySQL 5.6 deep dive. The event will repeat on March 19th for Europe, Middle East, Africa, and some Asian Countries.

Percona is glad to announce the release of Percona Server for MySQL version 5.5.29-30.0 on February 26th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.29, including all the bug fixes in it, Percona Server 5.5.29-30.0 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the 5.5.29-30.0 milestone at Launchpad.

New Features:

…

There is going to be a MySQL Tech Tour in Moscow planned for March 21, 2013 and followed by the local MySQL User Group meeting to talk about the MySQL 5.6! Please find details below.

MySQL Tech Tour:

Date: March 21, 2013
Details: http://www.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=166491&src=7667490&src=7667490&Act=175

MySQL User Group meeting:

Date: March 22, 2013
Location: Mail.Ru Airport; Leningradsky prospect 47 building 2
Planned time: 19:00
Agenda:
Dmitry Lenev & Victoria Reznitchenko will speak about MySQL 5.6

…

I was at FOSDEM for the first time this year and it was very exciting.
I was very glad to see Percona, MariaDB and Oracle together.
If you’ve never been at FOSDEM, I recommend you to join us next year, this is truly a magical event!

You can find some of the slides on [Plus], enjoy! :

If you would like to add your slides, post a comment with the link.
And remember to visit this page for more slides about MySQL : http://www.mysqlplus.net/mysql-docs/

…

In many MySQL Benchmarks we can see performance compared with rather high level of concurrency. In some cases reaching 4,000 or more concurrent threads which hammer databases as quickly as possible resulting in hundreds or even thousands concurrently active queries.

The question is how common is it in production ? The typical metrics to use for concurrency defined as number of queries being actually processed is “Threads_Running” which you can easily see for your production system:

root@smt2:/mnt/data/ mysqladmin extended -i1 | grep Threads_running
| Threads_running                               | 60          |
| Threads_running                               | 61          |
| Threads_running                               | 63          |
| Threads_running …

Today we released MySQL Connector/Python v1.0.9. Release notes can be found in the MySQL Developver Zone.

Connector/Python v1.0.9 contains some important fixes, especially for the Windows platform. It also comes with a new connection argument called force_ipv6, and can be used to force IPv6 when an address resolves to both IPv4 and v6. Also, RPM packages have been made available in addition to the TAR/ZIP and MSI packages.

Please use the MySQL Bugs website to report any problem.

Some useful links:

• Documentation: …

I have been meaning to write this down for quite some time, but it always eluded me. When you are using Time Machine to back up your Mac, you get the chance of password-protecting your backups.

Whenever the machine is restarted you will have to unlock the disk by entering the password, unless you store the password for the backup disk in your keychain. For paranoia's sake (and to keep the password fresh in my memory, just in case) I do not store the password in the keychain.

Now, what happens quite regularly to me is this: I reboot the machine for some reason or other, and while it is doing that, I leave the room and do something else. Before I know it, maybe an hour has passed before I come back. In the meantime, the external Time Machine drive has gone to sleep, because it was not used for an extended period of time. On the screen, there is the password dialog dutifully waiting for me to unlock the protected volume.

As …

EDIT: Video from today's #DBHangOps!

Hey there peeps!

February 27th at 12:00pm PST it is! Check back here for more info and keep a watchful eye on the twitter search (and feel free to join the conversation!). The topics we're looking to cover this week are:

• Day-to-day pain points (what takes more time than it should?)
  • rolling restarts and upgrades
  • Performing checksums on your data $ /usr/bin/pt-table-checksum \ --quiet \ --ignore-databases=mysql,percona,information_schema,per formance_schema \ --lock-wait-time=50 \ --chunk-size-limit=0 \ --no-check-plan \ --no-check-binlog-format \ --max-lag=1 \ --replicate percona.checksums \ h=database.example.com \ 2>&1 | grep -v '^Cannot connect to'
• Troubleshooting …

There are many reasons for wanting a small MySQL database server:

• You’re a uni student who wants to learn the SQL language better and needs a mini-testbox
• You’re a Windows user who wants to play around with Percona Server on Linux
• You’re a corporate application developer who wants a small SQL development & test box
• You’re a Internet startup that just needs a tiny startup database server without all the added costs

So, how about if you could setup a small Arch Linux ARMv6-based hardware device which runs Percona Server for MySQL, in a space not much bigger than your mouse, with the power consumption of only a smartphone charger, fully networked, all for under $80?

Introducing the Raspberry Pi with Percona Server:

Raspberry Pi Fully …

MySQL 5.6 was made generally available as a production-ready solution earlier this month. This release comes about 2 years after MySQL 5.5 was released, but MySQL 5.6 contains improvements started long before that – for example, work on the Innodb Full Text Search project was started over 6 years ago, in addition with many optimizer and replication features. We’re happy to congratulate MySQL development team at Oracle with making this release happen.

In this blog post, I will not go into a features overview of MySQL 5.6. You can check out Release Notes for a good overview as well as many blog posts and articles written on this matter. Instead, I will tell you what is the current state of things with MySQL 5.6 at …