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

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


11h
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 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 Creating a trigger, function and procedure for this problem
Oct
12
reviewed Close Saas MySQL Multiple Databases or One Database
Oct
12
reviewed Close Data type for a interval of time
Oct
12
reviewed Close Get player count per match on a matchmaking server
Oct
12
reviewed Close What the best monitor for MariaDB Galera Cluster?
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