thinkbot
- Total activity 275
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 67
Comments
Recent activity by thinkbot-
Your mysql settings are fine, the script (queries) and database structure needs optimizations Please generate slow log once again
-
As you see here # 1 0x656F8265D013DC88 8647502.2474 89.9% 349356 24.7527 2.04 SELECT kouponidb_kino_wins_xls # 2 0xAA2D53B32C14D11C 540788.7260 5.6% 13809 39.1620 37.49 SELECT kouponidb_...
-
it wont make a difference much Please add index on drawDate column in kouponidb_kino_wins_xls table This will speed up the slow query a lot you can also review the rest of slow queries like that:...
-
If you want to increase innodb_log_file_size, you need to remove old logfiles first like this rm -rf /var/lib/mysql/ib_logfile* and then restart mysql but before for innodb you can set this: in...
-
key_buffer_size increase will make huge difference if those queries run on MyISAM tables join_buffer_size lower to 1M 8M there wont make any difference, it will only take more memory You can also...
-
Add indexes in phpmyadmin for those columns
-
Queries: pitajfm_cms 1. SELECT * FROM odgovori WHERE uid = 7954 AND pid = 86013 table odgovori, make sure index for uid and pid exists, if not add it in phpmyadmin 2. SELECT id FROM brojac_posje...
-
There is not much that can be optimized here, since you got not much queries, you can increase table_cache=1000 The best thing you can do is add slow queries tracking slow_query_log=1 slow_query_...
-
run mysqltuner.pl and copy here result
-
rerun mysqltuner.pl and post the results, also run pt-query-digest to review slow log cd /root wget