On Fri, Oct 1, 2010 at 12:24 PM, Jake Peavy wrote:
> All,
>
> I have a number of routers which report in with various stats
> periodicially. This period is not a regular interval and can drift based on
> other factors. Each router drifts independently. The stats the routers
&g
All,
I have a number of routers which report in with various stats
periodicially. This period is not a regular interval and can drift based on
other factors. Each router drifts independently. The stats the routers
provide need to be analyzed in terms of deltas between reports (rather than
the a
On 9/19/08, Kinney, Gail <[EMAIL PROTECTED]> wrote:
>
> Hello, We have MySQL 4.0.14 and have just gotten an error:
>
Please help.
>
Answer the door, 2004 is calling.
--
-jp
I hope that someday we will be able to put away our fears and prejudices and
just laugh at people.
deepthoughtsbyjackh
On 7/19/08, Rob Wultsch <[EMAIL PROTECTED]> wrote:
>
> On Sat, Jul 19, 2008 at 6:54 AM, Jake Peavy <[EMAIL PROTECTED]> wrote:
> > I may be wrong, but I think you could accomplish this through the use of
> > triggers. Triggers are designed to monitor data change ac
On 7/18/08, Jason Yergeau <[EMAIL PROTECTED]> wrote:
>
> Hi Rob ---
>
> MySQL 5.
>
>
>
> On Fri, Jul 18, 2008 at 3:01 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> > On Fri, Jul 18, 2008 at 2:00 PM, Jason Yergeau <[EMAIL PROTECTED]>
> wrote:
> >> I'm having trouble working through a data problem. A
On 4/5/08, Jonathan Mangin <[EMAIL PROTECTED]> wrote:
>
> I'm getting incorrect results from a sum and wonder if
> anyone sees something obviously wrong. (Won't surprise
> me.) Leaving 'simple' out of the equation (or adding
> 'simple' values manually) gets me the correct number.
>
> $menu is a per
Hi all,
Can someone suggest a good method or normalized schema for storing product
information (id, description, price) which changes over time so that as a
product is gradually discounted, an order will reflect the cost of that
particular product at that particular time?
--
-jp
At birth, Chuck
On 5/4/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi,
Jake Peavy wrote:
> On 5/4/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>>
>> Mark Leith wrote:
>> > Baron Schwartz wrote:
>> >> I will test again on my servers now that I have upgraded t
-- Forwarded message --
From: Jake Peavy <[EMAIL PROTECTED]>
Date: May 4, 2007 7:41 AM
Subject: Re: expire_logs_days
To: Baron Schwartz <[EMAIL PROTECTED]>
On 5/4/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Mark Leith wrote:
> Baron Schwartz wrote:
>&
On 2/6/07, Yong Lee <[EMAIL PROTECTED]> wrote:
Hi all,
Just wondering how people are dealing with tables that are used for
logging, ie: insert only tables supporting occasional queries used for audit
or event logs.
These tables will keep growing and there is no need to keep them that
large
On 1/25/07, Sid Lane <[EMAIL PROTECTED]> wrote:
all,
I have been tasked with upgrading a critical 3.23.55 database to 5.0
(.27-ish).
short version is it's never been upgraded because authors have moved on
and
nobody's sure of everything that uses it.
I enabled the general log a few days ago an
On 1/11/07, Dan Nelson <[EMAIL PROTECTED]> wrote:
In the last episode (Jan 11), Jake Peavy said:
> On 1/11/07, Gilles MISSONNIER <[EMAIL PROTECTED]> wrote:
> >How could I load in the database, data from a text file containaing
> >date in a NOT MySQL standard date form
On 1/11/07, Gilles MISSONNIER <[EMAIL PROTECTED]> wrote:
hello,
I rewrite my question in a simpler (?) way :
How could I load in the database, data from a text file containaing date
in a NOT MySQL standard date format [precisely char(10)], so that I get
the date into a MySQL standard date forma
-- Forwarded message --
From: Jake Peavy <[EMAIL PROTECTED]>
Date: Jan 4, 2007 10:48 PM
Subject: Re: mysql data into CSV file.
To: Shain Lee <[EMAIL PROTECTED]>
On 1/4/07, Shain Lee <[EMAIL PROTECTED]> wrote:
I wanted to get that info which has stored in rela
On 12/6/06, Mikhail Berman <[EMAIL PROTECTED]> wrote:
-Original Message-
>
From: Dotan Cohen [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 06, 2006 3:37 PM
> To: MySQL General
> Subject: How many records in table?
>
> What's a quick query to determine how many records a given tab
As I only qualify as 'barely literate' as a Unix admin, does anyone know of
a good article on inode count, or, even better, one as it pertains to
partitioning?
I'm thinking about developing a two partitions per month per table schema
but I'm worried about the sheer number of files this will creat
On 7/10/06, Kishore Kumar Barik <[EMAIL PROTECTED]> wrote:
< snip >
Please send me solution immediately.
anything else, your highness?
--
-jp
Chuck Norris got in touch with his feminine side, and promptly got her
pregnant.
On 7/6/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
On 7/6/06, Chuck Holzwarth <[EMAIL PROTECTED]> wrote:
>
> Is there a way to set the auto_increment start number? I am trying to
> set up a development and test system and the application that is writing to
> the tables
On 6/13/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
On 6/7/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
>
> On 6/7/06, Paul DuBois <[EMAIL PROTECTED]> wrote:
> >
> > At 17:30 -0600 6/7/06, Jake Peavy wrote:
> > >Hey yall,
> > >
> > >I&
On 5/24/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server. I think that by doing somethin
On 6/7/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
On 6/7/06, Paul DuBois <[EMAIL PROTECTED]> wrote:
>
> At 17:30 -0600 6/7/06, Jake Peavy wrote:
> >Hey yall,
> >
> >I'm unable to open the .chm I just downloaded for 5.1. I get the
> followi
On 6/8/06, Jay Pipes <[EMAIL PROTECTED]> wrote:
Jesse wrote:
> I have been using Microsoft SQL Server for a while, and I'm now trying
> to switch all our applications over to use MySQL. Microsoft SQL Server
> is pronounced "Sequel Server". Is MySQL pronounced "My Sequel", or is
> it pronounced
On 6/7/06, Paul DuBois <[EMAIL PROTECTED]> wrote:
At 17:30 -0600 6/7/06, Jake Peavy wrote:
>Hey yall,
>
>I'm unable to open the .chm I just downloaded for 5.1. I get the
following
>error:
>
>Cannot open the file: mk:@MSITStore:C:\Documents and Settings\jpeavy1\My
Hey yall,
I'm unable to open the .chm I just downloaded for 5.1. I get the following
error:
Cannot open the file: mk:@MSITStore:C:\Documents and Settings\jpeavy1\My
Documents\refman-5.1-en.chm.
Any ideas?
TIA
--
-jp
One time in an airport a guy accidently called Chuck Norris "Chick Norr
On 6/1/06, Lukasz Budnik <[EMAIL PROTECTED]> wrote:
name column is:
`name` varchar(50) NOT NULL default 'NN'
and table is DEFAULT CHARSET='latin2' but as I wrote before
all those names have only latin1 characters
I am not able to reproduce it on 5.0.16 on WinXP.
mysql> DROP TABLE IF EXIS
On 5/31/06, Lukasz Budnik <[EMAIL PROTECTED]> wrote:
I'm losing my mind - no idea what's going on with this name.
Any hints most welcome ;)
Show your show create table?
--
-jp
Chuck Norris does not teabag the ladies. He potato-sacks them.
On 3/27/06, Lucas Vendramin <[EMAIL PROTECTED]> wrote:
>
> Thank you.
> The INET_ATON() function works fine. :D
> I hope this solution save me.
> Thanks.
>
> > Take a look at the MySQL function INET_ATON and it's counterpart (I
> don't
> > remember what it's counterpart is but it should be easy to
On 3/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> "Jake Peavy" <[EMAIL PROTECTED]> wrote on 03/14/2006 01:52:28 PM:
>
>
> > On 3/10/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
> > >
> > > On 3/7/06, C.R.Vegelin <[
On 3/10/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
>
> On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote:
>
> > Hi Ariel,
> >
> > Maybe this example helps you to create CSV output from MySQL.
> > The first SELECT generates the headerline; the second the
On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote:
> Hi Ariel,
>
> Maybe this example helps you to create CSV output from MySQL.
> The first SELECT generates the headerline; the second the data.
> ( SELECT 'FieldA','FieldB','FieldC', ... )
> UNION
> ( SELECT `FieldA`, `FieldB`, `FieldC`, ...
> INTO
On 3/3/06, Vinay <[EMAIL PROTECTED]> wrote:
>
> Hello,
>I am trying to install DBI and mysql DBD for perl on HP-UX 11.23i. I
> have installed DBI successfully but having a hard time installing DBD for
> mysql on HP-UX.
> I am getting make errors while installing. I want to use perl to connect
>
On 2/3/06, Andrew Braithwaite <[EMAIL PROTECTED]> wrote:
>
> Hi everyone,
>
> Does anyone know if there is a way to get the last access time from a
> mysql table through mysql commands/queries?
>
> I don't want to go to the filesystem to get this info.
>
> I understand that this could be tricky esp
On 1/30/06, Jacques Brignon <[EMAIL PROTECTED]> wrote:
>
> I would like some advice on the various and best ways of finding the rank
> of the
> row which satisfies a given condition in a rsult set.
>
> Let's assume that the result set includes a field containing an identifier
> from
> one of the t
DROP TABLE IF NOT EXISTS?
On 1/16/06, Michael Williams <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> Having a bit of mysqldump trouble again. I've looked over the
> documentation (again) and can't seem to find the flag to make
> 'mysqldump' out put "CREATE TABLE IF NOT EXISTS". Any ideas?
>
> Reg
On 1/12/06, Mark Phillips <[EMAIL PROTECTED]> wrote:
> There is a column in my table with string values, but the strings have
> spaces
> in them. I want to read the unique column values into an array in my bash
> script, so I can use these values in a separate query on this table. How
> do I
> get
Hey yall,
I have a delimited text file I'm trying to load into my db. The problem is
that for whatever reason (totally beyond my control) the line and field
delimiters include an Extended ASCII char (0xA0) like so:
05HIUT841427BLCA á Dell Computer á"One *Dell* Way, *Round
Rock*Texas 786
On 1/6/06, Brian Dunning <[EMAIL PROTECTED]> wrote:
>
> On Jan 5, 2006, at 9:38 PM, Michael Stassen wrote:
>
> > DATEDIFF was added in 4.1.1. What version of mysql do you have?
>
> Thanks Michael - that was indeed the problem. Some ancient-ass
> version that's been on my development server for who
you could also have a look at
http://dev.mysql.com/tech-resources/articles/mysql-triggers.pdf which I
found useful.
-jp
e found a bit similar issue related to building php-mysql extension
>
> on MySQL forums. The person declares that he has solve the problem. May
>
> be it will help you:
>
> http://forums.mysql.com/read.php?52,9,9,quote=1`
>
>
>
>
>
>
>
>
>
> J
ee if you guys
> > had
> > any ideas on why I can't make test for DBD::mysql on Solaris.
> >
> > TIA,
> > F
> >
> > -- Forwarded message --
> > From: Jake Peavy <[EMAIL PROTECTED]>
> > Date: Nov 29, 2005 11:37 PM
> > Subject:
Since I didn't get a response from the perl list, and since Daryn received
some responses to his similar question I thought I might see if you guys had
any ideas on why I can't make test for DBD::mysql on Solaris.
TIA,
F
-- Forwarded message ------
From: Jake Peavy <[EM
Also, do you know if there is any way at all to do the tiniest amount of
research on my own to find out even the most basic information about MySQL
without bothering an entire worldwide mailing list with my trivial
questions?
Hey, I sent this a while ago, but never received a response.
This still seems to exist under 5.0.15-standard (at least under
mysql-standard-5.0.15-linux-i686-glibc23)
Can anyone from MySQL comment on this or should I open it as a bug?
Thanks,
JP
On 6/11/05, Jake Peavy <[EMAIL PROTECTED]>
Hey, sorry everyone - I figured it out.
I had to add the following to my.cnf
read-only
skip-innodb
I guess I shoulda kept googling before asking... mybad.
/JP
On 9/21/05, Jake Peavy <[EMAIL PROTECTED]> wrote:
>
> Hey yall,
> I'm trying to use a DVD (containing a num
Hey yall,
I'm trying to use a DVD (containing a number of packed MyISAM tables in a
directory) as the datadir in my my.cnf but I can't start the server: mysqld
is trying to write to the datadir - error log, etc - and when it can't the
server craters.
Is there anyway of using a readonly directory
On 6/16/05, Gabriel B. <[EMAIL PROTECTED]> wrote:
> If i have a table with about 800M records. and one of the fields is a
> enum("a", "b", "c") and i want to change it to enum("a","b","x")
My understanding (such as it is) is that the best way to do this is to add a
second column with enum('a','b
On 6/17/05, asteddy <[EMAIL PROTECTED]> wrote:
> Hello,
> I have found Mysql Performance Tuning Seminar available for download, but I
> don't know how to see it.
Use the WebEx player at http://www.meetingcenter.net/record_play.htm
-JP
--
MySQL General Mailing List
For list archives: http://lis
Has anyone been able to use a named pipe for their general query log
(or any of the other logfiles for that matter)?
I tried the following as user mysql:
rm /var/lib/mysql/myhost.log
mkfifo -m 0660 /var/lib/mysql/myhost.log
but the mysql server would not start.
I think it would be very useful
48 matches
Mail list logo
