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

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


Oct
20
comment MySQL: #126 - Incorrect key file for table '/tmp/#sql_9dc_1.MYI'; try to repair it
Try observing your free disk space with df -k while the view is opening. If the view needs to build a temporary table while it's opening, you could be running out of free space. The space will be used up, then freed again, as the space consumed by the failed temporary table creation attempt will be freed almost immediately when the error is returned, if this is your problem.
Oct
17
comment Rows are not getting deleted from MySQL Table
On the InnoDB server, SELECT @@global.autocommit;... shows 1 or 0? Is this a new problem, or did you have a working system that stopped working? Can you update or insert from the Federated side?
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 MySQL keeps inserting new rows automatically
Oct
16
reviewed Approve
Oct
16
reviewed Approve
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.