Database Tuning Configuring MySQL Parameters
Using the best practices document (Database Tuning Configuring MySQL Parameters), I wonder if I did the setup correctly in the file "startMYSQL.bat":
@ echo off
rem $Id$
rem batch file for starting mysqld
set MYSQL_HOME=..\mysql
if "test"=="%1test" goto startmysqld
set MYSQL_HOME=%1
:startmysqld
if "%OS%"=="Windows_NT" cd /d %MYSQL_HOME%\bin
if NOT "%OS%"=="Windows_NT" cd %MYSQL_HOME%\bin
mysqld-nt --defaults-file=..\my-huge.ini --basedir=..\ --datadir=data --language=..\share\english --tmpdir="%CD%\..\tmp" --default-character-set=utf8
rem Settings for 64 bit machine, 4GB RAM
@start /B mysqld-nt --defaults-file=..\data\my.cnf --basedir=..\ --port=%DB_PORT% --
datadir=..\data --tmpdir=..\tmp --set-variable=query-cache-type=1 --
read_buffer_size=10M --read_rnd_buffer_size=10M --sort_buffer_size=10M --
join_buffer_size=10M --myisam_sort_buffer_size=50M --
myisam_max_sort_file_size=50M --key_buffer_size=400M --
bulk_insert_buffer_size=50M --innodb_buffer_pool_size=200M --
query_cache_size=200M --max_heap_table_size=100M --tmp_table_size=100M --
innodb_flush_log_at_trx_commit=2 --language=..\share\english\ --log-warnings --skipbdb --skip-ndbcluster --skip-external-locking
Tiago Toledo - Bigode
Blog: http://www.pastelariadigital.com.br