8,051 reputation
1822
bio website
location Cincinnati, OH
age 43
visits member for 1 year, 7 months
seen yesterday

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


1d
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.
1d
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”
Apr
2
comment Amazon RDS mysqbinlog “Could not find first log file name in binary log index file”
Please don't post the same question here and on SO. stackoverflow.com/questions/22797278
Mar
14
reviewed Close How to run different MySQL-statements with parameters in a loop using Powershell 2.0?
Mar
14
reviewed Close Oracle RAC Vs SQL Server Cluster
Mar
14
reviewed Close Choosing a database for big data