Controlling MySQL Threads ???

How do I control the number of threads MySQL opens initially? Basically I only wish to have a single thread running as there are only 2-3 queries per minute. I have installed MySQL binary package 4.0.xx on my Debain system. Instead of this in PS command:

mysql 31327 0.0 36.8 22288 10496 pts/0 S 05:37 0:00 /server/mysql/bin/mysqld --defaults-extra-file=
mysql 31328 0.0 36.8 22288 10496 pts/0 S 05:37 0:00 /server/mysql/bin/mysqld --defaults-extra-file=
mysql 31329 0.0 36.8 22288 10496 pts/0 S 05:37 0:00 /server/mysql/bin/mysqld --defaults-extra-file=
mysql 31330 0.0 36.8 22288 10496 pts/0 S 05:37 0:00 /server/mysql/bin/mysqld --defaults-extra-file=
mysql 31331 0.0 36.8 22288 10496 pts/0 S 05:37 0:00 /server/mysql/bin/mysqld --defaults-extra-file=
mysql 31332 0.0 36.8 22288 10496 pts/0 S 05:37 0:00 /server/mysql/bin/mysqld --defaults-extra-file=
mysql 31333 0.0 36.8 22288 10496 pts/0 S 05:37 0:00 /server/mysql/bin/mysqld --defaults-extra-file=
mysql 31334 0.0 36.8 22288 10496 pts/0 S 05:37 0:00 /server/mysql/bin/mysqld --defaults-extra-file=
mysql 31335 0.0 36.8 22288 10496 pts/0 S 05:37 0:00 /server/mysql/bin/mysqld --defaults-extra-file=
mysql 31336 0.0 36.8 22288 10496 pts/0 S 05:37 0:00 /server/mysql/bin/mysqld --defaults-extra-file=

I only wish to have this:

mysql 31327 0.0 36.8 22288 10496 pts/0 S 05:37 0:00 /server/mysql/bin/mysqld --defaults-extra-file=

Regards
Akash

 

 

 

 

Top