Re: About combine ssl with mysql.

can you please share how you have solved that? Did u use mysql -u root -p --ssl when connecting? Regards, Chandru www.mafiree.com On Fri, Dec 12, 2008 at 1:15 PM, Moon's Father yueliangdao0...@gmail.comwrote: I have solved this problem. ^_^ On Fri, Dec 12, 2008 at 10:54 AM, Moon's Father

RE: MYSQL startup problem

Hi, I cannot see port 3306 listening. how can i start the listener to that port. Pls. find netstat -n result: C:\Documents and Settings\Administratornetstat -n Active Connections Proto Local Address Foreign AddressState TCP172.21.138.200:3389

RE: MYSQL startup problem

Hi, Pls. Find response below: C:\wamp\mysql\binMysql -h localhost -u root ERROR 2003: Can't connect to MySQL server on 'localhost' (10055) -- Thanks Regards Pooja Bajaj Alcatel-Lucent, India Email:pooja.ba...@alcatel-lucent.com Phone:+124-413-3078 | Onnet: 2721-3078 -Original Message-

Re: MYSQL startup problem

Hi, I think you may have to get me the output of netstat -an (this only tells the ports that are all listening). sorry for the confusion. can you connect using mysql -u root -p and also using mysql -u root -p -h 127.0.0.1 one thing that i find here is that you have missed the -p option

RE: MYSQL startup problem

Hi, Pls. find response below: C:\wamp\mysql\binnetstat -an Active Connections Proto Local Address Foreign AddressState TCP0.0.0.0:25 0.0.0.0:0 LISTENING TCP0.0.0.0:80 0.0.0.0:0 LISTENING TCP

Re: MYSQL startup problem

Hi, I find that mysql is running fine :) TCP * 0.0.0.0:3306 * 0.0.0.0:0 LISTENING . you are connecting wrongly please connect using mysql -u root -p -h 127.0.0.1 I find that you tried the same option both times :) Regards, Chandru www.mafiree.com On Fri, Dec 12,

Re: MYSQL startup problem

You have ten half-open connections (in SYN_SENT state), and a new connection attempt is giving you error 10055 which is windows' way of saying it can't allocate a buffer for a new connection. Are you running XP SP2 or SP3 or Vista? Microsoft introduced a throttle on in these versions, if

Operating Systems.

I'm currently spec'ing out a design plan for a large scale MySQL infrastructure to support a high-read large scale web environment for a client. I've got the overall MySQL set up planned out (which I'll post here later to get peoples inputs/advice) but one issue which is currently undecided

RE: Replication

did u check if any of the file system holding bin-logs/data files are having enough free space. If the slave runs out off disk space, then you need to rebuild the slave from scratch. Yes lots of free space, so no problem there! regards anandkl On 12/8/08, ewen fortune ewen.fort...@gmail.com

RE: Replication

WHat errors are you getting when you try and start the slave? That's the exact thing mysql show slave status\G *** 1. row *** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.11.252

MySQL Guru Needed!!

Hi. I've got a situation where I need to reach out/talk to a mysql guru every now and then. For the most part, the questions are probably 5-10 minutes for the right person, but they might take me hours/days to cobble together a good solution. (I'm not a mysql guru!!) As an example, I have a

Re: MySQL Guru Needed!!

Hello, Depending on your budget and SLA needs, check out the support offerings available directly from MySQL/Sun. http://www.mysql.com/products/enterprise/features.html -- Jimmy bruce wrote: Hi. I've got a situation where I need to reach out/talk to a mysql guru every now and then. For the

Re: Operating Systems.

--- On Fri, 12/12/08, Craig Dunn li...@codenation.net wrote: I'm currently spec'ing out a design plan for a large scale MySQL infrastructure to support a high-read large scale web environment for a client. I've got the overall MySQL set up planned out (which I'll post here later to get

Re: MySQL Guru Needed!!

As an alternative you also have www.percona.com www.pythian.com www.openquery.com.au www.provenscaling.com Percona's minimum billing unit is 15 minutes, not sure about the rest On Dec 12, 2008, at 17:35, bruce bedoug...@earthlink.net wrote: Hi. I've got a situation where I need to reach

Best method for checking if a row exists.

Hello, What is the best method to check if (one or more) row exists (note: primary key is auto inc and table engine is InnoDB - but what if these were not true) ? 1) SELECT * FROM table WHERE condition Check to see if the result set is non-empty. 2) SELECT COUNT(*) AS cnt FROM table WHERE

Re: MySQL Guru Needed!!

If you use ProvenScaling - ask for Jeremy. Time and time again is he a great resource and he is a great speaker at the MySQL Users Conferences. J.R. Bullington, CMA From: Ewen Fortune ewen.fort...@gmail.com Sent: Friday, December 12, 2008 2:26 PM To:

Re: Best method for checking if a row exists.

SELECT EXISTS( SELECT * FROM table WHERE condition ) - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Pid file issue

Hi all, I just rebooted one of my servers and get the following error when trying to restart the mysql daemon: Starting MySQLManager of pid-file quit without updating[FAILED] The server shut down fine and that is when the pid file should have gone away. Any ideas? This is from the error

Re: [Solved] Compiled configure string

Hi All, I confirm that 'mysqlbug' prints, among other info, the configure string with which mysql has been compiled with. Brilliant! Thank you Chandru and thanks all for supporting. Have a nice day, Mike On Fri, 12 Dec 2008 11:56:01 +0530 Chandru chandru@gmail.com wrote: Hi, you

Re: [Solved] Compiled configure string

Hi, 'mysqlbug' is a sh shell script in which the configure string is hardcoded. You can get a cleaner output of the configure line by using this command: grep ^CONFIGURE_LINE $(which mysqlbug) P. -- Pascal Charest, Free software consultant {GNU/Linux} http://blog.pacharest.com On Fri, Dec

Re: MySQL Guru Needed!!

And you may also try: Ronald Bradford: http://42sql.com Another frequent conference speaker that really knows his stuff! Ask him about mentoring program... On Dec 12, 2008, at 8:21 PM, Ewen Fortune wrote: As an alternative you also have www.percona.com www.pythian.com www.openquery.com.au

Re: Pid file issue

Where does the pid file usually live? Does it exist? I guess you need to do some digging, but as a punt you could always try firing off the stop part of the init script and then try to start it again /etc/init.d/mysql top /etc/init.d/mysql start Assuming you're running some linux flavour,

Re: MYSQL startup problem

Hi, something weird is in the logs, the timestamps are messed up, can you post the full logfile as attachment? Claudio BAJAJ POOJA wrote: Hi, Pls find logs attached below in mail: 080605 15:28:08 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: