On Tue, 28 Aug 2007 13:31:43 -0400, "Michael Dykman" <[EMAIL PROTECTED]>
said:
> No, I'm afraid not. 32 bit architectures have a theoretical limit of
> 4G of memory space for the entire application: in actual practice, for
> a variety of reasons too complex to go into here (and are well
> documen
On 8/27/07, Daevid Vincent <[EMAIL PROTECTED]> wrote:
> Fortune 500 companies You mean in 21 years from now, all this will
> just fail miserably because of some obscure 2038 limitation? This is Y2K
> all over again -- unless mySQL fixes this bug.
Obscure? Not really - lots of software is going
Craig,
Right you are, here is a corrected func:
DROP FUNCTION IF EXISTS BizDateTimeDiff;
DELIMITER |
CREATE FUNCTION BizDateTimeDiff( d1 DATETIME, d2 DATETIME )
RETURNS CHAR(30)
DETERMINISTIC
BEGIN
DECLARE dow1, dow2, days, wknddays INT;
DECLARE tdiff CHAR(10);
SET dow1 = DAYOFWEEK(d1);
SET
Ok then,
Now I have a result set so very close to where I want to be. The query
thus far:
mysql> SET @d1 = '2007-02-01 18:24:04';# Start date
SET @d2 = '2007-2-28 23:05:40';# End date
set @wkldays = (select WorkDayDiff`(@d2,@d1)-1);
Set @wkldays2 = if(@wkldays < 0,1,0);
set @Day_End = (select `
heh.. ok I'll throw that at my system tech. and see what it's going to
take to get a 64bit version of an OS.
for now I'll limit to 2.5
thanks michael.
- Original Message -
From: "Michael Dykman" <[EMAIL PROTECTED]>
To: "Justin" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, August 28, 200
Ok, So, What I have come up with (so far) as a variant of Baron's query:
SET @d1 = '2007-2-1 00:00:00';# Start date
SET @d2 = '2007-2-28 23:59:59';# End date
SET @tdiff = TIMEDIFF( TIME(@d1), TIME(@d2) );
SET @dow1 = DAYOFWEEK(@d1);
SET @dow2 = DAYOFWEEK(@d2);
SET @days = DATEDIFF(@d2,@d1);
SET
No, I'm afraid not. 32 bit architectures have a theoretical limit of
4G of memory space for the entire application: in actual practice, for
a variety of reasons too complex to go into here (and are well
documented elsewhere) your key buffer should be limited to around 2.5G
max, and this is assumin
32bit, but I have all available memory..
MemTotal: 8179612 kB
MemFree: 43684 kB
on the box. I think the 4gb is only windows.
All my tables are in myisam
so if I was to set
key_buffer_size=5500M
That'd be acceptable?
- Original Message -
From: "Mathieu Bruneau" <[EMAIL
Bill Newton wrote:
Will mysql-table-checksum from mysql toolkit work with setups that have
different Master/ Slave storage engines? Are there any things to
consider when using it between two different engines ( say Innodb master
and MyIsam slave)?
It should work fine with the default settings
Will mysql-table-checksum from mysql toolkit work with setups that have
different Master/ Slave storage engines? Are there any things to
consider when using it between two different engines ( say Innodb master
and MyIsam slave)?
Thanks in advance,
Bill Newton
--
MySQL General Mailing List
I think Gerald was suggesting you convert the IP's into integers and
then do bitwise stuff on them. I don't know of a way to do what you're
asking.
Baron
Wagner, Chris (GEAE, CBTS) wrote:
Those functions concern dotted quad IP addresses, not packed binaries.
Anybody know of some obscure MyS
Those functions concern dotted quad IP addresses, not packed binaries.
Anybody know of some obscure MySQL functions to do bit logic on strings
or get MySQL to recognize a char sequence as an integer?
"Gerald L. Clark" wrote:
>
> Wagner, Chris (GEAE, CBTS) wrote:
> > Hi. I've got IP addresses st
Hi Peter,
It would be great if you'd post this snippet at the forge too. More is
better :-)
Baron
Weston, Craig (OFT) wrote:
Wow, thanks. Lots to think about.
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Monday, August 27, 2007 10:18 PM
To: We
Wow, thanks. Lots to think about.
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Monday, August 27, 2007 10:18 PM
To: Weston, Craig (OFT)
Cc: mysql@lists.mysql.com
Subject: Re: [MYSQL]Time formatting for cycle time.
Craig,
>I am working on Martin M
14 matches
Mail list logo
