December 2010 20:25
To: 'mysql'
Subject: /etc/init.d/mysql start WITHOUT integrity check?
Is there a way to /etc/init.d/mysql start WITHOUT doing an integrity
check?
Can I pass in a command line parameter or set something in the my.cnf file?
Our DB is a Billion rows (with a B) and that check can
. Adding
a slave shouldn't require any restarts/reloads.
What have you changed in the my.cnf to solicit a restart?
Andy
From: ext Daevid Vincent [dae...@daevid.com]
Sent: 29 December 2010 20:25
To: 'mysql'
Subject: /etc/init.d/mysql start WITHOUT
-Original Message-
From: andrew.2.mo...@nokia.com [mailto:andrew.2.mo...@nokia.com]
Sent: Thursday, December 30, 2010 2:45 AM
To: dae...@daevid.com; mysql@lists.mysql.com
Subject: RE: /etc/init.d/mysql start WITHOUT integrity check?
Daevid,
I'm not quite sure I understand
?
_
From: Wagner Bianchi [mailto:wagnerbianch...@gmail.com]
Sent: Thursday, December 30, 2010 5:01 AM
To: andrew.2.mo...@nokia.com
Cc: dae...@daevid.com; mysql@lists.mysql.com
Subject: Re: /etc/init.d/mysql start WITHOUT integrity check?
Let me know with you whether I understood what do you want
On 12/30/2010 5:00 PM, Daevid Vincent wrote:
Comment WHAT lines?
I looked through /etc/init.d/mysql and don't see anything related to
check or chk. I eyeballed each line in the file and nothing stands out
as the culprit causing an integrity check of the databases.
develo...@mypse:/etc/init.d$
There are different and connected things being discussed here.
1-) Is there a way to read new configurations from my.cnf whithout restart
server?
= No. A simple mysqladmin reaload don't submit server to read configuration
file again.
2-) Is there a way to avoid debian-script to check databases'
Is there a way to /etc/init.d/mysql start WITHOUT doing an integrity
check?
Can I pass in a command line parameter or set something in the my.cnf file?
Our DB is a Billion rows (with a B) and that check can take HOURS.
All we want to do is restart the server to put another slave online
Hi
I have installed some software on aix5.2 .
the list of software:
apache-1.3.29-1.aix4.3.ppc.rpm
php-4.0.6-5.aix4.3.ppc.rpm
MySQL-3.23.47-3.aix4.3.ppc.rpm
MySQL-client-3.23.47-3.aix4.3.ppc.rpm
All of them was installed by using the command : rpm -i *.*
then
Apache and php can work
but
On Wed, 15 Sep 2004, [GB2312] ÀîÈñ wrote:
Hi
I have installed some software on aix5.2 .
the list of software:
apache-1.3.29-1.aix4.3.ppc.rpm
php-4.0.6-5.aix4.3.ppc.rpm
MySQL-3.23.47-3.aix4.3.ppc.rpm
MySQL-client-3.23.47-3.aix4.3.ppc.rpm
All of them was installed by using the command :
Hi
I have installed some software on aix5.2 .
the list of software:
apache-1.3.29-1.aix4.3.ppc.rpm
php-4.0.6-5.aix4.3.ppc.rpm
MySQL-3.23.47-3.aix4.3.ppc.rpm
MySQL-client-3.23.47-3.aix4.3.ppc.rpm
All of them was installed by using the command : rpm -i *.*
then
Apache and php can work
but
On Wed, 15 Sep 2004, [GB2312] ÀîÈñ wrote:
Hi
I have installed some software on aix5.2 .
the list of software:
apache-1.3.29-1.aix4.3.ppc.rpm
php-4.0.6-5.aix4.3.ppc.rpm
MySQL-3.23.47-3.aix4.3.ppc.rpm
MySQL-client-3.23.47-3.aix4.3.ppc.rpm
All of them was installed by using the command :
Hello, MySQL gurus,
I just installed mysql 4.0.20 on an athlon i686 linux red hat. Then I copy
the my-huge.cnf to /etc/my.cnf and only added these 2 lines to the file
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/host.pid
when I use 'sudo -b mysqld_safe --user=mysql' to
At 11:26 -0700 7/21/04, ginger cheng wrote:
Hello, MySQL gurus,
I just installed mysql 4.0.20 on an athlon i686 linux red
hat. Then I copy the my-huge.cnf to /etc/my.cnf and only added these
2 lines to the file
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/host.pid
when I
Hi-
having a problem with a new installation of MySQL 4 on a Xeon-based system
(Tyan S2723), single processor installed. Whenever I start mysql, I then
check using ps -ef and find that not only has mysqld_safe started, but in
addition I have 10 new 'mysqld' processes.
Why are there so many
Hi Scott,
Those aren't processes. There is 1 process with many threads and your
system is reporting them as separate processes. :-)
Hope that helps.
Matt
- Original Message -
From: Scott Stingel
Sent: Monday, December 01, 2003 4:47 PM
Subject: mysql 'start' spawns 10 instances
hi,
i have this problem that mysql doesn't want to start.
I am using:
Mandrake Linux 9.0
MySQL 3.23.52
when i start mysql with
[adriaan@megatron adriaan]# service mysql start
then mysqld dies and give me this error log:
--- start of megatron.darkrealm.net.err ---
We will try our best
Hi,
I have a problem. I run Debian (libc6 2.2.5-6) and I am not able to start
MySQL 4.0.1
I got this error log:
-
020613 12:49:06 mysqld started
mysqld got signal 11;
This could be because you hit a bug. It is also
:
change owner to mysql then restart mysql
Submitter-Id: [EMAIL PROTECTED]
Originator:Sylvain Rousse
Organization:
Aricia webagency
MySQL support: none
Synopsis: mysql start on boot
Severity: non-critical
Priority: medium
Category: mysql
Class: sw-bug
Release
sylvain,
Wednesday, May 15, 2002, 12:05:48 PM, you wrote:
sDescription:
s On boot of linux, mysql doesn't start automatically because mysql.log
s file is owned by root. One has to whange owner by hand to
s mysql and then restart mysql.
sHow-To-Repeat:
s on next
Samuel,
Tuesday, April 23, 2002, 8:55:00 PM, you wrote:
SM Victoria Reznichenko
Samuel,
Tuesday, April 23, 2002, 4:04:20 PM, you wrote:
SM file serwer.err:
SM 020422 19:16:29 mysqld started
SM 020422 19:16:32 /usr/libexec/mysqld: Table 'mysql.host' doesn't
exist SM 020422 19:16:32
Can you help me in the following problem?
OS: Linux Slackware 8.0
Source: mysql-3.23.42.tar.gz
I can't start mysql after installing the source file. I did it step by step
according guidance from Install-Source file.
My OS is generating such messages:
root@serwer:/TEMP# mysql
ERROR 2002:
Samuel,
Tuesday, April 23, 2002, 4:04:20 PM, you wrote:
SM Can you help me in the following problem?
SM OS: Linux Slackware 8.0
SM Source: mysql-3.23.42.tar.gz
SM I can't start mysql after installing the source file. I did it step by step
SM according guidance from Install-Source file.
SM
Victoria Reznichenko
Samuel,
Tuesday, April 23, 2002, 4:04:20 PM, you wrote:
SM Can you help me in the following problem?
SM OS: Linux Slackware 8.0
SM Source: mysql-3.23.42.tar.gz
SM I can't start mysql after installing the source file. I did it step
by step SM according guidance
From: bruce
To: [EMAIL PROTECTED]
Subject: mysql start produces can't connect thru
/var/lib/mysql/mysql.sock
Description:Trying to run mysql-3.23.41 that came with RH7.2 following
mysql.org documentation. files are not located as documented either for rpm
or source install. 'mysql start
Hi folks,
I am still new in the mysql world. I have just installed mysql but it
when I try to start it (/usr/local/mysql/bin/safe_mysql ) I get the
following error massages in the linux.err file:
020101 19:51:58 mysqld started
^G/usr/local/mysql/libexec/mysqld: File './linux-bin.1' not found
Richard --
Did you set the --prefix=/usr/local/mysql when you ran config? If not
Your bin are located in /usr/local/bin maybe /usr/local/sbin?
The start script is saying the either the programs not ther or you
have a permissions problem?
Did you create user and group mysql,
Install as above
Hi,
I have mysql 3.something or other, a max edition from sometime last month.
I am having problems with startup. It will not run as a service, if i run
just mysqld-max or mysqld-max-nt both start then terminate with no error
message on screen. However if I run mysqld-max* --console it runs just
Hello,
I have the following Mysql installed on a RH 7.1 PC:
mysql-server-3.23.36-1
mysql-3.23.36-1
mysql-devel-3.23.36-1
php-mysql-4.0.4pl1-9
mysqlclient9-3.23.22-4
unixODBC-mysql-2.0.7-1
If I try to start Mysql as root, as explained in:
http://www.mysql.com/doc/S/t/Starting_server.html
I get
(me looking down, ashamed...)
Of course Usual RH style. I know it and use it for many other
services, but for God knows which reason I just did not think about it
this time. Maybe because I only wanted to experiment, not use it as a
regular daemon to start at boot time every time..
Now it
/snip
any other idea ?
I even ran it with all options listed here in the log. I mean basedir,
tmpdir, ...
thanks,
Bastien.
-Original Message-
From: Chris Freeman [SMTP:[EMAIL PROTECTED]]
Sent: Saturday, May 19, 2001 3:07 PM
To: DEVOS BASTIEN
Subject: Re: mysql start failed
-Original Message-
From: Chris Freeman [SMTP:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 2:29 PM
To: DEVOS BASTIEN
Subject: Re: mysql start failed.
oops that was not quite right,
that was a mixture of starting the daemon and connecting to the server all
with one
: Monday, May 21, 2001 2:29 PM
To: DEVOS BASTIEN
Subject: Re: mysql start failed.
oops that was not quite right,
that was a mixture of starting the daemon and connecting to the server all
with one command, and would never have worked. I am very new to mysql, so
you will have
has it already started? ps -ef | grep mysql
- Original Message -
From: DEVOS BASTIEN [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 18, 2001 19:11
Subject: mysql start failed.
Here's a problem I have when trying starting mysql.
Config : RH7.0, MySQL 3.23.32, kernel2.4.3
: Friday, May 18, 2001 1:29 PM
To: DEVOS BASTIEN; [EMAIL PROTECTED]
Subject: Re: mysql start failed.
has it already started? ps -ef | grep mysql
- Original Message -
From: DEVOS BASTIEN [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 18, 2001 19:11
Subject: mysql
Hi...
i'd like to ask about
how to set MySQL start and stop automatically when machine reboot.
We are using Redhat 6.0 and MySQL 3.23.36
thankyou
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
35 matches
Mail list logo