Laurynas Biveinis

less info
221 reputation
16
bio website of-code.blogspot.com
location Lithuania
age 31
visits member for 2 years, 10 months
seen Jul 22 at 7:59

I hack MySQL and InnoDB for Percona.


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
Nov
25
comment Why mysql 5.5 slower than 5.1 (linux,using mysqlslap)
Your answer is correct but I think it does not apply to OP. When he configures InnoDB, then we'll see.
Nov
25
comment Why mysql 5.5 slower than 5.1 (linux,using mysqlslap)
Your my.cnf configures MyISAM but benchmarks use InnoDB. I am sorry, this is still a joke (and so are InnoDB defaults if you don't change them)
Sep
23
awarded  Editor
Sep
23
revised Trying to get multiple mysql instances running on Ubuntu dev box
Forgot mysql_install_db
Sep
22
answered Trying to get multiple mysql instances running on Ubuntu dev box