Reputation
323
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 3 14
Impact
~41k people reached

  • 0 posts edited
  • 0 helpful flags
  • 18 votes cast
Mar
30
comment Why is DROP DATABASE taking so long? (MySQL)
Very interesting. @RolandoMySQLDBA have you tried this yet? If this works so well, I wonder why MySQL does not set permissions like this automatically.
Mar
16
revised Does it make sense to create index with all columns included
added 142 characters in body
Mar
16
answered Does it make sense to create index with all columns included
Feb
3
asked Does mysql's `SHOW PROCESSLIST` appreciably slow down other queries?
Jan
21
comment Fast copy/rename database, not mysqldump
@jkavalik they mention faster restore time, so that could be a possible solution for me as well. I didn't realize Percona had this free products.
Jan
21
comment Fast copy/rename database, not mysqldump
@Aleksandrus mysqlhotcopy is only for MyISAM, and I'm using nearly all InnoDb. The user's other suggestion seems like it has potential, although the tools he mentions are completely new to me.
Jan
21
asked Fast copy/rename database, not mysqldump
Jan
8
answered I want to set lower_case_variables to 1 but I'm unable to locate my.cnf
Jan
8
comment I want to set lower_case_variables to 1 but I'm unable to locate my.cnf
stackoverflow.com/a/2485758/631764
Aug
28
awarded  Self-Learner
Aug
25
awarded  Autobiographer
Aug
3
awarded  Caucus
Jun
17
awarded  Nice Question
Jun
16
comment Should innodb_buffer_pool_size be much larger than the innodb_buffer_pool_bytes_data?
@RickJames !!!! I could do that. Should I put them in my question, or make use a paste site?
Jun
16
asked Should innodb_buffer_pool_size be much larger than the innodb_buffer_pool_bytes_data?
Jun
13
comment How to properly kill MySQL?
In MySQL 5.6, I wonder if the TCP method lets mysql save its buffer pool before close, or if it is lost. The buffer pool save/load options in 5.6 are incredibly valuable. Waiting 10 minutes for MySQL to shutdown is annoying, but if the TCP method doesn't save the buffer pool then it might still be worth waiting.
Apr
17
comment Are certain environment variables required for mysql login-path?
So, in a sense, you are right that mysqldump needs a user and password, but the --login-path is supposed to supply it and it's not working in the cron.
Apr
17
comment Are certain environment variables required for mysql login-path?
Actually, I have to clarify the error. The user that is denied is the system "linuxuser", but the user specified in --login-path=local directive would be a mysql user and the password IS specified there. When I run the script from the terminal, the mysql user/password are passed in, but it seems like they are not when run from CRON. So mysql, I think, defaults to the current system user ("linuxuser" is specified in the cron), and no password is supplied. --login-path is not working in the cron.
Apr
17
comment Are certain environment variables required for mysql login-path?
mysqldump needs -u and -p for some mysql "user". Um, no it doesn't? As I said, the script works when run from the command line. It only fails in cron. Are you familiar with --login-path=local ?
Apr
17
asked Are certain environment variables required for mysql login-path?