steliosd
- Total activity 32
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 3
Comments
Recent activity by steliosd-
Hi everybody, my server load problem continues and I would appreciate some more help.Here are mysqltuner and my.cnf output: root@host [/]# ./mysqltuner.pl >> MySQLTuner 1.2.0 - Major Hayden ...
-
The drawDate index made things a lot faster indeed.Does it matter that this array has 4 more columns as indexes? I checked the query and I need all of the columns of the array kouponidb_kino_wins_x...
-
This is the correct one. .vB
-
Forget about the last thing I wrote.It still hits 600% of cpu sometimes. I don't understand how come when in top processes mysql reaches 600% of cpu, server load is at 5-7 and when server load is a...
-
The slow.txt is 5MB large and I can't post it here.Can you pm me your email so I can send it to you? Here is my new mysqltuner output: root@host [/]# ./mysqltuner.pl >> MySQLTuner 1.2.0 - Maj...
-
On a second thought, there is the Innodb table I mentioned before with 4 million rows and a MyISAM table with 9,7 million rows. Both of them are important (especially the first one) and data are be...
-
Thanks for the update!I have applied the changes and I am waiting. My main used tables are Innodb. Actually there is only one Innodb table that uses slow queries which take up to 25 sec to complete...
-
Thanks a lot thinkbot for your help! I have made the changes you suggested and I will post the results tomorrow. Are there any other optimizations I can do for innodb tables?I had to remove innodb_...
-
I have just changed the key_buffer_size to 768M and join_buffer_size to 8M according to mysqltuner recommendations.
-
Hi everybody! My name is Stelios.I am working as a server administrator for a company in Korinthos, Greece. I started using cPanel 4-5 months ago and due to this forum I have expand my knowledge a ...