Reputation
546
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
3 13
Impact
~23k people reached

Jan
30
awarded  Notable Question
Oct
14
revised Help on MySQL joins
Punctuation.
Oct
14
suggested approved edit on Help on MySQL joins
Sep
30
awarded  Explainer
Jul
2
awarded  Curious
Feb
13
awarded  Popular Question
Nov
11
awarded  Popular Question
Jul
30
awarded  Popular Question
May
25
awarded  Yearling
Feb
28
comment Is there a tuning parameter for MySQL that allows you to set an on-disk gap between non-sequential primary keys?
Why is there such a dramatic performance degradation for using non-sequential keys, then?
Feb
27
answered How to get non repeat results
Feb
27
asked Is there a tuning parameter for MySQL that allows you to set an on-disk gap between non-sequential primary keys?
Feb
9
comment Improve the performance and stability of a MySQL server
Shoot Percona an email, and they would be happy to tell you about the options they have. Much cheaper than hiring on onsite DBA until you are scaled up.
Feb
9
comment Improve the performance and stability of a MySQL server
Sorry--just saw this. Percona and Maria are forks of MySql, so they have a ton in common. Percona has extended InnoDB, so you can snap-in convert from InnoDB to XtraDB, and Percona does provide a lot of value added services.
Dec
15
comment Improve the performance and stability of a MySQL server
Are you using the vanilla MySQL binaries? You may also want to look at Percona, or Maria; both are drop in binary compatible, and both have some performance benefits. Percona specifically deals with several locking issues, which could be contributing.
Dec
14
revised Improve the performance and stability of a MySQL server
Lots of grammar....
Dec
14
answered Improve the performance and stability of a MySQL server
Dec
14
suggested approved edit on Improve the performance and stability of a MySQL server
May
25
awarded  Yearling
Dec
20
accepted MySQL conversion from float (10,2) to fixed(10,2)