…TABLE IF EXISTS `dim_airport`; CREATE TABLE `dim_…parse time). $ echo “select count(*) from ontime_fact;” …results cd shard-query/ $ ./run_query < queries.sql | tee raw |./pivot_results…name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table…
Post: Living with backups
November 6, 2008 By 28 Comments
…and this is especially true for MyISAM tables which have dedicated buffers only to store…copy operation from MySQL data directory will result in a total disaster after MySQL stops…name of the new scheduler: # for device in `ls /sys/block` ; do if [ -f /sys/block/$device/queue/scheduler ] ; then \ echo…
