In the last episode (Jul 29), Asif Iqbal said:
> Now I am running these processes for my mysql serever
>
> /bin/sh /usr/local/mysql/bin/safe_mysqld --datadir=/usr/local/mysql/data
> --pid-file=/usr/local/mysql/data/webrt.pid
>
> /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/bin/mysqld
> --defaults-extra-file=/usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/data/my.cnf
> --basedir=/usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc
> --datadir=/usr/local/mysql/data --user=mysql
> --pid-file=/usr/local/mysql/data/webrt.pid
>
>
> Now on the same logic if I run 4 pair ( the above two processes )
> will it imporve my mysql query performance done through my
> DBIx::SeacrhBuilder ?
No; the server will use as many CPUs as you have automatically. To
take advantage of multiple CPUs you need multiple clients working in
parallel. Oracle can split complicated queries into sections and let
different processors work on each part (Parallel Query option), but
mysql will only use one processor per query.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
