Re: Last established connection timestamp by a specific user

h is currently running on version > `5.7.11-enterprise-commercial-advanced-log`. On this instance I am > trying to figure out the most recent timestamp at which a specific user has > established a connection to this instance (or) performed any DML operations > which might have changed

Last established connection timestamp by a specific user

Hi, We have a MySQL instance which is currently running on version `5.7.11-enterprise-commercial-advanced-log`. On this instance I am trying to figure out the most recent timestamp at which a specific user has established a connection to this instance (or) performed any DML operations

Re: Lost Connection Upon Loading Dump

95610 characters long. The error is: ERROR 2013 (HY000) at line 1763: Lost connection to MySQL server during query About 40 tables are restored correctly from the dump prior to it failing at this line. Based on advice from posts I've found on the internet, I've added the follow set

Lost Connection Upon Loading Dump

line 1763: Lost connection to MySQL server during query About 40 tables are restored correctly from the dump prior to it failing at this line. Based on advice from posts I've found on the internet, I've added the follow settings to my.cnf net_read_timeout=60 # 16 MB max_allowed_pac

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

e the same > machine? > > I left this out, that it only then happens when the client has been idle, > and right afterwards the client repeats the request and all goes well. The > message is no more than an irritatind break between request and fulfillment. > > Hello, That happe

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2014/01/06 17:07 +0100, Reindl Harald what about look in the servers logfiles most likely "max_allowed_packet" laughable low Is this then, too, likly when the server and the client are the same machine? I left this out, that it only then happens when the client has been idle, a

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

Am 06.01.2014 15:36, schrieb h...@tbbs.net: > Now that I installed 5.6.14 on our Vista machine, when using "mysql" I often > see that error-message, which under 5.5.8 I never saw. What is going on? what about look in the servers logfiles most likely "max_allowed_packet" laughable low signatu

ERROR 2013 (HY000): Lost connection to MySQL server during query

Now that I installed 5.6.14 on our Vista machine, when using "mysql" I often see that error-message, which under 5.5.8 I never saw. What is going on? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Lost connection to MySQL server - need help.

milar - based > on your followups it probably isnt, but will just toss this out there > anyhows. We were experiencing connection timeouts when load would ramp up. > Doing some digging we learned that our firewall between the servers > bandwidth would get consumed by a large wordpress loa

Re: Lost connection to MySQL server - need help.

We had a similar issue a bit back - and although it sounds similar - based on your followups it probably isnt, but will just toss this out there anyhows. We were experiencing connection timeouts when load would ramp up. Doing some digging we learned that our firewall between the servers

Re: Lost connection to MySQL server - need help.

Am 12.10.2013 19:45, schrieb Jørn Dahl-Stamnes: > On Saturday 12 October 2013 17:36, Reindl Harald wrote: >> so someone did "optimize table" on a large table >> you do yourself not a favour restarting the server in such a moment > > 7 hours before the server was shut down, we did a alter table t

Re: Lost connection to MySQL server - need help.

On Saturday 12 October 2013 17:36, Reindl Harald wrote: > so someone did "optimize table" on a large table > you do yourself not a favour restarting the server in such a moment 7 hours before the server was shut down, we did a alter table to add a primary key to a table that is read-only from the

Re: Lost connection to MySQL server - need help.

Am 12.10.2013 17:02, schrieb Jørn Dahl-Stamnes: > On Saturday 12 October 2013 13:07, Andrew Moore wrote: >> Could be a crash related to innodb data dictionary being out of sync. Could >> be a bug. > > Seems like a bug yes. However, we had a strange situation yesterday when we > had several proc

Re: Lost connection to MySQL server - need help.

On Saturday 12 October 2013 13:07, Andrew Moore wrote: > Could be a crash related to innodb data dictionary being out of sync. Could > be a bug. Seems like a bug yes. However, we had a strange situation yesterday when we had several processes in the state "copying to tmp table" (if i remember the

Re: Lost connection to MySQL server - need help.

mysqld: /lib/libc.so.6(clone+0x6d) [0x7f7ede00992d] > Oct 12 11:53:33 cebycny mysqld: > Oct 12 11:53:33 cebycny mysqld: Trying to get some variables. > Oct 12 11:53:33 cebycny mysqld: Some pointers may be invalid and cause the > dump to abort. > Oct 12 11:53:33 cebycny mysqld: Query (7f

Re: Lost connection to MySQL server - need help.

bycny mysqld: Trying to get some variables. Oct 12 11:53:33 cebycny mysqld: Some pointers may be invalid and cause the dump to abort. Oct 12 11:53:33 cebycny mysqld: Query (7f7f1c0dcbc0): SHOW CREATE TABLE `calculation` Oct 12 11:53:33 cebycny mysqld: Connection ID (thread ID): 92 Oct 12 11:53:33

Re: Lost connection to MySQL server - need help.

several batch scripts using the database in addition to a web application using it. The php scripts running in batch mode began to get: mysql_connect(): Lost connection to MySQL server at 'reading initial communication packet', system error: 111 I stopped the server and restarted it and

Lost connection to MySQL server - need help.

(): Lost connection to MySQL server at 'reading initial communication packet', system error: 111 I stopped the server and restarted it and everything seems to work OK for hours but when the load start to increase, the errors begin to appear again. Today I noticed that after I starte phpM

Re: connection issue

Hi, # mysql -P 5045 Add -h127.0.0.1 # mysql -P5045 -h127.0.0.1 Cheers -- Claudio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

connection issue

This mysql newbie is having trouble connecting to a mysqld instance, hoping someone can offer a clue on troubleshooting. I have 2 mysql 5.0.45 installations on one RHEL server. One live mysqld is setup in what appears to be a relatively standard installation, port 3306, user 'mysql', etc.

Re: How to change max simultaneous connection parameter in mysql.

esday, April 02, 2013 8:29 AM >> To: mysql@lists.mysql.com >> Subject: Re: How to change max simultaneous connection parameter in >> mysql. >> >> >> >> Am 02.04.2013 16:09, schrieb spameden: >>> 2013/3/24 Reindl Harald >> <mailto

Re: How to change max simultaneous connection parameter in mysql.

> > Sent: Tuesday, April 02, 2013 2:00 PM > > To: mysql@lists.mysql.com > > Subject: Re: How to change max simultaneous connection parameter in > > mysql. > > > > > > > > Am 02.04.2013 22:56, schrieb Rick James: > > > I hear that nginx is very fa

RE: How to change max simultaneous connection parameter in mysql.

e- > From: spameden [mailto:spame...@gmail.com] > Sent: Tuesday, April 02, 2013 7:10 AM > To: Reindl Harald > Cc: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > 2013/3/24 Reindl Harald > > > > > > &

RE: How to change max simultaneous connection parameter in mysql.

ld [mailto:h.rei...@thelounge.net] > Sent: Tuesday, April 02, 2013 2:00 PM > To: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > > > Am 02.04.2013 22:56, schrieb Rick James: > > I hear that nginx is very fas

Re: How to change max simultaneous connection parameter in mysql.

tell me something new >> -Original Message- >> From: Reindl Harald [mailto:h.rei...@thelounge.net] >> Sent: Tuesday, April 02, 2013 2:00 PM >> To: mysql@lists.mysql.com >> Subject: Re: How to change max simultaneous connection parameter in >> mysql. >

RE: How to change max simultaneous connection parameter in mysql.

ei...@thelounge.net] > Sent: Tuesday, April 02, 2013 8:29 AM > To: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > > > Am 02.04.2013 16:09, schrieb spameden: > > 2013/3/24 Reindl Harald > <mailto:h

Re: How to change max simultaneous connection parameter in mysql.

il.com] >> Sent: Tuesday, April 02, 2013 7:10 AM >> To: Reindl Harald >> Cc: mysql@lists.mysql.com >> Subject: Re: How to change max simultaneous connection parameter in >> mysql. >> >> 2013/3/24 Reindl Harald >> >>> >>> >>>

Re: How to change max simultaneous connection parameter in mysql.

Am 02.04.2013 16:09, schrieb spameden: > 2013/3/24 Reindl Harald > > > Am 24.03.2013 05:20, schrieb spameden: > > 2013/3/19 Rick James >: > >>> you never have hosted a large site > >> Check my email address before sayin

Re: How to change max simultaneous connection parameter in mysql.

