days, I am struggling with the problem of increasing history
>>> list
>>> length on mysql 5.6.29. Application that this server is running IOT
>>> based.
>>> Also, this server has so many threads running in sleeping mode. SHOW
>>> ENGINE
>>>
;
>> For many days, I am struggling with the problem of increasing history
>> list
>> length on mysql 5.6.29. Application that this server is running IOT based.
>> Also, this server has so many threads running in sleeping mode. SHOW
>> ENGINE
>> INNODB STATUS shows
On 4/2/2016 10:36 AM, geetanjali mehra wrote:
Hi to all,
For many days, I am struggling with the problem of increasing history list
length on mysql 5.6.29. Application that this server is running IOT based.
Also, this server has so many threads running in sleeping mode. SHOW ENGINE
INNODB
increasing history list
length on mysql 5.6.29. Application that this server is running IOT based.
Also, this server has so many threads running in sleeping mode. SHOW ENGINE
INNODB STATUS shows all these threads in *cleaning up* mode.
I tried all the options to reduce history list length. But it is
Hi to all,
For many days, I am struggling with the problem of increasing history list
length on mysql 5.6.29. Application that this server is running IOT based.
Also, this server has so many threads running in sleeping mode. SHOW ENGINE
INNODB STATUS shows all these threads in *cleaning up* mode
Hello,
Could someone educate me on relation between
"innodb_thread_concurrency" and number of MySQL threads running on the
server with "thread pool" feature in Enterprise version of MySQL
(based on release 5.6.16 (.4)?)
If I set "innodb_thread_concurrency=32", how m
hotshot, so the basis of my assumption is a *hunch* only).
I'm not sure (yet) if a single-threaded operation would run into an
i/o bottleneck. I didn't run mysqlimport using --use-threads=1 just
yet (will do if I have the time), but when I've ran it with
--use-threads=4 the import (of
I'm skeptical that use-treads can every be very effective.
What order are the rows in? They are probably in PRIMARY KEY order, which
means that the INSERTing threads will be fighting over similar spots in the
table.
Is it I/O bound when it is single-threaded? If so, then there can
E=NDB, etc.) import it and after this I import
the InnoDB data *as is* using mysqlimport.
I use it like this:
mysqlimport --local --use-threads=4 db dir/*.txt
(dir of course cotains the tab delimited data I dumped before.)
The import starts, and I check its progress via mysqladmin, like
Hello,
Does anyone know if MyISAM supports background
IO threads, or it is available only for InnoDB?
Thanks,
Jacek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ions about this on the web but no
>> resolution yet.
>>
>>
>> When MySQL runs out of threads, you are unable to stop /
>> restart the database.
>>
>>
>> Is there a way to reserve threads for the root user /
>> database restarts?
>&
On 6/30/2010 6:56 AM, Machiel Richards wrote:
Good day all
Sorry one more question.
I have seen many questions about this on the web but no
resolution yet.
When MySQL runs out of threads, you are unable to stop /
restart the
Good day all
Sorry one more question.
I have seen many questions about this on the web but no
resolution yet.
When MySQL runs out of threads, you are unable to stop /
restart the database.
Is there a way to reserve
o not accept threads
Hi!
Machiel Richards wrote:
> [[...]]
>
> We received an error on a MySQL database this morning
which
> caused it to be unavailable for connections.
>
> Error:
>
> ERROR 1135 (0): Can't create
RORS
|The pthread_create() function shall fail if:
|
|EAGAIN The system lacked the necessary resources to create
another thread, or the system-imposed
| limit on the total number of threads in a process
{PTHREAD_THREADS_MAX} would be exceeded.
|
| [[...]]
Jörg
--
J
imports relevant data within a single
transaction.
This import runs every 30 minutes so the amount of data being import
is not that much and have not increased drastically so I am not yet sue as
to where else to look.
The only log created was that there was that no more threads
Note that some of the memory settings are per connection, if you have
63 connections, you may have up to 63 copies of the buffers, and you
have pretty huge buffers even with 30GB of memory. Join buffers close to
1 G, tmp_table_size of 2 G, 63 connections could mean upto 63 copies of
these, and
Good morning all
Hope everyone is well
We received an error on a MySQL database this morning which
caused it to be unavailable for connections.
Error:
ERROR 1135 (0): Can't create a new thread (errno 11); if
you
Hi Baron,
I am too new to mysql internal jargon to understand "Handler:info()". Can
you tell me specific variables you want to get the real issue?
*Regarding OS:* It ubuntu disto. of linux.
dhee...@:~$ uname -a
Linux host0125 2.6.24-16-generic #1 SMP Thu Apr 10 12:47:45 UTC 2008 x86_64
GNU/Li
Hi,
You probably aren't doing anything wrong, per se, but I suspect
Handler::info() is slow and is being called once per partition. You
should probably start looking at your system overall to check where
the time is spent. Is it in reading from disk? If so, can you make
it read from memory inst
We have installed mysql-5.1.39 and having a database with following table.
CREATE TABLE `EntMsgLog` (
`msgId` bigint(20) NOT NULL,
`causeId` bigint(20) NOT NULL,
`entityId` int(11) NOT NULL,
`msgReceiver` bigint(20) NOT NULL,
`msgTextId` int(11) NOT NULL,
`flags` bit(8) NOT NULL,
`t
> Is it recommended we disable connection pooling,
> so that all connections are instantly closed ?
Frankly, no. Well-behaved connection pooling is a good thing. It
will reduce the load on your system resources and speed up responses
considerably.
If the only thing at issue is that you have obs
Hi Michael,
We are using standard classic ASP code like :
*Function OpenConnection()
OpenConnection = "DSN=MyDSN_SSL"
End Function
DSNTemp = OpenConnection()
Set Conn = Server.CreateObject("ADODB.Connection")
Set RecordsetTest = Server.CreateObject("ADODB.RecordSet")
response.wri
I am certainly no expert in Windows, but that sounds like the work of
whatever is managing the connections on your application server.
Whatever language you are using, if you opened the connection raw,
what you are describing would be impossible. You need to look at how
you are acquiring your conn
Hi
Thanks for your quick response. In our test environment running MySQL
5.1.31 over SSL (hosted external of our network) and IIS 6 on Windows 2003
Server, I've found when opening a test connection to the database from my PC
and one from my colleagues PC on the same internal network, we both had
Hi,
With regards the CONNECTION_ID() variable in MySQL, is this based on a per
user basis. Or can multiple users use the same connection_id ?
Thanks,
Neil
astmail.fm]
Envoyé : mardi 8 septembre 2009 17:21
À : mysql@lists.mysql.com
Objet : Re: Tuning mysql concurrent running threads
If you are talking about MyISAM tables, in my.cnf you can set the
thread_concurrency=x
where x=2*# of CPU's
but this unfortunately only works on Solaris and not on Lin
rver where thousands of users connect. I configured max
connections but i didn't found how to configure concurrent raunning
threads. When i do show status, always RUNNING THREADS=1, even several
threads are pending.
How to change this please ?
Anyone can help me please ?
Thank you very
Hello,
I have a mysql server where thousands of users connect. I configured max
connections but i didn't found how to configure concurrent raunning threads.
When i do show status, always RUNNING THREADS=1, even several threads are
pending.
How to change this please ?
Anyone can he
On 7/19/07, Mariella Petrini <[EMAIL PROTECTED]> wrote:
Question:
Which could be the MySQL variables that could be
changed and that could provide a major increase ?
Take a look on that[1].
[1]
http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
--
Hi,
I have been working with MySQL 5.1.20 (64 bits
compiled on Mac OS for MacPro Intel Xeon Quad-Core
qith 2 processors and 8GB of RAM) and MySQL 5.0.41 (32
bits).
While running some of the select statements
(independently of the storage engine used, either
InnoDB or MyISAM) I have noticed that
r the case of LinuxThreads, in seeing the mysql
threads as processes, when in fact they're not.
I have no clue how boxes prepared and compiled the same way could end up
with different setups, but it seems this is the reason from what i get when
running "getconf GNU_LIBPTHREAD_VERSION
---
> De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De
> la part de Quentin
> Gouedard
> Envoyé: mercredi 30 mai 2007 09:02
> À: Scott Tanner
> Cc: mysql@lists.mysql.com
>
>
http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html#starting-
>
> server
>
> Geoffroy
>
> -Message d'origine-
> De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de
Quentin
>
> Gouedard
> Envoyé: mercredi 30 mai 2007 09:02
offroy
>
> -Message d'origine-
> De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Quentin
>
> Gouedard
> Envoyé: mercredi 30 mai 2007 09:02
> À: Scott Tanner
> Cc: mysql@lists.mysql.com
> Objet: Re: mysql creating lots of processes (not threads
rigine-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Quentin
Gouedard
Envoyé: mercredi 30 mai 2007 09:02
À: Scott Tanner
Cc: mysql@lists.mysql.com
Objet: Re: mysql creating lots of processes (not threads, linux processes)
Nope, I'm using 5.0.38 on Gentoo, built via em
: Re: mysql creating lots of processes (not threads, linux processes)
Nope, I'm using 5.0.38 on Gentoo, built via emerge in the exact same manner.
Thanks for your answers guys.
On 5/30/07, Scott Tanner <[EMAIL PROTECTED]> wrote:
>
> Sounds like your not using threaded libr
t; >
> > Geoffroy
> >
> > -Message d'origine-
> > De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de
Quentin
> > Gouedard
> > Envoyé: mardi 29 mai 2007 16:41
> > À: mysql@lists.mysql.com
> > Objet: mysql creating lots of process
uedard
> > Envoyé: mardi 29 mai 2007 16:41
> > À: mysql@lists.mysql.com
> > Objet: mysql creating lots of processes (not threads, linux processes)
> >
> > Hi,
> > So I use mysql as the DB for a large site (up to 1 concurrent users at
> > peaks).
> >
i 2007 16:41
À: mysql@lists.mysql.com
Objet: mysql creating lots of processes (not threads, linux processes)
Hi,
So I use mysql as the DB for a large site (up to 1 concurrent users at
peaks).
I have a front server as a reverse proxy and multiple (7) backend machines
serving the site.
Each machine has dat
mysql@lists.mysql.com
Objet : mysql creating lots of processes (not threads, linux processes)
Hi,
So I use mysql as the DB for a large site (up to 1 concurrent users at
peaks).
I have a front server as a reverse proxy and multiple (7) backend machines
serving the site.
Each machine has data strictly simil
process (process in linux
terms):
# ps -ef | grep mysqld | wc -l
2
There are generally 5-8 threads (processes as mysql means it) running when i
do a show processlist;
Now, on one of those machines there are huge number of processes for mysql.
# ps -ef | grep mysqld | wc -l
34
Running just ps shows for
x27;s there to
detect bugs in the mysql cluster code. There is currently no code in
mysql to terminate active threads when the client connection closes.
That's why I said you'd have to file a feature request bugreport :)
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL Gener
2006 19:00
An: André Ress
Cc: mysql@lists.mysql.com
Betreff: Re: Threads of terminated clientapplications
In the last episode (Jul 28), André Ress said:
> We have a problem with abortet clients and long time querys.
>
> If our application performs a long time select statement on
In the last episode (Jul 28), André Ress said:
> We have a problem with abortet clients and long time querys.
>
> If our application performs a long time select statement on the mySql
> database and the application is abortet, the query still runs! We
> tried several time-out variables like wait
Hello MySQL Comunity.
We have a problem with abortet clients and long time querys.
If our application performs a long time select statement on the mySql database
and the application is abortet, the query still runs!
We tried several time-out variables like wait_timeout, interactive_timeout or
Hallo
On Thu, Jun 22, 2006 at 01:54:07PM -0500, Dan Buettner wrote:
> Christian, I hope raising the open_files_limit helps (I think it
> should). I second Brent's suggestion to enable the thread_cache.
>
> Please do report back and let us know how you fare.
The effect that lots of tables are i
lcore-Hyperthreading Xeon system with 8GB RAM) the database
performance suddenly goes down and stays so for a while.
There is no significant memory or CPU activity but the Load goes up to
200 which indicates to me that there must be many mysql threads (hidden
in the process list) which are calcula
abase server
(Quad-Dualcore-Hyperthreading Xeon system with 8GB RAM) the database
performance suddenly goes down and stays so for a while.
There is no significant memory or CPU activity but the Load goes up to
200 which indicates to me that there must be many mysql threads (hidden
in the process list)
You should also up your thread cache, currently it's set to 0. MySQL won't reuse threads if this is set to 0. MySQL has created
13781740 new threads so far.
You can change the value while the server is running (example below), but may
want to also add it to your conf file.
gt; >
> >There is no significant memory or CPU activity but the Load goes up to
> >200 which indicates to me that there must be many mysql threads (hidden
> >in the process list) which are calculated in the Load value but are
> >effectively doing nothing as CPU/RAM stays.
>
must be many mysql threads (hidden
in the process list) which are calculated in the Load value but are
effectively doing nothing as CPU/RAM stays.
The mysqladmin processlist output looks suspicious, *lots* of queries in
the opening+closing tables state which should, according to the docs,
be happen
Recently I noticed a changed behavior in how linux utilities (ps ans
pstree) report mysql usage.
Previously a ps output would list all active mysql threads, and a
pstree would list the number of mysql threads currently running.
Now I merely see a pstree output such as:
├─mysqld_safe
I got this error,
You seem to be running 32-bit Linux and have 308 concurrent connections.
If you have not changed STACK_SIZE in LinuxThreads and built the binary
yourself, LinuxThreads is quite likely to steal a part of the global
heap for
the thread stack. Please read http://www.mysql.com/doc
Hello.
Very often InnoDB provides a better performance in
environment where a lot of concurrent SELECTs and
UPDATEs. Check if the problem still exists if you change
the engine of you tables from MyISAM to InnoDB.
M.E. Koch wrote:
> Hello:
>
> After haveing a look at the `show proce
May my guess was not right.
Thanx so far for the help!!!
yours
mathias
>-Ursprüngliche Nachricht-
>Von: Gleb Paharenko [mailto:[EMAIL PROTECTED]
>Gesendet: Sonntag, 16. Oktober 2005 14:45
>An: mysql@lists.mysql.com
>Betreff: Re: limited threads to two but 25 waiting?!
&
M)
>
> 1. prob.
> the mysql> show processlist gives me a list of 25 threads
> waiting for there work.
> even on heavy load `pgrep mysql` will just show two PIDs
> doing somthing even if there are just SELECT queries on the
> DB. therefor the server get's really slow
Hi,
I have searched and tried and have no clue why the db on
4.1.11-Debian_4sarge2 behaves like this.
I have no TABLE LOCK query anywhere in my code!
About the server (LAMP/ 2x3Mhz, 4GB RAM)
1. prob.
the mysql> show processlist gives me a list of 25 threads
waiting for there work.
even on he
'm having the same problem, and I'm using mysql official binary.
I have two servers, one is webserver and the other is the database
server. The webserver connects to the mysql server over tcp.
at some times there are many connections and mysql creates more than
1000 threads and then jus
Hello.
Use -m command line option for ps to see all threads.
>I compiled mySQLd 4.1.10a from Source on Linux 2.6. Although the server
>does it's work
>well, I wondered why there's only one mysqld thread running. Is that
>new/normal for mySQL
>4.1? While usin
4.1? While using mySQL 3.23 I always had
several threads running on my system.
>
> your glibc probably are compiled with NPTL.
> The thread are still there but to see them you must use a different
> sintax of ps , like:
>
> #ps -eLf
>
>
>
> --
> No problem is so for
B. Heller wrote:
Hello List,
I compiled mySQLd 4.1.10a from Source on Linux 2.6. Although the server does it's work well, I wondered why there's only one mysqld thread running. Is that new/normal for mySQL 4.1? While using mySQL 3.23 I always had several threads running on my system.
Hello List,
I compiled mySQLd 4.1.10a from Source on Linux 2.6. Although the server does
it's work well, I wondered why there's only one mysqld thread running. Is that
new/normal for mySQL 4.1? While using mySQL 3.23 I always had several threads
running on my system.
--
This messag
Gleb Paharenko wrote:
Hello.
I have mysql-server 3.23.49-8.9 in a debian woody,
chosen for its stability. It looks like the server
stops accepting connections when it has created
more than 1024 threads.
> I recommend you to switch to the official binaries.
Does the problem remain on the lat
Hello.
> I have mysql-server 3.23.49-8.9 in a debian woody,
> chosen for its stability. It looks like the server
> stops accepting connections when it has created
> more than 1024 threads.
I recommend you to switch to the official binaries.
Does the problem remain o
I have mysql-server 3.23.49-8.9 in a debian woody,
chosen for its stability. It looks like the server
stops accepting connections when it has created
more than 1024 threads.
The kernel is 2.4.29.
failed: Can't create a new thread (errno 11). If you
are not out of available memory.
I
Hello Everybody,
Can anyone explain to me the differences pros/cons of having a DB Pool
of connections or a DB Pool of cursors?
I'm running a multi-threaded program in pyhton, and I know I can open
several cursors from one single connection, or open a bunch of
connections with one cursor per con
I appear to be running kernel 2.4.x
ps -ax only shows one mysqld thread
John McCaskey wrote:
Did you upgrade to a 2.6.x linux kernel as well? Threads get hidden in a
normal ps aux command starting in 2.6 and show as a single process. If
this is the case do ps aux -L and you will see the threads
Did you upgrade to a 2.6.x linux kernel as well? Threads get hidden in a
normal ps aux command starting in 2.6 and show as a single process. If
this is the case do ps aux -L and you will see the threads as well.
On Tue, 2005-01-18 at 13:15 -0500, Eben Goodman wrote:
> I used to run mysql 3.x
I used to run mysql 3.x on Redhat, and would on any given day have
anywhere from 5 to 30 mysqld process/threads going depending on
traffic. I upgraded to mysql 4.0.17 on a dedicated redhat box, and now
it only ever shows 1 mysqld process/thread that uses max cpu and
consumes a good deal of
inst it'. I keep on running into all kinds of dynamic
> linker errors.
>
> The page http://www.volano.com/linuxnotes.html referred to in the manual
> don't exist. Exhaustive search of this list didn't help (i followed the
> recent discussion re
ea how to 'statically
link MySQL against it'. I keep on running into all kinds of dynamic
linker errors.
The page http://www.volano.com/linuxnotes.html referred to in the manual
don't exist. Exhaustive search of this list didn't help (i followed the
recent discussion re 'My
: Wednesday, November 17, 2004 11:37 AM
To: [EMAIL PROTECTED]
Subject: RE: MySQL 4.0.2 is topping out at 1024 threads!
wait_timeout
Will set the maximum amout of time a thread will be in the Sleep
state before MySQL drops it.
Eric Gunnett
System Administrator
Zoovy, Inc.
[EMAIL PROTECTED
au
Cc: [EMAIL PROTECTED]
Subject: RE: MySQL 4.0.2 is topping out at 1024 threads!
threads or connections ? if the problem is about connection maybe change the
parameter in your my.cnf :
max_connections = 1024
to a higher value ...
Hope this helps...
Saludos / Regards,
Alvaro.
On Wed, 2004-
>
> Here is some more info on the problem I am experiencing:
>
> mysql> status
> --
> mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686)
>
>
> Threads: 1023 Questions: 781971 Slow queries: 0 Opens: 33 Flush tables:
> 1 Open tables: 27 Querie
threads or connections ? if the problem is about connection maybe change
the parameter in your my.cnf :
max_connections = 1024
to a higher value ...
Hope this helps...
Saludos / Regards,
Alvaro.
On Wed, 2004-11-17 at 11:18 -0800, Matt Babineau wrote:
> F
.0.20-standard-log
Protocol version: 10
Connection: 63.12.130.192 via TCP/IP
Client characterset:latin1
Server characterset:latin1
TCP port: 3306
Uptime: 19 hours 40 min 2 sec
Threads: 1023 Questions: 781971 Slow queries: 0 Opens: 33 Flush tabl
In the last episode (Nov 17), Gleb Paharenko said:
> > Help! I can't figure out a way to stop my server from topping out
> > at 1024 threads. This is a very strange behavoir. I have tons of
> > legit use on my database server but I don't think the threads are
&g
Hello.
Similar problems are often found in lists. Usually they are solved by
increasing file limits. You likely need to increase open-files-limit.
>Help! I can't figure out a way to stop my server from topping out at 1024
>threads. This is a very strange behavoir. I have tons o
Help! I can't figure out a way to stop my server from topping out at 1024
threads. This is a very strange behavoir. I have tons of legit use on my
database server but I don't think the threads are dying does anyone have any
suggestions for this?
Thanks,
Matt Babineau
Web Developer
Cr
Hello
We're having some locking problems with our vBulletin 3.0 forum.
Snapshots of mysql process list show that some simple queries linger too
much in the "end" state, locking subsequent updates:
Id UserHostdb Command TimeState Info
..
33753 rcgroups12.
Luke,
As far as I know you can't do that in mysql, it would have to be at the
kernel level. Replication threads, really don't use much cpu anyway at
least not on the master, since all it's doing is basically reading a binary
file.
Now the kernel itself does do something like
l rh-mysql-2 411 Binlog Has sent all binlog to
slave; waiting for binlog to be updated
2667 repl rh-mysql-3 411 Binlog Has sent all binlog to
slave; waiting for binlog to be updated
it looks like three seperate threads are running on the maste
.
When from another computer I run a query that selects and sorts say 200,000
records. All the mysql threads for all the workstations go to locked state
except the one running the big query. No computer has locked any tables. In
a minute or two when the big query is complete the computers all unlock
What type of select is this? Is the application and the database on the same
machine? Is this query build a large temp table?
-Original Message-
From: John Nairn
To: [EMAIL PROTECTED]
Sent: 7/14/04 7:11 PM
Subject: Any select with a large result set locks all other threads until it
Hi,
I am testing mysql on a large database (10GB). When I post a large
select request via myodbc all other process threads lock until that
thread completes. I am not locking any tables.
How do I stop a read only select statement with a large result set from
locking all the other threads until
em.. You can read exactly what they're for here:
http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
Hope this helps
Lachlan
-Original Message-
From: Daniel Eliav Sharvit [mailto:[EMAIL PROTECTED]
Sent: Friday, 9 July 2004 5:16 AM
To: [EMAIL PROTECTED]
Subject: Handling threads
Hi list, I'm having the following problem when I tried to connect to MySQL
server through terminal mysql client it displayed "Can't create thread errno
(11)" , I worked around the variables thread_stack and thread_cache_size,
its initial value was 64KB for thread_stack and 20 for thread_cache_size;
looded and allowing no more
connections.
Status of all threads (most recent and old are Has sent all binlog to
slave; waiting for binlog to be updated)
Is it me or should I report a bug?
Thanks
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Jon,
an update statement is supposed to return the # of rows updated, so the
client must wait for a response, which means the client will wait if you
low_priority your updates. But if they are insert delayed then the
client gets a return immediately. This behavior limits the usefullness
of low
Dathan Vance Pattishall wrote:
log-bin=/var/opt/mysql/db2-binlog
skip-innodb
log-error=/var/opt/mysql/db2-errlog
This is on a separate drive?
yes, the database is the only thing on the high speed RAID. everything
else is on the other drive (also a RAID but only RAID0 with 2 drives).
any ideas
> -Original Message-
> From: news [mailto:[EMAIL PROTECTED] On Behalf Of Jon Drukman
> Sent: Thursday, May 13, 2004 3:21 PM
> To: [EMAIL PROTECTED]
> Subject: avoiding "Locked" threads
>
> I've got a very high traffic discussion forum database that is
I've got a very high traffic discussion forum database that is
constantly running into a problem with lots and lots of threads in the
"Locked" state. i was under the impression that MySQL could
update/insert and select from the same table at the same time, but it
doesn't
On Tue, May 04, 2004 at 12:36:19PM -0700, Max Clark wrote:
>
> Can't create a new thread (errno 35). If you are not out of
> available memory, you can consult the manual for a possible
> OS-dependent bug
>
> I am running FreeBSD 4.9 with Mysql 4.0.18 compiled with Linux
&
Can't create a new thread (errno 35). If you are not out of available
memory, you can consult the manual for a possible OS-dependent bug
I am running FreeBSD 4.9 with Mysql 4.0.18 compiled with Linux Threads.
I am running large inbound concurrency on Postfix which is forking
several proc
[EMAIL PROTECTED] wrote:
Hi folks!
I have diffrent linux-machines running with the great mysqld.
But on some machines I have 20 running threads on some other only 2
threads.
If only 2 threads are running is that not bad for fast sql-results?
I have about 500 v-hosts and many sql-queries on my
Hi folks!
I have diffrent linux-machines running with the great mysqld.
But on some machines I have 20 running threads on some other only 2
threads.
If only 2 threads are running is that not bad for fast sql-results?
I have about 500 v-hosts and many sql-queries on my machine.
Does somebody
uot;'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]>
Subject: RE: Handling threads
Date: Fri, 2 Apr 2004 10:36:22 -0600
You say you have a monitor that is logging active connections. Is this
monitor reporting that all available connections are used?
-Original Message-
From: Mike
You say you have a monitor that is logging active connections. Is this
monitor reporting that all available connections are used?
-Original Message-
From: Mikel -
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 4/2/04 10:29 AM
Subject: Re: Handling threads
Yes I can ping my server, the
L PROTECTED]
To: "Mikel -" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: Re: Handling threads
Date: Thu, 1 Apr 2004 15:23:29 -0600
When this happens are you able to ping the MySQL server? The literal error
message is "Resource temporarily unavailable"
Have you looked in the
1 - 100 of 225 matches
Mail list logo