524 reputation
212
bio website nonparametrics.com
location Portland, OR
age 31
visits member for 3 years, 2 months
seen 22 hours ago

Bryan has years of experience in business and computer programming as well as those rare visionary qualities that make a great entrepreneur. He is an accomplished executive and leader with a passion for fostering new business growth in the United States and building a strong economy. His current business endeavor can be found at www.pamiris.com.


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 suggested 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)
Dec
15
asked What are some good methods of structuring a MySQL audit trail to be both immutable, and perform well for usage?
Dec
15
revised MySQL conversion from float (10,2) to fixed(10,2)
added 304 characters in body
Dec
15
comment MySQL conversion from float (10,2) to fixed(10,2)
I'm not sure if this has performance implications on a live system vs. Rolando's method, but it was plenty fast under our load
Dec
15
revised MySQL conversion from float (10,2) to fixed(10,2)
edited body