… amount of pages which do not fit in compressed space. Fast Index Creation This is another feature which I was asking Heikki about… tables may take a lot of time. Fast Index creation will allow Innodb to build indexes by sorting rather by row by row insertions… be optimized same way as for MyISAM tables by separate phase of building Indexes ? Will be UNIQUE indexes built by sorting in case…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… use MyISAM tables exclusively. Right size depends on amount of indexes, data size and workload – remember MyISAM… over 100.000 used. thread_cache Thread creation/destructions can be expensive, which happen at… amount of concurrent connections and I see fast growth of Threads_Created variable I boost …
