Determine connection origins

2010-06-30 Thread Machiel Richards
Good day all We are trying to find out where the current connections on our Mysql database originates from. We are receiving 4000+ connections at the moment where this was usually only about half this. Is there a way of determining where

Re: Application lost database connection

2010-03-08 Thread Hartmut Holzgraefe
t to reestablish the connection ... You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

Application lost database connection

2010-03-08 Thread Manasi Save
fully received from the server was40939 seconds ago.The last packet sent successfully to the server was 40939 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your applicat

Re: Problem starting connection pooling

2010-01-22 Thread Mark Witczak
:40:35 PM org.apache.catalina.core.ApplicationContext log INFO: SessionListener: contextInitialized() Jan 21, 2010 9:43:06 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet jsp threw exception javax.servlet.jsp.JspException: Unable to get connection

Re: Problem starting connection pooling

2010-01-22 Thread Mark Matthews
text log > INFO: SessionListener: contextInitialized() > Jan 21, 2010 9:43:06 PM org.apache.catalina.core.StandardWrapperValve invoke > SEVERE: Servlet.service() for servlet jsp threw exception > javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: >

Re: Problem starting connection pooling

2010-01-22 Thread Mark Witczak
org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet jsp threw exception javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "org.apache.commons.dbcp.SQLNe stedException: Cannot create PoolableConnectionFactory (Communications

Re: Problem starting connection pooling

2010-01-22 Thread Mark Matthews
re.StandardWrapperValve invoke > SEVERE: Servlet.service() for servlet jsp threw exception > javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: > "org.apache.commons.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory (Communications link fa

Problem starting connection pooling

2010-01-22 Thread Mark Witczak
I'm very new to MySQL, Tomcat, connection pooling, JSP, etc. and I've been banging my head against a wall for two weeks trying to get a simple program to connect to a MySQL database. *Vital Stats:* Ubuntu 9.10, Java 1.6.0_0, Java Servelet 2.5, Java Server Pages 2.1, JSTL 1.

Re: mysqlpp::Connection memory leak?

2010-01-18 Thread Attila
form of adding DBWork to it's list to > process when a connection is received) > --> These DBWorkers will request a connection from the pool, the pool > then queues a connection for usage back to the DBWorker (when a connection > becomes available) > > That all being sa

mysqlpp::Connection memory leak?

2010-01-18 Thread Attila
threadpool threads. DBConnectionPool passes out connections. DBWorker's accept work (in the form of adding DBWork to it's list to process when a connection is received) --> These DBWorkers will request a connection from the pool, the pool then queues a connection for usage back to the DBW

Connection timeout supported ? MySQL ODBC 5.5

