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

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


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”
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 Oracle RAC Vs SQL Server Cluster
Mar
14
reviewed Close Choosing a database for big data
Mar
14
reviewed Close SQL statement slower on as400 console than from remote odbc
Mar
14
reviewed Close SQL Server 2008 R2: cannot attach database
Mar
14
reviewed Close DMV queries for capturing most frequently used queries and worst performing queries
Mar
14
reviewed Leave Open CentOS and Ubuntu differences with information_schema
Mar
14
comment CentOS and Ubuntu differences with information_schema
Yes, if you declare them in a way that the documentation specifically says will not work, then, strangely enough, it's not going to work: MySQL does not recognize or support “inline REFERENCES specifications” (as defined in the SQL standard) where the references are defined as part of the column specification. MySQL accepts REFERENCES clauses only when specified as part of a separate FOREIGN KEY specification. dev.mysql.com/doc/refman/5.6/en/create-table.html
Mar
14
comment MySQL backup breakes a table every time
That's a good catch. No matter where this script is run, it is dangerous and wrong and something will be deleted unexpectedly... but it seems like the /var/backup/mysql directory is still there, and that command, as shown, should remove it, no? Still, +1... at any rate, a backup simply would not remove a MyISAM tablespace in any circumstance I can think of, and I'd also note that the exit status of mysqldump is not being checked as it should be.
Mar
12
comment CentOS and Ubuntu differences with information_schema
SHOW CREATE TABLE will give you more useful information than DESCRIBE TABLE. I think @a_horse_with_no_name is onto something, there... It sounds a bit like one table might show ENGINE=InnoDB and the other ENGINE=MyISAM... If SELECT @@default_storage_engine; returns different values on the two machines, and the setup scripts aren't explicit in their table declarations, that could be the explanation.