- Original Message -
> From: "Dan Nelson"
>
> I doubt that mysql calls anything other than gethostbyname() or
> getaddrinfo(), so your behaviour is probably dependant on whatever OS
> you are running and how often its local resolver re-checks resolv.conf.
> Usually that's only once when a
In the last episode (May 19), Johan De Meersman said:
> I use DNS names instead of IPs in mysql grants. Yes, I'm aware of the
> performance impact, that's not an issue.
>
> I just found out through failing logins that a server was still connecting
> to an old DNS server, and properly updated the r
- Original Message -
> From: "Claudio Nanni"
> Consider also the DNS TTL.
That should be irrelevant when changing DNS servers :-)
> If you flush hosts in MySQL it'll ask again the OS to resolve a name
> , but if that is still in the DNS cache it could return that 'old'
> value instead
Johan,
Consider also the DNS TTL.
If you flush hosts in MySQL it'll ask again the OS to resolve a name , but
if that is still in the DNS cache it could return that 'old' value instead
of querying the newly updated NS.
I'm not sure thou, may be test by restarting the name server cache
deamon */et
Baron,
Thanks very much for that simple but very effective solution.
I altered your SQL slightly, the final SQL looks like this:
SELECT
domain,
count(*) AS 'count all',
SUM(IF(mime = 'text/html', 1, 0)) AS 'count text',
SUM(IF(mime LIKE 'image/%', 1, 0)) AS 'count image'
FROM
tableA
G
On Thu, April 26, 2007 18:38, Baron Schwartz wrote:
> Hi,
>
> Imran Chaudhry wrote:
>> I'm wondering if any of you can assist with an interesing SQL
>> query. I have a single table within a database, the relevant fields of
>
> Try IF or CASE expressions:
>
> SELECT foo, count(*), sum(case when fo
Hi,
Imran Chaudhry wrote:
I'm wondering if any of you can assist with an interesing SQL
query. I have a single table within a database, the relevant fields of
which are defined as:
CREATE TABLE tableA
(
domain text,
mime text
);
Where "domai
Jochem van Dieten wrote:
> On 12/19/06, David Sparks wrote:
>> I noticed an interesting benchmark at tweakers.net that shows mysql not
>> scaling very well on hyperthreading and multicore cpus (see links at end
>> of email).
>>
>> Does anyone know what engine they are using for their tests? (Innodb
On 12/19/06, David Sparks wrote:
I noticed an interesting benchmark at tweakers.net that shows mysql not
scaling very well on hyperthreading and multicore cpus (see links at end
of email).
Does anyone know what engine they are using for their tests? (Innodb,
myisam, berkdb heheh)
InnoDB, the f
Hi,
An alternative for any MySQL version (from 3.23.??) would be:
SELECT r1.question_id,count(r1.member_id)
FROM Records r1
LEFT JOIN Records r2 ON r1.question_id=r2.question_id
AND r2.member_id=
WHERE r2.question_id IS NULL;
Hello.
Perhaps this will work (depends on the version of MySQL you're using):
select question_id
, count(*)
from Records
group by question_id
having question_id not in (
select distinct question_id
from Records r
wher
Martijn van den Burg wrote:
Greetings,
I've been keeping track of Bytes_sent and Bytes_received for a while in
the fashion of 'mysqlreport': divide those values over Uptime in order
to obtain a data rate (bytes/sec).
The resulting graphs look like this:
|
|
| /| /|
|/ |/ |
|
probably biased towards AMD.
money is a powerful thing, which is why it should be taken with a grain
of salt as you stated.
i would guess the 12% decrease on 64bit xeon and 32% increase on 64bit
opteron is BS. why didn't they try itanium instead? ;)
David Griffiths wrote:
Anandtech has an in
On 18/06/2005, at 4:28 AM, David Griffiths wrote:
Anandtech has an interesting article
(http://www.anandtech.com/IT/showdoc.aspx?i=2447) on hardware for
Linux database servers.
Some very interesting conclusions:
1) Moving to 64-bit MySQL on a 64-bit Xeon actually decreases
performance by a
Victoria,
The seleect statements that I wrote is what I use.
And if there was a limit should the limit be used in both o f my select?
Database changed
mysql> SELECT @@session.sql_select_limit;
++
| @@session.sql_select_limit |
++
|
"Nestor" <[EMAIL PROTECTED]> wrote:
> I send this last week and no one commented.
Nestor, I've already asked you check value of sql_select_limit variable:
SELECT @@session.sql_select_limit;
Is "SELECT * FROM course_eng" exact query that you use?
> Has anyone run into this simmilar proble
ou have "course_eng" and
"Course_eng" in the same database, one with 200 rows and one with 40 rows
but a bug in MySQL is keeping you from seeing one of them??
Rhino
- Original Message -
From: "Nestor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Frida
I send this last week and no one commented.
Has anyone run into this simmilar problem?
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 10:28 AM
I have a php web application that has an admin page for inserting course
records and one for sel
"Nestor Florez" <[EMAIL PROTECTED]> wrote:
>
> I have a php web application that has an admin page for inserting course =
> records and one for selecting course records=20
> and a client page for selecting course record. =20
> In the admin side I insert records with an "insert into Course_Eng" and
Hello,
> We make updade of database from 3.23.49 to 4.0.12
> Before update we can see host of connections /see Example1/.
> After update every connections looks like they made from local host
> /see Example2/, but they did not.
> Any explanation of effect?!?
mysql>> show processlist;
> ++
On Wed 2003-04-02 at 13:32:22 +0300, [EMAIL PROTECTED] wrote:
> Hello mysql,
> We make updade of database from 3.23.49 to 4.0.12
> Before update we can see host of connections /see Example1/.
> After update every connections looks like they made from local host
> /see Example2/, but they did not.
>
Message-
From: James Northcott [mailto:jnorthcott@;dpmg.com]
Sent: Monday, November 04, 2002 2:29 PM
To: Black, Kelly W [PCS]
Subject: RE: Interesting Challenge
> I have tried with and without having. Neither works.
>
> If you try running the query without cell, or sector, the
>
I know this is not elegant, but have have you tried using a temporary
table? It adds up your function column correctly. There was an
example of this earlier today from Oyekanmi - "Re: getting around a
subselect",
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:123911:200211:onbajmklkgifeckohcpa
This simply returns me to the documentation.
Thanks
-Original Message-
From: James Northcott [mailto:jnorthcott@;dpmg.com]
Sent: Monday, November 04, 2002 12:13 PM
To: Mysql (E-mail)
Subject: RE: Interesting Challenge
> mysql> SELECT cell, sector,
If you only want one row
> mysql> SELECT cell, sector,
If you only want one row, then selecting cell doesn't make any sense.
Cell is different in each row you've selected. If you only want one
row, don't select cell.
> -> sum(att) as att,
> -> sum(lc) as lc,
> -> sum(csh) as csh,
> -> ROUND((SUM( lc + cs
]
Subject: Re: Interesting innodb activity with 3.23.52
Adrian,
- Original Message -
From: ""Adrian Liang"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, September 21, 2002 6:48 AM
Subject: Interesting innodb activity with 3.23.52
>
Adrian,
- Original Message -
From: ""Adrian Liang"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, September 21, 2002 6:48 AM
Subject: Interesting innodb activity with 3.23.52
>
> Hi,
>
> We experienced some interesting things when we upgraded to Mysql-Max
> 3.23
al Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 06, 2002 3:27 PM
To: Clemson Chan
Cc: Mysql
Subject: Re: interesting find
Clemson Chan wrote:
> The MySQL 3.23.52-nt (FTP image) I just downloaded from USA [UUNET]
> (appointed by MySQL.com).
>
h
Clemson Chan wrote:
> The MySQL 3.23.52-nt (FTP image) I just downloaded from USA [UUNET]
> (appointed by MySQL.com).
> http://www.mysql.com/downloads/download.php?file=Downloads/MySQL-3.23/mysql-
> 3.23.52-win.zip
>
> I realized that these two html (manual.html and manual_toc.html) files in
> th
Nick,
Monday, July 15, 2002, 5:58:31 PM, you wrote:
NM> I'm using version 3.23.53 on Win 2k.
NM> The same things happens to me.
NM> I've also noticed that if you don't specify a WHERE clause and you have a
NM> Auto-incrementing ID field, it is reset to zero and the next record you
NM> create st
Bhavin,
Monday, July 15, 2002, 7:39:52 PM, you wrote:
BV> I did a select * as such:
BV> mysql> select * from Sqs;
BV> +-+-++
BV> | RecordState | Sqs | SqsKey |
BV> +-+-++
BV> | L | unknown | 1 |
BV> +-+---
I'm using version 3.23.53 on Win 2k.
The same things happens to me.
I've also noticed that if you don't specify a WHERE clause and you have a
Auto-incrementing ID field, it is reset to zero and the next record you
create starts at 1 again.
Surely this is wrong as well? In Other RDBMS's after DE
http://www.mysql.com/doc/D/E/DELETE.html
"In MySQL 3.23, DELETE without a WHERE clause will return zero as the number
of affected records."
Alain Fontaine
Consultant & developer
VAlain S.A.
http://www.valain.lu/
-Message d'origine-
De : Bhavin Vyas [mailto:[EMAIL PROTECTED]]
Envoyé : lu
- Original Message -
From: "Ralf Narozny" <[EMAIL PROTECTED]>
To: "Bhavin Vyas" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 9:16 AM
Subject: Re: Interesting
> Bhavin Vyas wrote:
[snip]
> Hello!
>
> Whenev
That syntax will always report zero rows affected, but it is very fast. If
you want to know how many rows were deleted, use something like "DELETE *
FROM Sqs WHERE 1=1".
The latter query will be much slower, as it examines each record.
Nick
> -Original Message-
> From: Bhavin Vyas [mai
Hello!
Whenever deleting without a WHERE clause, there's always this '0 rows
affected' message. I consider that a bug.
Greetings
Ralf
Bhavin Vyas wrote:
>I did a select * as such:
>
>mysql> select * from Sqs;
>+-+-++
>| RecordState | Sqs | SqsKey |
>+-
Carl,
Tuesday, June 18, 2002, 5:30:31 PM, you wrote:
CM> Below is an example of a problem I'm having when issuing an alter table
CM> command to create a foreign key in mysql version 3.23.51. I am running the
CM> max version and the tables exist in the innodb table space.
CM> Thoughts? Comments
Hi.
I meant the system environment variable. I do not really believe that
it causes the problem, because it shouldn't be able to shift by a
whole day. But this is the only thing I know of which may influence
time values. On second thought, I really think it isn't TZ, because
that influences only
lf Of Benjamin
Pflugmann
Sent: Tuesday, May 28, 2002 6:19 PM
To: Kevin Carlson
Cc: Mysql
Subject: Re: Interesting datetime problem
Hi.
Maybe your TZ (timezone) environment variable is set to a strange
value? If not, could you provide a full example, so that we can try to
reproduce it and see wh
Hi.
Maybe your TZ (timezone) environment variable is set to a strange
value? If not, could you provide a full example, so that we can try to
reproduce it and see whether this is a local behaviour of your machine
or a common MySQL behaviour.
Bye,
Benjamin.
On Tue, May 28, 2002 at 01:27
* Yoed Anis
> Hi... I have an interesting problem I don't know which way to
> solve. I tried posting this on the PHP site (since I'm coding
> with PHP and mysql) but they said I might want to try my odds
> here.. since they suggested I go with the mysql solution, but
> I'm clueless where to start.
Yeah, just have your backend script parse the info it needs and just call
two queries to make that happen.
On Fri, 16 Feb 2001, Chris Toth wrote:
> I have a form on a webpage for a simple trouble ticket system. When
> requesting a computer be fixed, software be installed, etc...a faculty
> memb
42 matches
Mail list logo
