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
…
[Read more]
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 …[Read more]
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:
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 …
[Read more]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:
$
/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'
There are many reasons for wanting a small MySQL database server:
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 …
[Read more]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 …
[Read more]MySQL enables innovative Developers to create and deploy the next generation of web, embedded and Cloud/SaaS/DaaS applications on the latest generation of development frameworks and hardware platforms.
By taking the MySQL for Developers course, you will learn to write applications with the MySQL database server.
This course examines the tools used by MySQL development professionals. Expert instructors reference real-world examples when illustrating how to generate complex queries, and consume them in your application. You will perform lab work with Java and PHP, connecting to MySQL databases and executing queries and stored routines.
You can take this five-day, live instructor-led course as a:
