From: Aleksey Novodvorsky <a.e.nvdv@gmail.com>
To: "Культурный офтопик" <smoke-room@lists.altlinux.org>
Subject: Re: [room] mysql 5.1
Date: Wed, 10 Nov 2010 21:38:48 +0300
Message-ID: <AANLkTinu4ZzN3sQa83awkBW+Xi_8r_oJuDxr6L7Sn9-O@mail.gmail.com> (raw)
In-Reply-To: <AANLkTimP5Q-4uBxoLoJ6Q88Ya=L0fznuf+MwGK9Z95VL@mail.gmail.com>
2010/11/10 Michael Bykov <m.bykov@gmail.com>:
> 2010/11/10 Michael Bykov <m.bykov@gmail.com>
>>
>> 2010/11/10 Michael Bykov <m.bykov@gmail.com>
>>>
>>> салют,
>>> а почему у меня на только что поставленной 5.1
>>>
>>> show innodb status;
>>> ERROR 1286 (42000): Unknown table engine 'InnoDB'
>>> подскажите?
>>> --
>>> М.
>>>
>>> http://diglossa.org
>>> xmpp://m.bykov@jabber.ru
>>>
>>>
>>
>>
>> В my.cnf
>> # Uncomment the following if you are using InnoDB tables
>> innodb_data_home_dir = /db
>> innodb_data_file_path = ibdata1:10M:autoextend
>> innodb_log_group_home_dir = /log
>> # You can set .._buffer_pool_size up to 50 - 80 %
>> # of RAM but beware of setting memory usage too high
>> innodb_buffer_pool_size = 16M
>> innodb_additional_mem_pool_size = 2M
>> # Set .._log_file_size to 25 % of buffer pool size
>> innodb_log_file_size = 5M
>> innodb_log_buffer_size = 8M
>> innodb_flush_log_at_trx_commit = 1
>> innodb_lock_wait_timeout = 50
>>
>> --
>> М.
>>
>> http://diglossa.org
>> xmpp://m.bykov@jabber.ru
>>
>>
>
>
> Господа, сорри. У нас что, 5.1 вообще без поддержки innoDB собрана?
> mysql> show variables like '%inno%';
> +-----------------------+-------+
> | Variable_name | Value |
> +-----------------------+-------+
> | have_innodb | NO |
> | ignore_builtin_innodb | OFF |
> +-----------------------+-------+
> 2 rows in set (0.00 sec)
> и что делать, если нужны транзакции? Собирать самому?
> В search.altlinux.org нет ответа
Миша, это не в этот список вопрос.
Rgrds, Алексей
parent reply other threads:[~2010-11-10 18:38 UTC|newest]
Thread overview: expand[flat|nested] mbox.gz Atom feed
[parent not found: <AANLkTimP5Q-4uBxoLoJ6Q88Ya=L0fznuf+MwGK9Z95VL@mail.gmail.com>]
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=AANLkTinu4ZzN3sQa83awkBW+Xi_8r_oJuDxr6L7Sn9-O@mail.gmail.com \
--to=a.e.nvdv@gmail.com \
--cc=smoke-room@lists.altlinux.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Культурный офтопик
This inbox may be cloned and mirrored by anyone:
git clone --mirror http://lore.altlinux.org/smoke-room/0 smoke-room/git/0.git
# If you have public-inbox 1.1+ installed, you may
# initialize and index your mirror using the following commands:
public-inbox-init -V2 smoke-room smoke-room/ http://lore.altlinux.org/smoke-room \
smoke-room@lists.altlinux.org smoke-room@lists.altlinux.ru smoke-room@lists.altlinux.com smoke-room@altlinux.ru smoke-room@altlinux.org smoke-room@altlinux.com
public-inbox-index smoke-room
Example config snippet for mirrors.
Newsgroup available over NNTP:
nntp://lore.altlinux.org/org.altlinux.lists.smoke-room
AGPL code for this site: git clone https://public-inbox.org/public-inbox.git