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 need to develop a questionnaire with around 50 questions in Android and the model is below. How do I reuse layouts to better the performance. I have listed 2 sections in the top level - but there are 6 sections. The sub-section varies for each section & the number of questions varies under each sub-section as well.
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.