network profile
| bio | website | of-code.blogspot.com |
|---|---|---|
| location | Lithuania | |
| age | 30 | |
| visits | member for | 1 year, 8 months |
| seen | yesterday | |
| stats | profile views | 35 |
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 |
