-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ledet, Mike wrote:
| 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.
|
I'm afraid, you table row isn't fixed-length row, as far as you'll be using varchar your rows will not be considered to be a
fixed length rows. try to change it to char(60) (BINARY if you don't care for U/L case) this may help. it will be more helpful if
you provide table structure for us...
I have table with approx 6M rows with fixed length, used for site statistics with approx. ++250k rows/day. There are extensive
writes (UPDATE DELAYED) and minor reads and I'm not having problems... As for my config its 2x 1GHz PIII + 1GB RAM + 2 channel
onboard SCSI on 64-bit PCI WITHOUT RAID, 2x 16GB 10,000 RPM SCSI-HDD one disc is used for db data only. As for RAID 0 it is not
very good idea to have databases stored in that manner (safety - if one disk fails, you will lost everything ...).
| 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.
|
As I wrote, to keep table fixed-length you must not use varchar. As for datetime I'm using UNSIGNED int(11) and unix_timestamp to
store date and time.
| 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.
ext-3 is so-called journaling file system. it has small performance slow-down (no flame, please ;-))
|
| 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.
everyone had been newbie. Keep trying :)
TIPS:
- check settings for your RAID controller -
are you using native driver for SCSI/RAID controller ?
# of TCQ (tagged commands queuing)
elevator sorting - should be ON
- do you really need ext3?
- rethink structure of your table (R. M. Ryordan Designing relational database, ISBN:073560634X - it is MS oriented, but
theoretical parts are very good and helpful for any platform)
|
| Thanks in advance
|
| Mike
- --
Mirek Novak
Anima Publishers, s.r.o.
Prilucka 360, Zlin 760 01
Czech Republic
tel/fax: 067/721 91 32
jabber:[EMAIL PROTECTED]
ICQ:119499448
GSM:+420603807837
AUTO.CZ
http://www.auto.cz
NEWS.AUTO.CZ
http://news.auto.cz
FORMULE1.CZ
http://www.formule1.cz
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAj3vJNoACgkQz+tW1WzgrpSjSACcD1R30nPOyUUgjmg//61aQaBX
ltsAmwTEHf+A3eZo5kNKnF6F+qJs8Keb
=53Lx
-END PGP SIGNATURE-
-
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
