Hi René, everybody!
René Fournier wrote:
[[...]] However, even if the Index can't fit in memory (4GB of RAM, lots
free), just reading it from disk should allow sub-millisecond response, no?
No chance!
Of course, performance of disk drives varies, but AFAIK typical values
are in the range of
Martijn,
thanks for your excellent mail:
Martijn Tonies wrote:
[[...]]
A column can have two states: null or not null. It either has
data (a value, depending on the datatype), or no data (null),
which is where column IS NULL (has no data) or
column IS NOT NULL (has data) comes into play.
Hi!
We have just launched a worldwide, multilingual petition at
http://helpmysql.org to get signatures to show the regulators in the
EU and other places that it's important that MySQL continues to be
available and developed as a strong Open Source product for all
database needs.
If you care
Jerry Schwartz wrote:
From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
Sent: Monday, December 28, 2009 9:25 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
performance
Jerry Schwartz wrote:
-Original
I would encourage everyone on this list to at least read the two articles
Fox in the henhouse (http://helpmysql.org/en/theissue/foxinthehenhouse)
and
GPL is not the answer (http://helpmysql.org/en/theissue/gplisnottheanswer)
You may or may not agree with those, but at least then you'll have
I am from Indonesia, have been use The Great MySQL for 10 years in development
and production environments. Count me in.
Willy
Sent from my Sony Ericsson XPERIA X1.
-Original Message-
From: Michael Widenius mo...@askmonty.org
Sent: 29 December 2009 19:59
To: mysql@lists.mysql.com
I would encourage everyone on this list to at least read the two articles
Fox in the henhouse (http://helpmysql.org/en/theissue/foxinthehenhouse)
and
GPL is not the answer
(http://helpmysql.org/en/theissue/gplisnottheanswer)
You may or may not agree with those, but at least then you'll have
Dear Jerry,
Sorry, did you suggest to use 5.x / 5.y ( NO 6.x ) ?
[JS] No, I am not saying that. The system I inherited was running 5.x, and I
have not had the time nor urgent need to move upwards. There are some
incompatibilities that I would have to deal with. For example, although short
tags
Jerry Schwartz wrote:
Dear Jerry,
Sorry, did you suggest to use 5.x / 5.y ( NO 6.x ) ?
[JS] No, I am not saying that. The system I inherited was running 5.x, and I
have not had the time nor urgent need to move upwards. There are some
incompatibilities that I would have to deal with. For
Monty,
Good looking site. I just signed the petition and hope others will too.
Go get'em Monty!
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ML,
trying to write some SQL that will give me records for the CURRENT WEEK.
Example, starting on a Sunday and going through Saturday.
This week it would be Dec 27 - Jan 2.
For the week of any date @d:
... WHERE order_date BETWEEN AddDate(@d, -DayOfWeek(@d)+1) AND
AddDate(@d,
From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
Sent: Tuesday, December 29, 2009 10:35 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
performance
Jerry Schwartz wrote:
Dear Jerry,
Sorry, did you suggest to use
If all you want is the current week then the query is simple:
SELECT * FROM orders where WEEK(orders.order_date) = WEEK(NOW())
The default is thje day starts on Sunday so the second value is not needed.
WEEK(NOW(),7) is equivalent to WEEK(NOW(),0) - the valid values are 0 - 6.
As for
On Sun, Dec 27, 2009 at 10:40 AM, Kaushal Shriyan
kaushalshri...@gmail.com wrote:
On Wed, Dec 23, 2009 at 5:38 PM, Kaushal Shriyan
kaushalshri...@gmail.com wrote:
Hi
I am running collectd
(http://www.collectd.org/wiki/index.php/Plugin:MySQL) version 4.9.0 on
Ubuntu Linux 8.04 (Hardy)
Hi,
My MySQL server Aborted_connects status is showing 8692 and is rapidly
increasing.
What are reasons and how do i decrease the same?
We are using connect() method in PHP code and have tried below command
mysqladmin flush-hosts
but still the value is same.
Thanks
Jeetendra Ranjan
Jetendra,
Can u attach your my.cnf files and also your variable status (show
variable status). This is required because we need to tune some params.
Thanks,
Dilipkumar
-Original Message-
From: Jeetendra Ranjan [mailto:jeetendra.ran...@sampatti.com]
Sent: Wednesday, December 30, 2009
16 matches
Mail list logo