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. Selec
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 this
On Thu, Jan 21, 2010 at 7:15 AM, Krishna Chandra Prajapati
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 conditions (SELE
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_i
On Thu, Jan 21, 2010 at 5:18 PM, Suresh Kuna 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
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.
>
> T
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 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 con
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
