x27;
Cc: [EMAIL PROTECTED]
Subject: Re: Space is filling up
Jack Coxen wrote:
> If you database contains time-based data you could age out old
> records. I only need to keep data for 6 months so I run a nightly
> script to delete any records more than 6 months old. And before
>
If you database contains time-based data you could age out old records. I
only need to keep data for 6 months so I run a nightly script to delete any
records more than 6 months old. And before anyone asks...yes, I also run
another script to ANALYZE/OPTIMIZE my tables.
Jack
-Original Messag
You might also want to read these articles:
http://www.onlamp.com/lpt/a/4397
and
http://dev.mysql.com/tech-resources/articles/wizard/index.html
In addition, there's a Perl module - DBIx::SQLCrosstab - that may help.
It's available from CPAN at
http://search.cpan.org/~gmax/DBIx-SQLCrosstab-1.17.
the before and after data.
Jack
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 1:52 PM
To: Jack Coxen
Cc: MySQL List (E-mail)
Subject: Re: DISTINCT query
Jack,
I am not sure what you want your output to look like... If you want the
sa
00'
AND speed!='1000'
AND speed!='1200'
AND speed!='2400'
AND speed NOT BETWEEN '4000' AND '4600'
AND speed!='1'
AND speed!='15500'
AN
This isn't caused by MySQL. It's an OS issue. Linux and Unix are case
sensitive operating systems so any program you run, unless it is
specifically written to be NON-case sensitive, is case sensitive as well.
Jack
-Original Message-
From: Andre MATOS [mailto:[EMAIL PROTECTED]
Sent: Wedn
e file, it goes
back to sleep.
Jack
-Original Message-
From: William Wang [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 1:43 PM
To: Jack Coxen; [EMAIL PROTECTED]
Subject: RE: many updates really slow
Thanks Jack and Jeremy.
But this is part of my application and I need to do
this a
I'm guessing here but it sounds like you have the cmd.sql file on your local
machine (in Europe). If that's the case, compress the file, ftp it to the
US server, uncompress it and do the load locally on the US server.
If you're doing the update remotely, you're probably being killed by
transmissi
AND speed!='2400'
AND speed NOT BETWEEN '4000' AND '4600'
AND speed!='1'
AND speed!='15500'
AND speed NOT BETWEEN '59900' AND '65000'
AND speed!='
Is there a planned release date for the production version of 4.1 x? I'd
love to be able to use sub-queries but I don't want to use a non-production
version on a production database.
Jack
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Monday, April 19, 2004 6:30 PM
fairly easy and the documentation that comes with the module is clearly
written with tons of examples.
Jack
Jack Coxen
IP Network Engineer
TelCove
712 North Main Street
Coudersport, PA 16915
814-260-2705
-Original Message-
From: Bart De Man [mailto:[EMAIL PROTECTED]
Sent: Thursday, April
would be best.
I'm running MySQL 4.0.16 standard on a Sun e250 running Solaris 8. The
database consists of around 650 tables ranging in size from 20 KB to 3-4 GB
(approx. 12 million records).
Any help and advice would be greatly appreciated. If more info is needed,
please let me know.
Ja
PROTECTED]
Sent: Monday, March 29, 2004 12:24 PM
To: Jack Coxen
Cc: '[EMAIL PROTECTED]'; MySQL List (E-mail)
Subject: RE: Index not functioning - update
just out of curiousity,
have you tried the 4.1.1 version?
there may (or may not) be something from 4.1.0 to 4.1.1
could be a total wa
7;ll do that if I
have to but I'd prefer to fix the existing setup of a single index on dtime.
Jack
-----Original Message-
From: Jack Coxen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 1:51 PM
To: '[EMAIL PROTECTED]'; MySQL List (E-mail)
Subject: RE: Index not fun
The index is on dtime only. I've done some testing and dual-column indexes
using id and dtime are significantly faster. However, I'm not one of the
developers of this package - RTG. I have reported the speed increase to
them, though.
In the meantime, I'm trying to run a "standard" system so I'm
sec)
Is my syntax wrong?
The resultset size should be around 8640 rows - 5 minute interval data for
30 days - 12 X 24 X 30 = 8640
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 1:22 PM
To: Jack Coxen; MySQL List (E-mail)
Subject:
, 2004 12:24 PM
To: Jack Coxen; MySQL List (E-mail)
Subject: Re: Index not functioning
The optimizer is informing you that `it` believes a table scan is more
efficient than using an index due to the resultset size.
On Wed,
24 Mar 2004, Jack Coxen wrote: >
> I have a series of tables tha
have any suggestions on what is going on and how I can fix it?
Any help would be greatly appreciated.
Thanks,
Jack
Jack Coxen
IP Network Engineer
TelCove
712 North Main Street
Coudersport, PA 16915
814-260-2705
$statement="DELETE FROM ifInUcastPkts_$rid WHERE dtime < '$deldate
$deltime'";
&run_query($statement);
print "$statement\n";
$statement="DELETE FROM ifOutUcastPkts_$rid WHERE dtime < '$deldate
$deltime'";
&run_query($s
Original Message-
From: Michael S. Fischer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 1:43 PM
To: 'Jack Coxen'; 'MySQL List (E-mail)'
Subject: RE: Delete questions and speed/safety issues
It's quite possible you're using the wrong tool for the job.
is a primary concern. If this takes a day or two to
run but the application can be running at the same time then there's no
problem. But if I have to shut down my application for any appreciable
length I time, then I have to find another way of doing this.
Thanks,
Jack
Jack Coxen
IP Network Engineer
TelCove
712 North Main Street
Coudersport, PA 16915
814-260-2705
ld 2GB RAM and I'm already at 1.5GMB. I've
modified the RTG table structure to use different indexes and modified the
Perl/PHP scripts to suit those changes and gotten significant performance
boosts from that. What I really need are system tweaks and configuration
changes to improve perfo
A shell prompt is the Unix/Linux equivalent of the DOS prompt. Since you
have the choice of several different operating systems shells to work in
(Bourne shell - sh, Korn shell - ksh, C shell - csh, Bourne Again shell -
bash (my favorite), etc) the command line prompts are generically referred
to
23 matches
Mail list logo