8,540 reputation
1923
bio website
location Cincinnati, OH
age 43
visits member for 1 year, 10 months
seen 4 hours ago

If you question or otherwise fail to recognize the superiority of the relational model... you're doing it wrong.


Jun
25
answered mysqld constant CPU usage when absolutly nothing is connected and no queries
Jun
20
comment Unable to load innodb log file settings from my.cnf
Take a look at the output from $ /Applications/MAMP/Library/bin/mysqld --help --verbose | grep -A 2 ^Default
Jun
4
answered Cannot execute statement: impossible to write to binary log?
May
27
comment Table Not Created On All MySQL Masters
If log_slave_updates is not enabled in any of your my.cnf files, then the real question is not why M2 is wrong. T1 was created separately on M1 and M3 (or why is there data on M3, which you don't show inserting it on M1?). Multi-master requires log_slave_updates on every server.
May
15
comment Move MySQL database to another server
that is true, transportable tablespaces was introduced in 5.6. It's important to note that it is a somewhat more delicate operation for InnoDB.
May
9
comment MySQL Seconds behind Master fluctuation
Does running FLUSH LOGS; trigger this behavior?
May
9
comment MySQL Seconds behind Master fluctuation
What are your server IDs and what versions are they running?
May
9
comment Move MySQL database to another server
Copying the data files is only valid for MyISAM tables.
May
9
answered MySQL - HDD size
May
9
comment MySQL Seconds behind Master fluctuation
Does SELECT NOW(); give you the same answer on all servers? This usually means your clocks disagree.
May
6
comment MySQL Replication : Duplicate entries - SQL_SLAVE_SKIP_COUNTER or delete row?
This is very bad advice. You "can" but you should not. Correctly configured replication does not encounter errors. If you configure the slave to ignore errors, you are only masking the real problem.
May
1
reviewed Close SQL Server Projects in Visual Studio 2013
May
1
comment RDS MySQL instance is unavailable, probably during binlog rotation
This wouldn't happen to coincide with your configured RDS maintenance window would it?
May
1
comment Convert this Ruby function into MySQL Function?
User-defined functions are not written in SQL, they are written in C. Perhaps you are thinking of stored functions? In any event, you'll need to make some effort, rather than ask us to write your code for you.
Apr
25
comment Can't run subqueries on my server (MySQL)
The version information you've posted is the version of the client, not the server. SELECT @@VERSION; to confirm the version numbers of your local machine and the server; different versions may optimize the queries very differently. Try EXPLAIN SELECT... to see the query plans. SHOW PROCESSLIST; from another connection to see what the server has to say about what it's doing when it "hangs." Also, do the systems both have a similar number of rows in the two tables?
Apr
23
revised “Display width out of range for column” error when importing mysql 5.1 dump into 5.5
clarification
Apr
23
answered “Display width out of range for column” error when importing mysql 5.1 dump into 5.5
Apr
23
comment MySql query keep running for a long time
Can you show them, please?
Apr
23
answered Mysql tar ball installation
Apr
15
comment Mysql Master Offline
Actually, as long as the binlog where the slave last read is complete and not corrupt on the master, the slave will have no problem picking up where it left off, even if the master's binlog position has advanced or the log has rotated to a different binlog file, if all of the intermediate events on the master's binlogs are intact.