thinkbot
- Total activity 275
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 67
Comments
Recent activity by thinkbot-
Based on the results I can tell that you got some not optimized code/script, is it some custom code ? or maybe some CMS with a lot of non optimized third party plugins the output is of course bett...
-
add tmpdir=/dev/shm the simplest way
-
[mysqld] innodb_file_per_table = 1 local-infile=0 join_buffer_size=2M sort_buffer_size=256K query_cache_size = 128M query_cache_type = 1 query_cache_limit = 1M thread_cache_size = 16 open_files_...
-
those 2 methods don't change much Your current results are very good, you got only 6% of queries that create temporary tables on disk, so it's ok You have no problems to worry about now, it's ver...
-
remove all the stuf you got in your current my.cnf and add [mysqld] skip-name-resolve myisam_use_mmap=1 max_connections = 200 max_user_connections = 75 join_buffer_size=2M sort_buffer_size=256K...
-
run mysqltuner.pl
-
Please install APC or eaccelerator, it would make huge difference during php processing
-
Do you have php opcode installed, like apc/eaccelerator ?
-
Current changes should be enough For the backups part, you should check what is taking so much space, some stuff can be excluded like logs etc. and some doesn't have to backed up daily
-
I see you got multiple databases with the same structure user13_roland, user5_table1 You should add there (in all similar database structures, to all users databases) index for 'pseudo' and 'email...