joe schrieb:
U might want to try seting you index to calldate, disposition
or calldate, day, disposition ...
and depending on your MySQL version:
(to circumvent possible limitations in InnoDB with your MySQL version)
you could try
WHERE calldate = '2007-07-01 00:00:00'
AND calldate =
Hello guys,
I am little bit worried about the mysql future and me too. Oracle has
acquired Innobase and now BDB also. Slowly it is capturing the whole. What
is the future of mysql. my future is also related to mysqls future. MySQL
should have some thing in their own hands
Thanks
--
Krishna
Tnx for your interest
# uname -a
Linux corona 2.6.18-5-amd64 #1 SMP Thu May 31 23:51:05 UTC 2007 x86_64
GNU/Linux
64 bit shouldn't have problems in using 4gb of ram .. right ?
[EMAIL PROTECTED] ha scritto:
just want to take a note on 4Gbytes
What kernel u use?
4Gbytes or bigger means
Yes, you're right, with that index query is flying...
then I used DAYOFMONTH(calldate) instead of DATE_FORMAT(calldate, '%d'),
it gives an extra performance gain of 5x
tnx for help
joe ha scritto:
U might want to try seting you index to calldate, disposition
-Original Message-
From:
Tnx for your precious advice.
Do you know if there is some documentation somewhere on the net with the
most known Innodb performance limitations ? so I can avoid to teast
again each query and doing different optimization.
I tried the original query with 5.0 and 5.1... same results...
Tnx
Hi All,
I have three databases namley nddata, archivedata and alldata. I want to
create three table space for all the three
databases. Is it possible. If yes then how to do this thing.
Thanks
--
Krishna Chandra Prajapati
MySQL DBA,
Ed Ventures e-Learning Pvt.Ltd.
1-8-303/48/15, Sindhi Colony
I am little bit worried about the mysql future and me too. Oracle has
acquired Innobase and now BDB also. Slowly it is capturing the whole. What
is the future of mysql. my future is also related to mysqls future. MySQL
should have some thing in their own hands
Like Falcon?
Martijn Tonies
Like Falcon?
Yes, Falcon is a great piece in the MySQL arsenal if you ask me (or
probably any MySQL devotee).
Cheers,
Craig Huffstetler
On Nov 26, 2007 8:06 AM, Martijn Tonies [EMAIL PROTECTED] wrote:
I am little bit worried about the mysql future and me too. Oracle has
acquired
Hi,
I found one thread on this that included some people's opinions, but I
haven't been able to find anyone who has actually done some performance
testing to see if there is a cost and what that cost is to doing cross
database joins. I do tend to want to keep everything in one DB, but it
surely mysql would just fork the last gpl innodb release if they got
bummed by oracle...
--- Martijn Tonies [EMAIL PROTECTED] wrote:
I am little bit worried about the mysql future and me too. Oracle
has
acquired Innobase and now BDB also. Slowly it is capturing the
whole. What
is the
surely mysql would just fork the last gpl innodb release if they got
bummed by oracle...
I doubt if they can -- from the InnoDB website:
The GPLv2 License
The GNU General Public License version 2, under which both MySQL and InnoDB
are published, does not allow, without permission from MySQL
Hi everybody,
Does different table space with multiple databases is good for production
server. Is there any testing has been done. What is the impact on the other
things like speed.
Thanks,
--
Krishna Chandra Prajapati
MySQL DBA,
Ed Ventures e-Learning Pvt.Ltd.
1-8-303/48/15
Sindhi Colony
Michael Stearne wrote:
Is mysql-table-sync design to be used as a fix for when your
replication is out of sync OR can it be used instead of replication?
Thanks,
Michael
You need to use replication not mysql-table-sync for replication.
mysql-table-sync is use to get it back in sync.
Hi,
I have a problem with SELECT speed. The first execution takes up to
several minutes while the next (with the same statement) takes not more
then several seconds.
The statement example is:
select nas.nasIpAddress, count(distinct(acct.user_id)), count(*),
sum(acct.acctOutputOctets)
from acct,
Hi,
I have a problem with SELECT speed. The first execution takes up to several
minutes while the next (with the same statement) takes not more then several
seconds.
The statement example is:
select nas.nasIpAddress, count(distinct(acct.user_id)), count(*),
sum(acct.acctOutputOctets) from acct,
What is the reason for Oracle to detain Mysql Features like BDB,
INNODB...? Is there any Hidden Market strategies for that
Thanks Regards ,
Dhandapani S
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Monday, November 26, 2007 7:41 PM
To: MySql
Subject:
You seem to have an over-reliance on BTREE Indexes over BITMAPPED Indexes or
HASH Indexes
There are specific rules governing implementation of BTREE Index
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14220/schema.h
tm#sthref893
As well as specific rules governing use of HASH
What is the reason for Oracle to detain Mysql Features like BDB,
INNODB...? Is there any Hidden Market strategies for that
Who knows, but Oracle?
Either way, given that MySQL isn't free and thus InnoDB isn't free,
there's money in it.
Martijn Tonies
Database Workbench - development tool
Hi,
I wouldn't say the Sleepycat/BDB acquisition had anything to do with
MySQL. BDB is much more useful *outside* of MySQL, and has a much
bigger market there anyway. The BDB storage engine is all but useless.
As for Innobase/InnoDB, their motives are still unclear. :)
Regards,
Jeremy
Hi all,
Wow, the rumors were true. Oracle is snapping up Open Source Database
companies now. First it was Innobase (see Oracle buys Innobase. MySQL
between rock and hard place?) and now it's Sleepycat Software.
The purchase of Sleepycat, which has been rumored for weeks, gives
Oracle another
Does all these reasons brings oracle massive on Global market.. compared
to other databases...?
Thanks Regards ,
Dhandapani S
-Original Message-
From: Parikh, Dilip Kumar
Sent: Tuesday, November 27, 2007 12:03 AM
To: Jeremy Cole; Shanmugam, Dhandapani
Cc: Martijn Tonies; MySql
Yup
But it has come up with new features like Oracle's Berkeley DB 4.5 is a
replication framework .etc.
Dilip
-Original Message-
From: Jimmy G [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 27, 2007 12:13 AM
To: Parikh, Dilip Kumar
Cc: Jeremy Cole; Shanmugam, Dhandapani;
Hello,
we have a column in a table, called tag numbers, which start with numerical and
alpha characters, IE:
012345
123456
LH12345
KB055698
47899901
MO558585
... etc.
now what I need to do is to display all the tag numbers, but order by their
alpha prefix, either DESC or ASC. What is
At 07:26 AM 11/26/2007, you wrote:
Like Falcon?
Yes, Falcon is a great piece in the MySQL arsenal if you ask me (or
probably any MySQL devotee).
Craig,
I have my doubts about Falcon replacing InnoDb. I don't think it
will be fast enough to handle a lot of users.
As to why
The second query might be faster due to caching.
On 11/26/07, Alexander Bespalov [EMAIL PROTECTED] wrote:
Hi,
I have a problem with SELECT speed. The first execution takes up to several
minutes while the next (with the same statement) takes not more then several
seconds.
The statement
Hi Phillip
Did you get a chance to look at Navicat?
http://www.navicat.com/download.html
Martin--
- Original Message -
Wrom: CGPKYLEJGDGVCJVTLBXFGGMEPYOQKEDOTWFAOBUZXUW
To: mysql@lists.mysql.com
Sent: Sunday, September 30, 2007 1:42 AM
Subject: Crystal Reports XI on W2k3 Server SP2 x64
26 matches
Mail list logo