Reputation
13,534
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 18 39
Newest
 Mortarboard
Impact
~969k people reached

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
Oct
16
revised Moving an ibd file temporarily to free up disk space
spelling
Oct
16
awarded  Nice Answer
Oct
16
answered Moving an ibd file temporarily to free up disk space
Oct
12
comment Mysql server does not start if binary logging is disabled
@user77522 the post you cited was never accepted as an answer, so we don't know whether it worked. In 5.6, GTID mode is optional. Without it enabled, this should work, but not with it enabled. And don't think about disabling it as a workaround. Enable multi-threaded replication, instead, which almost requires GTIDs: dev.mysql.com/tech-resources/articles/… (It doesn't technically require them, but it's much more straightforward).
Oct
11
answered Remote access from domain and other pages on that domain
Oct
9
comment How to auto populate a foreign table?
If you are just entering a query, what do you expect '$this->username' to be? There is no $this object in SQL. I assume you must be talking about a programming language, which you haven't mentioned, and you also have not mentioned the error message you should be seeing, something like "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM userinfo'"