It looks like my MySQL server is hammered by this queries:

5601265 user localhost site Query Sending data SELECT ... FROM jos_k2_tags as t LEFT JOIN jos_k2_tags
5601267 user localhost site Query Locked UPDATE jos_k2_items SET hits = ( hits + 1 ) WHERE id='1
5601318 user localhost site Query Sending data SELECT ... FROM jos_k2_tags as t LEFT JOIN jos_k2_tags
5601320 user localhost site Query Sending data SELECT ... FROM jos_k2_tags as t LEFT JOIN jos_k2_tags
5601321 user localhost site Query Sorting resu SELECT ... FROM jos_k2_items as i LEFT JOIN jos_k2_cat
5601806 user localhost site Query Sending data SELECT ... FROM jos_k2_tags as t LEFT JOIN jos_k2_tags
5601807 user localhost site Query preparing SELECT ... FROM jos_k2_tags_xref WHERE tagID=428) ORDER
5601808 user localhost site Query Sending data SELECT ... FROM jos_k2_tags as t LEFT JOIN jos_k2_tags
5601889 user localhost site Query Sending data SELECT ... FROM jos_k2_tags as t LEFT JOIN jos_k2_tags
5601890 user localhost site Query Sending data SELECT ... FROM jos_k2_tags as t LEFT JOIN jos_k2_tags


When there are many people accessing site I got 5 or more queries trying to send data to k2_tags, is there any way I can maybe optimize this or fix it?
Thanks

Hi. Try this:
1. Ensure that Joomla! is up to date. Joomla! 1.5.26 is the latest version for 1.5 series.
2. Ensure that K2 is up to date. Currently the latest version is 2.6.8.
3. Ensure that Joomla! caching is enabled.
4. If you are familiar with MySQL and phpMyAdmin you can try to change the database engine to InnoDB. First read getk2.org/community/English-K2-Community/192249-Convert-Tables-from-MyISAM-2-InnoDB-4-Performance and getk2.org/community/English-K2-Community/190573-Sorry-K2#191017 .