8,121 reputation
1822
bio website
location Cincinnati, OH
age 43
visits member for 1 years, 7 months
seen 1 hour ago

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


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
2
answered MariaDB not caching any queries
Mar
1
reviewed Close Lookup table naming convention?
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
28
answered Mysql import table warning
Feb
27
reviewed Close unable to allocate 4064 bytes of shared memory
Feb
27
reviewed Close What are the possible risks involved in partitioning large database tables?
Feb
27
reviewed Leave Open How to know spid which is filling tempdb from temp table name in sybase
Feb
27
reviewed Close In MySQL, does the order of the columns in a WHERE clause affect query performance,why?
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.
Feb
26
comment Online Schema migration in MySQL : When to start?
Are the tables InnoDB? And, are you using MySQL 5.5?
Feb
25
answered XML dump of MySQL database don't include foreign key constraints. What can be the reason? sqldump(.sql) file list it
Feb
24
answered Amazon RDS - and binary log rotation
Feb
24
comment Upgrading from MySQL 5.5 to 5.6 - timestamp issue?
I'm working on a more authoritative confirmation, but this looks like a case sloppy documentation, not cause for concern on a routine upgrade. It looks like it is all about directly importing a tablespace, not importing a table, the former being a low-level operation you are not going to be needing for a routine upgrade.
Feb
24
comment Compressing Base64 Encoded Image in Database Field. Table Size too Large
Are you saying you are getting an error of "table size too large," or are you saying, "this table is larger than I want it to be?"
Feb
24
comment Issues with mysqldump after upgrade 5.5 -> 5.6
Add --verbose to the mysqldump options and see what you get in the error logs. This option doesn't change the dump files, but it writes some progress information to STDERR. You should, at a minimum, see what it is "trying" to do, written to the error logs.
Feb
22
comment How to recover a crashed MyISAM table which myisamchk couldn't recover?
Incidentally, you say you take backups by "stopping the database" ... define "stopping the database" please... that should not result in these errors for any reason I can think of.
Feb
22
comment How to recover a crashed MyISAM table which myisamchk couldn't recover?
Right, but I wanted to be certain you've monitored the free space as the process runs, such that you have confirmed it's not a case of... open temp file, unlink temp file, fill all available temp space stealthily by writing to open-but-unlinked file, crash, space allocated to open file is immediately freed by the system because the process holding it open has crashed...?