I'm not sure if there are formal resources on this topic, but here are some basic
guidelines I have followed in the past:
1) You can imagine that each running thread will have its own MySQL connection.
2) The connection can get created and held for the lifetime of a thread, or, if you
plan to have
Mike, what version of MySQL are you running?
A month ago or so, I tried 4.1alpha on a FreeBSD4.8 machine and noticed the same
thing you are describing. I had a bunch of threads inserting on a MyISAM table and
the threads would just wedge. They'd show up in SHOW PROCESSLIST and wouldn't
respond to
I would assume that if you have two MySQL threads, one doing the ugly ALTER TABLE
and another responsible for a simple SELECT query (perhaps even query cached) on a
table in another database, that no matter how long that ALTER TABLE thread took,
the OS would schedule the SELECT thread soon enough a
if someone could clear it up for sure.
http://www.mysql.com/doc/en/Query_Cache_Status_and_Maintenance.html
--- Per Andreas Buer <[EMAIL PROTECTED]> wrote:
> LS <[EMAIL PROTECTED]> writes:
>
> > Hi-
> > Can anyone tell me why mysql4 would prune queries from the cach
Hi-
Can anyone tell me why mysql4 would prune queries from the cache if the
Qcache_free_memory is still very big? I'm confused why we get so many
Qcache_lowmem_prunes:
| Qcache_queries_in_cache | 175011 |
| Qcache_inserts | 343244 |
| Qcache_hits | 4041221|
|
wrote:
> On Wed, May 28, 2003 at 03:42:24PM -0700, LS wrote:
> >
> > I don't know about Mac OS X, but I can tell you that with 4.1 on
> > FreeBSD w/LinuxThreads, my application's query threads get hung up
> > almost instantly, requiring a kill -9.
> >
n "opening table" state
> when doing a show processlist ?
> If this is the case, I'm experiencing the same problem here with Linux.
>
> Regards,
> Jocelyn
> - Original Message -
> From: "LS" <[EMAIL PROTECTED]>
> To: "Ted Rogers&
I don't know about Mac OS X, but I can tell you that with 4.1 on FreeBSD
w/LinuxThreads, my application's query threads get hung up almost instantly,
requiring a kill -9.
When I back down to 4.0.13 (and 3.23), I don't see that particular problem anymore.
So keep an eye out for how it behaves for
Where does Connector/J fit into the MySQL3.23.x versus MySQL4.x client libraries?
Someone mentioned to me today that mod_php is still compiled with the old 3.23
client even though it may be talking to a 4.x server, so I'm wondering if
Connector/J does anything different depending on whether it's ta
hi;
i tried to download the file mysqlDBD but how to find GNU zipping program?
thnks
leo
10 matches
Mail list logo
