List:General Discussion« Previous MessageNext Message »
From:Suresh Kuna Date:January 21 2010 11:48am
Subject:Re: Selecting, Inserting and Deleting data
View as plain text  
Innodb contains multi-version property, so it can handle more concurrent
queries from user connections.


On Thu, Jan 21, 2010 at 5:07 PM, Krishna Chandra Prajapati <
prajapatikc@stripped> wrote:

> 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
>>>
>>
>>
>>
>


-- 
Thanks
Suresh Kuna
MySQL DBA

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