Aaron Brown
  • Member for 10 years, 3 months
  • Last seen more than a month ago
ACID-compliance of MySQL master-master replication?
Accepted answer
1 votes

MySQL replication is not ACID compliant since it is asynchronous. There are no guarantees that queries executed on one server will be committed on the other. In fact, the master doesn't even know ...

View answer
Rows already DELETEd on MySQL slave; How to DELETE on master?
1 votes

Just run the DELETEs on the master. Worst case - it will execute and be a no-op on the slave. I recommend against disabling binary logging for this on the master, as it will prevent you from using ...

View answer
Adding an index very slow...is there a mysql cmd to get an ETA or show progress?
1 votes

There is no reliable way to see progress of an index creation. If you had innodb-file-per-table on, you could get some indication by looking at the temporary .ibd file that is being created in the ...

View answer
How to convert mysql to postgresql?
1 votes

I am throwing this out there, having never tried it, but Tungesten Replicator may do what you want. It's primarily a replication tool, but I think it may have a bootstrapping process that may help ...

View answer
MySQL Performance Monitoring
1 votes

I wrote a daemon that logs the results of SHOW GLOBAL STATUS and SHOW MUTEX STATUS every x seconds to graphite or a CSV. You may find it useful: https://github.com/9minutesnooze/mysampler. It can ...

View answer
Resetting MySQL Password
1 votes

Your innodb_log_file_size is set incorrectly, so InnoDB isn't starting up. You haven't even gotten to the part where the password reset would matter.

View answer
How to migrate from MySql to HSQLDB?
0 votes

mysqldump -d --all-databases -u root -p > schema.sql will dump your schema without data. Use man mysqldump and mysqldump -h to see what other options are available. two questions, though... Why? ...

View answer
MySQL said "InnoDB: Initializing buffer pool, size = 128.0M", does it mean it is using 128MB RAM?
0 votes

MySQL allocates the memory for the bufferpool at startup, but only actually occupies the memory as needed. This means that the MySQL will not start if it cannot grab ahold of 128M of RAM, but your ...

View answer
MySQL aggregate anomaly
0 votes

Without seeing your exact results, I'm not sure that I understand what the problem is. I tried this on a random table on my machine and got back the results that I expected. mysql> select count(*)...

View answer
1 2
3