2013/3/24 Reindl Harald > > > Am 24.03.2013 05:20, schrieb spameden: > > 2013/3/19 Rick James : > >>> you never have hosted a large site > >> Check my email address before saying that. > > > > :D > > as said, big company does not have only geniusses > I do not judge only on 1 parameter, Rick has

Re: How to change max simultaneous connection parameter in mysql.

2013/3/24 Reindl Harald > > > Am 24.03.2013 05:20, schrieb spameden: > > 2013/3/19 Rick James : > >>> you never have hosted a large site > >> Check my email address before saying that. > > > > :D > > as said, big company does not have only geniusses > > >> 20 may be low, but 100 is rather high. >

Re: How to change max simultaneous connection parameter in mysql.

Am 24.03.2013 05:20, schrieb spameden: > 2013/3/19 Rick James : >>> you never have hosted a large site >> Check my email address before saying that. > > :D as said, big company does not have only geniusses >> 20 may be low, but 100 is rather high. > Never use apache2 it has so many problems un

Re: How to change max simultaneous connection parameter in mysql.

e if well tuned. > >> -Original Message- >> From: Reindl Harald [mailto:h.rei...@thelounge.net] >> Sent: Monday, March 18, 2013 1:36 PM >> To: mysql@lists.mysql.com >> Subject: Re: How to change max simultaneous connection parameter in >> mysql. >>

Re: How to change max simultaneous connection parameter in mysql.

mory and CPU so please get rid of your i386 and stop to explain me the world >> -Original Message- >> From: Reindl Harald [mailto:h.rei...@thelounge.net] >> Sent: Monday, March 18, 2013 1:36 PM >> To: mysql@lists.mysql.com >> Subject: Re: How to change max sim

RE: How to change max simultaneous connection parameter in mysql.

ubject: Re: How to change max simultaneous connection parameter in > mysql. > > > > Am 18.03.2013 21:01, schrieb Rick James: > > 20 is plenty if your pages run fast enough > > it is not > you never have hosted a large site > > > Excess clients after MaxClients

RE: How to change max simultaneous connection parameter in mysql.

6, 2013 1:45 AM > To: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > Hi Kevin, > In your MySQL client pls execute: > SET GLOBAL max_connections = 200; > To Make the change permanent you can edit /etc/my.cnf or whatev

Re: How to change max simultaneous connection parameter in mysql.

On Mon, 2013-03-18 at 21:35 +0100, Reindl Harald wrote: > > Am 18.03.2013 21:01, schrieb Rick James: > > 20 is plenty if your pages run fast enough > > if your server can not serve more than 20 simultaionous > requests you are not doing any serious things > or he's using a 286 signatu

Re: How to change max simultaneous connection parameter in mysql.

o:h.rei...@thelounge.net] >> Sent: Monday, March 18, 2013 12:15 PM >> To: mysql@lists.mysql.com >> Subject: Re: How to change max simultaneous connection parameter in >> mysql. >> >> >> >> Am 18.03.2013 19:26, schrieb Rick James: >>> If you are r

RE: How to change max simultaneous connection parameter in mysql.

error. > -Original Message- > From: Reindl Harald [mailto:h.rei...@thelounge.net] > Sent: Monday, March 18, 2013 12:15 PM > To: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > > > Am 18.03.2013 19:26,

Re: How to change max simultaneous connection parameter in mysql.

Am 18.03.2013 19:26, schrieb Rick James: > If you are running Apache with MaxClients set too high, that can cause the > problem. "too high" is relative > That Apache setting should be something like 20. (Other web servers have > similar settings.) 20 is a laughable value as long you are n

Re: How to change max simultaneous connection parameter in mysql.

make sure it looks like: max_connections = 200 No MySQL restart required Cheers, Igor On 16/03/13 07:39, Manuel Arostegui wrote: 2013/3/16 Kevin Peterson I am using PHP along with mysql. Mysql default configuration allows to have 100 simultaneous connection which I want to chane to 200. P

Re: How to change max simultaneous connection parameter in mysql.

2013/3/16 Kevin Peterson > I am using PHP along with mysql. Mysql default configuration allows to > have 100 simultaneous connection which I want to chane to 200. Please help. > If you're reaching too many connections quite often, this change can imply memory problems in your

Re: connection issue

