Hi wharms,
Yor are right. It's some kind of queue mechanism. Right now i am working i
telco company (We used to send sms)
Users will be inserting records into send_sms @ 30,000msg/min Then those
record will be updated and moved to alt_send_sms and deleted from send_sms.
After that 30,000msg/min
Never mind. I got it to work..
I had to really trim down the entire statement:
set @sql = concat( "select
iams_id as iamsId
,division_name as divisionName
,region_name as regionName
,isactive as isActive
from user_approvers
li
Is there anyway the SELECT query can be forced to use the "from" and "to"
rownum parameters?
1st LIMIT arg = OracleFromArg
2nd LIMIT arg = OracleToArg - OracleFromArg + 1
so 'from 11 to 20' becomes LIMIT 11,10.
PB
-
Anoop kumar V wrote:
Hi All,
I am facing a problem in porting an appli
Hi All,
I am facing a problem in porting an application written for oracle to run on
mysql.
The application uses a sqlmap (ibatis) at the heart of which is basically a
file that defines all sql's used in the application. It is very well
organized this way. The application uses Oracle as the datab
At 01:44 PM 8/21/2009, you wrote:
RENAME statement is atomic, and you can specify multiple tables to rename
at once.
Instead of two statements, do this:
rename table send_sms to send_sms_full, send_sms_empty to
send_sms;
There will be no "gap" in-between.
Ah yes, that's what I forgot. It's a
>-Original Message-
>From: Gavin Towey [mailto:gto...@ffn.com]
>Sent: Friday, August 21, 2009 2:45 PM
>To: Jerry Schwartz; 'mos'; 'MySQL'
>Subject: RE: Scaling Mysql
>
>RENAME statement is atomic, and you can specify multiple tables to rename
at
>once.
>
>Instead of two statements, do thi
RENAME statement is atomic, and you can specify multiple tables to rename at
once.
Instead of two statements, do this:
rename table send_sms to send_sms_full, send_sms_empty to
send_sms;
There will be no "gap" in-between.
-Original Message-
From: Jerry Schwartz [mailto:jschwa...@the-inf
Yeah.. I think i misunderstood what he is trying to do here..
I thought he only wanted rows where t BEGINS with /sr/db, but I think he
wants rows that have a line in column t that begins with that -- then of
those rows, he only wants t to contain the lines within t that begin with
/sr/db as well.
>
>Krishna,
> Rather than copying rows from one table to another, and deleting the
>previous rows, why not just do:
>
>1) create table send_sms_empty like send_sms;
>
>2) rename table send_sms to send_sms_full;rename send_sms_empty to
send_sms;
>
>3) insert into alt_send_sms select * from send_
>-Original Message-
>From: Ananda Kumar [mailto:anan...@gmail.com]
>Sent: Friday, August 21, 2009 2:55 AM
>To: Johnny Withers
>Cc: MySQL
>Subject: Re: alternate in mysql
>
>Hi Johnny,
>Thanks for the reply, but the below sql does not seems to work
>
> SELECT * FROM tmp WHERE t REGEXP '^/sr/
I am upgrading minor MySQL versions, 5.0.67 to 5.0.84
I have a master-master replication setup, and want to upgrade both
installations.
The ideal procedure for upgrading mysql using the mysql_upgrade command is to
have binary logging turned off during the execution of mysql_upgrade.
My situation
At 01:30 AM 8/21/2009, Krishna Chandra Prajapati wrote:
Hi list,
I have two tables send_sms and alt_send_sms. Users are inserting records
into send_sms @ 500/sec ie 3/min. After applying some updates to
send_sms data are transferred to alt_send_sms and deleted from send sms. The
same thing i
Krishna Chandra Prajapati schrieb:
> Hi list,
>
> I have two tables send_sms and alt_send_sms. Users are inserting records
> into send_sms @ 500/sec ie 3/min. After applying some updates to
> send_sms data are transferred to alt_send_sms and deleted from send sms. The
> same thing is happeni
13 matches
Mail list logo
