Re: MySQL server has gone away

2017-04-04 Thread Reindl Harald
Am 03.04.2017 um 21:22 schrieb Mahmood N: well, who did set it that low? ِDon't know. Maybe the previous admin hadn't used mysql for sending emails!! on a proper server you have a local smtpd like postfix listening on 127.0.0.1 and hence you can send thousands of messages within seconds f

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
>well, who did set it that low? ِDon't know. Maybe the previous admin hadn't used mysql for sending emails!! Anyway, thanks.  Regards, Mahmood On Monday, April 3, 2017 11:37 PM, Reindl Harald wrote: Am 03.04.2017 um 20:41 schrieb Mahmood N: > Good news! > > I changed wait_timeout=30 t

Re: MySQL server has gone away

2017-04-03 Thread Reindl Harald
Am 03.04.2017 um 20:41 schrieb Mahmood N: Good news! I changed wait_timeout=30 to wait_timeout=600 and now the error disappears... I don't know if long_query_time=1 has effect. well, who did set it that low? https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_wait_ti

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
Good news! I changed wait_timeout=30 to wait_timeout=600 and now the error disappears... I don't know if long_query_time=1 has effect. Regards, Mahmood On Monday, April 3, 2017 10:32 PM, Mahmood N wrote: Dear reindl, I tested with both 5 and 1 and see the log files are empty. I am reall

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
Dear reindl, I tested with both 5 and 1 and see the log files are empty. I am really confused about that error and it is taking more than 2 weeks about that! Regards, Mahmood

Re: MySQL server has gone away

2017-04-03 Thread Reindl Harald
Am 03.04.2017 um 19:45 schrieb Mahmood N: So I set long_query_time=5 and restarted the service. Test the email page again. Still the logs are empty WTF - you had it set to 5 seconds 2 hours ago i am out here... Am 03.04.2017 um 18:11 schrieb Mahmood N: > The my.conf file contains > >

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
So I set long_query_time=5 and restarted the service. Test the email page again. Still the logs are empty.  Regards, Mahmood

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
>since when is phpinfo() - the *real* active configuration be it changed >by some config snippet, vhost-configuration or even ini_set() - the same >than a random file in /etc? Sorry I totally didn't understand that sentence... Regards, Mahmood

Re: MySQL server has gone away

2017-04-03 Thread Reindl Harald
Am 03.04.2017 um 19:26 schrieb Mahmood N: given that a reasonable server should be able to handle hunredts to thousands of requests per second anything above 1 second is a alert sign Excuse me, do you mean higher values are better? I didn't understand. I said in my posts that when I submit th

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
>given that a reasonable server should be able to >handle hunredts to thousands of requests per second anything above 1 >second is a alert sign Excuse me, do you mean higher values are better? I didn't understand. I said in my posts that when I submit the email test, the refresh time for that pa

Re: MySQL server has gone away

2017-04-03 Thread Reindl Harald
Am 03.04.2017 um 18:11 schrieb Mahmood N: The my.conf file contains log_error=/var/log/mysql/error.log slow_query_log=1 slow_query_log_file=/var/log/mysql/error_slow.log max_connections=200 max_user_connections=30 wait_timeout=30 interactive_timeout=50 long_query_time=5 character-set-client-ha

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
The my.conf file contains log_error=/var/log/mysql/error.log slow_query_log=1 slow_query_log_file=/var/log/mysql/error_slow.log max_connections=200 max_user_connections=30 wait_timeout=30 interactive_timeout=50 long_query_time=5 character-set-client-handshake = FALSE thread_concurrency = 8 query_ca

Re: MySQL server has gone away

2017-04-03 Thread Reindl Harald
Am 03.04.2017 um 17:52 schrieb Mahmood N: Dear all, Currently max_allowed_packet is set to 8M. That test email is simply a test email containing some basic information in the message body to assure that the email system works. Thing that can help me is to put mysql in the debug mode in one te

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
Dear all, Currently max_allowed_packet is set to 8M. That test email is simply a test email containing some basic information in the message body to assure that the email system works. Thing that can help me is to put mysql in the debug mode in one terminal and at the same time, submit a test em

Re: MySQL server has gone away

2017-04-03 Thread shawn l.green
On 4/3/2017 8:15 AM, Mahmood N wrote: When I click on the submit button in Moodle and it is waiting for refresh, I execute the mysql command but the output is not meaningful mahmood@ce:/var/www/html/courses$ mysql -u moodle -p Enter password: Welcome to the MySQL monitor. Commands end with ;

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
When I click on the submit button in Moodle and it is waiting for refresh, I execute the mysql command but the output is not meaningful mahmood@ce:/var/www/html/courses$ mysql -u moodle -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 30912

Re: MySQL server has gone away

2017-04-03 Thread Johnny Withers
I'd suspect the underlying query is poorly designed for the amount of data you have stored. If you have access to the mysql server you could connect to it using any mysql client and run 'show full processlist' to see the query as that page is trying to load. The query is probably in the 'sending da

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
Thanks for the quick reply. So, how can I get further information? Thing is that, after 5 minutes, when I refresh the page every thing is normal.  Regards, Mahmood On Monday, April 3, 2017 3:39 PM, Ken D'Ambrosio wrote: Basically, it says that MySQL is not responding to queries. So it

Re: MySQL server has gone away

2017-04-03 Thread Ken D'Ambrosio
Basically, it says that MySQL is not responding to queries. So it likely has died, or perhaps is mis-configured. On April 3, 2017 7:07:25 AM EDT, Mahmood N wrote: >Hi,I am using Moodle which itself uses SQL for the database. Problem is >that, when I run the email plugin and execute the command,

Re: Mysql server - which filesystem to choose? Is it really that important nowadays?

2013-05-23 Thread Tim Callaghan
Thanks for the information, I'll give it a try myself. On Thu, May 23, 2013 at 5:02 AM, Manuel Arostegui wrote: > > > > 2013/5/22 Tim Callaghan > >> Rafal, >> >> I don't believe TRIM is supported for XFS. >> > > I tried this two weeks ago and worked pretty well: > http://xfs.org/index.php/FITR

Re: Mysql server - which filesystem to choose? Is it really that important nowadays?

2013-05-23 Thread Johan De Meersman
- Original Message - > From: "Rick James" > Subject: RE: Mysql server - which filesystem to choose? Is it really that > important nowadays? > > ext does less well with simultaneous IOPs than xfs. Possibly, but how much less (and which ext)? Without numbers

Re: Mysql server - which filesystem to choose? Is it really that important nowadays?

2013-05-23 Thread Manuel Arostegui
2013/5/22 Tim Callaghan > Rafal, > > I don't believe TRIM is supported for XFS. > I tried this two weeks ago and worked pretty well: http://xfs.org/index.php/FITRIM/discard Manuel.

RE: Mysql server - which filesystem to choose? Is it really that important nowadays?

2013-05-22 Thread Rick James
ext does less well with simultaneous IOPs than xfs. > -Original Message- > From: Manuel Arostegui [mailto:man...@tuenti.com] > Sent: Wednesday, May 22, 2013 12:22 AM > To: Rafał Radecki > Cc: mysql@lists.mysql.com > Subject: Re: Mysql server - which filesystem to ch

Re: Mysql server - which filesystem to choose? Is it really that important nowadays?

2013-05-22 Thread Tim Callaghan
Rafal, I benchmark a lot on various hardware and software configurations. When I started 2 years back I went along with the general consensus that XFS is faster than ext4 for MySQL. I recently had the opportunity to see how much of a difference, if any, it made. I didn't find much, especially o

Re: Mysql server - which filesystem to choose? Is it really that important nowadays?

2013-05-22 Thread Manuel Arostegui
2013/5/22 Rafał Radecki > Hi All. > > I use mysql/perconna/maria on my production CentOS 6 Linux servers. I > currently try to choose the default filesystem for partitions with mysql > data. Some time ago (previous dba) reiserfs was the choice but now it is > not in the kernel and the main author

Re: mysql server does not recognize user password

2011-10-19 Thread Reindl Harald
Am 19.10.2011 17:45, schrieb Tim Johnson: > * Reindl Harald [111018 23:24]: >> Am 19.10.2011 01:36, schrieb Tim Johnson: try "mysql -u tim -p" >>> Same error: >>> ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using >>> password: NO) > and enter yur password in the fol

Re: mysql server does not recognize user password

2011-10-19 Thread Tim Johnson
* Reindl Harald [111018 23:24]: > Am 19.10.2011 01:36, schrieb Tim Johnson: > >> try "mysql -u tim -p" > > Same error: > > ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using > > password: NO) > >> > and enter yur password in the followed dialog > > Doesn't even ask for the pwd