gt; > 2012/12/22 Doug : >> Hello, >> >> When connecting to mysql, sometime I got this error: >> >> # mysql -ucdn -h113.108.22x.xx -p >> Enter password: >> ERROR 2013 (HY000): Lost connection to MySQL server at 'reading >> initial communication pa

Re: connection issue

; ERROR 2013 (HY000): Lost connection to MySQL server at 'reading > initial communication packet', system error: 0 > > > But most time it's correct. > What's the reason? Thanks. > > I am running mysql-5.1.37 on Linux, there is no firewall configured on t

connection issue

Hello, When connecting to mysql, sometime I got this error: # mysql -ucdn -h113.108.22x.xx -p Enter password: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 But most time it's correct. What's the reason? T

Re: MySQL Connection Information

On Tue, November 13, 2012 22:38, Prabhat Kumar wrote: > No, If you are using non-persistence connection & once the query get > complete you are closing the connection properly. > Is this true if you are using mod_php or equivalent? > > On Wed, Nov 14, 2012 at 11:44 AM, Trimur

Re: MySQL Connection Information

No, If you are using non-persistence connection & once the query get complete you are closing the connection properly. On Wed, Nov 14, 2012 at 11:44 AM, Trimurthy wrote: > hi every one, i am working with some application which is > developed in php and back end is

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

Error Code: 1. Can't create/write to > file > Fred> "C:\test123.csv"(Errocde: 2). > > This probably means that you don't have write access to C:\ > > > Fred> I tried running the query outputting to a different named .csv file, > but it > Fred> i

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

different named .csv file, but it Fred> is still just "running..." and seems like it was like yesterday where after Fred> 10 minutes I will get the Error that the MySQL connection was lost. The reason that your connection is lost are ether: - There is timeout in the client you are

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

Thanks! On Thu, Jul 26, 2012 at 12:05 AM, wrote: > 2012/07/26 06:52 +0530, Dhaval Jaiswal > SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ',' > ENCLOSED BY '"' LINES TERMINATED BY '\n' > > as above give your join condition before INTO OUTFILE. > > Right

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

2012/07/26 06:52 +0530, Dhaval Jaiswal SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' as above give your join condition before INTO OUTFILE. Right: MySQL server writes into some directory where it is, not where

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

: Error Code: 1. Can't create/write to file "C:\test123.csv"(Errocde: 2). I tried running the query outputting to a different named .csv file, but it is still just "running..." and seems like it was like yesterday where after 10 minutes I will get the Error that the MyS

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

mp_id; > > The query without exporting the file works fine, in about 12 sec/77 sec. I > read online how to export MySQL queries into csv's, and I'm not sure what I > am doing wrong. I keep getting the error: > Error Code: 2013. Lost connection to MySQL server during query,

Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

ery without exporting the file works fine, in about 12 sec/77 sec. I read online how to export MySQL queries into csv's, and I'm not sure what I am doing wrong. I keep getting the error: Error Code: 2013. Lost connection to MySQL server during query, where the duration/fetch values

Re: [Warning] Aborted connection...... (Got timeout reading communication packets)

fi.ah...@sifycorp.com] > Sent: Monday, May 21, 2012 2:04 PM > To: 'Suresh Kuna' > Cc: 'mysql@lists.mysql.com'; 'shafi...@gmail.com' > Subject: RE: [Warning] Aborted connection.. (Got timeout reading > communication packets) > > Hi suresh: I have g

RE: [Warning] Aborted connection...... (Got timeout reading communication packets)

t Rgs, Shafi AHMED Sify - Chennai -Original Message- From: Shafi AHMED [mailto:shafi.ah...@sifycorp.com] Sent: Monday, May 21, 2012 2:04 PM To: 'Suresh Kuna' Cc: 'mysql@lists.mysql.com'; 'shafi...@gmail.com' Subject: RE: [Warning] Aborted co

RE: [Warning] Aborted connection...... (Got timeout reading communication packets)

