Threads on FreeBSD 4.9

Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug I am running FreeBSD 4.9 with Mysql 4.0.18 compiled with Linux Threads. I am running large inbound concurrency on Postfix which is forking several processes.

Performance Tuning on FreeBSD

Hi all, I have a db that is connection heavy running on FreeBSD 4.9. The server was compiled with Linux Threads enabled. I am searching for performance tuning information. Outside of enabling Linux Threads I haven't been able to find much else. I am under the impression that I should be using

Re: Select Date Help

Thanks everyone for their help! Max Clark [EMAIL PROTECTED] wrote in message av2eai$8he$[EMAIL PROTECTED]">news:av2eai$8he$[EMAIL PROTECTED]... Hi all, I have a DATE column (CCYY-MM-DD), I would like to do a query like this: select * from table where date = '2003-01' What ad

Select Date Help

Hi all, I have a DATE column (CCYY-MM-DD), I would like to do a query like this: select * from table where date = '2003-01' What additional information do I need to provide for this query to work properly? Thanks in advance, Max

newbie - linking queries with dynamic where conditions

Hi- I am trying to write a sql query that will output (domain, transport, sum(count), sum(size)) from multiple tables for many records. When the domain field is dynamic based on the adminId passed to the query, how do I execute the second query at the same time? Thanks in advance, Max select

Re: newbie - linking queries with dynamic where conditions

because of the error. Can anyone point me in the right direction? Thanks in advance, Max Max Clark [EMAIL PROTECTED] wrote in message ataq2r$ev1$[EMAIL PROTECTED]">news:ataq2r$ev1$[EMAIL PROTECTED]... Hi- I am trying to write a sql query that will output (domain, transport, sum(count),

Newbie- Help with query

Help! I am a new mysql user, I understand the basic syntax of the commands for different sql queries. I am trying to write a query and I can't seem to figure it out. I would like to select all domain,transport fields from the transport table where the transport id = a query agains the acl

Newbie - group and tally help

Hi- I am trying to write a sql query that will select, group and tally records returned. select name, count from stats order by name; foo2 foo4 foo6 foo15 foo210 foo315 I would like the output to be like this: foo12 foo130 How do I accomplish this in mysql?

Newbie - auto_increment multiple table insert help

Hi- I would like to run an insert query across two tables at the same time. The first table has a primary key that is auto_increment, the second table needs to insert the primary key from the first table as a reference? How do I auto-populate the tableId field with the correct entry from the