Recently there has been a storm of bugs and problems in all variants of MySQL including MySQL, Percona Server, and MariaDB. To list a few:
On the lighter side: I’ve always had trouble with mysqldump’s expected syntax. You know, as the author of a book and all that, you might think I can get this to work. But pretty much every time I run this tool, it humiliates me. Witness: $ mysqldump --host localhost --password secr3t --all-databases Usage: mysqldump [OPTIONS] database [tables] OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...] OR mysqldump [OPTIONS] --all-databases [OPTIONS] For more options, use mysqldump --help Alas.
I’ll be attending Percona Live NY 2012 next month, co-presenting a tutorial with Marcos Albe (also from Percona) and a couple of sessions with Marcos and Ryan Lowe (of Square). On Monday, Marcos and I will be doing a hands on tutorial on Percona Toolkit, and on Tuesday, Ryan will join us for a session … Continue reading Presenting at Percona Live NY 2012 →
No related posts.
This is to continue my previous experiments on adaptive flushing in MySQL 5.6.6. Now I am running Ubuntu 12.04, which seems to provide a better throughput than previous system (CentOS 6.3), it also changes the profile of results.
So, as previous I run tpcc-mysql 2500W, against MySQL 5.6.6 with
innodb_buffer_pool_size 150GB, and now I vary
innodb_buffer_pool_instances as was advised in
comments to previous post. I also tried to vary
innodb_flushing_avg_loops, but it does not
affect results significantly.
So, let’s see throughput with 10 sec averages.
Obviously with innodb_buffer_pool_instances=1 the result is better and more …
[Read more]
When investigating core files from crashes, one can quite easily
figure out which query crashed, as we've
seen.
Sometimes you want to just list all the currently executing
statements, this is useful for diagnosing hangs or
corruptions.
At least GDB 7 supports python macros, which can help us a lot here. I
use a core file from 5.5.27, also a non-debug build but not
"stripped". So it's a standard build made with -g allowing us to reference symbols.
I wrote a simplistic macro to iterate through mysqld's global
"threads" variable.
This is what my …
Installing Apache2 With PHP5 And MySQL Support On OpenSUSE 12.2 (LAMP)
LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an OpenSUSE 12.2 server with PHP5 support (mod_php) and MySQL support.
This week we present InnoDB FULLTEXT search. Ear Candy is about SOUNDEX() and SOUNDS LIKE queries, and At the Movies is about FULLTEXT search throwdown by Bill Karwin.
Events
MySQL Connect will be held in San Francisco on
Saturday September 29th and Sunday September 30th. The schedule is now online.
Taxonomy upgrade extras: trainingMySQL Cluster
The dates for the next MySQL Cluster (ndb) trainings with the
Linux
Hotel are scheduled now: March 11 - 12 2013 and September 23 - 24 2013.
You can book your training here.
Taxonomy upgrade extras: trainingMySQL Clustermysql-training
The dates for the next MySQL Cluster (ndb) trainings with the
Linux
Hotel are scheduled now: March 11 - 12 2013 and September 23 - 24 2013.
You can book your training here.
The binary version for MySQL Cluster 7.2.8 has now been made available at http://www.mysql.com/downloads/cluster/ (GPL version) or https://support.oracle.com/ (commercial version).
A description of all of the changes (fixes) that have gone into MySQL Cluster 7.2.8 (compared to 7.2.7) is available from the 7.2.8 Change log.
