Re: disadvantages of myisampack?
Posted by:
Apachez
Date: April 24, 2006 04:50PM
Generally the cpu will go up when using myisampacked tables. Also some queries "might" go slower due to the fact that more cpu will be needed to process all rows.
However usually you will gain speed (mostly due to less diskio (less data to read from disk)) and the cpu usage is often not that dramatically change.
The problem is to batch this efficiently.
Like making first 1 million rows into its own table which you then myisampack and new rows will get into a regular myisam table.
Also note (which I assume you have already noted) that myisampacked tables are readonly so you cannot run an INSERT or similar against them.
Subject
Views
Written By
Posted
6661
April 20, 2006 02:54PM
Re: disadvantages of myisampack?
2772
April 24, 2006 04:50PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.