172 reputation
110
bio website
location
age
visits member for 1 year, 11 months
seen Aug 29 at 0:31

Oct
15
awarded  Popular Question
Sep
5
awarded  Popular Question
Aug
28
awarded  Teacher
Aug
6
comment Mysql query with LIMIT much slower under RDS (5.6) than old 5.1 system
Yes, but how come it wasn't a problem previously?
Aug
6
revised Mysql query with LIMIT much slower under RDS (5.6) than old 5.1 system
deleted 65 characters in body
Aug
6
asked Mysql query with LIMIT much slower under RDS (5.6) than old 5.1 system
Jul
11
accepted Are there benefits to using more than 4 CPUs for MySQL?
Jul
11
comment Are there benefits to using more than 4 CPUs for MySQL?
The front-end application is web-based, and we are seeing periods of 100% CPU, but it sounds like we won't get much benefit from going from 4 to 8 CPUs.
Jul
10
asked Are there benefits to using more than 4 CPUs for MySQL?
Jun
27
accepted Upgrade mysql from 5.0 to 5.5 in master-master configuration leads to broken replication
Jun
27
comment Upgrade mysql from 5.0 to 5.5 in master-master configuration leads to broken replication
That seems to have helped - I wondering why with a 5.0.x system it wasn't need, but we started seeing errors on the 5.5 system?
Jun
26
comment Upgrade mysql from 5.0 to 5.5 in master-master configuration leads to broken replication
Yes, it's all MyISAM.
Jun
26
asked Upgrade mysql from 5.0 to 5.5 in master-master configuration leads to broken replication
Jun
9
comment Mysql replication is enabled but stuck at “waiting for binlog to be updated”
Let us continue this discussion in chat.
Jun
9
awarded  Commentator
Jun
9
comment Mysql replication is enabled but stuck at “waiting for binlog to be updated”
After the start/stop of the slave, the relay_log_file has changed from 00005 to .00006, and relay_log_space has changed, put it's still not getting new data. I tried stopping the slave, adding replicate-do-db=mydbname, then starting mysqld again, but that didn't change. The slave user on master has GRANT REPLICATION SLAVE ON . TO 'xxx'@'ip' IDENTIFIED BY PASSWORD '...'
Jun
9
comment Mysql replication is enabled but stuck at “waiting for binlog to be updated”
Master is redhat, slave is centOS.
Jun
9
comment Mysql replication is enabled but stuck at “waiting for binlog to be updated”
The master is getting new data, but none of those 3 values is changing. The master is a 5.1 db while the slave is 5.5.
Jun
9
asked Mysql replication is enabled but stuck at “waiting for binlog to be updated”
Apr
28
comment How can I determine how many IOPs I need for my AWS RDS database?
BTW, as a followup to this: we set up a 300GB database, and that meant a minimum of 1000 IOPS. After about 6 months live on RDS we have been 0 incidents due to I/O issues. Probably overkill, but as close to fire & forget as you can get.