2010-01-04 Thread Tompkins Neil
Hi Can anyone confirm if there are any connection time out values I can specify in my application (ASP (VBScript) for the MySQL ODBC connection. Cheers Neil

Re: CONNECTION (SOCKET AND TCP/IP)

2009-10-27 Thread lists
Socket connections do not use tcp (meaning localhost) Remote hosts use tcpip Sent via BlackBerry from T-Mobile -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

CONNECTION (SOCKET AND TCP/IP)

2009-10-27 Thread Krishna Chandra Prajapati
Hi All, Any body can explain the difference between socket connection and tcp/ip connection. Thanks, Krishna

Re: Slot connection on a remote MySQL server - not name resolve problem!

2009-10-08 Thread Kim Delevati
ed my database to another machine, on a Windows Server 2008. > Problem is, the connection to that other server (which is on the same > network) is very slow, taking 4-6 seconds every time. That is impossible to > use on our applications. The ping from my machine to the server is around

Slot connection on a remote MySQL server - not name resolve problem!

2009-10-08 Thread Kim Delevati
Hi. I'm using MySQL on a Ubuntu Server 8.10, I was running as a MySQL server but switched my database to another machine, on a Windows Server 2008. Problem is, the connection to that other server (which is on the same network) is very slow, taking 4-6 seconds every time. That is impossible t

RE: mysql odbc connection problem

2009-10-06 Thread John Daisley
1 AM To: mysql@lists.mysql.com Subject: mysql odbc connection problem Hi All We are experiencing some problems when trying to connect to a mysql database using ODBC. The settings have been configured and it seems to be getting to the DB but we getting the following error: [S1T00][unixODBC][MySQL][ODBC

mysql odbc connection problem

2009-10-06 Thread Machiel Richards
Hi All We are experiencing some problems when trying to connect to a mysql database using ODBC. The settings have been configured and it seems to be getting to the DB but we getting the following error: [S1T00][unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'root'@'hostname' (using pas

Re: Lost connection to MySQL server during query

2009-09-09 Thread stutiredboy
the application program and mysql server are in the same host and i have add skip-name-resolv to the my.cnf and extend the max_allowed_packet from 16M to 32M our application connected to mysql server from mysql.sock before the query which cause "lost connection to MySQLserver.." w

Re: Lost connection to MySQL server during query

2009-09-09 Thread Claudio Nanni
Since it is very unlikely that you lose connection on the socket file, I guess you are using a PHP app, that uses the mysql driver and the problem must be in the driver. I would not look at mysql but at the PHP and PHP2MYSQL layer, mainly at the later one. Try different PHP (and driver) versions

Re: Lost connection to MySQL server during query

2009-09-09 Thread Claudio Nanni
Can you provide more details? network layout, type of client/app used, connectors,etc,etc? Thanks Claudio 2009/9/9 stutiredboy > hi,all: > > we met a problem that: > > * Lost connection to MySQL server during query > SHOW TABLE STATUS WHERE ENGINE='MyISAM'

Lost connection to MySQL server during query

2009-09-08 Thread stutiredboy
hi,all: we met a problem that: * Lost connection to MySQL server during query SHOW TABLE STATUS WHERE ENGINE='MyISAM' *sometimes it works well, sometimes not our mysql version is 5.0.84 our system is FreeBSD 6.2 thanks -- MySQL General Mailing List For list archives: http://lists

RES: [SPAM] RE: Remote connection

2009-08-05 Thread Hugo Leonardo Ferrer Rebello
connection 1.) remove bind-address= and skip-networking from my.cnf 2.) grant permission to the external 'user'@'host' 3.) remove any firewall rules blocking port 3306 4.) make sure no overrides on the mysqld commandline. See http://hashmysql.org/index.php?title=Remote_Clients

RE: Remote connection

2009-08-04 Thread Gavin Towey
systems.com.br] Sent: Tuesday, August 04, 2009 1:09 PM To: mysql@lists.mysql.com Subject: Remote connection Hello Guys, I have a big doubt. I'm trying to access the mysql database remotely, but I can't. I have changed the skip-networking option on my.cnf file however it doesn't w

Re: Remote connection

2009-08-04 Thread Carlos Proal
Are you sure that root has granted access to connect remotely ?? Carlos On 8/4/2009 3:09 PM, Hugo Leonardo Ferrer Rebello wrote: Hello Guys, I have a big doubt. I'm trying to access the mysql database remotely, but I can't. I have changed the skip-networking option on my.cnf fi

RE: Remote connection

2009-08-04 Thread Pablo A. Otero
, 04 de Agosto de 2009 05:09 p.m. Para: mysql@lists.mysql.com Asunto: Remote connection Hello Guys, I have a big doubt. I'm trying to access the mysql database remotely, but I can't. I have changed the skip-networking option on my.cnf file however it doesn't work.

Remote connection

2009-08-04 Thread Hugo Leonardo Ferrer Rebello
Hello Guys, I have a big doubt. I'm trying to access the mysql database remotely, but I can't. I have changed the skip-networking option on my.cnf file however it doesn't work. I have tried to include the bind_address = 0.0.0.0 but it still doesn't work. Sure I have commented the s

MySQL query working directly but not through .NET connection

