9,386 reputation
11025
bio website
location Cincinnati, OH
age 43
visits member for 2 years, 1 month
seen 12 hours ago

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


Oct
17
comment MySQL has gone away with two connections
SET GLOBAL LOG_WARNINGS = 2; and try again? Then check the MySQL error log...
Oct
16
reviewed Close SQLDependency equivalent for MySQL
Oct
16
reviewed Close MySQL keeps inserting new rows automatically
Oct
16
reviewed Approve suggested edit on
Oct
16
reviewed Approve suggested edit on
Oct
16
answered Dealing with Mysql Replication and Functions
Oct
13
comment MySQL Binlog Dump process stops after net_write_timeout
Interesting. But mysql client run on db01 connecting to db01 is fine, right? Also, connections from other machines to db01 using mysql client are fine, too? Have you tried connecting to db01 from elsewhere with mysqlbinlog? Are the two server machines on the same subnet, same lan, or...?
Oct
13
answered MySql MBRCONTAINS not accurate
Oct
13
comment returning the number of columns in a row that are zero in mysql
@Kondybas ... "returns NOT NULL if operand is NULL" ...? Negating null is still null.
Oct
12
reviewed Close Saas MySQL Multiple Databases or One Database
Oct
12
reviewed Close Get player count per match on a matchmaking server
Oct
11
comment MySQL 5.6 replication causes 'waiting for table lock'
SELECT @@BINLOG_FORMAT; on the master. If it's STATEMENT, consider changing to ROW or perhaps MIXED.
Oct
11
comment Sync 8 tables of differents databases on same server
@Jacques-AlexandreBossu I inadvertently omitted the keyword AS before SELECT in the view definition. Updated.
Oct
11
revised Sync 8 tables of differents databases on same server
missing keyword
Oct
11
answered Upgrading from MySQL 5.1.37 to MySQL 5.1.73
Oct
11
reviewed Close Split date/time range into day ranges
Oct
11
answered Sync 8 tables of differents databases on same server
Oct
11
reviewed Close Conditionally updating the columns PHP/MySQL
Oct
11
reviewed Close Very high load avg for MySQL database
Oct
11
comment MySQL Binlog Dump process stops after net_write_timeout
Also, SET GLOBAL LOG_WARNINGS = 2; everywhere, if it isn't, for some slightly increased verbosity in the MySQL error log.