Reputation
14,103
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
2 20 43
Newest
 Talkative
Impact
~1.1m people reached

Dec
10
comment Release MySQL Memory and Performance Tunning
You are tweaking far too many variables with this configuration. If you don't have a specific, objective reason for each of these entries, you should start with the defaults.
Dec
9
comment Why is MySQL 5.5 ignoring this index?
Also, don't select * unless you really need all the columns. This can also modify the query plan.
Dec
9
comment Why is MySQL 5.5 ignoring this index?
ALTER TABLE cba_device_log ADD KEY (device_id, device_time_ms); If there are a large number of device 1067 rows, the optimizer can conclude that the index will be more trouble than it's worth, but a more useful index, as I suggest here, might get more attention.
Dec
3
comment mysql ssl replication - fails while attempting to connect to master
Use the mysql command line client while logged in on the slave server to try connecting to the master using the same cert, key, and credentials. Replication uses an ordinary client connection from slave to master, so this is an effective approach that may tell you something useful.
Nov
27
answered Is DETERMINISTIC NO SQL function which returns the same value always a good alternative for using as a constant in MySQL?
Nov
20
comment Taking a mysqldump from a specific point in time
To clarify what @ypercube is saying, the servers do have to start with identical data from a fixed point in time, but as long as you know the binlog coordinates of a given dump of server A, and no logs have been purged, you can restore the dump elsewhere and play forward from there using master A's logs, however much later that may be... but identical data is essential.
Nov
17
answered How can I generate the code-containing comments like mysqldump?
Nov
8
answered Import MySQL table from a textfile to a remote host with compression
Nov
6
comment How to handle billions of rows in MySQL for biometric project?
Note "using MRR" in the output of EXPLAIN. Disable that optimization. dev.mysql.com/doc/refman/5.6/en/mrr-optimization.html
Nov
6
comment How to handle billions of rows in MySQL for biometric project?
I would make (dna_hash,animal_id) the pk, then no index needed to search by dna_hash and the space for the implicit pk is eliminated.
Nov
6
comment How to handle billions of rows in MySQL for biometric project?
A MEDIUMINT can only contain 8,388,607 unique values (or ~2x that if unsigned) so, if you have 20M rows... what's defined as the primary key?
Nov
2
comment Does mysql “lock” (no other process can take from it) the memory allocated to it?
Agreed. Oversimplification on my part.
Nov
2
comment Does mysql “lock” (no other process can take from it) the memory allocated to it?
Indeed. Usually mysql is not "crashing" but rather is being killed. dba.stackexchange.com/a/25083/11651 When this happens, it will try to restart itself, and usually will fail because all of the configured memory for the InnoDB buffer pool is allocated at startup, which won't work if that much memory is not available.
Oct
30
awarded  Enlightened
Oct
30
awarded  Nice Answer
Oct
26
comment To give a user all privileges except the 'Create user' privilege
Was the user created WITH GRANT OPTION?
Oct
23
awarded  Nice Answer
Oct
23
revised Is it possible to modify an existing trigger definition in MySQL?
New feature in alternative
Oct
17
answered Will a mysqldump ever break my database?
Oct
16
awarded  Enlightened