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