# Increase transaction query performance

**URL:** <https://forums.percona.com/t/increase-transaction-query-performance/1022>\
**Category:** Other MySQL® Questions\
**Created:** [December 4, 2008, 5:17am UTC](https://forums.percona.com/t/increase-transaction-query-performance/1022 "2008-12-04T05:17:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![selvasays](https://avatars.discourse-cdn.com/v4/letter/s/c57346/32.png) [@selvasays](https://forums.percona.com/u/selvasays)\
**Post date:** [December 4, 2008, 5:17am UTC](https://forums.percona.com/t/increase-transaction-query-performance/1022/1 "2008-12-04T05:17:56Z")

</div>

Hi,

I am installed My SQL 4.1 database under Red Hat linux with 1GB RAM.

Table A (No Index) having two columns  
MobileNo  
Name

Table B (No Index) also having the same structure (MobileNo and Name)

Table A having 5,400,000 records.  
Table B having 1,200,000 records.

this is query to run

delete A from A,B where A.MobileNo = B.MobileNo

It is taking more than 6 hrs.

I am using default my.cnf file setting.

How to improve the performance to change the my.cnf file?

---

<div class="post-metadata">

**Author:** ![vgatto](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vgatto/32/748_2.png) [@vgatto](https://forums.percona.com/u/vgatto)\
**Post date:** [December 4, 2008, 10:57am UTC](https://forums.percona.com/t/increase-transaction-query-performance/1022/2 "2008-12-04T10:57:00Z")

</div>

Can you elaborate a little? In particular, are these tables MyISAM or InnoDB? Did you attempt this delete on a system with a heavy transaction load or on a test system? Can you provide the results of SHOW CREATE TABLE for both of these tables? What are the results of:

EXPLAIN SELECT A.\* FROM A, B WHERE A.MobileNo = B.MobileNo;