On Mon, Nov 10, 2008 at 08:23:24PM +0300, Alexey Vlasov wrote:
> DBI connect('database,...)
> failed: Can't create a new thread (errno 12); if you are not out of
> available memory, you can consult the manual for a possible OS-dependent
> bug at ...
I just thought, all this can be a result of du
On Mon, Nov 10, 2008 at 06:36:34PM +0100, Uwe Kiewel wrote:
> Alexey Vlasov schrieb:
>> open files (-n) 1024
>
> just a shot to the blue:
>
> can you count your open files with lsof?
# lsof -u mysql | wc -l
1719
I doubt that the problem is in that otherwise every second use
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John Daisley schrieb:
> Hit 'Reply to All' instead of reply.
>
Is is okay for you the have your answers twice? If I post to a list, I
read that list. So there is no need to have the ansers at the list and
in my inbox
Uwe
-BEGIN PGP SIGNATURE
not to the list :-(
>
> - Original-Nachricht
> Betreff: Re: Is it a bug or my mistake in server configuration?
> Datum: Mon, 10 Nov 2008 18:36:34 +0100
> Von: Uwe Kiewel <[EMAIL PROTECTED]>
> An: Alexey Vlasov <[EMAIL PROTECTED]>
> Referenzen: <[EMAIL PRO
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Andy Shellam schrieb:
>
>> This mailing list has a stupid configuration. Pressing the answer
>> button, the message goes to the sender not to the list :-(
>>
>
> Hint - use Reply to All - it's not specific to this mailing list. :-)
>
It dosn't m
he sender not to the list :-(
>
> - Original-Nachricht
> Betreff: Re: Is it a bug or my mistake in server configuration?
> Datum: Mon, 10 Nov 2008 18:36:34 +0100
> Von: Uwe Kiewel <[EMAIL PROTECTED]>
> An: Alexey Vlasov <[EMAIL PROTECTED]>
> Referenzen: <
This mailing list has a stupid configuration. Pressing the answer
button, the message goes to the sender not to the list :-(
Hint - use Reply to All - it's not specific to this mailing list. :-)
Regards,
Andy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Curtis Maurand schrieb:
>
> I've been having the same trouble in a Xen virtual machine. After about
> an hour and a half, mysql will be consuming 100% of cpu. There is
> nothing wrong with the tables. I'm assuming its a dynamic vs. fix
> amount of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
This mailing list has a stupid configuration. Pressing the answer
button, the message goes to the sender not to the list :-(
- Original-Nachricht
Betreff: Re: Is it a bug or my mistake in server configuration?
Datum: Mon, 10 Nov
I've been having the same trouble in a Xen virtual machine. After about
an hour and a half, mysql will be consuming 100% of cpu. There is
nothing wrong with the tables. I'm assuming its a dynamic vs. fix
amount of memory available to mysql. I'm guaranteed x amount of ram,
but that might g
Hi.
One client from my shared hosting periodically informs me about an
error:
DBI connect('database,...)
failed: Can't create a new thread (errno 12); if you are not out of
available memory, you can consult the manual for a possible OS-dependent
bug at ...
There's nothing suspicious in the MySQL
Just noticed that you said partitions. I am assuming that you meat
multiple drives in a raid array.
Bill
David Lazo said:
> Thanx again.
>
> For the time being, we will keep 4 drives with Dan's suggestion. OS and
> MySQL running from there.
>
>
>
> On 8/25/06 11:03 AM, "Dan Buettner" <[EMAIL PR
Thanx again.
For the time being, we will keep 4 drives with Dan's suggestion. OS and
MySQL running from there.
On 8/25/06 11:03 AM, "Dan Buettner" <[EMAIL PROTECTED]> wrote:
> James, with just 4 drives, you can set up one big RAID 10 disk
> (usually called a "logical disk", with Dell PERCs I
Sorry, I think I had James and David backwards there!
On 8/25/06, Dan Buettner <[EMAIL PROTECTED]> wrote:
James, with just 4 drives, you can set up one big RAID 10 disk
(usually called a "logical disk", with Dell PERCs I think it's a
"container"), and then partition it for your different needs.
James, with just 4 drives, you can set up one big RAID 10 disk
(usually called a "logical disk", with Dell PERCs I think it's a
"container"), and then partition it for your different needs.
If you have 4 73 GB disks, you probably have around 135 GB formatted
capacity with RAID 10; I'd do somethin
David Lazo wrote:
I'm sorry to bother you again with this.
So we have the server but we have 4 Drives and now that I'm trying to set up
the RAID10 I'm starting to think I needed 5 Drives one for the OS?.
Please advise.
David.
We built one pretty close to this recently. You definitely
Thanks for all the recommendations.
On 8/22/06 1:11 PM, "Dan Buettner" <[EMAIL PROTECTED]> wrote:
> I second what James recommends re: spindles and RAID 10. Better than
> RAID 5 for live data in my opinion; RAID 5 is decent for archival
> storage.
>
> You've got a pretty decent setup there oth
I second what James recommends re: spindles and RAID 10. Better than
RAID 5 for live data in my opinion; RAID 5 is decent for archival
storage.
You've got a pretty decent setup there otherwise - 4 CPU cores, 8 GB
RAM - and you want to make sure your disks can keep things fed.
As far as splittin
David Lazo wrote:
We want to get:
Windows Server 2003 R2, Standard x64 Edition
2- Dual Core Intel Xeon 5080, 2x2MB Cache, 3.73GHz, 1066MHz FSB
8GB 533MHz (8x1GB), Dual Ranked DIMMs
3- 146GB, SAS, 3.5-inch, 15K RPM Hard Drives
What would be the recommended RAID configuration settings for a dedic
We want to get:
Windows Server 2003 R2, Standard x64 Edition
2- Dual Core Intel Xeon 5080, 2x2MB Cache, 3.73GHz, 1066MHz FSB
8GB 533MHz (8x1GB), Dual Ranked DIMMs
3- 146GB, SAS, 3.5-inch, 15K RPM Hard Drives
What would be the recommended RAID configuration settings for a dedicated
MySQL db runnin
Ed Pauley II wrote:
I need to come up with a high availability, high performance MySQL
server setup. I have two database servers half way across the country
from one another being replicated through a VPN. These db servers
serve two very busy web sites with multiple applications accessing th
I need to come up with a high availability, high performance MySQL
server setup. I have two database servers half way across the country
from one another being replicated through a VPN. These db servers serve
two very busy web sites with multiple applications accessing the db.
During busy tim
é : lundi 6 décembre 2004 09:21
À : [EMAIL PROTECTED]
Objet : Server Configuration Help
Greetings,
I am running MySQL (version 4.0.15 max) database on Linux (RH9) box.
This linux box is a dedicated database server with following h/w
configuration:
CPU: 2 * 2.4 Ghz Xeon Processor, 512 K 533
Greetings,
I am running MySQL (version 4.0.15 max) database on Linux (RH9) box.
This linux box is a dedicated database server with following h/w
configuration:
CPU: 2 * 2.4 Ghz Xeon Processor, 512 K 533 FSB
Ram :6GB
Hdd:36GB * 5 raid config
Typically, this database has
Greetings,
I am running MySQL (version 4.0.15 max) database on Linux (RH9) box. This
linux box is a dedicated database server with following h/w configuration:
CPU: 2 * 2.4 Ghz Xeon Processor, 512 K 533 FSB
Ram :6GB
Hdd:36GB * 5 raid config
Typically, this databa
On Wed, Jun 09, 2004 at 01:45:49PM +0100, Marvin Wright wrote:
> Hi,
>
> We are about to build some new database servers and I have some questions
> which I'd like some advice on.
>
> The machines we are building have 4 Xeon 2GHz CPU's, 4 x 32GB SCSI disk
> using RAID 1+0 (so thats 64GB of storag
Hi,
We are about to build some new database servers and I have some questions
which I'd like some advice on.
The machines we are building have 4 Xeon 2GHz CPU's, 4 x 32GB SCSI disk
using RAID 1+0 (so thats 64GB of storage) and 4 Gig of RAM.
The OS will be Redhat 7.3.
Other than the mysql database
Hello!
Sorry not to have given any signs of life...
Thank you for your answer. Changing the number of connections to 100 solved
the problem of the Server configuration error, but I've gone back to
getting java.sql.SQLException: DBCP could not obtain an idle db connection,
pool exhausted (
ally about once or twice a day I get
this exception org.apache.commons.dbcp.DbcpException:
java.sql.SQLException: Server configuration denies access to data source.
Once the exception occurs, it happens for every request and Tomcat needs
restarting.
Before getting this exception, I used to run out of c
the mysql-
> connector-java-2.0.14-bin.jar in commons/lib.
> The application runs normally, and usually about once or twice a day I get
> this exception org.apache.commons.dbcp.DbcpException:
> java.sql.SQLException: Server configuration denies access to data source.
> Once the excepti
- Original Message -
From: "Mysql List" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 24, 2003 11:15 AM
Subject: Re: Huge Server configuration
> I have RAID 5 with 5 hardisks, so usuable number of spindle will only be 4.
Unless you've d
X-Original-To: [EMAIL PROTECTED]
X-Original-To: [EMAIL PROTECTED]
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]>
Date: Thu, 24 Jul 2003 10:42:31 -0700
RAID-5 is cool, RAID-1+0 (10) is better for writes.
Raid5 is slow and
-->-Original Message-
-->From: Mysql List [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, July 24, 2003 10:47 AM
-->To: Dathan Vance Pattishall
-->Cc: [EMAIL PROTECTED]
-->Subject: Re: Huge Server configuration
-->
-->Dathan Vance Pattishall wrote:
-->
--
Dathan Vance Pattishall wrote:
RAID-5 is cool, RAID-1+0 (10) is better for writes.
Your defiantly are going to be IO bound. I would go with many smaller
disks >= 20 disk, in multiple RAID-1+0 configurations on different
channels or better yet different RAID controllers.
Well I do not have the l
BEGIN my.cnf
[mysqld]
port = 3306
socket= /tmp/mysql.sock
basedir = /usr/local/mysql
log = /var/log/mysql/mysql.log
log-slow-queries = /var/log/mysql/mysql-slow.log
log-err = /var/log/mysql/mysql.err
log-bi
IO bound with a read heavy 2 Gb where most of
the data is in memory. I'm transferring 15Mb a second of read traffic.
-->-Original Message-
-->From: Mysql List [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, July 24, 2003 10:16 AM
-->To: [EMAIL PROTECTED]
-->Subject: R
t;Subject: Huge Server configuration
-->
-->Hello all,
-->
-->I have a server like 8way Intel Pentium 4 Xeon processor with 12GB
RAM
-->and 1TB harddisk space.
-->All the tables size are over 10GB and they have over 100mm records.
-->
-->Could some one help me get an appropria
Christopher Knight wrote:
what table types? Innodb.etc...
It is mainly innodb.
about how many tables?
there are around 200 tables
do you do alot of sorting?
Lots of sorting and fltering is done
are the exact same queries repeated alot?
Not likely
is the machine doing anything else or is ma
-
From: Mysql List [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 11:38 AM
To: [EMAIL PROTECTED]
Subject: Huge Server configuration
Hello all,
I have a server like 8way Intel Pentium 4 Xeon processor with 12GB RAM
and 1TB harddisk space.
All the tables size are over 10GB and they have over
-variable = max_allowed_packet=16M
-->-Original Message-
-->From: Mysql List [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, July 24, 2003 9:38 AM
-->To: [EMAIL PROTECTED]
-->Subject: Huge Server configuration
-->
-->Hello all,
-->
-->I have a server like 8way Intel Pe
Hello all,
I have a server like 8way Intel Pentium 4 Xeon processor with 12GB RAM
and 1TB harddisk space.
All the tables size are over 10GB and they have over 100mm records.
Could some one help me get an appropriate mysql configuration(my.conf)
file for the machine.
I understand ther are lots
se','teva');
Hope this helps,
- Original Message -
From: "Rodolfo Ricci" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 01, 2003 6:32 PM
Subject: Server configuration denies access to data source
> I'm trying to use mysql with ja
I'm trying to use mysql with java, I create a short
piece of code to make a conection but when the class
run it sends an exception:
Server configuration denies access to data source
I can use the database using mysql client without
problem.
Could someone help me, or ask me where i find the
li
Hi, I am a new user of MYSQL, when I use JDBC to
connect MYSQL, I got exception:
SQLException: Server configuration denies access to
data source.
Could some one kindly help me ?
Thanks a lot.
Jeff Zhao
Here is my program, it is very simple
import java.sql.*;
public class LoadDriver
[mailto:[EMAIL PROTECTED]]
Sent: 17 January 2002 15:42
To: [EMAIL PROTECTED]
Subject: Server configuration denies access to data source
Ok, i think i've found the cause of my problem and maybe your too !
In fact my MySQL doesn't close opens conections and he doesn't let me open
Ok, i think i've found the cause of my problem and maybe your too !
In fact my MySQL doesn't close opens conections and he doesn't let me open
an another one...and so throw me an exception. If i'm waiting few minutes
before opening new connections, it's working, so just check your
'connection t
I got the same problem, and i have the impression that this is a MySQL bug...
Sorry i can't help you at this moment... i have to help myself first ! :))
Good luck
-
Before posting, please check:
http://www.mysql.com/manual.ph
ves SQLException
"Server configuration denies access to data source". I am running the MySQL
server using following command "./bin/mysqld_safe &". I created the database
named "TEST" and given the log/pass as "root/" (password nothing, as I do
not have any password f
> i!='AP' AND i != 'J3' AND...to 5000).
>
> >
>
> > When I try to execute the Query I get the error:
>
> >
>
> > "Packet is Larger than max_allowed_packet from server configuration of
> 65536
>
> > bytes"
>
>
ry I get the error:
>
> "Packet is Larger than max_allowed_packet from server configuration of 65536
> bytes"
>
> I read the MySQL documentation and increased my max_allowed_packet to 24M on
> both the client and the Server in the my.cnf, but I still get the same
> errorIs th
I try to execute the Query I get the error:
"Packet is Larger than max_allowed_packet from server configuration of 65536
bytes"
I read the MySQL documentation and increased my max_allowed_packet to 24M on
both the client and the Server in the my.cnf, but I still get the same
errorIs
mysql -u was -p" works perfectly. But remote
connection doesn't work. I can
see in my application log file : Server configuration denies access to data
source
Do you have any idea about this problem ?
Best regards,
Nicolas Beaumont
Atos Origin
Activité Intégration
Tour Les Miroirs
18
I have a couple java servlets and WebObjects applications that fetch
data from MySQL databases. I recently tried running them and received
the following error:
SQLException raised when connecting : java.sql.SQLException: Server
configuration denies access to data source
From a command line
I have a couple java servlets and WebObjects applications that fetch
data from MySQL databases. I recently tried running them and received
the following error:
> SQLException raised when connecting : java.sql.SQLException: Server
> configuration denies access to data source
Since th
hi.
I had installed mysql on redhat-7.0
I have a java program that inserts, deletes from
mysql. It used to work fine.
I had to reinstall linux and hence mysql.
Now the same program doesnt work.
I get the error: "Server configuration denies access
to data source"
I can access the
Hi,
I'm connecting to a MySQL server through the MM JDBC driver on under Red Hat
6.2 using the below code. I keep getting an error message returned that says
: "Server configuration denies access to data ".
I'm connecting as the root user and I am definitely passing the corr
all of a sudden, they are getting these errors in their error logs:
Cannot load connection class 'java.sql.SQLException: Server configuration
denies access to data source'.
This is happening to multiple customers at the same time. The only way we
can fix the problem is to shut down th
Hi Everyone,
I am in a very very
desperate state 'coz my whole site is down and if I
cannot connect to the database through my servlet my
@ss is grass.
Everything seems to be working fine except when I
execute the servlet I get this frustrating error:
" Server configuration denies
58 matches
Mail list logo
