Article View: pl.comp.os.linux.debian
Article #42051mysql 5.1 - innodb
From: MaRc
Date: Wed, 28 Sep 2011 11:17
Date: Wed, 28 Sep 2011 11:17
118 lines
3594 bytes
3594 bytes
witam postawiłem nowy serwer mysql. przerzuciłem bazy, niby działa, ale wszystkie bazy które miałem na silniku InnoDB zrobyły się MyISAM :( podczas stawiania serwera mysql z usr/share/doc przekopiowałem mycnf mający w nazwie large - mam 16Gram show engines nie pokazuje mi innodb :( ale jak uruchomie serwer mysql ze standardowym konfigiem my.cnf to silnik się pokazuje. oto standardowy my.cnf: #v+ [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] 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 bind-address = 127.0.0.1 key_buffer = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 16M expire_logs_days = 10 max_binlog_size = 100M [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] [isamchk] key_buffer = 16M !includedir /etc/mysql/conf.d/ #v- a to my.cnf - large przy którym nie ma silnika innodb: #v+ [client] port = 3306 socket = /var/run/mysqld/mysqld.sock default-character-set = utf8 [mysqld] port = 3306 socket = /var/run/mysqld/mysqld.sock default-character-set = utf8 back_log = 50 max_connections = 1000 max_connect_errors = 100 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 1M max_heap_table_size = 64M sort_buffer_size = 40M join_buffer_size = 80M thread_cache_size = 8 thread_concurrency = 8 query_cache_size = 64M query_cache_limit = 8M ft_min_word_len = 4 thread_stack = 192K transaction_isolation = REPEATABLE-READ tmp_table_size = 128M log-bin=mysql-bin binlog_format=mixed slow_query_log long_query_time = 2 server-id = 1 key_buffer_size = 32M read_buffer_size = 2M read_rnd_buffer_size = 16M bulk_insert_buffer_size = 64M myisam_sort_buffer_size = 128M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover innodb_additional_mem_pool_size = 48M innodb_buffer_pool_size = 12G innodb_data_file_path = ibdata1:10M:autoextend innodb_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_file_size = 256M innodb_log_files_in_group = 3 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 512M sort_buffer_size = 512M read_buffer = 8M write_buffer = 8M [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit = 8192 #v- któa z powyższych opcji wyłącza mi silnik InnoDB? -- MaRc
Technical Details
Message-ID:
<j5uvnu$ri5$1@pippin.nask.net.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.nask.pl!news.nask.org.pl!not-for-mailShow Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.nask.pl!news.nask.org.pl!not-for-mail From: MaRc <tuksmr@gmail.com> Newsgroups: pl.comp.os.linux.debian Subject: mysql 5.1 - innodb Date: Wed, 28 Sep 2011 13:17:18 +0200 Organization: NASK - www.nask.pl Lines: 118 Message-ID: <j5uvnu$ri5$1@pippin.nask.net.pl> NNTP-Posting-Host: h36-176.interdom.net.pl Mime-Version: 1.0 X-Trace: pippin.nask.net.pl 1317208638 28229 193.59.36.176 (28 Sep 2011 11:17:18 GMT) X-Complaints-To: abuse ATSIGN nask.pl NNTP-Posting-Date: Wed, 28 Sep 2011 11:17:18 +0000 (UTC) User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.21) Gecko/20110831 Thunderbird/3.1.13 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit