Any MySql gurus on the site.

[Admin]

I need some help tweaking the new servers my.cnf ...

here is the default

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

 

[Goop]

I need some help tweaking the new servers my.cnf ...

here is the default

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

PM'd you a URL with some parameters to try out. :thumbup: Hope it helps!

 

[Admin]

Awesome info!!! thank you

 

[Admin]

The revision



[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
　
#Don't cache results that are bigger than this.
query_cache_limit=26M
#minimal size of unit in wich space for results is allocated (last unit will be trimed after writing all result data
query_cache_min_res_unit=4096k
#The memory allocated to store results from old queries.
query_cache_size=128M
#Query cache type to use.
query_cache_type=1
　
max_connections=400
[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
#connect-string="nodeid=2;host=localhost:1186"
[ndb_mgm]
# connection string for MySQL Cluster management tool
#connect-string="host=localhost:1186"
key_buffer_size=800M
table_cache=64
tmp_table_size=24M
thread_cache_size=4
join_buffer_size=512K
innodb_buffer_pool_size=209M
max_heap_table_size=24M
sort_buffer_size=1M

 

[Goop]

Did the CPU usage drop at all?

 

[Admin]

yes it did.. and everthing seems faster

 

[Motogiro]

:rockon::rockon:You guys are Da Sheeeeee!!!!! :rockon::rockon: