Sun 450 Solaris 7 3 CPU MySQL binary install 50 million record table. Initially tested on dual CPU Intel Linux, now trying on Sun.
During index create (via alter), it copies the base file (as documented). It spins the CPU at about 31%, with 7 threads active. There is almost NO iowait (fast fibre channel, spread across 4 external raid 5 sets via veritas). iostat says very low utilization, no wait-for-io, minimal usage, ie: 2MB per second copy. These disks can copy 40 MB per second without breaks a sweat. What is the bottleneck? Is it simply the internal MySQL copy routine? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
