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: '4.0.18-n
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, othe
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
ww
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 1
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 wrote:
> Hi,
>
> you can use mysqlbug t
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 log
SELECT EXISTS(
SELECT * FROM WHERE
)
- Perrin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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
Sent: Friday, December 12, 2008 2:26 PM
To: bruce
Subject: Re: MySQL
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 WHERE
Check to see if the result set is non-empty.
2) SELECT COUNT(*) AS cnt FROM WHERE
Check to see if the f
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" wrote:
Hi.
I've got a situation where I need to reach out/talk to a mysql guru
--- On Fri, 12/12/08, Craig Dunn 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 peoples inputs/advic
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
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 situa
>>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
>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 wrote:
>
> Hi,
>
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
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 more
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, 20
Hi,
Pls. find response below:
C:\wamp\mysql\bin>netstat -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
TCP0.0.0.0:13
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
Hi,
Pls. Find response below:
C:\wamp\mysql\bin>Mysql -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
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\Administrator>netstat -n
Active Connections
Proto Local Address Foreign AddressState
TCP172.21.138.200:3389172.21.138.11:25
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 wrote:
> I have solved this problem.
> ^_^
>
> On Fri, Dec 12, 2008 at 10:54 AM, Moon's Father
> wrote:
>
> > Hi.
>
23 matches
Mail list logo
