Reputation
1,347
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 8 19
Impact
~108k people reached

May
10
awarded  Necromancer
Apr
19
comment What is more important for a database server? Mem? Mem speed? Cores?
InnoDB Plugin can be installed easily in 5.1. Also, Percona Server 5.1 is based on InnoDB plugin.
Apr
19
comment What is more important for a database server? Mem? Mem speed? Cores?
Since MySQL was specifically mentioned, faster processors are usually a better choice than more (assuming you're not talking about just 1 or 2), as the speed of a single query is fundamentally limited by the speed of a single processor. Even the most recent MySQL versions don't scale as well as some other RDBMSes across multiple cores due to internal mutex and semaphore contention. I run several 24 core servers and I would give my left arm to trade them in for half as many cores that are 1.5x faster.
Mar
26
accepted Vertical output from FreeTDS fisql
Mar
25
comment MySQL master-master replication between database running on 3 different server
I have some advice. Don't do it. You'll regret it later. This configuration is incredibly unstable and increases your points of failure.
Mar
23
answered Vertical output from FreeTDS fisql
Mar
23
asked Vertical output from FreeTDS fisql
Mar
8
answered [MySQL]multiple-masters single-slave
Feb
2
comment HA Setup for MySQL/mostly MyISAM Tables
Sorry, i misread.
Jan
30
comment MySQL query caching - what happens if Server runs out of RAM?
You should confirm that you are using the right definition of free memory. The line that you generally care about is memory available for apps which is the free column on the -/+ buffers cache line. Nearly everyone I talk to doesn't understand how Linux utilizes memory.
Jan
29
comment How to migrate from regular MySQL to Percona Server in production?
You can just install Percona Server over MySQL. It is binary compatible.
Jan
23
awarded  Organizer
Jan
23
revised High iowait on Amazon EC2 MySQL instance with EBS volume
formatting of config files, more appropriate tags
Jan
23
suggested approved edit on High iowait on Amazon EC2 MySQL instance with EBS volume
Jan
23
revised High iowait on Amazon EC2 MySQL instance with EBS volume
correction to galera/Percona Cluster statement
Jan
23
comment High iowait on Amazon EC2 MySQL instance with EBS volume
Thanks, Baron! I will remove that statement.
Jan
23
revised High iowait on Amazon EC2 MySQL instance with EBS volume
added 168 characters in body
Jan
23
revised High iowait on Amazon EC2 MySQL instance with EBS volume
cluster stuff
Jan
23
answered High iowait on Amazon EC2 MySQL instance with EBS volume
Jan
15
comment Restore MySQL Databases from File backups, not MySQL Export
A list of the filenames that you restored would be helpful.