263 reputation
26
bio website
location
age
visits member for 1 year, 9 months
seen 18 hours ago

Sep
11
awarded  Necromancer
May
19
revised Does MySQL guarantee atomic upgrade from read lock to write lock?
fixing typo
May
19
answered Does MySQL guarantee atomic upgrade from read lock to write lock?
Mar
4
awarded  Commentator
Mar
4
comment MySQL: how to copy a database from one server to another without export / import
The question you linked is relevant to you need, please read the answers carefully. If it really isn't, then your question is unclear, please explain carefully why these solutions did not adress your needs. Also, please read the FAQ carefully, this question is off-topic on StackOverflow.
Jan
17
awarded  Yearling
Jul
5
comment MySQL Incremental Backup (cron job): “sh: mysqlbackup: command not found”
Please define "not working".
Jun
30
comment “Mysql2::Error: Table doesn't exist” after power outtage
Sorry for breaking the bad news, you lost your data. I hope you have a recent backup. This is very unusual, though. Are you 100% the database was full just before the power outage? Did you browse your site in the few minutes preceding the crash? What I mean is this could be a coincidence, the data may have disappeared some time ago, but you just realised it today.
Jun
30
comment “Mysql2::Error: Table doesn't exist” after power outtage
No such table, or no tables at all? And just to make sure, the power went out locally, when your site was running from your local machine, right?
Jun
22
answered Is this a normal set of MySQL privileges?
Jun
22
comment How to safely change MySQL innodb variable 'innodb_log_file_size'?
This is not an a "update". These manual pages have long existed. I always recommend first-hand information from the manual (one of the best manuals out there) rather than reinventing the wheel and duplicating information (which is something we DBA's hate the most).
Jun
18
answered How to safely change MySQL innodb variable 'innodb_log_file_size'?
Jun
18
comment how important are mysql's innodb logs?
@PeeyushKushwaha Oh and in case you want to resize your redo log, please make sure to follow this official procedure, and not the dubious shortcuts that you may stumble upon elsewhere.
Jun
18
awarded  Critic
Jun
18
revised how important are mysql's innodb logs?
the redo log is on disk
Jun
18
comment how important are mysql's innodb logs?
Thanks Derek Downey, I have detailed the role of the redo log. @PeeyushKushwaha log_file_size won't have an impact on memory usage, the redo log is stored on the disk (in innodb_data_home_dir). innodb_log_buffer_size will.
Jun
18
awarded  Editor
Jun
18
revised how important are mysql's innodb logs?
more info about the role of the redo log
Jun
17
answered how important are mysql's innodb logs?
Jun
15
comment How to automate insertion of new column in Mysql table?
@Kaii I prefered the original version ;)