My database has gone crazy

Hi

My website started loading really slow after the server was ddosed. I checked the database and found these errors: errors. I have tried to repair the tables with no luck the numbers just keep getting higher. I don't know very much (nothing) about mysql. Can this database be fixed and if so where do I start? Thanks

Select_full_join 7,172 The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables.

Select_range_check 1,964 The number of joins without keys that check for key usage after each row. (If this is not 0, you should carefully check the indexes of your tables.)

Opened_tables 11 k The number of tables that have been opened. If opened tables is big, your table cache value is probably too small.

Table_locks_waited 4,346 The number of times that a table lock could not be acquired immediately and a wait was needed. If this is high, and you have performance problems, you should first optimize your queries, and then either split your table or tables or use replication.

Qcache_lowmem_prunes 101 k The number of queries that have been removed from the cache to free up memory for caching new queries. This information can help you tune the query cache size. The query cache uses a least recently used (LRU) strategy to decide which queries to remove from the cache.

Handler_read_rnd_next 3,957.84 M The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.

 

have you restarted mysql / the server? i imagine that would clear most if not all of that..

 

Hi

How do I restart mysql? Sorry but I really don't know.

thanks

 

You can yourself restart mysql only if you are on a dedicated server or a VPS.
If you are on a shared hosting, since the same mysql is used by all
other webs-ites, you cannot restart it yourself. It is your hosting provider who can
do it.

 

I'm on semi dedicated so I can't restarted. Is there any other way to fix these errors?

Thanks

 

These are not errors. They are just statistics. The way you fix this is by fixing your queries. If you are having a lot of full_joins like you do, depending on what kind of data you are dealing with, you may need to create indexes on the databased on what you are querying.

 

I have no idea how to do that. I am going to hire someone to do that. If anyone is interested please pm me.

Thanks