# Increasing performance by parallel processing or multiple mysqld

**URL:** <https://forums.percona.com/t/increasing-performance-by-parallel-processing-or-multiple-mysqld/986>\
**Category:** Other MySQL® Questions\
**Created:** [November 1, 2008, 4:48am UTC](https://forums.percona.com/t/increasing-performance-by-parallel-processing-or-multiple-mysqld/986 "2008-11-01T04:48:30Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nook](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nook/32/794_2.png) [@nook](https://forums.percona.com/u/nook)\
**Post date:** [November 1, 2008, 4:48am UTC](https://forums.percona.com/t/increasing-performance-by-parallel-processing-or-multiple-mysqld/986/1 "2008-11-01T04:48:30Z")

</div>

I’m running a search engine for realestate and I am in the process of acquiring a new server.

My search engine process is very well suited for parallelization, therefore I want to know how I can tweak mysql to use this in an optimal way.

I’ve noticed that on my present server mysql only uses one processor, the other is not used at all…

I see a possible number of possibilities:

1. putting different databases on different hard drives so read/write can be made fully parallel.

2. for each database running a different mysqld on its own port.

3. configuring my linux server so that it consist of (say) 4 virtual linux servers. Then on each of these 4 servers I install mysql for a different database.

I haven’t been able to find any references on this subject.

---

<div class="post-metadata">

**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\
**Post date:** [December 25, 2009, 10:31am UTC](https://forums.percona.com/t/increasing-performance-by-parallel-processing-or-multiple-mysqld/986/2 "2009-12-25T10:31:45Z")

</div>

MySQL uses one processor per query. If you have many queries running at once you should see more than one CPU in use.

---

<div class="post-metadata">

**Author:** ![shanavas](https://avatars.discourse-cdn.com/v4/letter/s/da6949/32.png) [@shanavas](https://forums.percona.com/u/shanavas)\
**Post date:** [August 2, 2011, 5:32am UTC](https://forums.percona.com/t/increasing-performance-by-parallel-processing-or-multiple-mysqld/986/3 "2011-08-02T05:32:51Z")

</div>

Is it possible to do parallel processing with MySQL as like in Oracle

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [August 2, 2011, 6:13am UTC](https://forums.percona.com/t/increasing-performance-by-parallel-processing-or-multiple-mysqld/986/4 "2011-08-02T06:13:30Z")

</div>

You have to split up the query and do the work yourself, or use a tool such as [http://www.mysqlperformanceblog.com/2010/11/15/shard-query-a](http://www.mysqlperformanceblog.com/2010/11/15/shard-query-a) dds-parallelism-to-queries/

---

<div class="post-metadata">

**Author:** ![shanavas](https://avatars.discourse-cdn.com/v4/letter/s/da6949/32.png) [@shanavas](https://forums.percona.com/u/shanavas)\
**Post date:** [August 3, 2011, 4:13am UTC](https://forums.percona.com/t/increasing-performance-by-parallel-processing-or-multiple-mysqld/986/5 "2011-08-03T04:13:53Z")

</div>

Thanks for your update. Is there any function availble in MySQL to debugg procedures as like DBMSoutput in Oracle.?