With MariaDB, you can have this process done faster. Here's the settings that you'll need to set :
myisam_max_sort_file_size
myisam_sort_buffer_size
Ensure these 2 variables are bigger than each index that's going to be created. In a server with 128 GB of RAM, I set this to 50 GB. Indexes are always created very quickly 🙂
Otherwise, the index creation process will show as "Repair with keycache". This is really slow.Â
When these 2 variables are set with big enough numbers, then you'll see "Repair by sorting", or, when you set the following variable : "Repair with X threads"Â
myisam_repair_threads
When this variable is bigger than 1, MariaDB will utilize more than 1 cpu core in the index creation process.Â
The bigger the number, more cpu core may be used, so it'll be potentially faster. However, this will result in more usage of cpu (of course) and RAM.Â
NOTE: using this setting in MySQL is not advised, there are still bugs :Â http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_myisam_repair_threads
Hope this helps someone else.
Embedded Link
MySQL :: MySQL 5.7 Reference Manual :: 5.1.4 Server System Variables
The MySQL server maintains many system variables that indicate how it is configured. Each system variable has a default value. System variables can be set at server startup using options on the command line or in an option file. Most of them can be changed dynamically while the server is running …
Post imported by Google+Blog for WordPress.
kenapa bahasanya harus bahasa inggris gan ?
saya kurang ngerti nih hehe
sukses selalu yah gan 😀
Sukses ya mas harry
Artikel Anda sangat berkualitas dan saya mendapatkan banyak pengetahuan dalam setiap artikel yang Anda posting, selalu up to date dan terus posting begitu banyak saya ambil keuntungan dari artikel Anda terima kasih dan Salam.
info yang sangat berguna. salam kenal sukses selalu 🙂
WAH KEREN BEUTH WKWKWKWK
Wow this information is very interisting.
thank’s Bro.
Way cool! Some extremely valid points! I appreciate you writing this article and the rest of the website is very good.
terimakasih gan informasinya sangat bermanfaat
infonya bagus gan
Terimaksih telah berbagi infonya, info yang sangat bagus . sukses selalu untuk info and websitenya and be the best to the next info..
terimakasih atsa info nya gan , selamat siang semuahank u very much much much atas infonya gan 😉 http://goo.gl/u8z8HE | http://goo.gl/O2egrp | http://goo.gl/XmlGjZ
sangat bermanfaat untuk kita semua
mari berbagi kepada sesama agar selalu mendapatkan manfaat
ini juga masih perlu penjelasan lagi
Highloy energetic post, I loved thawt bit. Wiill there bee a part 2?