[sach4isha]

Hi

I m Checking my site's performance and I found log of Slow Mysql queries I posting them here and want to know how many of them are not must have query and can be removed to speed up my pligg site

mysql_slow_queries

INSERT INTO pligg_pageviews (pv_type, pv_page_id, pv_datetime, pv_user_id, pv_user_ip) VALUES ('story', 4434, FROM_UNIXTIME(1215015448), 0, '66.249.73.146')


select *, count(*) as count from pligg_links, pligg_categories where category_lang='en' and category_id=link_category group by link_category ORDER BY category_name ASC


select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE tag_lang='en' and link_id = tag_link_id and link_status!='discard' GROUP BY tag_words order by count desc limit 30


so many of them but those are most visible in my log

Thanks for any help or suggestion

[chuckroast]

Your profile says you are using Pligg 9.8.1
I would suggest that you update to the latest version. Pligg 9.9.0
A lot of queries have been removed and or condensed in the latest version which will give you a noticeable speed increase.

[sach4isha]

Originally Posted by chuckroast

Your profile says you are using Pligg 9.8.1
I would suggest that you update to the latest version. Pligg 9.9.0
A lot of queries have been removed and or condensed in the latest version which will give you a noticeable speed increase.

Thanks but

I m using 9.9.0

and getting those problems

[HighCorral]

Any updates to this?

I, too, am getting painfully slow queries.

# Query_time: 8  Lock_time: 0  Rows_sent: 1  Rows_examined: 887419
select count(*) as words FROM pligg_tags, pligg_links WHERE tag_lang='en' and link_id = tag_link_id and  link_status!='discard'  GROUP BY tag_words order by words desc limit 1;

# Query_time: 8  Lock_time: 0  Rows_sent: 5  Rows_examined: 887423
select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE tag_lang='en' and link_id = tag_link_id and  link_status!='discard'  GROUP BY tag_words order by count desc limit 5;

[reklama]

+1 to this im using pligg9.9.5 and im geting those errors

[chuckroast]

Originally Posted by reklama

+1 to this im using pligg9.9.5 and im geting those errors

Chances are you are getting these error due to your web host.
We don't have a lot of information to go on.

[reklama]

It might be the server.Thats what hostgator admin told me.
"Connections to your database are frequently being killed by the server. Our shared hosting servers have a policy of 15 seconds maximum per database connection, and a process to enforce this policy runs every 60 seconds. That means no connection can last longer than 60 seconds, and most will be killed before then.

As for why your database connections are staying open for so long, check to make sure you don't have "persistent" database connections enabled in your web applications. Also see if there are any updates or plugins for Pligg or your other web applications that reduce the need for complex database queries which may be taking a long time. You may also want to contact technical support or visit any support forums offered by the companies of your web applications, to see how database usage can be improved."

I have two pligg 9.9.5 sites in the same server and only one is giving me mysql problems. Everything is fast when you are a visitor but when you log in ( admin or user) it gets slow.

[chuckroast]

reklama
I mean no disrespect with my reply. It's good that you came here to alert us of your situation We are aware with some harsh queries with Pligg Beta 9.9.5 and some shared hosts. Have you tried to update to Pligg 1.0?
We've really done a lot of work with the new version.