Currently i run my sites on a dedi server . But after all optimization , server is quite slow . My host guys told me that
"We have been watching MySQL process for a long while and basically the slowness ie because databases are missing INDEXES which is slowing down the searches and increasing MySQL CPU activity.
Currently, we can see mysql in SENDING DATA [login to view URL] means that MySQL has some data stored on the disk (or in memory) which is yet to be read and sent over. It may be the table itself, an index, a temporary table, a sorted output etc.
If you have a 1M records table (without an index) of which you need only one record, MySQL will still output the status as "sending data" while scanning the table so adding an index will make it faster.
Database indexing should be done by MSQL developers."
Looking for a professional to do that
15 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hi i can work for MSQL developer needed i am expert at ,Database Administration,HTML,Linux,MySQL,PHP So send me Private message at PMB so we can discuss more about it Thanks