thinkbot
- Total activity 275
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 67
Comments
Recent activity by thinkbot-
[quote="nourjabi, post: 1466451">heres few big sites results: B2b-sy.com : Tested from New York City, New York, USA on September 22 at 20:28:54 Page size 2.9MB Load time 6.47s Requests 159 Pe...
-
what do you mean by sluggish ? you mean page generation time or static elements loading ? use tools.pingdom.com to test your site, and let me know the results link to check
-
childcli_ccs SELECT * FROM `t_news` WHERE approved = 1 and deleted = 0 and id in (select DISTINCT n_id from news_cats where c_id = 626 order by n_id desc) ORDER BY `sort_date` DESC,`id` DESC limi...
-
you dont have to wait 24h to generate slowlog, can be only few hours
-
can you generate slow.txt again with pt-query-digest, with new stats ? and can you tell how did you correct your queries, how does it look now ?
-
Yes, Yes, your problems are becouse : Query 1: SELECT * FROM pages where active=1\G it takes most of the time in mysql 83.6% of all queries what is this query trying to do ? select all elements, ...
-
ok you need to review slow queries now, there are a lot of them is this custom script ? cd /root wget
-
thread_cache_size = 50 without M same for table_cache = 5000 without M :)
-
Correct those: key_buffer = 2000M table_cache = 5000 thread_cache_size = 50 and add slow queries tracking slow_query_log=1 slow_query_log_file=mysql-slow.log long_query_time=0.1 log-queries-not...
-
Ohh, some of your settings are horrible, without any understanding (like join_buffer_size) Please adjust those: query_cache_limit=2M query_cache_size=50M max_user_connections=100 max_connections...