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.