Re: Writing multi-threaded mysql application

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

Re: Queries hang on concurrent inserts/locks to the same table

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

Re: alter table blocks other tables!

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

mysql4 query cache pruning unnecessarily?

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

Re: mysql4 query cache pruning unnecessarily?

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 cache if the Qcache_free_memory is still very big? I'm

Re: upgrading to v 4.1

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. When I back down to 4.0.13 (and 3.23), I don't see that particular problem

Re: MySQL Connector/J 3.0.8 STABLE Has Been Released

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

Re: upgrading to v 4.1

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

Re: upgrading to v 4.1

, I'm experiencing the same problem here with Linux. Regards, Jocelyn - Original Message - From: LS [EMAIL PROTECTED] To: Ted Rogers [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 29, 2003 12:42 AM Subject: Re: upgrading to v 4.1 I don't know about Mac OS X, but I

i have question

hi; i tried to download the file mysqlDBD but how to find GNU zipping program? thnks leo