my.cnf changes - what difference - living-e AG • View topic - wo ist my.cnf und was für innodb als - polala.com

living-e AG • View topic - wo ist my.cnf und was für innodb als ::
2 posts - Last post: Dec 22, 2008ich suche die my.cnf datei und würde gern wissen was in derselbigen reingehört damit innodb die Standardeinstellung in meiner
http://forum.webedition.de/phpBB/viewtopic.php?f=1&t=6781HOME

I have seen a few threads containing the following my.cnf changes and was wondering what these changes actually do. Do these changes have any impact on anything else on the server?

[mysqld]
safe-show-database
skip-locking
skip-innodb
max_connections = 650
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1280

my.cnf and default charsets::
7 posts - Last post: Sep 9, 2007This is a discussion on my.cnf and default charsets within the mysql forums in Other Databases category; Hi, I want to change my default
http://www.mydatabasesupport.com/forums/mysql/248247-my-cnf-default-charsets.htmlHOME

thread_cache_size = 64
wait_timeout = 1200
connect_timeout = 10
tmp_table_size = 64M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

PHP Bugs: #43812: 'password' parameter in my.cnf not honored even ::
Reproduce code: --------------- my.cnf contents: [client] host = localhost user please do so and change the status of the bug back to "Open".
http://bugs.php.net/bug.php?id=43812&edit=1HOME

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

Cheers
Bruce

basically mysql loves memory and majority of default mysql installs on servers run on default mysql settings as listed at http://dev.mysql.com/doc/mysql/en/server-system-variables.html

These default values set memory buffers too low and aren't optimised for forum like activity of any php/mysql forum software and need tuning.

You can read up on that at http://dev.mysql.com/doc/mysql/en/server-parameters.html and

You need to find a balance for the settings and allocate more memory to mysql buffers to allow mysql server to run optimally. These settings can differ for each server depending on how much memory they have to work with and the mysql activity/load as reported by mysqladmin extended-status output. If you run other php/mysql apps on the server besides vB, then mysql usage/activity also includes those other apps as well.

Thanks eva2000

We'll look into tuning the server to take advantage of the MySQl changes. We currently have 1Gb memory and dual 2.4Ghz cpu's..

Cheers
Bruce