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
On Thu, Jul 15, 2010 at 10:46 PM, P.R.Karthik 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 isolati
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 ', histUni
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 t
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 accomplish
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 analysis
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 |
+
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?
André
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 cr
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: mysql@lists.my
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 d
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 wh
>-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
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: http://t
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 Di
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 us
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 8:
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
wrote:
> Hi all,
>
> I just wanna make new My
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 se
Try Explain command before execute something
Please google how to use index
- Original Message -
From: "hewei"
To: "Ananda Kumar"
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 all rows from the table?
===> YES
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"
To: mysql@lists.mysql.com
Sent: Monday, July 19, 2010 4:31:51 PM
Subject: Re: Decimal points
On 19/07/2010 10:04, Ashley M. Kirchner wrot
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 [mailto:ash.
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
de
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
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 abou
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 bel
26 matches
Mail list logo
