0 Members and 1 Guest are viewing this topic.
performance-schema=ondefault-storage-engine=myisamskip-innodb#OpenVZ AIO bug fixinnodb-use-native-aio=0
I updated the values as advices, now I get:Variables to adjust: query_cache_limit (> 1M, or use smaller result sets)If I increase the 1M value to 2M and test again it say "query_cache_limit (> 2M, or use smaller result sets)"Here is my.cnf content:Code: [Select][mysqld]#OpenVZ AIO bug fixinnodb_use_native_aio=0## Generaldatadir = /var/lib/mysqltmpdir = /var/lib/mysqltmpsocket = /var/lib/mysql/mysql.sockskip-name-resolvesql-mode = NO_ENGINE_SUBSTITUTION#event-scheduler = 1## Cachethread-cache-size = 16table-open-cache = 4096table-definition-cache = 2048query-cache-size = 32Mquery-cache-limit = 1M## Per-thread Bufferssort-buffer-size = 1Mread-buffer-size = 1Mread-rnd-buffer-size = 1Mjoin-buffer-size = 2M## Temp Tablestmp-table-size = 64Mmax-heap-table-size = 128M## Networkingback-log = 100#max-connections = 200## Generaldatadir = /var/lib/mysqltmpdir = /var/lib/mysqltmpsocket = /var/lib/mysql/mysql.sockskip-name-resolvesql-mode = NO_ENGINE_SUBSTITUTION#event-scheduler = 1## Cachethread-cache-size = 16table-open-cache = 4096table-definition-cache = 2048query-cache-size = 32Mquery-cache-limit = 1M## Per-thread Bufferssort-buffer-size = 1Mread-buffer-size = 1Mread-rnd-buffer-size = 1Mjoin-buffer-size = 1M## Temp Tablestmp-table-size = 64Mmax-heap-table-size = 128M## Networkingback-log = 100#max-connections = 200max-connect-errors = 10000max-allowed-packet = 16Minteractive-timeout = 3600wait-timeout = 600### Storage Engines#default-storage-engine = InnoDBinnodb = FORCE## MyISAMkey-buffer-size = 64Mmyisam-sort-buffer-size = 128M## InnoDB#innodb-buffer-pool-size = 128M#innodb-log-file-size = 100M#innodb-log-buffer-size = 8M#innodb-file-per-table = 1#innodb-open-files = 300## Replicationserver-id = 1#log-bin = /var/log/mysql/bin-log#relay-log = /var/log/mysql/relay-logrelay-log-space-limit = 16Gexpire-logs-days = 7#read-only = 1#sync-binlog = 1#log-slave-updates = 1max-connect-errors = 10000max-allowed-packet = 16Minteractive-timeout = 3600wait-timeout = 600### Storage Engines#default-storage-engine = InnoDBinnodb = FORCE## MyISAMkey-buffer-size = 64Mmyisam-sort-buffer-size = 128M## InnoDB#innodb-buffer-pool-size = 128M#innodb-log-file-size = 100M#innodb-log-buffer-size = 8M#innodb-file-per-table = 1#innodb-open-files = 300## Replicationserver-id = 1#log-bin = /var/log/mysql/bin-log#relay-log = /var/log/mysql/relay-logrelay-log-space-limit = 16Gexpire-logs-days = 7#read-only = 1#sync-binlog = 1#log-slave-updates = 1#binlog-format = STATEMENT#auto-increment-offset = 1#auto-increment-increment = 2## Logging#log-output = FILE#slow-query-log = 1#slow-query-log-file = /var/log/mysql/slow-log#log-slow-slave-statements#long-query-time = 2[mysqld_safe]log-error = /var/log/mysqld.logopen-files-limit = 65535[mysql]no-auto-rehash
[mysqld]#OpenVZ AIO bug fixinnodb_use_native_aio=0## Generaldatadir = /var/lib/mysqltmpdir = /var/lib/mysqltmpsocket = /var/lib/mysql/mysql.sockskip-name-resolvesql-mode = NO_ENGINE_SUBSTITUTION#event-scheduler = 1## Cachethread-cache-size = 16table-open-cache = 4096table-definition-cache = 2048query-cache-size = 32Mquery-cache-limit = 1M## Per-thread Bufferssort-buffer-size = 1Mread-buffer-size = 1Mread-rnd-buffer-size = 1Mjoin-buffer-size = 2M## Temp Tablestmp-table-size = 64Mmax-heap-table-size = 128M## Networkingback-log = 100#max-connections = 200## Generaldatadir = /var/lib/mysqltmpdir = /var/lib/mysqltmpsocket = /var/lib/mysql/mysql.sockskip-name-resolvesql-mode = NO_ENGINE_SUBSTITUTION#event-scheduler = 1## Cachethread-cache-size = 16table-open-cache = 4096table-definition-cache = 2048query-cache-size = 32Mquery-cache-limit = 1M## Per-thread Bufferssort-buffer-size = 1Mread-buffer-size = 1Mread-rnd-buffer-size = 1Mjoin-buffer-size = 1M## Temp Tablestmp-table-size = 64Mmax-heap-table-size = 128M## Networkingback-log = 100#max-connections = 200max-connect-errors = 10000max-allowed-packet = 16Minteractive-timeout = 3600wait-timeout = 600### Storage Engines#default-storage-engine = InnoDBinnodb = FORCE## MyISAMkey-buffer-size = 64Mmyisam-sort-buffer-size = 128M## InnoDB#innodb-buffer-pool-size = 128M#innodb-log-file-size = 100M#innodb-log-buffer-size = 8M#innodb-file-per-table = 1#innodb-open-files = 300## Replicationserver-id = 1#log-bin = /var/log/mysql/bin-log#relay-log = /var/log/mysql/relay-logrelay-log-space-limit = 16Gexpire-logs-days = 7#read-only = 1#sync-binlog = 1#log-slave-updates = 1max-connect-errors = 10000max-allowed-packet = 16Minteractive-timeout = 3600wait-timeout = 600### Storage Engines#default-storage-engine = InnoDBinnodb = FORCE## MyISAMkey-buffer-size = 64Mmyisam-sort-buffer-size = 128M## InnoDB#innodb-buffer-pool-size = 128M#innodb-log-file-size = 100M#innodb-log-buffer-size = 8M#innodb-file-per-table = 1#innodb-open-files = 300## Replicationserver-id = 1#log-bin = /var/log/mysql/bin-log#relay-log = /var/log/mysql/relay-logrelay-log-space-limit = 16Gexpire-logs-days = 7#read-only = 1#sync-binlog = 1#log-slave-updates = 1#binlog-format = STATEMENT#auto-increment-offset = 1#auto-increment-increment = 2## Logging#log-output = FILE#slow-query-log = 1#slow-query-log-file = /var/log/mysql/slow-log#log-slow-slave-statements#long-query-time = 2[mysqld_safe]log-error = /var/log/mysqld.logopen-files-limit = 65535[mysql]no-auto-rehash
Page created in 0.036 seconds with 16 queries.