8,096 reputation
1822
bio website
location Cincinnati, OH
age 43
visits member for 1 year, 7 months
seen 31 mins ago

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


31m
revised “Display width out of range for column” error when importing mysql 5.1 dump into 5.5
clarification
5h
answered “Display width out of range for column” error when importing mysql 5.1 dump into 5.5
6h
comment MySql query keep running for a long time
Can you show them, please?
6h
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
4
reviewed Close Every 30 minutes mysql stuck for 20-30 seconds
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”