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

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 i

Re: MySQL as spider database.

is 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

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://

Re: Server Tuning

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 Highw

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

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.

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:/

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 Hodgkins

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 Hig

Re: Should I switch to SCSI HD for mysql?

owever, 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.hodgkin

Re: Should I switch to SCSI HD for mysql?

eate > 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