ql.com
Cc: [EMAIL PROTECTED]
Sent: Wednesday, October 4, 2006 11:59:27 PM
Subject: Re: FreeBSD 6.1 + Libthr + MySQL 5.0.24a max connection issue or bug?
Have a look at kern.threads.max_threads_per_proc: 1500
and kern.threads.max_groups_per_proc: 1500
You are probably hitting one of these sysctl'
ki on Freebsd and MySQL at
http://wikitest.freebsd.org/MySQL
Hope this helps,
Ken
- Original Message -
From: "Abdullah Ibn Hamad Al-Marri" <[EMAIL PROTECTED]>
To:
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, October 03, 2006 4:13 PM
Subject: FreeBSD 6.1 + Libthr + MySQL 5.0.
Hello folks,
I hope Greg is reading this list
I use MySQL 5.0.24a from the FreeBSD ports, with libthr threading.
I have a huge app makes alot of connections to MySQL server.
The max I could reach is 1500 threads, even I made the max connection in my.cf
5k and I used
Hello folks,
I hope Greg is reading this list
I use MySQL 5.0.24a from the FreeBSD ports, with libthr threading.
I have a huge app makes alot of connections to MySQL server.
The max I could reach is 1500 threads, even I made the max connection in my.cf
5k and I used
Hi Chenri,
> 1. is this value for one database or for overall mysql connections?
The value is for overall mysql connections... so it's not for one
database.
> 2. i'm unable to generate 100 connections, i don't have 100 workstations
yet,
> how do i test it?
Why would you ?
> 3. what w
Hello.
> 1. is this value for one database or for overall mysql connections?
This values is for overall mysql connections.
> 2. i'm unable to generate 100 connections, i don't have 100 workstations yet,
>how do i test it?
You may write a perl script, for example.
> 3. what will
my my.ini contain
max_connections=100
this mean that simultaneous connection available is 100 connections,
my questions are:
1. is this value for one database or for overall mysql connections?
2. i'm unable to generate 100 connections, i don't have 100 workstations yet,
how do i test it?
3.
Hi.
When MySQL reach max connection can root use mysql client program to login
and look for some process that can be kill to release connection.
I had ever seen from some web said that some user with PROCESS_ACL
privileges can do (can login MySQL reserved 1 connection for user who has
