Re: Excessive Server Load Problems

happy to help you. :) Its highly possible as this is the first database ive had to use with a large number of records. I shall look into indexing part of databasing now. Any suggested places to start that explains it helpfully ? Regards Chris Aitken The Web Hub Designer and Programmer Phone : 0

Excessive Server Load Problems

d down? My understanding of "nice" is that it puts mysql's cpu usage priority at the lowest. But if nothing else on the box needs the CPU, it'll still run full and bring load over 5 making sendmail crash anyway. Any responses would be appreciated. Regards Chris Aitken The W

Query with avg on last 60 entries

I have come up with a bit of a problem which I cant seem to work out... I have a table that gets updated every minute with data. The table has 3 fields in it... id, date, number what im trying to do with a single query is, select the last 60 records, and output the average of the number field w

mysqldump and a running mysql

really dont want to have any downtime to process the backup. Any info would be appreciated. Chris -- Chris Aitken - Administration/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2 4628 fax: +61 2 4628 8890

Ordering Semi-Numeric ???

because ultimately I want to do a descending sort, and just grab the last record.. Am I making sense, cause ive managed to confuse myself a little here :) Cheers Chris -- Chris Aitken - Administration/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2

Weird Error Inserting

Unable to insert [ insert into match (league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3') ]: You have an error in your SQL syntax near 'match ](league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')' at line 1.

Unix Shell Auth from MySQL

and instead using a MySQL database for auth. It sounds like a bit of a pipe dream but I figured i'd ask here because I havent been able to find anything on this. Thanks Chris -- Chris Aitken - Administration/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone:

DBI on FreeBSD & MySQL

comed. Cheers Chris -- Chris Aitken - Administration/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2 4628 fax: +61 2 4628 8890 __-__ *** Big Brother *** It just shows tha

Re: Expect Script accessing MySQL

tion with the serial device succeeds or not. Thats why Im wanting to use expect... and thats why I am trying to find a way to get mysql data into an expect script. Chris -- Chris Aitken - Administration/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2 4628

Expect Script accessing MySQL

Hi, Just a quick query. I haven't been able to locate any documentation on it, but has anyone ever used an expect script to connect to a MySQL database and pull out a bunch of data for use further in the expect script ? Any directions would be appreciated. Cheers Chris --

Select Highest ID query

that the record with the highest ID field is the newest record. Any suggestions on how I can do this efficiently ? Thanks Chris -- Chris Aitken - Administration/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2 4628 fax: +61 2 4628 8890

Shutting down Mysql

. Which is the best method for stopping mysql and then restarting it ? mysqladmin shutdown ? and whats the best way to start it back up again just running the .sh file(s) from /usr/local/etc/rc.d ? Thanks Chris -- Chris Aitken - Administration/Database Designer

Resetting root password

root can reset the mysql root password so he can go in and reset it ? Thanks Chris -- Chris Aitken - Webmaster/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2 4628 fax: +61 2 4628 8890

Weird Ordering & Queries

so much easier if I could do it. Thanks Chris -- Chris Aitken - Webmaster/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2 4628 fax: +61 2 4628 8890 Unix

Making a table have no Duplicates

Hi Everyone. Just a quick question I worked out once before on my lonseome and the mysql manual, but it was longer ago than yesterday and it a blur how I did it. What I need to do is. I have a table, and in that table there are several fields which need to be unique. What do I need to do t