- Posts: 18
COMMUNITY FORUM
K2 Database issues
- Derek
-
Topic Author
- Offline
- New Member
Less
More
8 years 9 months ago - 8 years 9 months ago #156850
by Derek
K2 Database issues was created by Derek
Guys, I need help. My site has been suspended by my host due to CPU abuse. They provided me the following codes...which per others points to K2 commenting issues. Comments WERE turned off when I installed K2 and the subsequent categories.
When other comes back up...is there a fast way to shut off all commenting? Like a master switch that would change all categories?
Can someone please help me!
Code has been removed
When other comes back up...is there a fast way to shut off all commenting? Like a master switch that would change all categories?
Can someone please help me!
Code has been removed
Last edit: 8 years 9 months ago by Derek.
Please Log in or Create an account to join the conversation.
- Mohamed Abdelaziz
-
- Offline
- Platinum Member
- Joomla Developer
8 years 9 months ago #156853
by Mohamed Abdelaziz
Multiple Extra Fields Groups for K2
AutoMeta for K2
Chained Fields for K2
More K2 Extensions In My Extensions Store
Replied by Mohamed Abdelaziz on topic K2 Database issues
Hi Derek,
Seems your hosting specs are not sufficient for your data volumes, if you are using a shared hosting, I think you should look for an upgrade, maybe a VPS will be good for your case.
From the attached database logs, I can detect that it is not only the comments having the problem, other tables have large number of rows as well, almost all of the queries take 2.5+ sec to execute! this is not a one table issue, I think it is the database server configuration and the resources available for your hosting account.
Seems your hosting specs are not sufficient for your data volumes, if you are using a shared hosting, I think you should look for an upgrade, maybe a VPS will be good for your case.
From the attached database logs, I can detect that it is not only the comments having the problem, other tables have large number of rows as well, almost all of the queries take 2.5+ sec to execute! this is not a one table issue, I think it is the database server configuration and the resources available for your hosting account.
Multiple Extra Fields Groups for K2
AutoMeta for K2
Chained Fields for K2
More K2 Extensions In My Extensions Store
Please Log in or Create an account to join the conversation.
- Derek
-
Topic Author
- Offline
- New Member
Less
More
- Posts: 18
8 years 9 months ago #156855
by Derek
Replied by Derek on topic K2 Database issues
Mohamed, thanks for getting back to me.
Turns out, I've been primarily attacked by a Chinese group (host tracked it back) as well as a smaller U.S. group, leaving 50,000+ comments on my site in the K2 posts.
I know 100% for sure I had turned off commenting when I had installed K2...but apparently somewhere along the way, it got turned back on. Not sure how, but it happened.
All "should" be ok now...but obviously only time will tell for sure.
Thank you again!
Turns out, I've been primarily attacked by a Chinese group (host tracked it back) as well as a smaller U.S. group, leaving 50,000+ comments on my site in the K2 posts.
I know 100% for sure I had turned off commenting when I had installed K2...but apparently somewhere along the way, it got turned back on. Not sure how, but it happened.
All "should" be ok now...but obviously only time will tell for sure.
Thank you again!
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
8 years 8 months ago #156971
by Krikor Boghossian
Replied by Krikor Boghossian on topic K2 Database issues
The comments are stored in a single table.
Mohamed mentioned several tables with significant size, I would suggest, knowing Mohamed's work to look into the possibility of a VPS.
Mohamed mentioned several tables with significant size, I would suggest, knowing Mohamed's work to look into the possibility of a VPS.
Please Log in or Create an account to join the conversation.
- Mohamed Abdelaziz
-
- Offline
- Platinum Member
- Joomla Developer
8 years 8 months ago #156974
by Mohamed Abdelaziz
Multiple Extra Fields Groups for K2
AutoMeta for K2
Chained Fields for K2
More K2 Extensions In My Extensions Store
Replied by Mohamed Abdelaziz on topic K2 Database issues
Thanks Krikor!
Multiple Extra Fields Groups for K2
AutoMeta for K2
Chained Fields for K2
More K2 Extensions In My Extensions Store
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
8 years 8 months ago #157029
by Krikor Boghossian
Replied by Krikor Boghossian on topic K2 Database issues
You 're welcome Mohamed.
Please Log in or Create an account to join the conversation.
- Derek
-
Topic Author
- Offline
- New Member
Less
More
- Posts: 18
8 years 8 months ago #157037
by Derek
Replied by Derek on topic K2 Database issues
Thanks again guys!
Please Log in or Create an account to join the conversation.