Re: Table structure

[Aftab Khan]

We are OK, thanks.

If you have only 6 million rows then you should use:

INT UNSIGNED NOT NULL primary key.

Please provide output of the following:

[ CODE ]

SHOW CREATE TABLE table_name \G
SHOW TABLE STATUS LIKE 'table_name'\G
SHOW KEYS FROM table_name;

[ /CODE ]


# Replace table_name with real table name. remove spaces in [ code ]... [ /code]

Can we see 'SELECTs' that you perform against this table? how do you do inserts, single insert or batch insert?

How much RAM do you have on the server? Can we see MySQL config file? i.e. /etc/my.cnf



Edited 1 time(s). Last edit at 08/17/2012 02:17AM by Aftab Khan.