238 reputation
16
bio website
location
age
visits member for 1 year, 3 months
seen Apr 16 at 11:53

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 ;)
May
24
comment Mysql settings for query_cache_min_res_unit
Database tuning involves some king of dark magic. There is no "correct" value for any setting (otherwise the MySQL folks would have made the engine tune itself automagically). It is up to you to find the right setting for your specific database.
Apr
29
awarded  Supporter
Apr
17
comment search for something in the first 1000 records in the table
+1 for spotting that a LIMIT clause without an ORDER BY clause has little meaning.