On my E420R with 4 x 450MHz and 4 gb mem what mysql variables should I need to
play with to improve the following output
mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye"));
+----------------------------------------------+
| BENCHMARK(1000000,ENCODE("hello","goodbye")) |
+----------------------------------------------+
| 0 |
+----------------------------------------------+
1 row in set (2.89 sec)
Sorry for newbie question
On Tue, 29 Jul 2003, Dan Nelson wrote:
> 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.
>
>
--
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There's no place like 127.0.0.1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
