thinkbot
- Total activity 275
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 67
Comments
Recent activity by thinkbot-
remove this table_cache = 64 and you can also increase query_cache_size to 50M and clean double repeated vars like: # CACHES AND LIMITS # tmp-table-size = 32M m...
-
you must run it at least for 24h to get reliable information, your mysql instance run for 17m before mysqltuner
-
it's partially an advert ;p
-
Exactly, tools always suggest to increase and increase :) put there this, it's cleaned up version of your my.cnf with enabled slow query log, after it gatherers some slow queries for few days, you...
-
lower table_cache to something like 6000 since it scales bad on high numbers table_definition_cache to 2000 Many of the values you put there are too big, it seems like it was copied from somewher...
-
if you changed the query to $result13 = mysql_query("SELECT * FROM ads where ads_size=\'790x90\' ORDER BY ads_id DESC LIMIT 1"); then it probably doesnt work, run explain extended SELECT * FRO...
-
"Inappropriate ioctl for device" Post the code of that script
-
in general its good, except InnoDB buffer, replace my.cnf with [mysqld] # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibil...
-
download this
-
run mysqltuner.pl and post results here