Seattlegaucho's Page

"thank you both for your answers. the tables are big and the outage we can take is not that 'generous'. I'll post the results once I get them."

"I'm facing this situation to convert a table from MyISAM to InnoDB, no structure changes. Since I have enough space for both tables on disk, I'm thinking that the following procedure might save some time: 1. Create the new table w/…"

"... and if you drop indexes before the data load and recreate them after it's finished, chances are it'll be even faster. Not to mention that you can do the same using mysqldump with the right options to dump a single table. Then edit the…"

"Depending on the server, you may want to avoid leaving credentials in the ".bash_history". Do the following: 1. Create a file for each host (host_cred for the current examples) with the lines: user=username password=passwd 2. chmod the…"

"Great profile pic!"