optimize the mysql table

[Ejason21]

I need help with optimizing the mysql Table, It seems to be spiking the server from what my host tells me.

Can anyone help or point me in the right direction. ?

Ej21

[hostonnet]

mysql is already optimized, may be your sites are getting too much traffic or web host have mysql usage limit. You can disable guest limit in admin area, that will disable writing to guest table. Check the size of guest_info table, if its too big, you can empty it.

[Ejason21]

Thanks for the Reply. Im not Computer savy at all to be homest just good at driving traffic.. Where do I got to dump the table and how ??? is it in my cpanel ?? or vshare admin ??? i have the limit set to 1 now ?? it was zero before

[hostonnet]

You can check mysql database in

cpanel > phpmyadmin

You can set guest limit in

vshare admin > Site Setting

[gpj]

How do I disable guest limit in admin area? I am not seeing how to do that? I am having server load issues big time. My site barely moves anymore. I am currently getting about 10,000 visitors a day and it doesn't seem to handle it. Any other suggestions on what to do? At the peak my site was getting 15,000 hits a day. but I have had to downsize the traffic because of the problems.

[gpj]

Okay.. I found my problem. My guest_info has currently over 700,000 entries. I need to delete the entries. How do i go about doing this? I have already deleted over 300,000 manually... I don't want to continue this. Especially when it will get big again. is there something I can set up or have someone set up for me to fix this problem?

David