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 11:
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
On Sun, Dec 27, 2009 at 10:40 AM, Kaushal Shriyan
wrote:
> On Wed, Dec 23, 2009 at 5:38 PM, Kaushal Shriyan
> 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) Server.
>>
>> #
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 performa
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 5
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, 7-DayOfWeek(@d
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
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 dea
>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
ta
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 hav
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
Sent: 29 December 2009 19:59
To: mysql@lists.mysql.com
Subject: Help keep t
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 hav
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 Message-
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 abou
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 IS NULL (has no data) or
> IS NOT NULL (has data) comes into play.
To ma
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
16 matches
Mail list logo
