🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: pl.comp.os.linux.debian
Article #42051

mysql 5.1 - innodb

#42051
From: MaRc
Date: Wed, 28 Sep 2011 11:17
118 lines
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-mail

Show 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