List:General Discussion« Previous MessageNext Message »
From:Krishna Chandra Prajapati Date:January 21 2010 11:37am
Subject:Re: Selecting, Inserting and Deleting data
View as plain text  
Hi Suresh,

my question is how i can run concurrent connection with the above work load.

Thanks,
Krishna

On Thu, Jan 21, 2010 at 4:46 PM, Suresh Kuna <sureshkumarilu@stripped>wrote:

> Hi Krishna,
> As table is using MyISAM engine and it acquires a table level lock, the
> queries will be executed one after one .
> By converting it into Innodb as it acquires a row level lock, doing a
> select and delete based on primary key will be faster and the concurrency
> increases.
>
> --
> Thanks
> Suresh Kuna
> MySQL DBA
>
>
>
> On Thu, Jan 21, 2010 at 4:30 PM, Krishna Chandra Prajapati <
> prajapatikc@stripped> wrote:
>
>> Hi List,
>>
>> I am working for a messaging company, sending sms to enterprise customers.
>>
>> In a mysql table data is being continuously inserted by user. Most of the
>> time we have 5 to 10 millions of data in this table.
>>
>> Table name : alt_send_sms engine myisam
>>
>> From this table, i need to select data based on below parameter. Send some
>> where else and then delete the selected data.
>>
>> selection and deletion part is done in bulk.
>>
>> SELECT sql_id, momt, sender, receiver, udhdata, msgdata, time, smsc_id,
>> service, account, id, sms_type, mclass, mwi, coding, compress FROM
>> alt_send_sms WHERE smsc_id = 'ite' ORDER BY msg_priority, sql_id LIMIT
>> 0,20
>>
>> delete from alt_send_sms where sql_id in
>> (....................................................)
>>
>> sql_id is a unique bigint column with auto_increment.
>>
>> Since the selection and deletion is done in bulk. Therefore, i cannot run
>> many similar concurrent queries. As duplicate messages will be send. What
>> can be the solution for this ?
>>
>> Any response is highly appreciated.
>>
>> Thanks,
>> Krishna
>>
>
>
>

Thread
Selecting, Inserting and Deleting dataKrishna Chandra Prajapati21 Jan
  • Re: Selecting, Inserting and Deleting dataSuresh Kuna21 Jan
    • Re: Selecting, Inserting and Deleting dataKrishna Chandra Prajapati21 Jan
  • Re: Selecting, Inserting and Deleting dataShawn Green21 Jan