Hi Abhishek. insert, select and delete are in the same proportion.
1. Inserted data into a table A by user. 2. Selecting data from table A inserting data to table B after applying some rules(update). 3. Deleting data from table A. 4. Selecting data from table B using some conditions (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) moving to third party for sending sms. 5. Deleting the selected data from table B. With the above scenario, i am not able to user concurrent connections. Other wise it will send duplicate sms. Thanks, Kishna On Thu, Jan 21, 2010 at 5:28 PM, Abhishek Singh <abhishek.r...@gmail.com>wrote: > > > On Thu, Jan 21, 2010 at 5:18 PM, Suresh Kuna <sureshkumar...@gmail.com>wrote: > >> 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 < >> prajapat...@gmail.com> 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 <sureshkumar...@gmail.com >> >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 < >> >> prajapat...@gmail.com> 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 >> > > > > Hi Krishna, > > Can you please tell me what kind query you mostly run is it select or > insert? > > -- > Abhishek Kumar Singh > >
