- 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
server cache
deamon */etc/rc.d/init.d/nscd
restart *
Claudio
2011/5/19 Johan De Meersman
> 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 ou
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 r
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
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:
go
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 engi
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
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 is a
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 worke
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
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 question_id
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:
|
|
| /| /|
|/ |/ |
|
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:
|
|
| /| /|
|/ |/ |
| / | /
| / | /
| /|
as 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
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
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
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 min
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
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,
> 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.
>
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;
+--
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 PROTE
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
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
]
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 interestin
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
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
Clemson Chan wrote:
> =
>
> =
>
> Is MySQL creating these documentation using a hacked version of software?
Just because it says it's been 'hacked
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
PROTECTED]]
Envoyé : 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 |
+-
- 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
6:16
An: Bhavin Vyas
Cc: [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 sele
rom: Bhavin Vyas [mailto:[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 | Sq
>>return just the first time row per each event_id.
>>
>>Thanks anyway. I may have to use second query... :-(
>>
>>
>>Mihail
>>
>>
>>- Original Message -
>>From: "Bhavin Vyas" <[EMAIL PROTECTED]>
>>To: &q
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 |
>+-
cond 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 - qu
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 gi
D]>
>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
>>
ROTECTED]>
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 Ran
PM
Subject: Help - query 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
>
&g
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 quer
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
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
(21
ot, 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.
[...]
> > > I have an interesting problem when updating columns of type DATETIME. It
> > > seems
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
: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?
>
&
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
* 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&
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&
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.
> 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
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 isamc
>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, whic
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
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
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 faculty
74 matches
Mail list logo
