Datasheet

#innodb_log_arch_dir = c:\iblogs
#set-variable = innodb_mirrored_log_groups=1
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
Although you can find a complete reference of configuration at the source (www.mysql.com), the
options a beginner will be most concerned with follow. To set any of these options, simply type the
appropriate line directly in your
my.cnf file under the appropriate section.
First, we’ll discuss the
local-infile option, which can be found in the my.cnf file as follows:
[mysqld]
local-infile =1
This allows you to load large amounts of data from a tab-delimited file or .csv file directly into your
MySQL database. While this option can be very helpful if you are running your own Web site, or if you
are the only one accessing the MySQL configurations, many third-party hosts have this set to 0 to block
their MySQL hosts from accessing this command, primarily for security reasons. If you are contemplat-
ing having your Web site hosted by a third party and you will need this feature, you may want to verify
that they have this setting enabled to save yourself some major headaches later on, such as having to
manually input large amounts of data a bit at a time, or having to write a subroutine that inputs the data
for you. If you haven’t yet chosen your third-party host, this will be an important selling point.
23
Configuring Your Installation
04_579665 ch01.qxd 12/30/04 8:09 PM Page 23