8,825 reputation
1923
bio website
location Cincinnati, OH
age 43
visits member for 1 year, 11 months
seen 15 hours ago

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


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.
Apr
15
answered Mysql Master Offline
Apr
9
comment MariaDB : Larger innodb_buffer_pool_size causing SQL updates to be slower
Is the increased buffer pool size causing your insurance to start using swap space? That would be my first suspicion.
Apr
9
comment While Loops Don't Work in MySQL 5.6?
You haven't said whether you're doing this in a stored program (stored procedure, stored function, trigger, or event) but if not, then that's your first problem. You can't use loop constructs outside the context of stored programs. "SQL syntax errors popping up everywhere" is a bit too vague to diagnose.
Apr
4
reviewed Close What is wrong with this a MySQL 5.6 procedure definition? Use a variable for table name