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

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


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 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.
Oct
11
comment MySQL Binlog Dump process stops after net_write_timeout
The version of mysqlbinlog shipped with 5.6 has a handy ability to "spoof" a slave connection to the master and stream the binlog at you in real time, and this should be an ideal test tool. mysqlbinlog -p --user='username with replication slave privilege' --base64-output=decode-rows --verbose --stop-never --host='db01-hostname-or-ip' --read-from-remote-server mysql-bin.001532 (current binlog). Run this actually on db01 pointing to db01, and on db02 pointing to db01, and also maybe from elsewhere on the network. It should reveal something interesting about which component is broken.
Oct
11
answered Calculating difference between consecutive timestamps. Error when i reach the hour mark
Oct
7
comment Create table on a Master - Master config avoiding replication
dev.mysql.com/doc/refman/5.6/en/set-sql-log-bin.html sql_log_bin is a session variable that defaults to 1. If you set it to 0 it disables binary logging of any statements you issue until you disconnect or set it back to 1. The application, here, is to allow you to alter the table without that individual statement getting replicated, because you want the servers to have a table that is identical other than the storage engine.
Oct
7
answered Create table on a Master - Master config avoiding replication
Oct
7
comment Log all table updates for all tables in MySQL
I'm not sure what you mean by "copied" databases.