8,051 reputation
1822
bio website
location Cincinnati, OH
age 43
visits member for 1 year, 7 months
seen yesterday

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


2d
comment Mysql Master Offline
Actually, as long as the binlog where the slave last read is complete and not corrupt on the master, the slave will have no problem picking up where it left off, even if the master's binlog position has advanced or the log has rotated to a different binlog file, if all of the intermediate events on the master's binlogs are intact.
Apr
9
comment MariaDB : Larger innodb_buffer_pool_size causing SQL updates to be slower
Is the increased buffer pool size causing your insurance to start using swap space? That would be my first suspicion.
Apr
9
comment While Loops Don't Work in MySQL 5.6?
You haven't said whether you're doing this in a stored program (stored procedure, stored function, trigger, or event) but if not, then that's your first problem. You can't use loop constructs outside the context of stored programs. "SQL syntax errors popping up everywhere" is a bit too vague to diagnose.
Apr
2
comment MySQL Query Cache - what type of queue is used?
See also: dba.stackexchange.com/questions/33811/33880#33880
Apr
2
comment Amazon RDS mysqbinlog “Could not find first log file name in binary log index file”
You need to download the correct version of mysqlbinlog. It looks like you are using a version that ships with MySQL 5.5, not 5.6. dev.mysql.com/doc/refman/5.6/en/mysqlbinlog.html
Apr
2
comment Amazon RDS mysqbinlog “Could not find first log file name in binary log index file”
Please don't post the same question here and on SO. stackoverflow.com/questions/22797278
Mar
14
comment CentOS and Ubuntu differences with information_schema
Yes, if you declare them in a way that the documentation specifically says will not work, then, strangely enough, it's not going to work: MySQL does not recognize or support “inline REFERENCES specifications” (as defined in the SQL standard) where the references are defined as part of the column specification. MySQL accepts REFERENCES clauses only when specified as part of a separate FOREIGN KEY specification. dev.mysql.com/doc/refman/5.6/en/create-table.html
Mar
14
comment MySQL backup breakes a table every time
That's a good catch. No matter where this script is run, it is dangerous and wrong and something will be deleted unexpectedly... but it seems like the /var/backup/mysql directory is still there, and that command, as shown, should remove it, no? Still, +1... at any rate, a backup simply would not remove a MyISAM tablespace in any circumstance I can think of, and I'd also note that the exit status of mysqldump is not being checked as it should be.
Mar
12
comment CentOS and Ubuntu differences with information_schema
SHOW CREATE TABLE will give you more useful information than DESCRIBE TABLE. I think @a_horse_with_no_name is onto something, there... It sounds a bit like one table might show ENGINE=InnoDB and the other ENGINE=MyISAM... If SELECT @@default_storage_engine; returns different values on the two machines, and the setup scripts aren't explicit in their table declarations, that could be the explanation.
Mar
12
comment Implementing older version of mySQL on RH9
@ypercube on reflection, I think you are probably right. I may have misread "built" as "build" as though it were advice on what not do to, rather than what he hasn't personally tried.
Mar
11
comment Install/bootstrap mysql without name-based users
What value does /usr/local/mysql/bin/resolveip `hostname` | awk '/ /{print $6}' return when run on your system?
Mar
11
comment What tool do I use to administer MySql?
I voted down because the question was "Which tool provided by MySQL," which I interpreted as "Which tool provided by Oracle," and this answer does not answer that question. If the question had, instead, been "What is a good tool for administering MySQL" then we would need to close the question as off-topic, primarily opinion based, or off-topic, shopping list question. MySQL Server is great ( MariaDB and Percona Server, too) but I personally think MySQL Workbench is a horrible, unstable, ill-conceived piece of dreadful ugly bloatware that Oracle should be ashamed of and nobody should use.
Mar
11
comment MySQL 5.5 to 5.6 Upgrade. Will data remain the same?
True, except for the system tables, where there are structural changes, but there should be no data loss. Also, read the upgrade guide and all of the release notes for every release of MySQL 5.6 to verify that there are no incompatible changes that may cause issues if your application is relying on some behaviors of older versions that could have changed.
Mar
9
comment MariaDB Galera Cluster
Did you change wsrep_sst_auth on both machines, or just one? I don't think server X's setting being wrong will stop X from connecting to and synching from Y... I think X's setting being wrong will stop Y (or any other node) from synching from X... the donor node's setting is relevant with innobackupex, not the joining node.
Mar
9
comment mysterious load on server due to mysql
@JensW. makes a very good point. Verifying the RAID array would not only potentially make performance terrible, it could also give the illusion that MySQL was the cause when in fact it's only a symptom of the impaired I/O performance. Until the storage array is in a fully normal state, with everything it displays being correctly understood, tinkering with MySQL will be a waste of time.
Mar
7
comment Multi-master + slaves replication in MySQL
@no6 if M1 sends an update to M2, M2 technically will send the update back to M1, because it has to -- binlogs are continuous streams of data, and the same stream is sent to all slaves of a given master -- but when M1 realizes that it was the originator of the event (as it can see from the server_id value of the binlog event) M1's slave IO_thread will discard the event and not write it to M1's relay log, thus the loop is broken when the event arrives back at the originating server. See sql/rpl_slave.cc in the source files if you are curious as to the implementation details.
Mar
5
comment Can someone explain why left joining two views in mysql is so slow?
@a_horse_with_no_name no, it doesn't. This answer is incorrect in that regard. If the MERGE algorithm can be used to process the view, the indexes on the underlying tables can and will be used. Only if the view definition explicitly uses the TEMPTABLE algorithm or the view contains functionality that implicitly requires a temporary table, then the view results will be materialized into a temp table. dev.mysql.com/doc/refman/5.6/en/view-algorithms.html
Mar
4
comment MySQL import low use of resources
Are you running the import process on the server, itself, or remotely? Are you using the mysql command line client, or something else?
Mar
1
comment Mysql import table warning
Don't remove the things that look like comments -- they are not comments. /*!nnnnn */ tells the server "execute the enclosed statement only if you are MySQLversion n.nn.nn or higher." dev.mysql.com/doc/refman/5.6/en/comments.html
Feb
26
comment Is there a more efficient way of using a match score in MySQL full text search?
@GhostGambler your answer is almost correct, but OP's example query is undoing this optimization. You don't want to explicitly ORDER BY ... DESC because the server is already doing this ordering when you specify MATCH twice as the documentation indicates. If you also explicitly order by the match, as is done in the original question, the query plan changes to include Using filesort... which would cause unnecessary additional overhead because the optimizer takes the request literally and re-sorts an already-sorted result.