Just encountered an interesting issue.
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 resolv.conf
*/etc/rc.d/init.d/nscd
restart *
Claudio
2011/5/19 Johan De Meersman vegiv...@tuxera.be
Just encountered an interesting issue.
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
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
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
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
- Original Message -
From: Dan Nelson dnel...@allantgroup.com
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
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
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 domain is a domain, such as:
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
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 foo = 'bar'
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
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,
myisam
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)
In fact they seem to show that postgres
I have data that is broken into anything from 30 sec to 15 minute time
series (with a DATETIME field). I need to transform all of this into 15
minute data. Does anyone know off the top of their head if there a way I
could use GROUP BY to make this happen? Nothing I have tried thus far
has
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
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=member_id
WHERE
Hello,
I have a simple Records table with two columns, member_id and question_id.
The object of the query is to retrieve the question_id, as well as how many
times it's been answered - as long as the current user hasn't answered it
(member_id). So, the query shouldn't return any
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:
|
|
| /| /|
|/ |/ |
| / | /
| / | /
| /|
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:
|
|
| /| /|
|/ |/ |
|
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 about 12% on average, while an Opteron running 64-bit
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
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 about 12% on average, while an Opteron running 64-bit
MySQL gets a 32
Harrison,
Taking your suggestion and building a combined key of member_id
and pts_awarded the query took 17 mins
create table pts_sumC_snap
select member_id, count(1) count, sum(pts_awarded) points
from pts_awarded_snap
group by member_id;
Query OK, 12488780 rows affected (16
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 problem?
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 |
++
|
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
: Nestor [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 26, 2004 7:38 PM
Subject: RE: interestingBUG? COMMENTS?
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
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 I =
People,
I have a php web application that has an admin page for inserting course records and
one for selecting course records
and a client page for selecting course record.
In the admin side I insert records with an insert into Course_Eng and I select
records witha select * from Course_Eng
Hi group,
I just read the first news item on the MySQL website and thought some of you might
need to read about it as it is very interesting for those who use MySQL for hi end
transactions.
This gave me more powers in choosing MySQL as my favorite DBMS.
Just go to http://www.mysql.com or
http
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.
Any explanation of effect?!?
Example1:
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.
Any
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;
http://www.databasejournal.com/features/mysql/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
Hi sql query wizards!
I need some help.
Is there a way I can take this query here =
mysql SELECT cell, sector,
- sum(att) as att,
- sum(lc) as lc,
- sum(csh) as csh,
- ROUND((SUM( lc + csh ) * 100 ) / (SUM(att) - SUM(tccf + bpp + bpc +
suf)),2) AS drops,
- sum(tccf) as tccf,
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 + csh ) * 100
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
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
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
result is an sql
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.52 (Red
Hi,
We experienced some interesting things when we upgraded to Mysql-Max
3.23.52 (Red Hat 7.1, 2.4.7-10enterprise). It looked like after a
sustained amount of large disk activity, the whole system would slow to
a crawl and CPU idle % would go down to 0 for about 30 seconds before it
popped back
Clemson Chan wrote:
=
!-- This HTML file has been created by texi2html 1.52 (hacked by
[EMAIL PROTECTED])
from manual.texi on 12 August 2002 --
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
the docs
-
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).
http://www.mysql.com/downloads
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 starts
I did a select * as such:
mysql select * from Sqs;
+-+-++
| RecordState | Sqs | SqsKey |
+-+-++
| L | unknown | 1 |
+-+-++
1 row in set (0.00 sec)
Then, look at the message that delete from
Message -
From: Bhavin Vyas [EMAIL PROTECTED]
To: Mihail Manolov [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Thursday, July 11, 2002 10:51 PM
Subject: Re: Help - query suggestion needed -
interesting case
How about:
SELECT
event_id, time,
count(DISTINCT time) AS Ranges
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 |
... :-(
Mihail
- Original Message -
From: Bhavin Vyas [EMAIL PROTECTED]
To: Mihail Manolov [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Thursday, July 11, 2002 10:51 PM
Subject: Re: Help - query suggestion needed -
interesting case
How about:
SELECT
event_id, time,
count(DISTINCT
:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 9:40 AM
To: [EMAIL PROTECTED]
Subject: Interesting
I did a select * as such:
mysql select * from Sqs;
+-+-++
| RecordState | Sqs | SqsKey |
+-+-++
| L | unknown | 1
: [EMAIL PROTECTED]
Betreff: Re: Interesting
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
- 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!
Whenever deleting without a WHERE clause, there's always this '0 rows
: lundi 15 juillet 2002 18:40
À : [EMAIL PROTECTED]
Objet : Interesting
I did a select * as such:
mysql select * from Sqs;
+-+-++
| RecordState | Sqs | SqsKey |
+-+-++
| L | unknown | 1 |
+-+-++
1 row
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
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
]
To: Mihail Manolov [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, July 11, 2002 10:51 PM
Subject: Re: Help - query suggestion needed - interesting case
How about:
SELECT
event_id, time,
count(DISTINCT time) AS Ranges
FROM
events
GROUP BY
event_id HAVING Ranges 1
.
Thanks anyway. I may have to use second query... :-(
Mihail
- Original Message -
From: Bhavin Vyas [EMAIL PROTECTED]
To: Mihail Manolov [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, July 11, 2002 10:51 PM
Subject: Re: Help - query suggestion needed - interesting case
How about
Greetings,
I am stuck with this problem:
I have the following table:
event_id time
1002000-10-23
1002000-10-23
1012000-10-24
1012000-10-25
I need to know all event_id's that have multiple times + time columns. Is it
possible to get that result in just one
suggestion needed - interesting case
Greetings,
I am stuck with this problem:
I have the following table:
event_id time
1002000-10-23
1002000-10-23
1012000-10-24
1012000-10-25
I need to know all event_id's that have multiple times + time columns
Below is an example of a problem I'm having when issuing an alter table
command to create a foreign key in mysql version 3.23.51. I am running the
max version and the tables exist in the innodb table space.
Thoughts? Comments? Criticism?
Carl McNamee
Systems Administrator
Billing Concepts
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?
that we can try to
reproduce it and see whether this is a local behaviour of your machine
or a common MySQL behaviour.
[...]
I have an interesting problem when updating columns of type DATETIME. It
seems that exactly one day is subtracted from the DATETIME value that I
submit in an update
Hi,
I have an interesting problem when updating columns of type DATETIME. It
seems that exactly one day is subtracted from the DATETIME value that I
submit in an update query. Has anyone encountered this? Any ideas?
Kevin
:27:18PM -0400, [EMAIL PROTECTED] wrote:
Hi,
I have an interesting problem when updating columns of type DATETIME. It
seems that exactly one day is subtracted from the DATETIME value that I
submit in an update query. Has anyone encountered this? Any ideas?
Kevin
--
[EMAIL PROTECTED
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 whether
* 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. So
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. So I'll shoot it out
If you use MySQL I respectfully ask to to avoid NuSphere.
Do not support spammers.
Here Here !!!
This really ticks me off, I mean really ticks me off big time.
Have they no shame?
Wait until you read this.
For a long time now Nusphere has been treading on far too many peoples toes
(who do
Andy Woolley wrote:
For a long time now Nusphere has been treading on far too many peoples toes
(who do they think they are) not only are they annoying MySQL users with
their exasperating antics they are also trying to steal MySQL from the very
people that actually wrote the software.
Hello All,
I came accross an interesting delima today after working on a client's database,
they are using MySQL 3.23.32 on a linux box. The database had 12 tables in it,
and almost all of them where displaying the corrupted table handler error, these
where ISAM tables. Now I used isamchk
I've been creating a site for someone using MySQL and PHP4.
Basically the table concerned is structured like this;
id int(5) UNSIGNED Noauto_increment Primary
ship varchar(50) NoIndex
year varchar(15) NoIndex
voyage varchar(50) Yes
sex varchar(50)Yes
I've been creating a site for someone using MySQL and PHP4.
Basically the table concerned is structured like this;
id int(5) UNSIGNED Noauto_increment Primary
ship varchar(50) NoIndex
year varchar(15) NoIndex
Sir, change the type of this column to Date, which
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
member can go to this website and type in the info via an HTML form.
My problem is, the form needs to be submitted to two different tables. All
of the
72 matches
Mail list logo