Re: Msql Connector/J (Way Off Topic.. INNODB on MYSQL)

[Martin Gainty <mg...@hotmail.com>]

WAY OFF TOPIC but include these directives into my.cnf to enable INNODB 
before starting mySQL

#*** INNODB Specific options ***

# Use this option if you have a MySQL server with InnoDB support enabled
# but you do not plan to use it. This will save memory and disk space
# and speed up some things.

# Additional memory pool that is used by InnoDB to store metadata
# information.  If InnoDB requires more memory for this purpose it will
# start to allocate it from the OS.  As this is fast enough on most
# recent operating systems, you normally do not need to change this
# value. SHOW INNODB STATUS will display the current amount used.
innodb_additional_mem_pool_size=2M

# If set to 1, InnoDB will flush (fsync) the transaction logs to the
# disk at each commit, which offers full ACID behavior. If you are
# willing to compromise this safety, and you are running small
# transactions, you may set this to 0 or 2 to reduce disk I/O to the
# logs. Value 0 means that the log is only written to the log file and
# the log file flushed to disk approximately once per second. Value 2
# means the log is written to the log file at each commit, but the log
# file is only flushed to disk approximately once per second.
innodb_flush_log_at_trx_commit=1

# The size of the buffer InnoDB uses for buffering log data. As soon as
# it is full, InnoDB will have to flush it to disk. As it is flushed
# once per second anyway, it does not make sense to have it very large
# (even with long transactions).
innodb_log_buffer_size=1M

# InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and
# row data. The bigger you set this the less disk I/O is needed to
# access data in tables. On a dedicated database server you may set this
# parameter up to 80% of the machine physical memory size. Do not set it
# too large, though, because competition of the physical memory may
# cause paging in the operating system.  Note that on 32bit systems you
# might be limited to 2-3.5G of user level memory per process, so do not
# set it too high.
innodb_buffer_pool_size=8M

# Size of each log file in a log group. You should set the combined size
# of log files to about 25%-100% of your buffer pool size to avoid
# unneeded buffer pool flush activity on log file overwrite. However,
# note that a larger logfile size will increase the time needed for the
# recovery process.
innodb_log_file_size=10M

# Number of threads allowed inside the InnoDB kernel. The optimal value
# depends highly on the application, hardware as well as the OS
# scheduler properties. A too high value may lead to thread thrashing.
innodb_thread_concurrency=8

# skip-innodb
innodb_data_home_dir = C:/MySQL/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = C:/MySQL/data/
innodb_log_arch_dir = C:/MySQL/data/

set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M

set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
set-variable = innodb_lock_wait_timeout=50

HTH/
Martin
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed.  If you have received this email message in error, please notify
the sender immediately by telephone or email and destroy the original
message without making a copy.  Thank you.

----- Original Message ----- 
From: "Martin Gainty" <mg...@hotmail.com>
To: "Tomcat Users List" <us...@tomcat.apache.org>
Sent: Wednesday, May 09, 2007 7:55 PM
Subject: Re: Msql Connector/J


> Good Evening Terrence
>
> Many Thanks for the followup
> Following up on svens original request of installing JForum which has 
> create table script which requires MySQL with Engine=INNODB
> Any idea on how to configure MySQL with ENGINE=INNODB would be much 
> appreciated or does MySQL have to be rebuilt for that option?
>
> Thanks-
> Martin
> This email message and any files transmitted with it contain confidential
> information intended only for the person(s) to whom this email message is
> addressed.  If you have received this email message in error, please 
> notify
> the sender immediately by telephone or email and destroy the original
> message without making a copy.  Thank you.
>
> ----- Original Message ----- 
> From: "Terence M. Bandoian" <te...@tmbsw.com>
> To: "Tomcat Users List" <us...@tomcat.apache.org>
> Sent: Wednesday, May 09, 2007 7:44 PM
> Subject: Re: Msql Connector/J
>
>
>> FYI-
>>
>> http://dev.mysql.com/doc/
>>
>> -Terence M. Bandoian
>>
>>>
>>> Subject:
>>> Re: Msql Connector/J
>>> From:
>>> "Martin Gainty" <mg...@hotmail.com>
>>> Date:
>>> Wed, 9 May 2007 16:37:56 -0400
>>> To:
>>> "Tomcat Users List" <us...@tomcat.apache.org>
>>>
>>> To:
>>> "Tomcat Users List" <us...@tomcat.apache.org>
>>>
>>>
>>> you and sven need to search thru the mostly nonexistent MySQL
>>> documentation on how to
>>> start MYSQLd
>>> create a user (other than null@localhost)
>>> create DATABASE
>>> create TABLE in DATABASE
>>> turn on INNODB
>>>
>>> the MySQL documentation is pretty much nonexistent so you and sven
>>> should have lots of fun
>>>
>>> M-
>>>
>>> GL
>>> M--
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To start a new topic, e-mail: users@tomcat.apache.org
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
> 


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org