Well, I've got an MSDN subscription so I have access to a legal copy.. the non-unix thing is a downside but there are number of scp command line utilities for Windoze that I can use to move the data back and forth as needed....
I'm seriously thinking of biting the bullet and going that way. -----Original Message----- From: Adam Nelson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 5:18 PM To: 'Ledet, Mike'; [EMAIL PROTECTED] Subject: RE: Slow performance using 3.23 on RH 8.0 Don't let this list fool you. SQL Server is a very good product. It is far superior to Mysql in every way except cost and the fact that it doesn't run on unix. > -----Original Message----- > From: Ledet, Mike [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 04, 2002 5:12 PM > To: 'Adam Nelson'; [EMAIL PROTECTED] > Subject: RE: Slow performance using 3.23 on RH 8.0 > > > Actually it is hardware Raid 0, not software. I knew about > the safety issue > but I had been told that from a performance stand-point that > Raid 0 was the > fastest. > > I've watched the disk activity on the IDE drive and there is > next to none, > but I guess it's possible something is going on there. > > Gnome is because linux is very new to me... I found the GUI to be > comfortable coming from a Windoze world. Since I first > installed I've had a > crash course in doing it from the command line (I'm managing > a web and mail > server as well) so at some point I could probably undo it. > > I'll try the variables when I get a chance. > > Just as an aside I had a friend running SQL Server on a 2000 > box that is a > pretty similar configuration... he added the same 3 columns > to a table with > 5 keys and 3 times as many columns in less than 2 minutes. > > -----Original Message----- > From: Adam Nelson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 04, 2002 4:35 PM > To: 'Ledet, Mike'; [EMAIL PROTECTED] > Subject: RE: Slow performance using 3.23 on RH 8.0 > > > The first thing I would do is toss the ultra ata drive and > just use the > scsi drives running raid1, raid0 just isn't safe and hardware raid1 is > much faster than you would think. This may seem > counter-intuitive, but > there are all sorts of bus issues that could be interfering. You may > very well have more logging going on on the ata drive than you think. > > Second, do not install X or gnome at all. What's the point? > > Third, look at these variables (although I doubt they will help much): > > set-variable = table_cache=256 > set-variable = tmp_table_size=256M > > If this doesn't work, get in touch. > > > -----Original Message----- > > From: Ledet, Mike [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, December 04, 2002 11:01 AM > > To: '[EMAIL PROTECTED]' > > Subject: Slow performance using 3.23 on RH 8.0 > > > > > > I'm running Mysql 3.23.52 on a Redhat 8.0 installation > > booting to Gnome. > > The machine is a dual AMD 1800, 1 gig of ram, one Ultra ATA > > IDE drive, and 2 > > 18 gig scsi 10,000 RPM drives on a RAID controller running Raid 0. > > > > I've got everything except /db on the IDE drive, /db is the > > only thing on > > the raid array. > > > > I've got a couple of smallish tables and one larger table > > with about 7 gigs > > of data. The larger table is a fixed row format table with > > each row being > > 462 bytes wide. I have a primary auto increment int column > > and a unique > > index on a varchar 60. Pack keys is off, delayed key writes on. > > > > With this kind of hardware I was expecting pretty good > > performance, but I > > haven't seen it yet. I finally decided something was wrong > > when I had to > > run an alter table on the 7 gig table, adding 3 columns, a > > varchar 12, a > > varchar 50, and a datetime columm.... and it took over 10 > > HOURS to complete. > > > > That seems way too slow to me... > > > > I've included relevant portions (the uncommented portions) > > from my.cnf, the > > OS installation was fairly vanilla, using defaults for just about > > everything. The file system is ext3. > > > > Any suggestions or things I haven't included that you need? > > Sorry if I'm > > doing something really stupid here... relatively new to Linux > > after a lot of > > years of windoze. > > > > Thanks in advance > > > > Mike > > > > ********** my.cnf ************* > > > > [mysqld] > > port = 3306 > > socket = /var/lib/mysql/mysql.sock > > datadir = /db/mysql > > skip-locking > > set-variable = key_buffer=500M > > set-variable = max_allowed_packet=2M > > set-variable = table_cache=512 > > set-variable = sort_buffer=22M > > set-variable = record_buffer=22M > > set-variable = thread_cache=8 > > # Try number of CPU's*2 for thread_concurrency > > set-variable = thread_concurrency=6 > > set-variable = myisam_sort_buffer_size=64M > > log-bin > > server-id = 0 > > tmpdir = /tmp/ > > [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=500M > > set-variable = sort_buffer=8M > > set-variable = read_buffer=10M > > set-variable = write_buffer=30M > > > > [myisamchk] > > set-variable = key_buffer=500M > > set-variable = sort_buffer=8M > > set-variable = read_buffer=10M > > set-variable = write_buffer=30M > > [mysqlhotcopy] > > interactive-timeout > > > > > > > --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
