mysql w/ mod_perl

2003-08-14 Thread Bob Ostermann
I've noticed that when I reboot a hung server (S1) that was using mod_perl to gain access to a remote mysql server (S2), the mysql threads on S2 persist even after S1 returns to active duty. This can (did) lead to the dreaded "Too many connections" error. I really don't want to hup S2/mysqld if

Re: inserting images to mysql - is it possible?

2003-06-30 Thread Bob Ostermann
0/03 -0500, you wrote: Bob: This question comes up over and over on the list ... do a search for 'images' of the list archive and you can read the accumulated pros and cons. Gerald Jensen - Original Message - From: "Bob Ostermann" <[EMAIL PROTECTED]> To: <[EMAIL

Re: inserting images to mysql - is it possible?

2003-06-30 Thread Bob Ostermann
Armand- Why is it not recommended to store images in a database? I've not heard this... bob. At 09:51 PM 6/29/03 +0200, you wrote: Hi, You have to insert a new blob field where you can store binary data. But it is not recommanded to store images in a database. I recommande you to store image

Re: slow performance on simple queries

2003-06-26 Thread Bob Ostermann
u run your query in another, what result do you get from the iostat? -- Michael Conlen Bob Ostermann wrote: Hi- I'm running mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) / RedHat 7.3 on a AMD 2400XP 256 MB. I've got a table (type=MyISAM) that's grown to 1,7 GB (154,815 recor

slow performance on simple queries

2003-06-26 Thread Bob Ostermann
Hi- I'm running mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) / RedHat 7.3 on a AMD 2400XP 256 MB. I've got a table (type=MyISAM) that's grown to 1,7 GB (154,815 records) and it takes several seconds to perform even simple querys: select data from eod where symbol='ZOOM' yields: 1 row