Selecting, Inserting and Deleting data

2010-01-21 Thread Krishna Chandra Prajapati
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

Re: Selecting, Inserting and Deleting data

2010-01-21 Thread Suresh Kuna
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

Re: Selecting, Inserting and Deleting data

2010-01-21 Thread Krishna Chandra Prajapati
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.comwrote: Hi Krishna, As table is using MyISAM engine and it acquires a table level lock, the queries will be executed

Re: Selecting, Inserting and Deleting data

2010-01-21 Thread Suresh Kuna
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,

Re: Selecting, Inserting and Deleting data

2010-01-21 Thread Abhishek Singh
On Thu, Jan 21, 2010 at 5:18 PM, Suresh Kuna sureshkumar...@gmail.comwrote: 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

Re: Selecting, Inserting and Deleting data

2010-01-21 Thread Krishna Chandra Prajapati
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

Re: Selecting, Inserting and Deleting data

2010-01-21 Thread Perrin Harkins
On Thu, Jan 21, 2010 at 7:15 AM, Krishna Chandra Prajapati prajapat...@gmail.com wrote: 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

Re: Selecting, Inserting and Deleting data

2010-01-21 Thread Shawn Green
Krishna Chandra Prajapati 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

Re: Selecting, Inserting and Deleting data

2010-01-21 Thread mos
At 06:15 AM 1/21/2010, Krishna Chandra Prajapati wrote: 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.