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

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


16h
comment How to change table with innodb/myisam engine to federated
@tombom the federated storage engine absolutely does support indexes, and in fact, they're critical for good performance... but they work in a very unconventional way. If FEDERATED doesn't know about a useful index for a given query, it won't send a WHERE clause in the remote query, and it will fetch the entire table and scan it locally. It usually makes sense to declare indexes on the federated table that don't even exist on the real table, so that it won't do this.
16h
answered Using concat inside a stored procedure parameters
16h
answered create federated copy of a table?
1d
revised MySQLfabric — Manage setup problem
cleanup/readability
1d
comment Returning true or false in a custom function
Note that if (the_nxt(44) = true) will never be true, because the_nxt() returns VARCHAR 'true' instead of the literal value TRUE (which is the integer 1)... and the string 'true' != the integer 1 (true, unquoted). A more correct and less error-prone solution would be for the function to return a TINYINT TRUE or FALSE and test whether the_nxt(44) IS TRUE (not =).
1d
comment Workaround to avoid read-only table locking during execution of MySql OPTIMIZE command
Are you sure you really need to optimize the table weekly? The excess space should level itself out over time if you leave the table alone. What kind of scale/size and what amount of reclaimable space are you dealing with?
Oct
20
comment Dealing with Mysql Replication and Functions
On the other hand, the number of read-only slaves you can deploy is virtually unlimited, since slaves can cascade from other slaves, as well as from the master.
Oct
20
comment Dealing with Mysql Replication and Functions
@jcho360 there's not really a meaningful limit. You'd have to stay below 255 masters to avoid collisions in UUID_SHORT() and below 65,535 masters to avoid problems with auto_increment_offset and _increment but those are all unreasonably large numbers of master servers. Avoiding consistency issues becomes almost exponentially complex as master server count rises. If you need more than 2, look at Galera in MariaDB or Percona server, both MySQL compatible, for synchronous replication.
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 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