SELECT statement

I'm attempting to collate a webpage showing results by various football teams in various cup competitions, and am trying to minimise the number of selects as best I can. What I'm trying to get out in one statement is the number of home matches played by Burnley, how many they've won, drawn and los

FW: mysqld-nt claims all available CPU

MySQLd-nt (v4.0.14) is eating up all the available CPU resources on a Windows 2000 server (dual 933 Pentium, 1GB RAM), with a maximum of 40 users so far. I have tried each combination of the default configuration files, and each variety of the executable (nt, max-nt etc.), and it's always the same

mysqld-nt claims all available CPU

MySQLd-nt (v4.0.14) is eating up all the available CPU resources on a Windows 2000 server (dual 933 Pentium, 1GB RAM), with a maximum of 40 users so far. I have tried each combination of the default configuration files, and each variety of the executable (nt, max-nt etc.), and it's always the same

RE: Mysql processlist sleep time

ugust 2003 22:55 To: Gary Broughton Cc: [EMAIL PROTECTED] Subject: Re: Mysql processlist sleep time On Thu, Aug 07, 2003 at 07:54:24PM +0100, Gary Broughton wrote: > Hi all > > I continue to have problems with the CPU usage with MySQL and PHP > under IIS 5 (Win2000). I recently rewrote

A final Windows MySQL PHP plea

Hi all Is there anybody out there who has managed to successfully configure Win2000, IIS5, MySQL 4.0.14 and PHP 4.3.2 (ISAPI) to work with a couple of hundred users at any one time? I have chucked absolutely everything I can think of at this, but the MySQL (it seems) simply eats all the available

FW: A final Windows MySQL PHP plea

ailto:[EMAIL PROTECTED] (B> Sent: Tuesday, August 12, 2003 10:04 PM (B> To: Gary Broughton; [EMAIL PROTECTED] (B> Subject: Re: A final Windows MySQL PHP plea (B> (B> (B> Hi Gary, (B> (B> I understood that the packages provided by MySQL are set to 100 (B> concurr

RE: MySQL, IIS and PHP

-- From: Dan [mailto:[EMAIL PROTECTED] Sent: 04 August 2003 21:59 To: Gary Broughton; [EMAIL PROTECTED] Subject: Re: MySQL, IIS and PHP Gary Broughton wrote: >Hi all > >I've just recoded a website in PHP from ASP, running off IIS 5. It has >been tested by a dozen users over the week

Mysql processlist sleep time

Hi all I continue to have problems with the CPU usage with MySQL and PHP under IIS 5 (Win2000). I recently rewrote our messageboards in PHP (from ASP). I now have both online separately, and if I look at the processlist, the times on the ASP version rarely hit double figures, but those on the

RE: Mysql processlist sleep time

as reading advice from "MySQL Second Edition" by Paul Dubois. I just wonder if this is a problem that is unable to be solved?! -Original Message- From: Adam Nelson [mailto:[EMAIL PROTECTED] Sent: 08 August 2003 17:16 To: 'Gary Broughton'; [EMAIL PROTECTED] Subject: RE

MySQL, IIS and PHP

Hi all I've just recoded a website in PHP from ASP, running off IIS 5. It has been tested by a dozen users over the weekend, but now I have put it live the CPU utilisation is up at 100%, mainly swallowed up by mysql-nt.exe. I wondered if anyone could offer any advice as to why this could be (the

UNION or not?

Hi all I want to provide a list of up to 20 online users on our network of football forums, but would like to list those live on the current team first, before "filling" any remainder with those online using a different team. I couldn't see any way of getting it all into one select (which in E

WHERE x IN (SELECT x ...

I believe the multiple 'SELECT' statements will not be included until version 4.1 is released? If this is the case, is there a crude workaround method of attempting to perform the following until such a time as it is? SELECT COUNT(*) FROM messages WHERE forum_id IN (SELECT forum_id FROM forums WH

More COUNT GROUP ORDER woes

I'm having a problem similar to one I mentioned last week. I'm trying to retrieve the number of posts a selected user has made on a selected forum, plus details of the record of his/her latest post (date and subject). SELECT COUNT(*) AS postcount, m.user_id, m.subject, m.posting_date, u.username,

RE: Repair table

It may or may not help, but if you connect to the database using MySQLCC, you can highlight all the tables and repair, optimise or check in one go (in the Windows version at least!). Gary -Original Message- From: Jeff McKeon [mailto:[EMAIL PROTECTED] Sent: 24 July 2003 16:15 To: MySQL LI

RE: GROUP BY ORDER BY

EMAIL PROTECTED] Subject: Re: GROUP BY ORDER BY "Gary Broughton" <[EMAIL PROTECTED]> wrote: > > I wonder if someone could help with what I assume is a simple query > using GROUP and/or ORDER statements (something I struggle to get to > grips with). I am trying to get a li

GROUP BY ORDER BY

Hi I wonder if someone could help with what I assume is a simple query using GROUP and/or ORDER statements (something I struggle to get to grips with). I am trying to get a list of users who have posted to a forum by number of posts descending, but am unable to find the right statement to do i

SQL statement dilemna

atly appreciated, and if I'm asking an inappropriate question for the group please accept my apologies in advance. Many thanks Gary Broughton

MySQL 4 maintenance tasks on Windows

;myisamchk ...' line-by-line, via Windows scheduled tasks, but I don't appear to be having much luck. Any assistance or pointers in the right direction would be very much appreciated. Regards Gary Broughton -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Auto decrement

Does anyone know if there is a way of setting an auto numbered field that starts at say 2,000,000 and decreases by one on each insert? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]