Increasing performance by parallel processing or multiple mysqld

  • Filter
  • Time
  • Show
Clear All
new posts

  • Increasing performance by parallel processing or multiple mysqld

    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.

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


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


      • #4
        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 dds-parallelism-to-queries/


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


          • #6
            is it possible to call webservice from mysql SP