nourjabi
- Total activity 30
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 3
Comments
Recent activity by nourjabi-
Thanks, I have also sent this query modification to the programmer. But I have a question, even thought we have tweaked the settings and the CPU usage went down a lot, what can we do to improve s...
-
[quote="thinkbot, post: 1465612">you dont have to wait 24h to generate slowlog, can be only few hours # 129.5s user time, 130ms system time, 43.58M rss, 193.03M vsz # Current date: Sat Sep 21 03:...
-
Ok, But it will take time untill tomorrow, as I removed old slow log to make sure i get new readings, i will post new results tomorrow after 24 HR. Also, I didn't do the changes my self, I handed ...
-
hi, I have made the changes to SQL Queries as you mentioned, and BAM! Down from 89% + to 8~10%, I mean you are the man. Do you think I should fine tune anything else now? Here's plsqltuner re...
-
I see, Seems my suspicious were true. That domain is giving me a headache, i will let my programmer check this topic and see if she can correct those queries to solve the issue, thanks . [quot...
-
Slow.txt Here's the slow.txt :) So, do you believe the whole issue is from slow queries (bad written sql queries) and I should let the client fix them ? # 600.2s user time, 580ms system time, ...
-
Here's 24 Hour SQLTuner readings: [QUOTE]-------- Storage Engine Statistics ------------------------------------------- [--] Status: [COLOR="#00FF00">+Archive [COLOR="#FF0000">-BDB -Federated [COL...
-
Thank you, i will hopefully post results later. thanks again. [quote="thinkbot, post: 1462091">thread_cache_size = 50 without M same for table_cache = 5000 without M :)
-
Hi, Just a question, did you mean thread_cache_size = 50 or thread_cache_size = 50M ?
-
Thank you very much, I will edit now, and let you know the result after 24 HR, to make sure sqltuner get's a good result log. [quote="thinkbot, post: 1461912">Correct those: key_buffer = 2000M ...