First of all I like to inform you that I am a new User on Linux administration and I need some help.
I own a CloudLinux web server, and I am faced with a MySQL Slow Queries problem. The problem is that I have several users on my host, that run lot's of slow queries, and this has as a result the MySQL Service termination (I suppose that is termination.
FXP released CM 9.1 for our device.
Please do not post queries or comments in dev section.
Don't spam up the dev thread.
Keep it clean so that devs can help us without taking any trouble.
If u have any problem/queries/comments relating to CM 9.1 post them here.
I just added another index to a table in my database but now the site is crashing, queries get locked and not unlocked and queries are not executed (I can see them in the process list and they usually take less than a second to execute but now they are at around 600 seconds and more etc.).
I didn't change anything on my site, just added an index.
I've been building dynamic website for many years on the LAMP platform. I've even made my own CMS system, that is pretty lightweight. In creating navigation on simple sites there is a MySQL query for the Sections, then a loop of the Sections querying the Pages for each section. On a modest site there are 5-10 queries for the navigation.