MY EXPERIENCE WITH MYSQL GAMMA 4.08 on win2000 professional SP 3
was not too bad:
PREPARE
A shutdown mysqlmax-nt (3.23.53) running as NT service,
B downloaded mysql-4.0.8-gamma-win.zip to desktop
C extracted zip to e:\mysql408
D installed to e:\mysql408\install
E opened the html manual
F skimmed 2.122 of the manual, and ignored recommendation
to remove old service. THIS WAS STUPID OF ME.
G. did not use named pipes. I always try to use TCP/IP
H edited my-large.cnf, since i have about 170 million
records in my dev machine (I develop in windows, and deploy on linux)
ok ok, its just a hobby - but it keeps me out of trouble.
I. edits in my-large.cnf (i changed name to my.cnf and left it in the base
directory) (THIS WAS STUPID) (Later on I changed name to my.ini and put it
into WINNT root.
set basedir=e:\\mysql408\\install ##i used the double backslashes ok..
set datadir = e:\\mysql408\\install\data #used double backslashes
uncommented the Innobase tables lines and set
the path to e:\\mysql408\\install\\ibase\\data #for the data
uncommented the Innobase tables lines and set the
path to e:\\mysql408\\install\\ibase\\logs #for the logs
set the innobase arch dir to e:\\mysql408\\install\\ibase\\logs
made no changes to the rest of the innobase cnf lines. left as is.
J. opened a dos shell , cd to the basedir\bin and ran
mysqld-max --standalone, then
GOT ERROR ON START
A. error message file e:\mysql\share\english\errmsg.sys had only 218
messages, should have 237.
FIX
It was looking at the old "my.ini" file in E:\WINNT, so i changed the base
directories there (Half of a fix really...)
Now i tried to install as service, since it ran standalone........
K TRIED TO RUN AS SERVICE
GOT SYSTEM ERROR 1067 - This is totally unintelligible ..its really
MicroSpeak for "GOTCHA" :-)
FIX BELOW
1. used only my.ini in the windows NT directory. did not use my.cnf in the
nonstandard directory (this way I can install to my E drive)
2. used my-large.cnf as the base to create the my.ini file in E:\WINNT - the
others probably work fine too...
3. ran mysql-max --standalone --console #and got error messages
indicated i had bad syntax errors in my my.ini file in e:\winnt
4. fixed the bad entries in my.ini located in E:\WINNT
5. did mysqld-nt-max --remove (removed old service)
6. did mysqld-nt-max --install (install new service)
7. did net start mysql -- with INNODB -- got lots of nice messages...ran
smooth
8. created JimTest database
9. imported 30 million records from testfile - import took 2:33 -- went
smooth
10. ran select = select * from mytable where name REGEXP '^joe.*$' LIMIT
5000 #select ran fine although it took 2:15
11 created index on name - went out for a walk....(hey its 30 million
records!) 51:23
12 reran the select in #9 - now takes 2:14 - a 1 second improvement --- but
lots of optimizations remain....
CONCLUSION
it works fine, but if not using C drive be sure to use my.ini in the WINNT
root, and not my.cnf in the non-standard directory (OR just install to C,
like most people do...)
MY.ini file below===============>========================>
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options (I copied this to
WINNT\my.ini)
#
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options
# This will be passed to all mysql clients
[client]
#password=my_password
port=3306
#socket=MySQL
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# The MySQL server
[mysqld]
port=3306
#socket=MySQL
skip-locking
set-variable = key_buffer=256M
set-variable = max_allowed_packet=1M
set-variable = table_cache=256
set-variable = sort_buffer=1M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
log-bin
server-id = 1
# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = e:\\mysql408\\install
datadir = e:\\mysql408\\install\data
# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=64M
#set-variable = bdb_max_lock=100000
# Uncomment the following if you are using Innobase tables
innodb_data_file_path = ibdata1:1000M
innodb_data_home_dir = e:\\mysql408\\install\\ibase\\data
innodb_log_group_home_dir = e:\\mysql408\\install\\ibase\\logs
innodb_log_arch_dir = e:\\mysql408\\install\\ibase\\logs
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=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
=========================================
I needed to install it anyway...
Hope this helps sql fans!
Jim
==================================Fin
-----Original Message-----
From: My Deja [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 6:35 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Has anyone managed to get 4.0.8 Win32 working properly?
Has anyone managed to get MySQL 4.0.8 Windows 2000
successfully?
I am trying to run it as an additional service. It
keeps crashing when I try to access data.
sql, query
__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail [EMAIL PROTECTED] instead.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
