From: "Joerg Bruehe"
Hi!
Octavian Rasnita wrote:
I have tried, but with no difference.
I have changed some indexes and made the queries run faster, but I still
found a problem:
I use a module that does paging and it makes a select(*) and this query
takes a very long time.
I have also t
ge -
> From: John Daisley
> To: Octavian Rasnita
> Cc: mysql@lists.mysql.com
> Sent: Wednesday, June 23, 2010 3:55 PM
> Subject: Re: Differences between 2 MySQL instances
>
>
> Have you tried running 'OPTIMIZE TABLE' on the tables in question
Rasnita
Cc: mysql@lists.mysql.com
Sent: Wednesday, June 23, 2010 3:55 PM
Subject: Re: Differences between 2 MySQL instances
Have you tried running 'OPTIMIZE TABLE' on the tables in question to make
sure statistics are up to date.
I would expect the vast majority of queries to
h this query uses the same index as the one under Windows, the
> number of estimated rows is approximately the total number of rows in the
> table and it also takes a very long time to complete.
>
> Do you have any idea why this works differently under Linux? Is it because
> under
in the table and it
also takes a very long time to complete.
Do you have any idea why this works differently under Linux? Is it because
under Linux I have MySQL 5.0 and under Windows MySQL 5.1 and I definitely need
to upgrade?
There are some differences between the global variables that star
Hi,
On Wed, Apr 16, 2008 at 6:26 AM, Nacho Garcia <[EMAIL PROTECTED]> wrote:
> hi, i have this table
>
> *TABLE friends:
> *id_usr INT
> id_friend INT
>
> and i have a query in which i return friends from a given user and data
> related to each of them stored in some other tables.
>
>
hi, i have this table
*TABLE friends:
*id_usr INT
id_friend INT
and i have a query in which i return friends from a given user and data
related to each of them stored in some other tables.
So i do this:
SELECT F.id_friend, M.status, P.firstname, P.lastname, IF( UNIX_TIMESTAMP( )
- UNIX_T
James;
> This finds common rows.
Eh!? ... HAVING COUNT(*)=1 returns ONLY pairs that are different:
drop table if exists a,b;
create table a(i int,j int,k int);
insert into a values(1,10,100),(2,20,200),(3,30,300);
create table b select * from a;
update b set k=301 where k=300;
select * from a;
On Feb 11, 2008 7:27 PM, James Eaton <[EMAIL PROTECTED]> wrote:
> SELECT
> MIN(TableName) as TableName, id, col1, col2, col3, ...
> FROM (
> SELECT 'Table a' as TableName, a.id, a.col1, a.col2, a.col3, ...
> FROM a
> UNION ALL
> SELECT 'Table b' as TableName, b.id, b.col1, b.col2, b.col3, ...
From: Peter Brawley
>I'd like to run a query to find the records that
>are present in one database but not the other.
See 'Compare data in two tables' at
http://www.artfulsoftware.com/infotree/queries.php.
Thanks. That's a start.
SELECT
MIN(TableName) as TableName, id, col1, col2, col3,
James
>I'd like to run a query to find the records that
>are present in one database but not the other.
See 'Compare data in two tables' at
http://www.artfulsoftware.com/infotree/queries.php.
PB
James Eaton wrote:
I have two different databases on the same 5.0 server that have the
same tabl
I have two different databases on the same 5.0 server that have the same
tables and structure. They also have very nearly the same data. For one
of the tables I'd like to run a query to find the records that are present
in one database but not the other. Is this possible and what would such a
Mark, is the 'secs' column the offset from the minimum value of the
timestamp column?
If so, you might try something like this:
SELECT UNIX_TIMESTAMP(MIN(timestamp)) INTO @min_timestamp FROM my_table;
SELECT uid, timestamp,
UNIX_TIMESTAMP(timestamp) - @min_timestamp AS secs
FROM my_table
ORDER B
Hi All
I have the following data example
UID Timestamp
123456 20071201 12:00:01
123456 20071201 12:00:06
987654 20071201 12:00:01
987654 20071201 12:00:09
etc
I need :
UID Timestamp secs
123456 20071201 12:00:01 000
Am Dienstag, den 08.01.2008, 14:48 +0800 schrieb Moon's Father:
> I always confused to them.
It's explained in the documentation:
http://dev.mysql.com/doc/refman/5.0/en/show-status.html
http://dev.mysql.com/doc/refman/5.0/en/show-variables.html
Norbert
--
MySQL General Mailing List
Fo
/ FAX: 860.674.8341
-Original Message-
From: Neil Tompkins [mailto:[EMAIL PROTECTED]
Sent: Friday, September 15, 2006 5:04 AM
To: mysql@lists.mysql.com
Subject: Show differences between two tables
Hi
I've two tables
TableA
FieldID
Enabled
TableB
FieldID
Enabled
What query would I ne
Hi Neil -
Something like this ought to work, joining on the ID column to find matches
between tables, then finding the enabled fields which are not equal.
SELECT a.fieldID, a.enabled, b.enabled
FROM TableA a, TableB b
WHERE a.fieldID = b.fieldID
AND a.enabled != b.enabled
Dan
On 9/15/06, Neil
Hi
I've two tables
TableA
FieldID
Enabled
TableB
FieldID
Enabled
What query would I need to show what FieldIDs which are the same, but the
enabled field status is different ?Thanks,
Neil
_
Be one of the first to try Windows Live
At 23:00 +0100 14/6/06, Graham Reeds wrote:
1) You may have a bogus hidden character in your SQL file. If you
look at it with a text editor (BBEdit, TextWrangler, etc), with the
"show invivisbles" feature on, do you see unusual stuff? Sounds
strange but I've seen stranger.
Took a brief look
On Wed, Jun 14, 2006 at 11:00:36PM +0100, Graham Reeds wrote:
> Dan Buettner wrote:
> >Graham, I seem to recall those single quote marks working without a
> >problem on various platforms and versions of MySQL. Of course they are
> > generally just a nicety and only required if you are using rese
Dan Buettner wrote:
Graham, I seem to recall those single quote marks working without a
problem on various platforms and versions of MySQL. Of course they are
generally just a nicety and only required if you are using reserved
words as table/column/key names, so you could just remove them ent
Graham Reeds wrote:
I have posted a similar question on the blojsom group but I feel I will
have better chance of an answer here.
Blojsom 3 was developed using MySQL5 for it's back end. However the
host I am with uses 4.0.25 and are unwilling to upgrade - which is fair
enough.
So I decided
Graham, I seem to recall those single quote marks working without a
problem on various platforms and versions of MySQL. Of course they are
generally just a nicety and only required if you are using reserved
words as table/column/key names, so you could just remove them entirely.
Could you po
I have posted a similar question on the blojsom group but I feel I will
have better chance of an answer here.
Blojsom 3 was developed using MySQL5 for it's back end. However the
host I am with uses 4.0.25 and are unwilling to upgrade - which is fair
enough.
So I decided to see what I can do
On 2006-01-20, at 01:13, Tucker Cunningham wrote:
So, my question is: what are the pros and cons of using varchar
vs. text/longtext? Right now, longtext seems to be the best option
(it provides most flexibility in data that can be stored, at only a
2-byte-per-row storage premium) There
Joerg Bruehe wrote:
Hi Dan, all!
Dan Trainor wrote:
Thanks for the prompt reply, Augusto -
I completely understand what you're saying. To have anything such as
a real-time measurement to the exact number of tables would be an
incredible preformance degration, not to mention overhead and th
Hi Dan, all!
Dan Trainor wrote:
Thanks for the prompt reply, Augusto -
I completely understand what you're saying. To have anything such as a
real-time measurement to the exact number of tables would be an
incredible preformance degration, not to mention overhead and the like.
Right.
This
Thanks for the prompt reply, Augusto -
I completely understand what you're saying. To have anything such as a
real-time measurement to the exact number of tables would be an
incredible preformance degration, not to mention overhead and the like.
I think I'm willing to accept the fact that wh
James Harvard wrote:
I suppose this is an inherent limitation of transactional tables - you might
see x rows, but at the same time a use who has just inserted some rows will see
x+y rows.
However I don't see that the numbers are going to be hugely inaccurate. After
all, if the table was MyISA
I suppose this is an inherent limitation of transactional tables - you might
see x rows, but at the same time a use who has just inserted some rows will see
x+y rows.
However I don't see that the numbers are going to be hugely inaccurate. After
all, if the table was MyISAM and you get an exact
Dan Trainor wrote:
Hello, all -
Still kidna new to MySQL, so please forgive me if this is somewhat dumb
question...
When issuing 'SHOW TABLE STATUS', I can see clearly that under the Rows
column for my table, I see 17333. However, when issuing a 'COUNT (*)
FROM table', I see 17203 - a diff
Hi -
Anyone else get the following message with *ever*single*post* to the
list? Anyone have a procmail filter established already? ;)
Thanks
-dant
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED]
If you really intend for this to get to me, remove the 'no' in the eMail address
above & I'll send
Dan Trainor wrote:
Hello, all -
Still kidna new to MySQL, so please forgive me if this is somewhat dumb
question...
When issuing 'SHOW TABLE STATUS', I can see clearly that under the Rows
column for my table, I see 17333. However, when issuing a 'COUNT (*)
FROM table', I see 17203 - a diff
Hello, all -
Still kidna new to MySQL, so please forgive me if this is somewhat dumb
question...
When issuing 'SHOW TABLE STATUS', I can see clearly that under the Rows
column for my table, I see 17333. However, when issuing a 'COUNT (*)
FROM table', I see 17203 - a difference of 130.
We'
hi all -
I was looking for some clarification about the difference between
varchar and the text types in MySQL 5.0.18. It seems to me that varchar
and text both hold text data, are variable length, and have the same
storage requirements (4 + L bytes). Also, longtext adds the ability to
hol
Hello.
There should be only one issue, because the MySQL 5.0 server has a new
implementation of the DECIMAL data type. See C API Changes at:
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
>I'm looking to use a RHEL4 server with standard RHEL4 packages to
>connect to
I'm looking to use a RHEL4 server with standard RHEL4 packages to connect to
a RHEL4 MySQL 5.0 server. I was curious if anyone knows of any known
problems with a 4.1 client (the one provided with RHEL4) communicating to a
5.0 database? It connects fine, but wanted to be sure there were not any
kn
On Fri, 16 Sep 2005 10:32:23 -0400
[EMAIL PROTECTED] wrote:
> You asked basically two questions:
>
> a) what are the differences between ORACLE SQL plus and MYSQL?
> depends on how they are with MySQL already. One well-known point on
how
> MySQL and Oracle differ is in how t
Phong Nguyen <[EMAIL PROTECTED]> wrote on 09/15/2005 10:56:57 AM:
> All,
>
> Could you please tell us what are the differences
> between ORACLE SQL plus and MYSQL SQL? We developed
> application using ColdFusion with Oracle. Now I like
> to point my application to mysql
Hi,
> Could you please tell us what are the differences
> between ORACLE SQL plus and MYSQL SQL? We developed
"oracle sql plus" is a client side application to execute SQL statements.
"oracle sql" is Oracles version of standard SQL (which is not standard)
and "
All,
Could you please tell us what are the differences
between ORACLE SQL plus and MYSQL SQL? We developed
application using ColdFusion with Oracle. Now I like
to point my application to mysql database. How do I
fix my application to work with Mysql?
Thankyou
All,
Could you please tell us what are the differences between ORACLE SQL plus
and MYSQL SQL?
Thank you :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have come across a very strange occurrence while working on a client's
system. I get different behavior between the two servers (one Windows, one
Linux) when it comes to a column defined as double(5,4). The Windows system
truncates new values (existing data in the table is not truncated) whereas
On 04.06.2004 20:46 (+0200), Sasha Pachev wrote:
Subquery optimizer is still is a very early stage in 4.1. Much more often than
not, a carefully crafted join, union, or a sequence of queries using a temporary
table will be faster. In fact, I wonder if it is even possible to write a
machine subqu
Daniel Ek wrote:
Hi all,
I am wondering if anyone have any knowledge if there is speed difference
between joins (inner | outer | left | right) and subqueries. Would I
actually gain preformance using subqueries (new since 4.1) against using
the "old" joins?
Would be interesting to hear comments
Hi all,
I am wondering if anyone have any knowledge if there is speed difference
between joins (inner | outer | left | right) and subqueries. Would I
actually gain preformance using subqueries (new since 4.1) against using
the "old" joins?
Would be interesting to hear comments on this matter,
On Friday, November 7, 2003, at 09:05 AM, David Steinbrunner wrote:
The Mac was HFS+ journaled. Disk: the stock Apple-supplied one. The
Linux machine was a default SuSE 8.0 installation. ext2 as the
filesystem? No idea about journaling. No SCSI or RAID, just an
internal IDE disk. Both machines a
The Mac was HFS+ journaled. Disk: the stock Apple-supplied one. The
Linux machine was a default SuSE 8.0 installation. ext2 as the
filesystem? No idea about journaling. No SCSI or RAID, just an
internal IDE disk. Both machines are really consumer-level machines,
no heavy-duty server hardware. That
On Thu, Nov 06, 2003 at 07:36:55PM +0100, Jan Pieter Kunst wrote:
> Jeremy D. Zawodny:
>
> > > I was wondering if there is something I can do, configuration-wise, to
> >> do something about those very slow 'inserts' (and 'updates') on the Mac?
> >>
> >> Thanks in advance for any insight,
> >
>
I just installed Panther on my G5 at home. Unfortunately, for some
reason I can't get the Perl module DBD::mysql to install (using
CPAN, had no problems doing this in Jaguar) so I can't run the
benchmark suite for now.
JP
I had similar issues, but I was also using a custom build of MySQL,
wh
Jeremy D. Zawodny:
> I was wondering if there is something I can do, configuration-wise, to
do something about those very slow 'inserts' (and 'updates') on the Mac?
Thanks in advance for any insight,
Did it appear to be disk or CPU bound?
Sorry, newbie here. I don't know how I can tell. The RU
On Thursday, November 6, 2003, at 11:38 AM, Jan Pieter Kunst wrote:
I'd be curious what kind of numbers Panther shows. Once I get my
xServe setup, just arrived, I'll try running some tests myself.
I just installed Panther on my G5 at home. Unfortunately, for some
reason I can't get the Perl mod
On Thu, Nov 06, 2003 at 10:19:59AM -0700, Van wrote:
>
> Jeremy:
>
> I believe that's what I was attempting to convey. My suggestion was that the
> G4 should not be disk bound (limited by disk bandwidth). The CPU on my DEC
> Alpha is a meagerly 300, but the disk can stream faster than my PIII t
Jeremy:
I believe that's what I was attempting to convey. My suggestion was that the
G4 should not be disk bound (limited by disk bandwidth). The CPU on my DEC
Alpha is a meagerly 300, but the disk can stream faster than my PIII true Intel
733MHz. That's why I suggested he look at the disk / c
On Thu, Nov 06, 2003 at 09:56:22AM -0700, Van wrote:
>
> I can't imagine a G4 would be disk bound relative to an Intel machine, unless
> there is something very wrong with the disk or controller. Also, you might want
> to defrag your disk on the Mac.
>
> G4s have much more disk bandwidth than an
I can't imagine a G4 would be disk bound relative to an Intel machine, unless
there is something very wrong with the disk or controller. Also, you might want
to defrag your disk on the Mac.
G4s have much more disk bandwidth than any Intel I've ever seen. Almost as much
as my DEC Alpha. >:)
Va
I'd be curious what kind of numbers Panther shows. Once I get my
xServe setup, just arrived, I'll try running some tests myself.
I just installed Panther on my G5 at home. Unfortunately, for some
reason I can't get the Perl module DBD::mysql to install (using CPAN,
had no problems doing this in
On Wed, Nov 05, 2003 at 07:57:00PM +0100, Jan Pieter Kunst wrote:
> Hi everyone,
>
> I recently ran the MySQL benchmark suite on a Dual 1 GHz G4 running Mac
> OS X Server 10.2.8, and an 800 MHz Intel machine running SuSE Linux 8.0.
> Both installations used the same my.cnf file.
>
> The results a
FYI, I've found 'iostat' to be quite useful in monitoring the drive
transfer rates while benchmarking in OSX. Then again, in Panther all
you really need to do is pop open Activity Monitor (formerly Process
Viewer) which now has some nifty graphing for system status: cpu, disk,
ram activity and
I'd be curious what the specs of the hard drives are. Using the stock
drives in the Mac means you are using a drive that's about average (2MB
cache, 7200RPM). I would assume they are both ATA/IDE drives. But I
would guess the bottleneck is the drive. Try running top when you are
running your t
I'm not entirely sure what to do about the slow insert results, they
are the slowest part no matter how you configure it, it seems. I've
attached some benchmark results I ran on a dual 2GHz G5 for comparison.
Both MyISAM and InnoDB.
Here are the insert results though:
MyISAM:
insert: Total tim
Hi everyone,
I recently ran the MySQL benchmark suite on a Dual 1 GHz G4 running Mac
OS X Server 10.2.8, and an 800 MHz Intel machine running SuSE Linux 8.0.
Both installations used the same my.cnf file.
The results are comparable in all benchmarks except one: the 'insert'.
In that one, the Mac is
Daevid Vincent
http://daevid.com
-Original Message-
From: Ooks Server [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 4:38 PM
To: [EMAIL PROTECTED]
Subject: concat() differences between mssql and mysql
I've run into a problem with the behavior of concat(). If I
have two f
003 4:38 PM
> To: [EMAIL PROTECTED]
> Subject: concat() differences between mssql and mysql
>
>
> I've run into a problem with the behavior of concat(). If I
> have two fields,
> char(10), and I do this:
>
> concat(field1,fields)
>
> With MSSQL I get both
; To: [EMAIL PROTECTED]
> Subject: Re: concat() differences between mssql and mysql
>
>
> "Ooks Server" <[EMAIL PROTECTED]> wrote:
> > I've run into a problem with the behavior of concat(). If I
> have two fields,
> > char(10), and I do this:
> >
> &
"Ooks Server" <[EMAIL PROTECTED]> wrote:
> I've run into a problem with the behavior of concat(). If I have two fields,
> char(10), and I do this:
>
> concat(field1,fields)
>
> With MSSQL I get both fields including trailing spaces. With MYSql, I get
> the two fields with the trailing spaces trim
I've run into a problem with the behavior of concat(). If I have two fields,
char(10), and I do this:
concat(field1,fields)
With MSSQL I get both fields including trailing spaces. With MYSql, I get
the two fields with the trailing spaces trimmed. Example:
Field1 = "abc "
Field2 = "qwerty
0887CB | T_AA0887CB |
> +--+---++---++
> | 1672BE70 | 01| S | NULL | NULL |
> | D27518B1 | 01| S | NULL | NULL |
> +--+---++---++
>
> Please note the differences in four
Some of the values passed to the CASE expressions are NULL.
There was a bug in handling NULL in CASE that was fixed in
MySQL 4.0.8:
http://www.mysql.com/doc/en/News-4.0.8.html
Note the last item on the page. I believe this explains the
differences that you are seeing.
At 16:28 +0200 6/12/03
---+---++
| o_obj| _69B96431 | T_69B96431 | _AA0887CB | T_AA0887CB |
+--+---++---++
| 1672BE70 | 01| S | NULL | NULL |
| D27518B1 | 01| S | NULL | NULL |
+--+---++
> TheBS>>> Do you mean the "stock" kernel branches
> TheBS>>> (2.0, 2.2, 2.4, 2.6)?
> yes, as you point
I need to enumerate the changes between all Version
Regards
Luiz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.c
Norris,
Saturday, May 18, 2002, 12:19:33 AM, you wrote:
Neoen> On my unix box when I use mysql I can spawn vi and edit the sql statement or
Neoen> save it out for reuse.
Neoen> This feature does not appear to be present on the windows version - or did I
Neoen> miss something?
I can use it on Wi
Group,
On my unix box when I use mysql I can spawn vi and edit the sql statement or
save it out for reuse.
This feature does not appear to be present on the windows version - or did I
miss something?
Thanks.
-
Before posting,
[filter-fodder: sql, query]
Hi,
I am having trouble finding differences.
Table1 holds the current data, and Table2 holds the updates.
I need to query the two and find ONLY the rows showing the current+updates.
Table1:
TABLE dttunes (
id smallint(5) unsigned NOT NULL auto_increment,
danceid
RBRoa,
Tuesday, March 19, 2002, 1:22:22 AM, you wrote:
R> Everyone,
R> What's the differences with MySQLD and MySQL-max?
MySQL-max is the MySQL server that support InnoDB and BDB table types.
You can read about mysqld-max in the manual:
http://www.mysql.com/doc/m/y/mysqld-
On Monday 18 March 2002 4:22 pm, [EMAIL PROTECTED] wrote:
> Everyone,
>
> What's the differences with MySQLD and MySQL-max?
MySQL-max supports more table types.
-
Before posting, please check:
http://www.mysql.
Everyone,
What's the differences with MySQLD and MySQL-max?
R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
Hello,
There's a problem with mysql query, which I would like to report to
all of you. I'm not sure if it can be taken as a "bug" though.
Suppose we have a very simple table with only three or four fields.
Let's say the table is "employee", and one of the fields is "name" in
varchar or char ty
On Thu, 15 Nov 2001 23:29:27 -0800, Jeremy Zawodny used
a few recycled electrons to form:
| On Thu, Nov 15, 2001 at 04:14:58PM -0600, Michael Brunson wrote:
| >
| > Has anyone ran any benchmarks as to what affect different number of
| > RAID_CHUNKS has on speed?
|
| The more chunks, the slower yo
On Thu, Nov 15, 2001 at 04:14:58PM -0600, Michael Brunson wrote:
>
> Has anyone ran any benchmarks as to what affect different number of
> RAID_CHUNKS has on speed?
The more chunks, the slower your retrieval speed is likely to be. But
how many chunks do you really need? More than a few?
> mysq
Here is the same data in a little easy format.
Raid Chunks count like %like % %
10.00 sec 0.33 sec 2 min 3.70 sec
30.00 sec 0.39 sec 14 min 59.83 sec
50.00 sec 0.38 sec 6 min 44.92 sec
15 0.00 sec 0.39 sec 6 min 33.72 sec
Has anyone ran any benchmarks as to what affect
different number of RAID_CHUNKS has on speed?
Also, what affect does the RAID_CHUNKSIZE have?
Here are a few results I've gotten all with the default
CHUCKSIZE.
-
No RAID Tables (yes, fewer rows.. hit the 2G limit)
mys
I have two lists of queries. One returns the intersection of all the
queries within itself.. the actual intersection being done by an external
function (which I'd like to change if I can learn how), the other the
union of all queries within itself.. again using an external function for
the union..
Hi All,
I have installed PHPTriad V1.0 on my Win98 and it is about the best
programme I have ever used. What I need to know is, when I have created my
site and upload it to my ISP's server (Linux / FreeBSD / MySQL + PHP 4) are
there any pitfalls or code differences I should be awa
84 matches
Mail list logo