2009-07-25 Thread John Meyer
Here's the query: INSERT INTO USERS(USER_ID,USER_NAME,USER_SCREENNAME,USER_DESCRIPTION,USER_FOLLOWERS,USER_IMAGE,USER_FRIENDS,USER_LOCATION,USER_CREATEDAT) VALUES('31264066','Justin Wienkers','BabyVegaz','I’m your secondhand news/yeah. That and an (aspiring) screenwriter, trained journalist,

Re: slow connection from localhost

2009-06-08 Thread Raymond Steigerwalt
with a mysql client to the mysqld (via socket or via > localhost). The connection takes 5 to 50 seconds, or it happens that the > connection is fast, but then the "use somethingdb;" needs 5 to 50 seconds. > > We have tried to use some advice from here already: > http://www.

slow connection from localhost

2009-06-08 Thread Jancsok Akos
hi, I need some urgent help. We have encountered a problem, when we try to connect in shell with a mysql client to the mysqld (via socket or via localhost). The connection takes 5 to 50 seconds, or it happens that the connection is fast, but then the "use somethingdb;" needs 5 to

Re: mysql error 2013 Lost connection to MySQL server during query

2009-06-02 Thread Per Jessen
Per Jessen wrote: > It happened agaIn this morning, but slightly different: > > [snip] > thd=0x7fe0140c7e00 > Attempting backtrace. You can use the following information to find > out where mysqld died. If you see no messages after this, something > went terribly wrong... > Cannot determine threa

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-27 Thread Per Jessen
: INSERT IGNORE INTO quarantine_archive SELECT * FROM quarantine WHERE state=1 AND domain='example.com' It's getting to be a bit annoying - not all our apps were written to be able to handle the database connection disappearing at any time. Yes, they should have been, but it is

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
Darryle Steplight wrote: > Hi Per, > > Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf > file. Are these queries appearing in your slow query logs?What is your > LOG_QUERY_TIMES set too? > > Here are some other settings you may want to play around wtih > CONNECT_TIMEOUT >

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Darryle Steplight
ation had choked > on getting "Error 2013 Lost connection to MySQL server during query". > The application is running remotely on 32bit using mysql library from > version 5.0.67. > > I've been googling quite a bit, but haven't really found anything of any > use.

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Michael Dykman
The issues that we saw only came to light under stress. The application I am referring to ran under a fair bit of load at the best of times but it was during sustained spikes that the flaws in our driver made themselves apparent. Mind you, we weren't using JFS, so I'm not sure how that would have

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
Michael Dykman wrote: > Given the new hardware, I'm now suspecting the RAID controller. I have > seen misconfigured RAIDs or bad RAID drivers take out a server in just > such a manner. I had a debian server connected to an EMC SAN.. As > debian isn't supported, we had this open-source driver whi

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Michael Dykman
Given the new hardware, I'm now suspecting the RAID controller. I have seen misconfigured RAIDs or bad RAID drivers take out a server in just such a manner. I had a debian server connected to an EMC SAN.. As debian isn't supported, we had this open-source driver which gave us no end of problems.

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
Per Jessen wrote: > Michael Dykman wrote: > >> Have you tried running the offending SQL manually against you new >> installation? Does it come back clean in the isolated case? > > No, not manually, but the job/the SQL is run several times a day, > maybe 2-3 times per hour. I've also just run t

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
Michael Dykman wrote: > Have you tried running the offending SQL manually against you new > installation? Does it come back clean in the isolated case? No, not manually, but the job/the SQL is run several times a day, maybe 2-3 times per hour. > Is there anything else which runs against this

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Michael Steinfeld
On Mon, May 25, 2009 at 11:19 AM, Per Jessen wrote: > Per Jessen wrote: > >> Michael Steinfeld wrote: >> >>> just a thought: Did you run "mysql_upgrade" after the import? >>> >> >> No, I didn't - I didn't think of it as I really only moved the data >> across. >> > I suspect that will solve your i

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Michael Dykman
Have you tried running the offending SQL manually against you new installation? Does it come back clean in the isolated case? Is there anything else which runs against this database at night? crons? Could you post the script that you are running to give some context to the statement which winds

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
Per Jessen wrote: > Michael Steinfeld wrote: > >> just a thought: Did you run "mysql_upgrade" after the import? >> > > No, I didn't - I didn't think of it as I really only moved the data > across. > Okay, have done a mysqlcheck --check-upgrade - came back all clean. I don't see a need to run

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
Michael Steinfeld wrote: > just a thought: Did you run "mysql_upgrade" after the import? > No, I didn't - I didn't think of it as I really only moved the data across. best regards Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Michael Steinfeld
just a thought: Did you run "mysql_upgrade" after the import? On Mon, May 25, 2009 at 10:19 AM, Per Jessen wrote: > Michael Dykman wrote: > >> It might be helpful if you could tell us how you affected your data >> migration > > Sorry, I'm not familiar with reporting problems in/on mysql. > > The

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
Michael Dykman wrote: It might be helpful if you could tell us how you affected your data migration Sorry, I'm not familiar with reporting problems in/on mysql. The data migration was done with a full database dump (mysqldump) from the 32bit system, then a reload on the new 64bit system. I

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
Per Jessen wrote: > This weekend we completed migrating a large(ish) mysql server from > 5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively > smoothly, until this morning when I noticed an application had choked > on getting "Error 2013 Lost connection to MySQL se

mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
This weekend we completed migrating a large(ish) mysql server from 5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively smoothly, until this morning when I noticed an application had choked on getting "Error 2013 Lost connection to MySQL server during query". The application

Re: expired mysql connection ?

2009-05-04 Thread Michael Dykman
a Perl program on a test run of about 4 hours and my database > connection expired/broke down. > Here is the error I got : > > DBI connect('project','root',...) failed: Can't connect to local MySQL > server through socket '/var/lib/mysql/mysql.sock'

expired mysql connection ?

2009-05-03 Thread Randomcoder
Hi, I run a Perl program on a test run of about 4 hours and my database connection expired/broke down. Here is the error I got : DBI connect('project','root',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

problem with ssl connection

2009-04-14 Thread Stefano Elmopi
Hi, Is there someone who is able to connect to an MySQL instance connection via ssl, from a client located on a different server than where is the MySQL instance, using the only option --ssl-ca ? I'm not able, I can only connect if I use the options --ssl-ca, --ssl- cert and --ss

Re: Newbie First Use Connection Question - Mac OSX 10.5.6

2009-02-19 Thread Curtis Maurand
Administrator & Query Browser (I come from a Visual Basic & MS SQL Server 2000/2005 environment) When you install MS SQL server the default login is "sa" with a blank password. My question is; How do I login (connection settings) to MySQL (for Administrator and Query Brows

Re: Newbie First Use Connection Question - Mac OSX 10.5.6

2009-02-19 Thread John Daisley
come from a Visual Basic & MS SQL Server 2000/2005 environment) > > When you install MS SQL server the default login is "sa" with a blank > password. > > My question is; > > How do I login (connection settings) to MySQL (for Administrator and > Query Brows

Newbie First Use Connection Question - Mac OSX 10.5.6

2009-02-19 Thread Jeff Murdock
from a Visual Basic & MS SQL Server 2000/2005 environment) When you install MS SQL server the default login is "sa" with a blank password. My question is; How do I login (connection settings) to MySQL (for Administrator and Query Browser tools)? (I start my server by goi

Re: Slow connection over VPN

2009-02-16 Thread Prathima Rao
it depends on the vpn router if u need more info let me know - Original Message - From: "Duncan, Kurt (MCUSA)" To: Sent: Tuesday, February 17, 2009 12:09 AM Subject: Slow connection over VPN We have an application using mysql. When we run it locally there are no issues.

Slow connection over VPN

2009-02-16 Thread Duncan, Kurt (MCUSA)
We have an application using mysql. When we run it locally there are no issues. If we try and connect to a remote database machine over VPN it works but takes a VERY long time to get anything done. We are using the exact same database. All other programs using the same VPN run fine and the spee

Re: MySQL v5.1 loses connection if too many updates in loop

2009-01-18 Thread Walter Heck
He's using Delphi according to his first post. You might wanna use a TClientDataSet if you're not doing so already. It provides a bit more flexibility and won't keep the select query open for longer than is necessary. Have fun! Walter OlinData: Professional services for MySQL Support * Consultin

Re: MySQL v5.1 loses connection if too many updates in loop

2009-01-18 Thread Dan
On Sun, 18 Jan 2009 16:26:58 -0600, mos wrote: > Walter, > I just re-ran the program this time using my old 5.0 my.ini file > (which worked fine with MySQL 5.0) with MySQL 5.1.30 and the same problem > occurs, the Next statement loses connection to the MySQL 5.1 serv

Re: MySQL v5.1 loses connection if too many updates in loop

2009-01-18 Thread mos
my.ini file (which worked fine with MySQL 5.0) with MySQL 5.1.30 and the same problem occurs, the Next statement loses connection to the MySQL 5.1 server after a while if there are a lot of updates in the loop. If the updates are moved outside of the loop, the program completes without a problem. So

Re: MySQL v5.1 loses connection if too many updates in loop

2009-01-18 Thread Walter Heck
thing about this is the loop will work fine for a few hundred > iterations then all of a sudden the Next statement is frozen and then loses > connection to the server. This fails every single time it is run. If I take > the updates out of the loop and process them later, it works fine. So there >

Re: MySQL v5.1 loses connection if too many updates in loop

2009-01-18 Thread mos
is frozen and then loses connection to the server. This fails every single time it is run. If I take the updates out of the loop and process them later, it works fine. So there is some sort of contention between traversing a table and updating a row of the table at the same time. There ar

Re: MySQL v5.1 loses connection if too many updates in loop

2009-01-18 Thread mos
s worked fine in v5.0.1. Since upgrading to v5.1.30 after a few > hundred rows have been updated, the Next statement will hang for 60 seconds > and then I get a "lost connection to mysql server" message. If I take the > updates out of the loop, it completes just fine. So why are a f

Re: MySQL v5.1 loses connection if too many updates in loop

2009-01-18 Thread Walter Heck
imple and has worked fine in v5.0.1. Since upgrading to v5.1.30 after a few >> hundred rows have been updated, the Next statement will hang for 60 seconds >> and then I get a "lost connection to mysql server" message. If I take the >> updates out of the loop, it completes just

Re: MySQL v5.1 loses connection if too many updates in loop

2009-01-18 Thread Baron Schwartz
grading to v5.1.30 after a few > hundred rows have been updated, the Next statement will hang for 60 seconds > and then I get a "lost connection to mysql server" message. If I take the > updates out of the loop, it completes just fine. So why are a few thousand > updates causing a

MySQL v5.1 loses connection if too many updates in loop

2009-01-17 Thread mos
for 60 seconds and then I get a "lost connection to mysql server" message. If I take the updates out of the loop, it completes just fine. So why are a few thousand updates causing a problem inside of a loop? The updates are updating 1 row at a time and does not alter any of the keys in

Re: < ? Solved ? > Re: mysqldump: Error 2013: Lost connection to MySQL server

2009-01-13 Thread Andrew Garner
On Tue, Jan 13, 2009 at 6:06 PM, Dan wrote: > On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner > wrote: > >> This sounds like you need to raise max_allowed_packet for mysqldump >> (and possibly mysqld) - these are separate settings for both the >> client and the server. You can do this via the

Re: < ? Solved ? > Re: mysqldump: Error 2013: Lost connection to MySQL server

2009-01-13 Thread Dan
On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner wrote: > This sounds like you need to raise max_allowed_packet for mysqldump > (and possibly mysqld) - these are separate settings for both the > client and the server. You can do this via the my.cnf (or ~/.my.cnf) > or specify it as an option on

Re: < ? Solved ? > Re: mysqldump: Error 2013: Lost connection to MySQL server

2009-01-13 Thread Andrew Garner
This sounds like you need to raise max_allowed_packet for mysqldump (and possibly mysqld) - these are separate settings for both the client and the server. You can do this via the my.cnf (or ~/.my.cnf) or specify it as an option on the command line "mysqldump --opt ... --max_allowed_packet=1G dbna

< ? Solved ? > Re: mysqldump: Error 2 013: Lost connection to MySQL server

2009-01-13 Thread Dan
On Tue, 2009-01-13 at 12:19 +0530, Chandru wrote: > Hi, > > Did u try using this command > > > mysqldump --opt db_name > db_name.sql -p 2>>bkp.err Not quite. Firstly, I had to alter the normal backup cron job, and that doesn't happen until late at night. Secondly, yes I added the redirecti

Re: mysqldump: Error 2013: Lost connection to MySQL server

2009-01-12 Thread Aaron Blew
Solaris 10 x64 (64bit MySQL as well). I wrote a script that starts a mysqldump process for each table within a database, which shouldn't be a problem since the host currently has around 12G unused memory. Midway through the dump I seem to lose the connection as Dan described. After attempti

Re: mysqldump: Error 2013: Lost connection to MySQL server

2009-01-12 Thread Dan
t; >> Hi all. I have a 30GB innodb-only database in mysql-5.0.54. I have >> always done nightly backups with: >> >> mysqldump --opt db_name > db_name.sql -p >> >> Recently this started failing with: >> Error 2013: Lost connection to MySQL server &g

Re: mysqldump: Error 2013: Lost connection to MySQL server

2009-01-12 Thread Chandru
n, Jan 12, 2009 at 9:07 AM, Daniel Kasak wrote: > Hi all. I have a 30GB innodb-only database in mysql-5.0.54. I have > always done nightly backups with: > > mysqldump --opt db_name > db_name.sql -p > > Recently this started failing with: > Error 2013: Lost connection to My

mysqldump: Error 2013: Lost connection to MySQL server

2009-01-12 Thread Daniel Kasak
Hi all. I have a 30GB innodb-only database in mysql-5.0.54. I have always done nightly backups with: mysqldump --opt db_name > db_name.sql -p Recently this started failing with: Error 2013: Lost connection to MySQL server I have checked all tables for corruption - nothing found. Also as far

Re: "lost connection to mysql server during query" errors

2008-10-30 Thread Moon's Father
e same database server- >> if you're doing, say, DNS round-robin or load balancing or something, >> maybe you're getting shunted to a different db server and it's killing >> the connection... don't know what your setup is. Another long shot in >> a multi

Re: "lost connection to mysql server during query" errors

2008-10-29 Thread mos
a different db server and it's killing the connection... don't know what your setup is. Another long shot in a multi-db-server config would be to make sure they all have different server ID's. Good luck... hopefully someone else has better advice :) Jake Just a guess, but maybe it&#x

Re: "lost connection to mysql server during query" errors

2008-10-29 Thread Jake Maul
cts: recent versions, persistent vs. non-persistent connections, etc. A long shot would be to make sure your always talking to the same database server- if you're doing, say, DNS round-robin or load balancing or something, maybe you're getting shunted to a different db server and it's killin

"lost connection to mysql server during query" errors

2008-10-29 Thread Waynn Lue
We've started seeing mysql errors in the logs, and when i look at the output of mysql_error() (in php), i get "lost connection to mysql server during query". Here's an example stack trace: 'Can't connect to database [Lost connection to MySQL server during query]&#

SSL Connection and emty SSL_CIPHER

2008-08-31 Thread Jonas Meurer
nas'@'' (using password: YES) $ mysql -u jonas -p --host= --ssl-ca=ca.crt --ssl-key=mysql-client.key --ssl-cert=mysql-client.crt Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 389 Server version: 5.0.51a-12-log (Debian) Type

Re: Lost connection

2008-08-26 Thread Moon's Father
Only increase max_allowed_packet is ok. On Tue, Aug 19, 2008 at 5:49 PM, Warren Young <[EMAIL PROTECTED]> wrote: > Mad Unix wrote: > >> >> During the update of the MySQL DB (delete/insert), I keep getting the >> following message >> Lost connection to My

Re: Connection failed!!

2008-08-25 Thread Micah Stevens
ch is: Connection failed: 1045 - Access denied for user 'root'@'localhost' (using password: NO) My Old pc has exactly the same settings but that uses MySQL 4 I have done a system restore to the point before I installed MySQL 5, and then installed MySQL 4 and that went on with no p

Re: Connection Failed!!

2008-08-25 Thread EvLSnoopY
Have you tried setting the password with mysql admin? Example: mysqladmin -u Root yourpassword 'yournewpassword' - Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Connection failed!!

2008-08-25 Thread Matthew Stuart
I have just loaded MySQL 5 and MySQL Front on to a new computer, and I am now getting a MySQL-Error which is: Connection failed: 1045 - Access denied for user 'root'@'localhost' (using password: NO) My Old pc has exactly the same settings but that uses MySQL 4 I have done

Language - MySQL connection collation

2008-08-23 Thread Nanu Kalmanovitz
Hi! I just upgraded from 4.0.26 to 4.1.22. On phpMyAdmin with the older (4.0.26) was only one field for "Language" and it was set to "Hebrew (he-iso-8859-i)". Now, upgrading (4.1.22) in the "Language" field appears "Hebrew (he-utf-8)" and a new fiel

Re: Lost connection

2008-08-19 Thread Warren Young
Mad Unix wrote: During the update of the MySQL DB (delete/insert), I keep getting the following message Lost connection to MySQL server during query... By default, the MySQL server drops a connection after 8 hours of receiving no queries on that connection. This can happen in an

Lost connection

2008-08-19 Thread Mad Unix
Hi all During the update of the MySQL DB (delete/insert), I keep getting the following message Lost connection to MySQL server during query... Any thoughts about this issue, could it be a network, code or tunning problem ... Thanks

How to set the separate connection timeout for a single user?

2008-06-29 Thread Moon's Father
For example,the user is [EMAIL PROTECTED] I want to adjust timeout value for him ,which is different from the global parameter named interactive_timeout or wait_timeout? -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn

Mysql Connection/NET and Visual Basic.NET 2008

2008-06-25 Thread John Meyer
I'm trying to start a connection to a mysql database, but even though I've installed the connector I don't see where the option to choose that data type of connection exists. I'm using Connection/NET v 5.1, btw -- MySQL General Mailing List For list archives: http://list

Re: connectors: per session persistent connection (PHP)

2008-05-13 Thread Paul DuBois
On May 9, 2008, at 12:17 AM, Sebastian Mendel wrote: Paul DuBois schrieb: On May 7, 2008, at 4:36 AM, Sebastian Mendel wrote: Hi, wouldn't it be very helpful if mysql connectors support some sort of per session persistent connection? this would save a lot of queries in many apps

Re: connectors: per session persistent connection (PHP)

2008-05-08 Thread Sebastian Mendel
Paul DuBois schrieb: On May 7, 2008, at 4:36 AM, Sebastian Mendel wrote: Hi, wouldn't it be very helpful if mysql connectors support some sort of per session persistent connection? this would save a lot of queries in many apps, for example SET NAMES, setting variables, creating temp

Re: connectors: per session persistent connection (PHP)

2008-05-08 Thread Paul DuBois
On May 7, 2008, at 4:36 AM, Sebastian Mendel wrote: Hi, wouldn't it be very helpful if mysql connectors support some sort of per session persistent connection? this would save a lot of queries in many apps, for example SET NAMES, setting variables, creating temporary tables How

Re: connectors: per session persistent connection (PHP)

2008-05-07 Thread Michael Dykman
t; wouldn't it be very helpful if mysql connectors support some sort of > per > > > session persistent connection? > > > > > > this would save a lot of queries in many apps, for example SET NAMES, > > > setting variables, creating temporary tables > &g

Re: connectors: per session persistent connection (PHP)

2008-05-07 Thread Sebastian Mendel
wouldn't it be very helpful if mysql connectors support some sort of per session persistent connection? this would save a lot of queries in many apps, for example SET NAMES, setting variables, creating temporary tables or are there any other methods i am not aware of to achieve this?

Re: connectors: per session persistent connection (PHP)

2008-05-07 Thread Michael Dykman
This is a little off-topic for this list (recent PHP tutorials nowithstanding)... replying offline On Wed, May 7, 2008 at 5:36 AM, Sebastian Mendel <[EMAIL PROTECTED]> wrote: > Hi, > > wouldn't it be very helpful if mysql connectors support some sort of per > sessio

connectors: per session persistent connection (PHP)

2008-05-07 Thread Sebastian Mendel
Hi, wouldn't it be very helpful if mysql connectors support some sort of per session persistent connection? this would save a lot of queries in many apps, for example SET NAMES, setting variables, creating temporary tables or are there any other methods i am not aware of to achieve

mysql-proxy losting connection

2008-04-29 Thread Tiago Cruz
0.11:3306 --proxy-backend-addresses=10.25.0.12:3306 --proxy-lua-script=lib/rw-splitting.lua Works as well for a while, but after stops with this error: ===== General Error SQL ERROR [ mysqli ] Lost connection to My

RE: Problem with character set and connection collation

2008-04-28 Thread Jerry Schwartz
-infoshop.com www.giiexpress.com www.etudes-marche.com >-Original Message- >From: Tim McDaniel [mailto:[EMAIL PROTECTED] >Sent: Monday, April 28, 2008 12:19 PM >Cc: mysql@lists.mysql.com >Subject: RE: Problem with character set and connection collation > >On Mon, 28 Apr 2008, Jerry

RE: Problem with character set and connection collation

2008-04-28 Thread Tim McDaniel
On Mon, 28 Apr 2008, Jerry Schwartz <[EMAIL PROTECTED]> wrote: A week or so ago I explored this in depth because I was having the same problems. (It was affecting an English file that had some Windows (CP-1252) characters that didn't directly map to UTF-8. That message is at http://lists.mysql.co

RE: Problem with character set and connection collation

2008-04-28 Thread Jerry Schwartz
nt: Sunday, April 27, 2008 6:01 AM >To: mysql@lists.mysql.com >Subject: Problem with character set and connection collation > >Hello all, >here is my problem: > >I am trying to set mysql to unicode character, so that i can get my >dictionary application to look at words in Ne

Re: Problem with character set and connection collation

2008-04-28 Thread Leandro Chapuis
I am trying to set mysql to unicode character, so that i can get my dictionary application to look at words in Nepali. here is my setting: mysql charset: utf-8 unicode when i make a new database: mysql connection collation is utf8-general-ci and my new database collation is also utf-general-ci

Problem with character set and connection collation

2008-04-27 Thread sulochan acharya
Hello all, here is my problem: I am trying to set mysql to unicode character, so that i can get my dictionary application to look at words in Nepali. here is my setting: mysql charset: utf-8 unicode when i make a new database: mysql connection collation is utf8-general-ci and my new database

RE: Php-mssql connection problems on Windows XP

2008-04-24 Thread Jerry Schwartz
>-Original Message- >From: Jerry Schwartz [mailto:[EMAIL PROTECTED] >Sent: Thursday, April 24, 2008 10:01 AM >To: 'Padiyath Sreekumaran'; mysql@lists.mysql.com >Subject: RE: Php-mssql connection problems on Windows XP > >When using odbc_connect, you don&

RE: Php-mssql connection problems on Windows XP

2008-04-24 Thread Jerry Schwartz
When using odbc_connect, you don't use the DSN you've previously created. You use the complete definition of the connection. Here's an example of connecting to an MS Access database: define('ODBC_CONNECT', 'DRIVER={Microsoft Access D

<    1   2   3   4   5   6   7   8   9   10   >