Re: mysql server does not recognize user password

2011-10-19 Thread Reindl Harald
Am 19.10.2011 01:36, schrieb Tim Johnson: >> try "mysql -u tim -p" > Same error: > ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using > password: NO) >> > and enter yur password in the followed dialog > Doesn't even ask for the pwd.. then your mysql CLIENT is broken or somehow

Re: mysql server does not recognize user password

2011-10-18 Thread Claudio Nanni
sql@lists.mysql.com > > Sent: Wednesday, 19 October, 2011 3:53:23 AM > > Subject: Re: mysql server does not recognize user password > > > > Why does mysql say "using password: no"? Seems to me the password is > > not > > being sent. > > > > On

Re: mysql server does not recognize user password

2011-10-18 Thread Johan De Meersman
t; > Cc: mysql@lists.mysql.com > Sent: Wednesday, 19 October, 2011 3:53:23 AM > Subject: Re: mysql server does not recognize user password > > Why does mysql say "using password: no"? Seems to me the password is > not > being sent. > > On Oct 18, 2011 8:37

Re: mysql server does not recognize user password

2011-10-18 Thread Johnny Withers
Why does mysql say "using password: no"? Seems to me the password is not being sent. On Oct 18, 2011 8:37 PM, "Tim Johnson" wrote: * Claudio Nanni [111018 17:02]: > FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER > etc, > > Usually this ... linus:~ tim$ sudo mysql Pas

Re: mysql server does not recognize user password

2011-10-18 Thread Tim Johnson
* Tim Johnson [111018 17:47]: Got this... mysql> select host,user,password from user; +-+--+---+ | host| user | password | +-+--+---+ | localho

Re: mysql server does not recognize user password

2011-10-18 Thread Tim Johnson
* Claudio Nanni [111018 17:02]: > FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER > etc, > > Usually this problem comes when you have the anonymous user in the grant > tables (''), > MySQL has a tricky way of processing the grant tables. > > Sometimes you can be surprise

Re: mysql server does not recognize user password

2011-10-18 Thread Claudio Nanni
FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER etc, Usually this problem comes when you have the anonymous user in the grant tables (''), MySQL has a tricky way of processing the grant tables. Sometimes you can be surprised by what you read issuing: SELECT USER(),CURREN

Re: mysql server does not recognize user password

2011-10-18 Thread Tim Johnson
* Reindl Harald [111018 15:14]: > > > Am 19.10.2011 01:03, schrieb Tim Johnson: > > Now when I try to log in with host as localhost, user as tim > > with 'secret' password: > > linus:~ tim$ mysql --host=localhost --user=tim --password=secret > > ERROR 1045 (28000): Access denied for user 'tim'@'

Re: mysql server does not recognize user password

2011-10-18 Thread Tim Johnson
* Mark [111018 15:14]: > Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session? Not originally, but I repeated the grant then issued flush privileges; quit and have the same problem thanks -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebs

Re: mysql server does not recognize user password

2011-10-18 Thread Reindl Harald
Am 19.10.2011 01:03, schrieb Tim Johnson: > Now when I try to log in with host as localhost, user as tim > with 'secret' password: > linus:~ tim$ mysql --host=localhost --user=tim --password=secret > ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password: > NO) > Huh! did

RE: mysql server does not recognize user password

2011-10-18 Thread Mark
Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session? - Mark -Original Message- From: Tim Johnson [mailto:t...@akwebsoft.com] Sent: woensdag 19 oktober 2011 1:02 To: MySQL ML Subject: mysql server does not recognize user password using 5.1.57 on Mac Lion. I've done t

Re: MySQL server has gone away

2011-05-31 Thread chandrudba
Are you using connection pooling in your application? Regards, Chandru On 5/27/2011 11:05 AM, Claudio Nanni wrote: 'MySQL server has gone away' Can be a network problem, Just to increase complexity :) On May 26, 2011 11:03 PM, "Prabhat Kumar" wrote: I had experience with such type of error,

Re: MySQL server has gone away

2011-05-31 Thread chandrudba
Try setting wait_timeout=36000 Regards, Chandru On 5/29/2011 11:13 PM, ars k wrote: Hi Aveek, I would like to suggest some points here: You could try increasing the max allowed packets to 128MB. Though you think 16MB is enough, increasing it is not going to affect the server. It is dynamic valu

Re: MySQL server has gone away

2011-05-31 Thread ars k
Hi Aveek, I would like to suggest some points here: You could try increasing the max allowed packets to 128MB. Though you think 16MB is enough, increasing it is not going to affect the server. It is dynamic value, so you could revert back the changes if you feel so. Also make sure log_warnings=2 wh

Re: MySQL server has gone away

2011-05-26 Thread Claudio Nanni
'MySQL server has gone away' Can be a network problem, Just to increase complexity :) On May 26, 2011 11:03 PM, "Prabhat Kumar" wrote: > I had experience with such type of error, It was due lack of resources > available to MySql, max connections exceeds on the server. > you can write a simple scr

Re: MySQL server has gone away

2011-05-26 Thread Prabhat Kumar
I had experience with such type of error, It was due lack of resources available to MySql, max connections exceeds on the server. you can write a simple script which will grab and store output of 'show processlist' every min. and later you cna investigate the issue. On Wed, May 25, 2011 at 3:34 A

Re: MySQL server has gone away

2011-05-25 Thread Aveek Misra
Nothing in the error log or the slow query log that suggests that the query size is too large or us taking too much time to execute. Thanks Aveek On May 25, 2011, at 3:53 PM, Rik Wasmus wrote: >> failed to execute "SELECT * FROM cluster_info WHERE cluster = ?": >> MySQL server has gone

Re: MySQL server has gone away

2011-05-25 Thread Rik Wasmus
> failed to execute "SELECT * FROM cluster_info WHERE cluster = ?": > MySQL server has gone away > > The error "MySQL server has gone away" is the error from the db handle. Can > anyone give me any pointers on why that happens? I looked up the > documentation in MySQL docs and the most com

Re: Mysql server full with idle connections

2010-11-29 Thread Johan De Meersman
On Mon, Nov 29, 2010 at 2:21 PM, Peter Wang wrote: > We had have a similar problem caused by broken network-card, use > `/sbin/ifconfig | grep errors' to check errors/dropped counter. for > example, broken network-card may cause many connections, since normal > tcp connect open/close can't be co

Re: Mysql server full with idle connections

2010-11-29 Thread Peter Wang
Johan De Meersman writes: Hi, You may check the network at that time. We had have a similar problem caused by broken network-card, use `/sbin/ifconfig | grep errors' to check errors/dropped counter. for example, broken network-card may cause many connections, since normal tcp connect open/cl

Re: Mysql server full with idle connections

2010-11-29 Thread Johan De Meersman
300 seconds is 5 minutes, while this whole thing happened probably under a minute. I'm looking for possible causes, not workarounds :-) On Fri, Nov 26, 2010 at 8:57 PM, Prabhat Kumar wrote: > Hi, > > to avoid this change ur "wait_timeout" value to 300 Secs or less, along > with this you can als

Re: Mysql server full with idle connections

2010-11-26 Thread Prabhat Kumar
Hi, to avoid this change ur "wait_timeout" value to 300 Secs or less, along with this you can also write a script to kill those process (mysql process) which are in sleep mode for more than certain time.. hope this will helpful.. On Wed, Nov 24, 2010 at 6:41 PM, Johan De Meersman wrote: > On

Re: Mysql server full with idle connections

2010-11-24 Thread Johan De Meersman
On Wed, Nov 24, 2010 at 1:13 PM, Nigel Wood wrote: > Quick thought: what is your idle timeout set to on the MySQL server? > Could you have configured it to reap these idle connections? > I could, probably, but the applications are generally well-behaved, and it's not a recurring problem. I hope.

Re: Mysql server full with idle connections

2010-11-24 Thread John Daisley
Seen this a lot with poorly written web apps which open connections but dont close them when finished. Try setting wait_timeout and/or interactive_timeout to close unused connections. John On 24 November 2010 11:27, Johan De Meersman wrote: > Hey, > > Late last night, I got a call that one of

Re: MySQL Server has gone away

2010-08-20 Thread Shawn Green (MySQL)
relay log '/var/run/mysqld/mysqld-relay-bin.01' (relay_log_pos 4) 100817 6:42:11 [ERROR] Could not find target log during relay log initialization 100817 6:42:11 [ERROR] Failed to initialize the master info structure 100817 6:42:11 [Note] /usr/libexec/mysqld: ready for connections. Vers

