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

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


1d
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.
1d
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.
2d
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
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
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
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
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
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
comment Log all table updates for all tables in MySQL
I'm not sure what you mean by "copied" databases.
Oct
6
comment Log all table updates for all tables in MySQL
Have you considered the binary log as a source?
Oct
6
comment MySQL - Checksum won't match between master and slave hosts despite dumping and reloading the table
Granted, the other question does not have a satisfactory answer at all, since the change that occurred between 4.1 and 5.0 should not be impacting you, now... but the question is still the same. I've long-suspected a latent bug in the way CHECKSUM TABLE works. One thing that might be worth trying is doing an OPTIMIZE TABLE on the master to check and see if the checksum remains the same there after the table is rebuilt.
Oct
5
comment How to handle too many instances of multiple tables?
Are these tables MyISAM? Are you experiencing a performance issue, now? Are you seeing errors?
Oct
5
comment mysql service takes too much memory
"Persistent connections also cause high CPU usage" ... "may cause sockets to wait for requests, which causes over usage of CPU" ... sorry, these statements are just not accurate when applied to MySQL.
Oct
1
comment MySQL 5.6: explicit_defaults_for_timestamp
You need to compare the table definitions among the servers with SHOW CREATE TABLE and then also SELECT @@SQL_MODE;. When replicating from 5.5 to 5.6, cascaded or not, setting explicit_defaults_for_timestamp to 1 was probably the wrong choice, and your table definitions may be different, on at least one of the replicas, since the way CREATE TABLE statements are interpreted is what that variable modifies. Please update the question with what you find.
Sep
29
comment MySQL dies when trying to access a specific database
"Lost connection to MySQL Server..." followed by can't connect message ending in (111) almost certainly means that whatever is happening is actually crashing the server (typically, it will recover and become available on its own, depending on the nature of the crash). Please check the MySQL server's error log and update your question based on what you find there.
Sep
18
comment MySQL - Database has huge overhead but tables don't
What process did you use to recreate the tables?