t Rgs, Shafi AHMED Sify - Chennai -Original Message- From: Suresh Kuna [mailto:sureshkumar...@gmail.com] Sent: Monday, May 21, 2012 1:29 PM To: Shafi AHMED Cc: mysql@lists.mysql.com; shafi...@gmail.com Subject: Re: [Warning] Aborted connection.. (Got timeout reading communic

Re: [Warning] Aborted connection...... (Got timeout reading communication packets)

Hello Shafi, The below blog will give you more information on the error - http://sureshkuna.blogspot.in/2010/12/aborted-connection-31084472-to-db-ms.html Thanks Suresh Kuna On Mon, May 21, 2012 at 1:15 PM, Shafi AHMED wrote: > Ladies and Gentlemen: > > I am getting below errors and

[Warning] Aborted connection...... (Got timeout reading communication packets)

Ladies and Gentlemen: I am getting below errors and therefore the user sessions terminate causing business impact...Can some one who is expertise already in this advice at the earliest? 120513 8:19:45 [Warning] Aborted connection 1167257 to db: 'iib' user: 'iibuser' host

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

If you did not work directly on mysql server (login by mysql command), please try this. Using script (PHP, ...) may lose connection, as my experience. Best --- On Mon, 3/5/12, Singer X.J. Wang wrote: > From: Singer X.J. Wang > Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

egards, > Javad Bakhshi, > > > > From: "mail...@securitylabs.it" > To: mysql@lists.mysql.com > Sent: Thursday, March 1, 2012 11:09 AM > Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during > query > > Il 01/03/2012 11:03, javad bakhshi ha sc

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

, 2012 11:09 AM Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during query Il 01/03/2012 11:03, javad bakhshi ha scritto: > Hi, > > I am trying to load data into my table from a very large file but after some > time I get this error: > > ERROR 2013 (HY000)

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

Il 01/03/2012 11:03, javad bakhshi ha scritto: Hi, I am trying to load data into my table from a very large file but after some time I get this error: ERROR 2013 (HY000): Lost connection to MySQL server during query My file size is around 4G and I have 220M lines in my file which have to be

ERROR 2013 (HY000): Lost connection to MySQL server during query

Hi, I am trying to load data into my table from a very large file but after some time I get this error: ERROR 2013 (HY000): Lost connection to MySQL server during query My file size is around 4G and I have 220M lines in my file which have to be loaded in to my table.  I have 10 of these

Re: Aborted connection 102

Hi Michael, Thanks :D. 2011/12/14 Michael Dykman > 102 is just the run-time assigned connection id. It appears that the > server bailed on a client connection due to a timeout. This suggests > that either you have/had network issues, an error on the client side > or someone j

Re: Aborted connection 102

102 is just the run-time assigned connection id. It appears that the server bailed on a client connection due to a timeout. This suggests that either you have/had network issues, an error on the client side or someone just killed a client connection without closing properly. Unless you are

Aborted connection 102

Hi everybody, I have this notice , 111214 11:55:53 [Warning] Aborted connection 102 to db: 'proninop_proninop' user: 'pronino' host: 'xxx.xxx.xxx.xxx' (Got timeout reading communication packets) I have watched in this site http://dev.mysql.com/doc/refman/5.0/en/commun

Re: Update table on lost connection

ocked, preventing > multiple logins for the same user code. > > I want to simulate this via a "locked" column in a mysql table, but would > need the field to be cleared if the server loses the connection to the > client. How would I do this, or is there an alternative? >

Update table on lost connection

the field to be cleared if the server loses the connection to the client. How would I do this, or is there an alternative? Thanks, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Practical connection limits MySQL 5.1/5.5

，Reindl Harald 写道： > Am 14.04.2011 11:50, schrieb Johan De Meersman: >> - Original Message - >>> From: "Reindl Harald" >>> >>> even if you have enough memory why will you throw it away for a >>> unusual connection count instead u

Re: Practical connection limits MySQL 5.1/5.5

Am 14.04.2011 11:50, schrieb Johan De Meersman: > - Original Message - >> From: "Reindl Harald" >> >> even if you have enough memory why will you throw it away for a >> unusual connection count instead use the RAm for innodb-buffer-pool, >&g

Re: Practical connection limits MySQL 5.1/5.5

- Original Message - > From: "Reindl Harald" > > even if you have enough memory why will you throw it away for a > unusual connection count instead use the RAm for innodb-buffer-pool, > query-cache, key-buffers? Maybe the application doesn't have support fo

RE: Practical connection limits MySQL 5.1/5.5

net > To: mysql@lists.mysql.com > Subject: Re: Practical connection limits MySQL 5.1/5.5 > > > Am 13.04.2011 23:50, schrieb Jeff Lee: > > Hey All, > > > > Can anyone provide some guidance as to what the practical connection limits > > to MySQL 5.1/5.5 are

Re: Practical connection limits MySQL 5.1/5.5

Am 13.04.2011 23:50, schrieb Jeff Lee: > Hey All, > > Can anyone provide some guidance as to what the practical connection limits > to MySQL 5.1/5.5 are under linux? > > We're running a ruby on rails application that establishes 50 to 100 > connections to our database

Practical connection limits MySQL 5.1/5.5

Hey All, Can anyone provide some guidance as to what the practical connection limits to MySQL 5.1/5.5 are under linux? We're running a ruby on rails application that establishes 50 to 100 connections to our database upon startup resulting in around 1,000 persistent db connections. I&#x

Re: Negative connection/thread IDs in mysqld.log?

> Hi, I tried searching for an answer to this to no avail. I noticed my > mysqld.log contains negative connection/thread IDs. mysqld itself shows > positive IDs as expected. Some sort of wrap? > > /usr/sbin/mysqld, Version: 5.0.32. started with: > Tcp port: 3306 Unix socket: /tmp

Negative connection/thread IDs in mysqld.log?

Hi, I tried searching for an answer to this to no avail. I noticed my mysqld.log contains negative connection/thread IDs. mysqld itself shows positive IDs as expected. Some sort of wrap? /usr/sbin/mysqld, Version: 5.0.32. started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time

RE: localhost vs domain for connection string

>-Original Message- >From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De >Meersman >Sent: Thursday, November 25, 2010 3:29 AM >To: Jerry Schwartz >Cc: Brent Clark; mysql mailing list >Subject: Re: localhost vs domain for connection string > &g

Re: localhost vs domain for connection string

On Wed, Nov 24, 2010 at 4:44 PM, Jerry Schwartz wrote: > [JS] This might or might not be enabled by default. I'm running on Windows, > and I seem to remember having to change it. > > # Enable named pipe, bypassing the network stack > enable-named-pipe > Windows' named pipes are not the same as u

RE: localhost vs domain for connection string

>-Original Message- >From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De >Meersman >Sent: Wednesday, November 24, 2010 2:39 AM >To: Jerry Schwartz >Cc: Brent Clark; mysql mailing list >Subject: Re: localhost vs domain for connection string >

Re: localhost vs domain for connection string

On Tue, Nov 23, 2010 at 7:55 PM, Jerry Schwartz wrote: > >IIRC, "localhost" is seen by the client as a magic word to mean "use the > >UNIX socket, not 127.0.0.1". > > > [JS] IF it is enabled in my.cnf. > Hmm, didn't know that bit. What's the option called ? -- Bier met grenadyn Is als mosterd

RE: localhost vs domain for connection string

>-Original Message- >From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De >Meersman >Sent: Tuesday, November 23, 2010 6:19 AM >To: Brent Clark >Cc: mysql mailing list >Subject: Re: localhost vs domain for connection string > >IIRC, "loc

Re: localhost vs domain for connection string

> From: Brent Clark > > Is there a difference if someone had to make the connection string the a > domain (hosts file entry makes the machine look at its ip) as opposed to just > using localhost. > If so would a performance hit be incurred? Using 'localhost' wil

Re: localhost vs domain for connection string

IIRC, "localhost" is seen by the client as a magic word to mean "use the UNIX socket, not 127.0.0.1". So, yes, that would make the connection not show up in netstat :-) On Tue, Nov 23, 2010 at 11:11 AM, Brent Clark wrote: > Hiya > > Is there a difference if someo

