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