On Mon, 09 Apr 2012 13:17:55 +0200
Reindl Harald <h.reindl@stripped> wrote:
>
>
> Am 09.04.2012 13:05, schrieb J. Bakshi:
> > I have reset these two now
> >
> > ` ` ` `
> > key_buffer_size=200M
> > innodb_buffer_pool_size=4G
>
> [!!] InnoDB data size / buffer pool: 3.6G/8.0M
>
> there did go something terrible wrong
> what is the mysqld log saying at startup?
> waht about post your complete my.cnf?
Here is the my.cnf of mine
` ` ` `
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip_external_locking
skip_name_resolve
skip_host_cach
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
## enable utf8 support###########
default-character-set=utf8
default-collation=utf8_general_ci
## It will automatically fix MyISAM tables
## as soon as they become corrupt
#############################################
myisam-recover=backup,force
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
general_log_file = /var/log/mysql/mysql.log
general_log = 1
#
# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
#
# Here you can see queries with especially long duration
log_slow_querie = /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
# other settings you may need to change.
#server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
concurrent_insert=1
key_buffer_size=200M
max_allowed_packet=156M
max_connections=150
max_connect_errors=2000000
wait_timeout=120
interactive_timeout=27800
max_tmp_table=100
query_cache_size=128M
query_cache_limit=4M
query_cache_type=1
read_buffer_size=10M
read_rnd_buffer_size=8M
#sort_buffer_size=16M
#myisam_sort_buffer_size=16M
table_cache=16000
tmp_table_size=100M
thread_cache_size=500
thread_concurrency=8
#innodb_thread_concurrency=1000
thread_stack=256K
max_heap_table_size=100M
#innodb_buffer_pool_size=4G
[mysqldump]
quick
quote-names
max_allowed_packet = 200M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M
#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
` ` `
