Hi All, I was looking at some of the live data from Grameen. From the data scapshot that I have I noticed that the index length on most tables is greater than the actual data length. For instance on account_trxn the "Data lenght " is 2.2 GB and "Index length" is 2.5 GB. The indexes on the table are :
ACCOUNT_TRXN_ID (PK) ACCOUNT_ACTION_ID PAYMENT_ID CURRENCY_ID AMOUNT_CURRENCY_ID CUSTOMER_ID ACCOUNT_ID MySQL allows 16 indexes per table, some of our tables have more indexes which I am not sure if they are at all needed. There are many other tables where the index length is more than the data length. This seems to be the issue with rebuilding the indexes. Either they are not being rebuilt or there is some problem with it. I want to know : i) Do we rebuild the indexes? ii) If yes, how are the indexes rebuilt? And when is it done? Please send me script which is used to rebuild the indexes. Thanks and regards *ravi
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
