Thanks to everybody, and to Rob Wultsch, his link helped me to understand
what I was doing...
./configure select an automake configure or a perl one...
I ended building mysql with innodb,heap,myisam and partitions, statically
built with:
./configure --with-plugins=heap,partition,innobase,myisam
WW...
While uploading the database to a clean mysql, mysql 4.1.22 didn't even get
over 26 mb/s of writting speed, but I'm monitoring the speed mysql 5.5.3 is
reaching and can squeeze 100mb/s, averga I'm seeing like 35mb/s
22GB at mysql 4.1 lasted like 3 hours to fully load, this one I
Dear MySQL users,
MySQL Server 5.5.5-m3, a new version of the popular Open Source
Database Management System, has been released.
The -m3 suffix indicates that these releases belong to the third
milestone. According to our milestone release model, also called
Celosia. You can read more about the
mysql select 1+1.0;
+---+
| 1+1.0 |
+---+
| 2.0 |
+---+
1 row in set (0.00 sec)
mysql select 1+1.1;
+---+
| 1+1.1 |
+---+
| 2.1 |
+---+
1 row in set (0.00 sec)
Is there a way to tell MySql to only return '2' in the first select as
opposed to
On 19/07/2010 10:04, Ashley M. Kirchner wrote:
Is there a way to tell MySql to only return '2' in the first select as
opposed to '2.0'? The second select is correct and should remain as such.
Not easily, no.
Basically I have two columns, one with an integer and another with a
SELECT IF((col1+col2) = FLOOR(col1+col2),FLOOR(col1+col2), col1+col2)
EXAMPLE
SELECT IF((1+1.1) = FLOOR(1+1.1),FLOOR(1+1.1),1+1.1) Results 2.1
SELECT IF((1+1.0) = FLOOR(1+1.0),FLOOR(1+1.0),1+1.0) Results 2
Regards,
Samrat Kar
-Original Message-
From: Ashley M. Kirchner
Hi,
Let try '' to treat numeric as character
For example:
select 1+'1.0';
== 2
select 1+'1.1';
== 2.1
- Original Message -
From: Mark Goodge m...@good-stuff.co.uk
To: mysql@lists.mysql.com
Sent: Monday, July 19, 2010 4:31:51 PM
Subject: Re: Decimal points
On 19/07/2010 10:04,
Try Explain command before execute something
Please google how to use index
- Original Message -
From: hewei heweiwe...@gmail.com
To: Ananda Kumar anan...@gmail.com
Cc: mysql@lists.mysql.com
Sent: Thursday, June 17, 2010 5:54:23 PM
Subject: Re: why the sql so slowly?
you want to select
Hi all,
I just wanna make new MySQL server for OLTP kind of environment. I want
to use InnoDB storage engine.
Which version is better for this kind of environment and which will give
the great performance?
MySQL 5.1.47/48 or MySQL 5.5?
Should we use mysql development release for production
I have just upgraded from mysql4.1 to mysql 5.5.3.. I will upgrade to 5.5.4.
5.5. has a lot of speed improvements...
and OF course you should NOT use mysql developtment release for production
server!
On Mon, Jul 19, 2010 at 8:05 AM, Nilnandan Joshi
nilnand...@synechron.comwrote:
Hi all,
I
But, can we get GA releases for MySQL 5.5?
Andrés Tello wrote:
I have just upgraded from mysql4.1 to mysql 5.5.3.. I will upgrade to
5.5.4.
5.5. has a lot of speed improvements...
and OF course you should NOT use mysql developtment release for
production server!
On Mon, Jul 19, 2010 at
Since everyone keeps bringing up Innodb's shared tablespace, I will point
out that Innodb has a file-per-table option where each table has it own
tablespace. This helps with management issues. While there is still a
central datafile it doesn't contain table data and is much smaller than if
you
Je serai absent(e) du 2010-07-10 au 2010-08-02.
Bonjour ,
Je suis présentement en vacance. Pour toute question Applicatif
Central vous pouvez contacter Diane Jean ou Steeve Garneau. Pour toute
question MySQL/SQL SERVER vous pouvez contacter Geneviève Caron , André
Pépin ou Louis
Any idea when the 5.5 GA release will be?
- John
--
---
John May : President http://www.pointinspace.com/
Point In Space Internet Solutions j...@pointinspace.com
Twitter:
-Original Message-
From: Rob Wultsch [mailto:wult...@gmail.com]
Sent: Sunday, July 18, 2010 2:57 PM
To: Martin Gainty
Cc: je...@gii.co.jp; keithcl...@k-wbookworm.com; claudio.na...@gmail.com;
alba.albe...@libero.it; mysql@lists.mysql.com
Subject: Re: How to become a DBA on MySQL
I very
I may be going at this completely wrong but at the moment I'm
stuck. I have a DB from a client and need to do several searches on
it. This one sentence is important because it's their DB, not mine. So
I can't modify the way the DB was created in the first place, I can only
work with
Not quite sure what the question is.
from:
mysql select * from table where id='1';
+---+-+-+---+
| 1 | 123 | 0.0 | C |
| 1 | 234 | 0.1 | D |
| 1 | 345 | 0.0 | D |
| 1 | 456 | 0.1 | C |
| 1 | 567 | 0.1 | G |
+---+-+-+---+
How do we deduce
In addition, the binlogs function as incremental backups. With a full backup +
binlogs, you can do point-in-time recovery to any moment you choose.
-Original Message-
From: Keith Murphy [mailto:bmur...@paragon-cs.com]
Sent: Monday, July 19, 2010 6:55 AM
To: Jan Steinman
Cc:
On 7/19/2010 12:36 PM, Ashley M. Kirchner wrote:
I may be going at this completely wrong but at the moment I'm
stuck. I have a DB from a client and need to do several searches on
it. This one sentence is important because it's their DB, not mine. So
I can't modify the way the DB was
No, current GA is 5.1.48
-Original Message-
From: Nilnandan Joshi [mailto:nilnand...@synechron.com]
Sent: Monday, July 19, 2010 6:14 AM
To: Andrés Tello
Cc: mysql@lists.mysql.com
Subject: Re: which version is better for production servers?
But, can we get GA releases for MySQL 5.5?
On 7/19/2010 10:48 AM, Michael Dykman wrote:
Not quite sure what the question is.
from:
mysql select * from table where id='1';
+---+-+-+---+
| 1 | 123 | 0.0 | C |
| 1 | 234 | 0.1 | D |
| 1 | 345 | 0.0 | D |
| 1 | 456 | 0.1 | C |
| 1 | 567 | 0.1 | G |
On 7/19/2010 11:08 AM, Shawn Green (MySQL) wrote:
Just because someone hands you a set of data to *start* with, does not
mean that you must only use that data to *work* with.
You should be able create additional tables derived from the original
data and work with those as part of your
Ashley,
I can't go back to the client and tell them their schema
is really messed up and to store their data differently.
You can hope that's not not necessary in order to deliver the requested
query, but it's a bad mistake to rule it out altogether, since it often
happens that
Today I downloaded MySQL-server-community, MySQL-client-community,
MySQL-shared-community, and mysql-workbench-gpl to install on an
RHEL5/x86_64 machine. The first three installed just fine. The fourth
failed due to a large pile of missing dependencies (see below). I do not
even know where
I have a stored procedure in mysql 5.1.48 that deletes old data from my
tables.
I would like to keep a running count while it does this. Here is what I
try now:
...
DECLARE dropCnt INT DEFAULT 0;
...
SET @sql = CONCAT('DELETE FROM myTable WHERE itemid = ', iID, ' AND
clock BETWEEN 0 AND ',
On Thu, Jul 15, 2010 at 10:46 PM, P.R.Karthik prk...@gmail.com wrote:
Hi,
I am newbie to mysql can i know the advantages of myisam storage engine
and some of its special features.
--
Regards
Karthik.P.R
kart...@mafiree.com
Special features:
1. Not atomic.
2. No consistency.
3. Horrible
On 7/19/2010 5:22 PM, Bryan Cantwell wrote:
I have a stored procedure in mysql 5.1.48 that deletes old data from my
tables.
I would like to keep a running count while it does this. Here is what I
try now:
...
DECLARE dropCnt INT DEFAULT 0;
...
SET @sql = CONCAT('DELETE FROM myTable WHERE itemid
27 matches
Mail list logo