Hi,

Is it possible to have logs for each database into differnt files ?
Rather on single file with log=/var/log/mysqld.log.
--
Sachin Sharma
Sr. Engineer Systems (Linux)
Net4India Ltd.

D-25
Sector 3
Noida-201301
INDIA

Tel: 0120-5323500
Fax: 0120-5323520
URL: http://www.net4.in
------------------------------------------------------------------------
This message may contain confidential and/or privileged information. If
you are not the addressee or authorized to receive this for the
addressee, you must not use, copy, disclose or take any action based on
this message or any information herein. If you have received this
message in error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.
------------------------------------------------------------------------

Sachin Sharma a écrit :
>
> Hi,
>
> Is it possible to have logs for each database into differnt files ?
> Rather on single file with log=/var/log/mysqld.log.
It's not possible no... Maybe you should look at running different mysql
instance for each of them that need separate lock! (Prevent join between
the db but allow for tuning of param for each, and allow more memory to
be used than the 3-4G limit per process on 32bits architecture)
mysqld_multi allows easy management of those kind of setup!

--
Mathieu Bruneau
aka ROunofF

===
GPG keys available @ http://rounoff.darktech.org

Hi friends,



How to show the engine/table type of the one table in my database??



I want to know the engine/table type (InnoDB, MyIsam.) for the tables that I
did in my database.



Thanks.



Wagner Bianchi

show table status;

Carlos


On 12/10/06, wagner@mysqlbrasil.com.br <wagner@mysqlbrasil.com.br> wrote:
> Hi friends,
>
>
>
> How to show the engine/table type of the one table in my database??
>
>
>
> I want to know the engine/table type (InnoDB, MyIsam.) for the tables that I
> did in my database.
>
>
>
> Thanks.
>
>
>
> Wagner Bianchi
>
>
>