thinkbot
- Total activity 275
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 67
Comments
Recent activity by thinkbot-
those 2 are set as default on 16MB, it's good
-
yes, those are only temporary files, when query finishes, they are removed
-
Nope, that won't make much of a difference if your load is MySQL bound but you can add after [mysqld] tmpdir=/dev/shm This will tell MySQL to place temp files on "RAM disk", this will speed que...
-
[client] port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-external-locking key_buffer_size = 384M max_allowed_packet = 32M table_ope...
-
On your last topic
-
it's good configuration, don't worry
-
Yeah, and max memory usage based on mysqltuner dropped from [OK] Maximum possible memory usage: 1.2G (61% of installed RAM) to [OK] Maximum possible memory usage: 681.5M (33% of installed RAM) The...
-
here [mysqld] max_connections=200 max_user_connections=50 key_buffer_size=325M myisam_sort_buffer_size=64M join_buffer_size=512K sort_buffer_size=256K table_open_cache=500 thread_cache_size=16 ...
-
run mysqltuner.pl and post results
-
you can reduce your VPS to 1GB RAM or 768