157 reputation
17
bio website
location
age
visits member for 1 year, 8 months
seen 7 hours ago

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.
Apr
27
awarded  Notable Question
Apr
23
accepted “Display width out of range for column” error when importing mysql 5.1 dump into 5.5
Apr
17
revised “Display width out of range for column” error when importing mysql 5.1 dump into 5.5
added 75 characters in body
Apr
17
asked “Display width out of range for column” error when importing mysql 5.1 dump into 5.5
Apr
2
asked Is it possible to recover from a LOST_EVENTS incident from an RDS read replica?
Feb
13
comment How can I replicate some tables without transferring the entire log?
No, I never did find an easy way without invoking an intermediate to filter the tables.