9,092 reputation
11025
bio website
location Cincinnati, OH
age 43
visits member for 2 years
seen 9 hours ago

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


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
Apr
4
reviewed Leave Open Three databases : one instance or three?
Apr
4
reviewed Leave Open How to set isolation to SERIALIZABLE DEFERRABLE for a whole Postgresql database?
Apr
4
reviewed Close SQL Server hardware configuration: Best Practices
Apr
4
reviewed Close Every 30 minutes mysql stuck for 20-30 seconds
Apr
4
reviewed Close How to distribute a given database between multiple DBMS on a LAN?
Apr
3
answered Is it possible to recover from a LOST_EVENTS incident from an RDS read replica?
Apr
2
revised Qcache_free_memory not full yet I get alot of Qcache_lowmem_prunes
added query-cache tag
Apr
2
comment MySQL Query Cache - what type of queue is used?
See also: dba.stackexchange.com/questions/33811/33880#33880
Apr
2
comment Amazon RDS mysqbinlog “Could not find first log file name in binary log index file”
You need to download the correct version of mysqlbinlog. It looks like you are using a version that ships with MySQL 5.5, not 5.6. dev.mysql.com/doc/refman/5.6/en/mysqlbinlog.html
Apr
2
answered Amazon RDS mysqbinlog “Could not find first log file name in binary log index file”