please help me..

[perx]

Hi,
i have some problem regarding mysql that i need help.

I have a member table that stores information of my user such as password,username,address,etc. Currently i have about 250k registered user(So thats 250k rows). The table has been running smoothly and querying to this table has been pretty fast. The table doesn't have an auto increment field before and i just assign the primary key to the username. Now, i need to add another auto increment field to it. But after i've done that, the database becomes significantly slower. Querying is super slow and sometimes when i try to browse the data from phpmyadmin, the database just hangs. As a result i have to restart the database.

This problem only occurs after i added the auto increment field. I am very sure. Because after i remove it, everything goes back to normal...

Can anyone help me here. I am really at a lost here....THANKS

[richie]

If your query is slow, it means you need to create some indexes.

Whatever query you're running that comes up slow, add the keyword EXPLAIN before it. Study the output to know where to create indexes.

[perx]

thanks alot...i will try it out...