Re: MySQL Server has gone away

2010-08-20 Thread jitendra ranjan
The account has full permission on all the databases. --- On Fri, 20/8/10, Ananda Kumar wrote: From: Ananda Kumar Subject: Re: MySQL Server has gone away To: "jitendra ranjan" Cc: "Krishna Chandra Prajapati" , "Prabhat Kumar" , mysql@lists.mysql.com Date: Fr

Re: MySQL Server has gone away

2010-08-20 Thread Ananda Kumar
ead_cache_size': unsigned value > 33554432 adjusted to 16384 > 100817 6:42:10 InnoDB: Started; log sequence number 0 44054 > 100817 6:42:11 [Warning] Neither --relay-log nor --relay-log-index were > used; so replication may break when this MySQL server acts as a slave and > has hi

Re: MySQL Server has gone away

2010-08-19 Thread jitendra ranjan
y-bin.01' (relay_log_pos 4) 100817 6:42:11 [ERROR] Could not find target log during relay log initialization 100817 6:42:11 [ERROR] Failed to initialize the master info structure 100817 6:42:11 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.77-log' socket: '/va

Re: MySQL Server has gone away

2010-08-19 Thread Prabhat Kumar
there is high chance of corruption of any data files, but it will clear only after looking of your error file (generated by mysql) can you post the 50 last lines of your mysql error file. On Thu, Aug 19, 2010 at 4:35 PM, Krishna Chandra Prajapati < prajapat...@gmail.com> wrote: > Hi Jitendra, >

Re: MySQL Server has gone away

2010-08-19 Thread Krishna Chandra Prajapati
Hi Jitendra, Check your error log file. Some thing might have gone wrong. Krishna On Wed, Aug 18, 2010 at 9:41 PM, jitendra ranjan wrote: > Hi, > > Whenever i run any commnd on mysql it gives message as below then gives the > result successfully. What is the reason of the below error message :

Re: [Mysql-server-5.0]Missing socket files and denied acess to root user

2010-04-03 Thread Carlos Andrade
Hello, (First let me remember that my OS is Ubuntu 9.04) I've found a solution today few minutes ago, so I'm posting here since I've sound so many posts around the web and not a single solution seemed to solve my problem. Its actually pretty simple. My real problem was related to the my.cnf and

Re: mysql server optimization

2009-12-15 Thread TianJing
; *From:* jingtian.seu...@gmail.com [mailto:jingtian.seu...@gmail.com] *On > Behalf Of *TianJing > *Sent:* 15 December 2009 12:43 > *To:* Daisley, John (Burton) > > *Cc:* mysql@lists.mysql.com > *Subject:* Re: mysql server optimization > > yes,you are right,the longblob is already

RE: mysql server optimization

2009-12-15 Thread Daisley, John (Burton)
ingtian.seu...@gmail.com] On Behalf Of TianJing Sent: 15 December 2009 12:43 To: Daisley, John (Burton) Cc: mysql@lists.mysql.com Subject: Re: mysql server optimization yes,you are right,the longblob is already move to a separate table fdna,it is about 10Gb/database the fdata is about 30Gb

Re: mysql server optimization

2009-12-15 Thread TianJing
; Inspired Gaming Group Plc > > Direct Dial +44 (0)1283 519244 > Telephone +44 (0)1283 512777 ext 2244 > Mobile +44 (0)7812 451238 > > Email john.dais...@llg.co.uk > > www.inspiredgaminggroup.com > > > -Original Message- > From: TianJing > Sent: 15 Dec

RE: mysql server optimization

2009-12-15 Thread Daisley, John (Burton)
244 Telephone +44 (0)1283 512777 ext 2244 Mobile +44 (0)7812 451238 Email john.dais...@llg.co.uk www.inspiredgaminggroup.com -Original Message- From: TianJing Sent: 15 December 2009 10:28 To: mg_s...@hotmail.com Cc: mysql@lists.mysql.com Subject: Re: mysql server optimization i use MyISA

Re: mysql server optimization

2009-12-15 Thread TianJing
i use MyISAM storage,the MYI file is more than 500Gb. most of the sql is select with many 'and','or','order by',for example: SELECT fref,fstart,fstop,fsource,fmethod,fscore,fstrand,fphase,gclass,gname,ftarget_start,ftarget_stop,fdata.fid,fdata.gid FROM fdata,ftype,fgroup WHERE fgroup.gid = fda

