Re: C api - mysql_list_fields

2008-10-07 Thread Doug Bridgens
It works for me, I used your code: Field =mycol Type=254 Length=20 so at least your code is fine, and the problem must be somewhere else. I am using RH EL3. cheers, Doug On 6 Oct 2008, at 19:52, Mike Aubury wrote: I'm probably being a bit stupid - but I'm trying to determine (in code)

Re: Ancient, unsolved high-CPU problem

2008-09-23 Thread Doug Bridgens
it's all a bit too general, we could be asking continual questions until someone asks the right one. However, I would put some debugging into the 30% scripts to check they complete before the next one starts, as if one script takes slightly longer (especially if the queries are the same)

Re: Ancient, unsolved high-CPU problem

2008-09-23 Thread Doug Bridgens
-Sep-08, at 3:47 PM, Doug Bridgens wrote: it's all a bit too general, we could be asking continual questions until someone asks the right one. However, I would put some debugging into the 30% scripts to check they complete before the next one starts, as if one script takes slightly longer

Re: another INNODB vs MYISAM question

2008-08-15 Thread Doug Bridgens
if you switch the default engine type any new tables would be created with that new engine type. it does not convert existing tables to your new format. if you have existing innodb tables you need to have the innodb settings active, in my.cnf On 15 Aug 2008, at 06:01, [EMAIL

Re: Slow mysql connections

2008-08-13 Thread Doug Bridgens
Do you have any other services running on the server, such as mail or web? How long does it take to connect to those services ('telnet server 25', or telnet server 80')? What are you using to connect to mysql? how long does 'telnet server 3306' take (assuming you are on the default