List:General Discussion« Previous MessageNext Message »
From:"J. Bakshi" <joydeep.bakshi Date:April 9 2012 11:53am
Subject:Re: Remote mysql too slow
View as plain text  
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/


` ` `

Thread
Remote mysql too slowJ. Bakshi9 Apr
  • Re: Remote mysql too slowReindl Harald9 Apr
    • Re: Remote mysql too slowJ. Bakshi9 Apr
      • Re: Remote mysql too slowReindl Harald9 Apr
        • Re: Remote mysql too slowJ. Bakshi9 Apr
          • Re: Remote mysql too slowReindl Harald9 Apr
            • Re: Remote mysql too slowJ. Bakshi9 Apr
  • Re: Remote mysql too slowJohnny Withers9 Apr
    • Re: Remote mysql too slowNoel Butler9 Apr