RE: mysql server optimization

2009-12-15 Thread John Daisley
What kind of queries are being run and what type of data is stored? There are a number of factors which causes MySQL to use on disk temporary tables instead of in memory tables. (If there a BLOB or TEXT columns in the table for example). As a starting point you could (if you have the memory in

Re: mysql server is not starting

2009-11-11 Thread Benedikt Schackenberg
in your my.cnf is the data dir "datadir=/var/LRM-INSTALL/ams/database/lrm_2.0.0.0_9.0.0.0-76641" in your list it should be : "datadir=/var/LRM-INSTALL/ams/database/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/data" is this correct? F.A.I.Z.A.L schrieb: > yes.. folde

Re: mysql server is not starting

2009-11-11 Thread F.A.I.Z.A.L
error log also having the same information.. do u feel any problem with the installation. bcos i could the files are installed in different locations.any suggestion.. Best Regards Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com On Wed, Nov 11, 2009 at 5:12 PM, Krishna Chandra Praj

Re: mysql server is not starting

2009-11-11 Thread F.A.I.Z.A.L
yes.. folder is exist. but don't know why its not starting.. these are the files exist in the folder drwx-- 2 amssys amssys 1536 Nov 11 17:12 bin drwx-- 4 amssys amssys 512 Nov 11 12:52 data drwx-- 2 amssys amssys 512 Apr 1 2009 docs drwx-- 2 amssy

Re: mysql server is not starting

2009-11-11 Thread Benedikt Schackenberg
"...mysql_upgrade examines all tables in all databases for incompatibilities with the current version of MySQL Server. mysql_upgrade also upgrades the system tables so that you can take advantage of new privileges or capabilities that might have been added" http://dev.mysql.com/doc/refman/5.1/

Re: mysql server is not starting

2009-11-11 Thread Benedikt Schackenberg
hi, exists this folder on your System? /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit F.A.I.Z.A.L schrieb: > hi > > thanks for your reply,, > > i can see only limited parameters are there in my.cnf > > basedir=/var/LRM-INSTALL/ams/soft

Re: mysql server is not starting

2009-11-11 Thread F.A.I.Z.A.L
hi thanks for your reply,, i can see only limited parameters are there in my.cnf basedir=/var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris but this is not in /usr/local/mysql.. if u see my error log. it ask me to run mysql_upgrade. why it is asking .. a

Re: mysql server is not starting

2009-11-11 Thread Krishna Chandra Prajapati
Hi faizal, Check your mysql error log file. Thanks, Krishna On Wed, Nov 11, 2009 at 4:17 PM, F.A.I.Z.A.L wrote: > hi iam trying to start mysql services but it showing error. while i start > it > automatically goes to shutdown.. > > what is errmsg.sys? its looking this file but it was not there

Re: mysql server is not starting

2009-11-11 Thread Benedikt Schackenberg
Check that your my.ini or my.cnf has the correct entry for the Basedir option. F.A.I.Z.A.L schrieb: > hi iam trying to start mysql services but it showing error. while i start it > automatically goes to shutdown.. > > what is errmsg.sys? its looking this file but it was not there.. please help >

Re: MySQL server has gone away...

2009-03-25 Thread Walter Heck - OlinData.com
; > How do I tell what the TTL is? > > I'm not too familiar with perfmon.  How do I set it up to watch MySQL > connections? > > Thanks, > Jesse > > - Original Message - From: "Gary Smith" > To: "Jesse" ; > Sent: Tuesday, March 24, 20

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
tions? Thanks, Jesse - Original Message - From: "Gary Smith" To: "Jesse" ; Sent: Tuesday, March 24, 2009 2:55 PM Subject: Re: MySQL server has gone away... Netstat -an. How many 3306 entries do you have in there. What's the TTL on them. Once the pool issu

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
An update on this issue. It just happened again, and the first error was: [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]Lost connection to MySQL server during que Then, after that, I got a BUNCH of "[MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]MySQL server has gone away

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
Go into the my.cnf and increase the connection timeout and see if that fixes it. Remember. Connection pooling is about reuse and sometimes when the server is using less connections its using the same ones over and over again. Then you get a burst and then connections that haven't been used are

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
Persistent connections that are dropped when the service is restarted OR the idle timeout has passed. if this is a connection pool and it hasn't been used in a long time the server can drop the connection but the pool will still thinkbits open and pass it out. Thus the server has gone away mess

Re: MySQL server has gone away...

2009-03-24 Thread drydell
this means that your connection has timed out... there's a mysql_ping command you can use to reconnect.- Original Message -From: Jesse Date: Tuesday, March 24, 2009 11:44 amSubject: MySQL server has gone away...To: mysql@lists.mysql.com> We are running MySQL Server version 5.0.67-commun

Re: MySQL Server 5.1.30 has been released

2008-12-07 Thread Michael Widenius
Hi! > "David" == David Giragosian <[EMAIL PROTECTED]> writes: David> On 12/1/08, Daevid Vincent <[EMAIL PROTECTED]> wrote: >> >> Monty Widenius (MySQL co-founder who recently left Sun)... David> What's the news on this? I haven't left Sun. When MySQL was acquired by Sun, I did move out f

Re: MySQL Server 5.1.30 has been released

2008-12-07 Thread Michael Widenius
Hi! > "Daevid" == Daevid Vincent <[EMAIL PROTECTED]> writes: Daevid> Monty Widenius (MySQL co-founder who recently left Sun), on the other Daevid> hand, doesn't cast a very favorable light on 5.1 for production use. Daevid> Good read: Daevid> "If you plan to use any of the new feat

Re: MySQL Server 5.1.30 has been released

2008-12-01 Thread David Giragosian
On 12/1/08, Daevid Vincent <[EMAIL PROTECTED]> wrote: > > Monty Widenius (MySQL co-founder who recently left Sun)... What's the news on this? David

Re: MySQL Server 5.1.30 has been released

2008-12-01 Thread Daevid Vincent
Monty Widenius (MySQL co-founder who recently left Sun), on the other hand, doesn't cast a very favorable light on 5.1 for production use. Good read: "If you plan to use any of the new features of MySQL 5.1, regard these as if they would be of beta quality." http://monty-

Re: MySQL server statistics

2008-07-22 Thread Yves Goergen
On 21.07.2008 22:52 CE(S)T, Benjamin Wiechman wrote: With 5.1 you have more control over general query log and the slow query log - enable or disable at runtime, output to file or DB table. Okay, now that sounds a lot better. Waiting for 5.1 GA then. Although it only provides the very basics.

RE: MySQL server statistics

2008-07-21 Thread Benjamin Wiechman
ery 10-15 seconds instead of a longer interval to help you profile which applications are hammering your db server. Ben Wiechman > -Original Message- > From: Yves Goergen [mailto:[EMAIL PROTECTED] > Sent: Monday, July 21, 2008 11:19 AM > To: Rob Wultsch > Cc: mysql@lists.mys

Re: MySQL server statistics

2008-07-21 Thread Yves Goergen
On 20.07.2008 23:49 CE(S)T, Rob Wultsch wrote: On Sun, Jul 20, 2008 at 1:33 PM, Yves Goergen <[EMAIL PROTECTED]> wrote: Hello, I've installed MySQL server 5.0 and have written a small statistics script that regularly checks the number of connections and queries to the server, which I can then v

Re: MySQL server statistics

2008-07-20 Thread Rob Wultsch
On Sun, Jul 20, 2008 at 1:33 PM, Yves Goergen <[EMAIL PROTECTED]> wrote: > Hello, > > I've installed MySQL server 5.0 and have written a small statistics script > that regularly checks the number of connections and queries to the server, > which I can then view in a diagram. But sometimes it just s

Re: mysql-server-4.1.20-2.RHEL4.1 - master/master error after crash

2008-07-07 Thread Tom Brown
I run 4.1.20 in master/master for nagios clustering. Everything was working fine until both machines went down due to power failure in the IDC. On powering back up one of the machines has come back fine but on the 'secondary' bearing in mind this is master/master but actually the 01 machin

RE: MySQL server connection question.

2007-12-05 Thread Rolando Edwards
Today, I installed 5.1.22RC and 6.0.3-alpha on my PC I used 5.0.45's client successfully to connect to both. I don't about 5.0.14 Give it a try !!! -Original Message- From: Jeffrey M. Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 05, 2007 4:36 PM To: mysql@lists.mysql.com S

Re: MySQL Server not running

2007-10-15 Thread Daniel Bau
gt; An: Ananda Kumar <[EMAIL PROTECTED]> Kopie an: Daniel Bau <[EMAIL PROTECTED]>, mysql@lists.mysql.com Betreff: Re: MySQL Server not running Given that FEHLGESCHLAGEN means "failed" and coupled with the proceding text, I would assu

Re: MySQL Server not running

2007-10-15 Thread Daniel Bau
Nothing, the server is definetively not running You get the bug script from me.. regards Daniel Datum: Fri, 12 Oct 2007 15:44:29 +0530 Von:"Ananda Kumar" <[EMAIL PROTECTED]> An: "Daniel Bau" <[EMAIL PROTECTED]> Betreff:Re: MySQL Server n

Re: MySQL Server not running

2007-10-12 Thread John Meyer
stall_db but >> dont tell me what for problem. >> The message say i should execute the bug script and send it to you . >> >> Greetings >> Bau Daniel >> >> >> Datum: Fri, 12 Oct 2007 14:45:45 +0530 >> Von:"Ananda Kumar&q

Re: MySQL Server not running

2007-10-12 Thread Ananda Kumar
age say i should execute the bug script and send it to you . > > Greetings > Bau Daniel > > > Datum: Fri, 12 Oct 2007 14:45:45 +0530 > Von:"Ananda Kumar" <[EMAIL PROTECTED]> > An: "Daniel Bau" <[EMAIL PROTECTED]> > Betreff:Re: MyS

Re: MySQL Server not running

2007-10-12 Thread Daniel Bau
An: "Daniel Bau" <[EMAIL PROTECTED]> Betreff:Re: MySQL Server not running Kopie an: mysql@lists.mysql.com what is the error ur getting. regards anandkl On 10/11/07, Daniel Bau <[EMAIL PROTECTED]> wrote: > > Dear MySQL Support team , > > I have bis prob

Re: MySQL Server not running

2007-10-12 Thread Ananda Kumar
what is the error ur getting. regards anandkl On 10/11/07, Daniel Bau <[EMAIL PROTECTED]> wrote: > > Dear MySQL Support team , > > I have bis problems to upgrade my MySQL 3.23.58 Version on a Linux Red Hat > 3 system. > I nearly download all MySQL Versions (4,5,6) and try to test them but > nowb

Re: MySQL Server crashing & database corruption

2007-10-10 Thread Samuel Vogel
I tried something different: This Server was acting as a slave before, so I removed all the Slave stuff from it. Also mydns DNS Server was running, but i relocated it to a different server. Unfortunately I still get the same behavior: # grep ' mysqld' /var/log/syslog Oct 10 07:06:29 h1314631 m

Re: MySQL Server crashing & database corruption

2007-10-07 Thread Samuel Vogel
Actually I have an somewhat reproducible test case. Problem is, it only works on my Server. When I start MySQL it crashes almost exactly after one minute. This happens every single time: Oct 7 21:41:04 h1314631 mysqld_safe[18591]: started Oct 7 21:41:04 h1314631 mysqld[18594]: 071007 21:41:0

Re: MySQL Server crashing & database corruption

2007-10-07 Thread Samuel Vogel
I did some more research: I ran "xfs_check" on the partition and it didn't report any errors at all, so I'm guessing, that the hard drives are ok. I also recompiled MySQL with "--with-debug". How would I get some debug output about the crashes now? Thanks, Samy Samuel Vogel schrieb: Hey guy

RE: mysql-server-5.1.19 path variable error set on compile

2007-06-18 Thread Geoffroy Cogniaux
Hi, Set this variable at command line or in your my.cnf. Geoffroy. -Message d'origine- De : David Southwell [mailto:[EMAIL PROTECTED] Envoyé : dimanche 17 juin 2007 17:33 À : mysql@lists.mysql.com Objet : mysql-server-5.1.19 path variable error set on compile # uname -a 6.1-RELEASE F

Re: mysql server has gone away

2007-01-16 Thread Chris White
If I fire a lot of querries, I get an error "mysql server has gone away/lost connection with the server" . I've seen this error for the second reason you've mentioned, wrong queries. You'll need to show us the query so we can see any possible issues. -- MySQL General Mailing List For lis

RE: MySQL Server

2006-06-07 Thread Jimmy Guerrero
Hello, Is there a particular reason you need to be working with version 3.23 (besides it being part of the RHL distro?) You might want to start with version 5.0 or 4.1. http://dev.mysql.com/downloads/ Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From:

  1   2   >