Reputation
306
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 7
Newest
 Nice Answer
Impact
~39k people reached

  • 0 posts edited
  • 0 helpful flags
  • 74 votes cast
Dec
3
revised Mysql (percona-server 5.5) completely stalls during import (myloader)
Oracle bug ref
Dec
3
answered Mysql (percona-server 5.5) completely stalls during import (myloader)
Dec
3
comment Mysql (percona-server 5.5) completely stalls during import (myloader)
Stall != deadlock
Nov
24
comment Mysql (percona-server 5.5) completely stalls during import (myloader)
When the server is completely stuck, what is the output of "gdb -ex "set pagination 0" -ex "thread apply all bt" --batch -p $(pidof mysqld)" ?
Jun
16
awarded  Nice Answer
May
10
comment Configuring MySQL (my.cnf) for MyISAM and InnoDB
Try this tool: tools.percona.com/wizard
May
6
comment Prevent reset of auto_increment id in Innodb database after server restart
For the reference this is bugs.mysql.com/bug.php?id=199
May
6
comment How to tune mysql to be inmemory-like
How is the insert structured WRT transactions? If it's transaction per statement, see if you can insert 1000 rows per trx instead. If it's a single thread doing loading, see if you can parallelize it. In the latter case Percona Server 5.5 / MariaDB 5.5 / MySQL 5.6 group commit would help to reduce I/Os as well.
May
2
comment MySQL hogging memory
Please test with 5.6.11. There are many serious bugs fixed in this second GA release, it is possible that memory leaks too.
Feb
12
answered Which hot backup tools for MySQL InnoDB database : Percona XtraBackup, Zmanda Recovery Manager Enterprise or Community or…?
Jan
7
awarded  Commentator
Jan
7
comment which mysql version to use - 5.1 or 5.5?
I believe they-once they get around fixing community bugs-weigh the fix invasiveness for each active branch individually for the fix-no fix decisions. There is a bunch of bugs fixed in 5.6+ only, or even 5.7 only.
Jan
6
comment which mysql version to use - 5.1 or 5.5?
Rolando, the linked post compares configured MySQL. The unconfigured MySQL tests would not provide any useful information, not even a single anecdotal data point
Jan
6
comment which mysql version to use - 5.1 or 5.5?
MySQL 5.1 is not EoL'ed as of today. 5.0 is.
Dec
26
comment MySQL Replication and High Availability
Look into Percona XtraDB Cluster as well.
Nov
26
awarded  Yearling
Nov
26
answered What happened to my-*.cnf in MySQL 5.6.8?
Sep
6
comment Is the overhead of frequent query cache invalidation ever worth it?
dom.as/tech/query-cache-tuner sums it up pretty nicely
Feb
21
comment Innodb mutex locking ?!? Inserts start stacking after 18-24hours, restart required
Maybe you are experiencing so-called InnoDB "furious flushing" issue. You could check if that's the case for checking if buffer page write activity spikes at the same time query performance drop.
Nov
25
awarded  Critic