Thai in MySQL
Do you have to do anything special to start putting Thai text into MySQL? Ta, Dave -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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
Re: Server Tuning
"Florian G. Pflug" <[EMAIL PROTECTED]> writes: > Hi > > I am running Mysql on a Machine with two PIII-600, and 1 GB of RAM. > The disks are connected via U2W-SCSI. > > I tried tuning mysql for maximal performance the last days, but I'm not > exactly sure which parameters I should increase, und to what value. > > Our web application is quite slow at the moment, and often the server is > slower in doing the queries than they are created by the users, which > steadily increases the number of running mysql-processes until they reach > max_connection (which is 100 at the moment). don't do this. you disappear up your own tailpipe. put a second apache behind your first and limit its MaxClients setting. this is a standard mod_perl trick and is in the mod_perl guide. > Our Application searches through about 1.000.000 Records, and does heavy > grouping, sometimes over 100.000 records. > > Is there any chance, that we can keep doing this queries on the fly, or will > we have to cache them somehow? (which has a _lot_ of downsides, since the > data changes quite frequently, about once every 1/2 hour). Have you had a good hard look at your EXPLAINs? > > Which server parameters should we increase to make things faster? > > Since a lot of users "do the same thing" on this website, we often have the > very _same_ query running 5 to 10 times, one started within 5 seconds or so > after the other. Definitely look at some form of cacheing. Do the result sets have the same columns in the result sets? you might want to consider selecting into a new results table...? -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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
Re: MySQL as spider database.
Vahan Yerkanian <[EMAIL PROTECTED]> writes: > My task is to implement several custom word parsing/modification > before writing the keywords into the database, as well as I just > want to have my own code ;-) Ah, OK. You could always just hack the spidering part of ht://Dig? -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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
Re: MySQL as spider database.
Vahan Yerkanian <[EMAIL PROTECTED]> writes: > Atle Veka wrote: > > > > Why not use something that's already created for you, and is probably > > *much* faster than your solution :) > > Oh... if it really was an acceptable choice, I won't post this question. > :)) Out of interest, what's unacceptable about ht::/Dig for you? -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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
Re: Restart MySQL after rebooting Linux
kentj <[EMAIL PROTECTED]> writes: > I believe so. I was trying that and was missing something because I could > not get it to work. If you've for it in init.d and "mysql stop" and "mysql start" work there, then make sure they're also symlinked into rc3.d directory. -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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
Re: Restart MySQL after rebooting Linux
kentj <[EMAIL PROTECTED]> writes: > I have been reading the mysql book by Dubois and trying to figure out > how to implement his restart methods > on a SUSE Linux 7.0 Box. Has anyone done this and can give me > information how to do it? You mean like putting stuff in /etc/rc.d/init.d? -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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
Re: Should I switch to SCSI HD for mysql?
"mike thomas" <[EMAIL PROTECTED]> writes: > I'll have to think about this one. My application > just consists > of a huge table of domain names and users will be > able to search for > full strings and partial strings. So I'm not sure > how I could create > an intermediate results set from this table that > would speed up queries? Split on "."? If they're looking for mycompany's domains then splitting out the mycompany part would be good... -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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
Re: Should I switch to SCSI HD for mysql?
"mike thomas" <[EMAIL PROTECTED]> writes: > Greg, > > Well, I'm doing like "%stuff%" selects on a single column table > with 20 million records, so any speed gain would be great. Would > I be correct in saying that a select of this type will always do > a table scan? Pretty much. > I think I'll go with SCSI and increase the RAM so I can use a > heap table. A cheap first step might be to go with a couple of decent 7200 rpm, ATA100 (or whatever the hell they're calling themsevles this week) disks and RAID0 them. Striping Good. Also, make sure your IDE is spiffed up to the max. Do an: hdparm /dev/hda (or whatever). Make sure it's using DMA, unmasked IRQ, 32 bit i/o and, a multcount of 16. Benchmark your drive before and after, with: hdparm -t /dev/hda You should see >10MB per second after tuning up. However, I can't help thinking for your application There Must Be A Better Way. Do you really need to do substring matching all the time? Can you pre-build an intermediate results set that can be optimally queried? Dave. -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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
Re: amazingly slow
Tim Samshuijzen <[EMAIL PROTECTED]> writes: > This still does not tell me why the query is amazingly slow. What else is happening on the system? what does, say, a vmstat 5 give? -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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
Re: problem with performance
"Pelle Eliasson" <[EMAIL PROTECTED]> writes: > Hi, > > I think I have a problem with performance. And the EXPLAIN said...? > Before posting, please check: >http://www.mysql.com/manual.php (the manual) It's in the manual... -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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
Re: amazingly slow
Tim Samshuijzen <[EMAIL PROTECTED]> writes: > Anyone out there who wants to save me and our company? You missed the important first step: EXPLAIN the query. -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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
Re: Dreamweaver can't connect to MySQL - that can't be!
"Murph" <[EMAIL PROTECTED]> writes: > I'm test-driving Dreamweaver UltraDev 4 and can't get it to connect to = > my remotely hosted MySQL database despite the last six hours' worth of = > effort. Macromedia's online docs aren't helping much. Can you do it via any other front end? -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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