162 reputation
17
bio website
location
age
visits member for 1 year, 9 months
seen Aug 14 at 18:29

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.
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