Reputation
4,320
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
6 16
Newest
 Nice Answer
Impact
~247k people reached

  • 0 posts edited
  • 0 helpful flags
  • 78 votes cast
Nov
19
comment MySQL relay log rotates too soon and too often
Also kill -HUP makes for an implicit FLUSH LOGS. Check if you have a crontab entry that does that
Nov
5
answered Truncating and inserting in a safe transaction on MySQL
Nov
5
comment Truncating and inserting in a safe transaction on MySQL
This leaves the database in a state where mytable does not exist. Use a RENAME table statement instead, which allows for two atomic renames
Oct
3
awarded  Nice Answer
Sep
28
revised Can I time out my scripted “FLUSH TABLES WITH READ LOCK;”?
fixed markdown
Sep
24
awarded  Autobiographer
Aug
6
answered SHOW SLAVE HOSTS shows incorrect output
Aug
2
answered Mysql dump with View dependent on user
Jul
12
awarded  Yearling
Jul
7
awarded  Revival
Jun
9
awarded  Enlightened
Jun
9
awarded  Nice Answer
Jun
4
comment How To Prevent Replication Failure
To skip a single, known query, issue: SET GLOBAL SQL_SLAVE_SKIP_COUNTER:=1; START SLAVE;
Apr
26
answered Are relay logs necessary for replication?
Apr
19
comment Will redirecting queries to dev/null warm up indexes?
@RolandoMySQLDBA are you using 5.6 yourself in production?
Apr
19
comment Will redirecting queries to dev/null warm up indexes?
That doesn't make sense, either.
Apr
18
answered Will redirecting queries to dev/null warm up indexes?
Mar
27
reviewed Approve mysqldump dump file size
Mar
24
comment How do I access a result set from a StoredProcedure… in another StoredProcedure
@a_horse_with_no_name is right; tables are the only way to pass non-primitive results, unless you're into ugly string concatenation & parsing (as in aggregating the entire result set into one long string).
Mar
22
comment Linux command to kill all MySQL sessions from a specific User?
When piping back to mysql, use --force, since a KILL command will fail if by change the connection has already terminated. Without --force this will abort all following KILL commands.