localhost vs domain for connection string

Hiya Is there a difference if someone had to make the connection string the a domain (hosts file entry makes the machine look at its ip) as opposed to just using localhost. If so would a performance hit be incurred? I have this client that has used the domain and in netstat im seeing all

Re: Persistent Connection VS One Time Connection Was Update Table

I have checked Apache's log. There is no refused connection. And also with MySQL I have set it to 999 connections and view the processes. Maximum connection ever reached was only around 200. What I'm thinking now is. Is it because of I use one time connection method? I mean ever

Re: cant establish connection at application side.

On 02/09/2010 6:01 p, karthik kumar wrote: Wow .. Cool that solved our problem... Thanks a lott .. No problem, it took me two weeks to figure out why it takes sooo long to log in; :-) enjoy! -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gm

Re: cant establish connection at application side.

Wow .. Cool that solved our problem... Thanks a lott .. On Thu, Sep 2, 2010 at 9:20 PM, Jangita wrote: > On 02/09/2010 4:57 p, karthik kumar wrote: > >> Hi .. I am facing a problem in mysql. >> >> I am getting error 'Can not open connection' at the

Re: cant establish connection at application side.

different port if it's first choice is in use). Good luck. -Leslie On Thu, Sep 2, 2010 at 8:29 AM, karthik kumar wrote: > I am running a tool which just makes connection and closes it (using > JDBC) > .. The JDBC connection never says 'Can not establish connection' .. I jus

