mysql libs and multiple hostnames

dly connects to "db.example.com" and my nameserver round-robins through those IPs, will the client also keep cycling through those? What is the behaviour if one of those hosts does not respond? Will the client application then try the next one? Thanks, Charles ___ Charles Sprickman NetEn

mysql libs and multiple hostnames

of those hosts does not respond? Will the client application then try the next one? Thanks, Charles ___ Charles Sprickman NetEng/SysAdmin Bway.net - New York's Best Internet - www.bway.net [EMAIL PROTECTED] - 212.655.9344 -- MySQL General Mailing List For list archives: http://lists.mysql

RE: mysqladmin shutdown command hangs

I've seen work). Your script can then wait a bit and see if mysql has stopped or not. If it hasn't, then you can get out the "kill -9" hammer. Thanks, Charles > Thanks again, > Ravi > > > -Original Message- > From: Charles Sprickman [mailt

Re: mysqladmin shutdown command hangs

On Thu, 8 Jul 2004 [EMAIL PROTECTED] wrote: > When there is an accidental communication breakdown between disk array > and server on which mysql process is running (e.g, pulling out FC > cable), this is being detected by our scripts and then we are trying to > shutdown the mysql process by using m

Re: slow response time

On Tue, 6 Jul 2004, Jeremy Zawodny wrote: > > procs memory pagedisks faults cpu > > r b w avmfre flt re pi po fr sr da0 md0 in sy cs us sy > > > > 0 13 0 782108 61388 748 0 0 0 863 0 13 0 399 3756 276 23 95 > > 2 13 0 78

Re: slow response time

On Tue, 6 Jul 2004, Jeremy Zawodny wrote: > On Tue, Jul 06, 2004 at 02:29:16PM -0400, Charles Sprickman wrote: > > On Tue, 6 Jul 2004, Jeremy Zawodny wrote: > > > > > Do you have a summary of the poor performance somewhere? Or at least > > > a sense of

RE: slow response time

is fine. I also see that vpopmail simply doesn't call mysql_close() in many places; the vpopmail folk claim that this is "OK", but I wonder if it's upsetting mysql in some way. Thanks, Charles > -Original Message- > From: Charles Sprickman [mailto:[EMAIL PROTE

Re: slow response time

On Tue, 6 Jul 2004, Jeremy Zawodny wrote: > Do you have a summary of the poor performance somewhere? Or at least > a sense of where you think the bottleneck is? The best I can tell you is that mysql + moderate qmail load on the same box causes problems. I don't know if this is a scheduler issue

Re: slow response time

On Tue, 6 Jul 2004, Egor Egorov wrote: > Charles Sprickman <[EMAIL PROTECTED]> wrote: > > > So I haven't really done much to optimize things, as this seems like a > > fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux > > Threads)

Re: slow response time

arles On Thu, 1 Jul 2004, Charles Sprickman wrote: > Hi, > > I have (what I thought) was a fairly small mysql setup. It's backing a > vpopmail installation, and basically just handling alot of SELECTs. > > In the process of delivering mail, the db gets hit a few times: >

slow response time

Hi, I have (what I thought) was a fairly small mysql setup. It's backing a vpopmail installation, and basically just handling alot of SELECTs. In the process of delivering mail, the db gets hit a few times: -initial check that the user exists during smtp conversation -lookup for homedir during

displaying errors in "load data from..."

Hi, I've seen this question asked before, but I'm hoping maybe this is now possible. When one does a "LOAD DATA INFILE..." or similar and get a result like this: Query OK, 428 rows affected (4.30 sec) Records: 428 Deleted: 0 Skipped: 0 Warnings: 431 ...is there any possible way to see the e