Re: cant establish connection at application side.

On 02/09/2010 4:57 p, karthik kumar wrote: Hi .. I am facing a problem in mysql. I am getting error 'Can not open connection' at the application side which happens at random timings. What i found was at whenever the problem occurs it takes 70 secs for connecting to my

Re: cant establish connection at application side.

I am running a tool which just makes connection and closes it (using JDBC) .. The JDBC connection never says 'Can not establish connection' .. I just says ' at this time ' took 70 secs to establish a connection .. So my guess was network was not a problem,( since connec

Re: cant establish connection at application side.

You might want to have a good close look at the state of your network before you consider mysql as a cause.. - michael dykman On Thu, Sep 2, 2010 at 10:57 AM, karthik kumar wrote: > Hi .. I am facing a problem in mysql. > >         I am getting error  'Can not open conn

cant establish connection at application side.

Hi .. I am facing a problem in mysql. I am getting error 'Can not open connection' at the application side which happens at random timings. What i found was at whenever the problem occurs it takes 70 secs for connecting to mysql server. The machine is a high end quad core,

Re: Fixed Connection Diagnostic Tool

; Cc: Sent: Tuesday, July 06, 2010 7:15 PM Subject: Re: Fixed Connection Diagnostic Tool C3P0 connection does, indeed work well on remote machines.. In fact, I only deploy it locally on dev servers. My production systems all use c3p0 on remote servers. Again, if you can connect from the comma

Re: Fixed Connection Diagnostic Tool

C3P0 connection does, indeed work well on remote machines.. In fact, I only deploy it locally on dev servers. My production systems all use c3p0 on remote servers. Again, if you can connect from the command line of your client machine to the server *via TCP* with the same credentials as your

Re: Fixed Connection Diagnostic Tool

Thank you all for the help and info! This error happened because I started MySQL with -bind-address=91.203.57.207; even if Softslate is given the proper IP address and port number is fails on connection pooling. I fixed the problem by setting the MySQL IP address to 127.0.0.1. I am thinking

Re: Connection Diagnostic Tool

On Mon, Jul 5, 2010 at 3:55 PM, michel wrote: > > I have been trying to figure this one out, but I don't have the skill sets > here so I can use some help. > > I tried ' -h 127.0.0.1' in my bash shell and I get a command not found, so I > am still really off-the-mark. Is there a place on the net I

re: Connection Diagnostic Tool

d how to run it? Thanks! - Original Message - From: "Michael Dykman" To: "michel" Sent: Saturday, July 03, 2010 11:37 PM Subject: Re: Connection Diagnostic Tool You are right.. Java never coonnects on that domain socket, it *always* used TCP. Check your credentials at

Re: Connection Diagnostic Tool

store package that uses Hibernate to > connect to MySQL. Softslate fails to connect to MysQL on the c3p0 connection > pooling. While I would love to solve this little problem it would be wiser > if I learn to diagnose the problem. Is there a tool that can run on the > Tomcat server that

Connection Diagnostic Tool

I am setting up the Softslate web store package that uses Hibernate to connect to MySQL. Softslate fails to connect to MysQL on the c3p0 connection pooling. While I would love to solve this little problem it would be wiser if I learn to diagnose the problem. Is there a tool that can run on the

Re: Determine connection origins

> 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 determinin

  1   2   3   4   5   6   7   8   9   10   >