Subject: Re: mysql_upgrade then mysqld. I feel very ID-10-T PEBKAC today
> 2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the
mysql.plugin table. Please run mysql_upgrade to create it.
> How do I run mysql_upgrade if the mysqld server won't start?
Please don't bother to ans
Am 23.02.2018 um 15:15 schrieb Bob Eby:
2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the
mysql.plugin table. Please run mysql_upgrade to create it.
How do I run mysql_upgrade if the mysqld server won't start?
post the *full* errorlog and watch for invaluid config stuff
most
2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the
mysql.plugin table. Please run mysql_upgrade to create it.
How do I run mysql_upgrade if the mysqld server won't start?
Man how stupid am I?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hello
I had to replace the datadisk where mysql had its innodb files.
But after I had added a new disk I'm not able to initialize mysql files any
more:
# mysqld --initialize --user=mysql
2015-12-23T13:07:08.216472Z 0 [ERROR] Plugin 'InnoDB' init function returned
error.
2015-12-23T13:07
Am 23.12.2015 um 14:11 schrieb Jørn Dahl-Stamnes:
I had to replace the datadisk where mysql had its innodb files.
But after I had added a new disk I'm not able to initialize mysql files any
more:
# mysqld --initialize --user=mysql
2015-12-23T13:07:08.216472Z 0 [ERROR] Plugin 'InnoDB' init
On Wednesday, December 23, 2015, Jørn Dahl-Stamnes wrote:
> Hello
>
> I had to replace the datadisk where mysql had its innodb files.
>
> But after I had added a new disk I'm not able to initialize mysql files any
> more:
>
> # mysqld --initialize --user=mysql
> 20
Have you changed the default mysqld port? Could you share with us the below
command output?
$ my_print_defaults mysqld
--
*Wagner Bianchi, MySQL Database Specialist*
Mobile: +55.31.8654.9510
E-mail: m...@wagnerbianchi.com
Twitter: @wagnerbianchijr
2014-09-04 4:33 GMT-03:00 Banerjee
Thanks a lot.
I changed rsh to ssh and things worked !
-somnath
From: shawn l.green [shawn.l.gr...@oracle.com]
Sent: Friday, September 05, 2014 8:21 PM
To: mysql@lists.mysql.com
Subject: Re: Getting error while launching mysqld
Hello Somnath,
On 9/4/2014
Hi,
We are getting following error while launching mysqld_safe in local machine.
Any help would be appreciated.
--
connect to address 127.0.0.1 port 544: Connection refused
connect to address 127.0.0.1 port 544: Connection refused
trying
to avoid problems, the number of
users/connections is constant
It is an automatic system but a few human users, a happy mix of myisam and
innodb tables running
with no problems on mysqld 5.0 . But now sometimes i am
hit with an insane increase hitting the ceiling at 60k. I do not like the
idea
Am 13.06.2013 12:07, schrieb Hartmut Holzgraefe:
On 06/13/2013 09:41 AM, walter harms wrote:
Hello Manuel,
thx for your tip. We caught the problem when we moved to partitions.
Strange is that
while testing the problem did not show up and even now we no clue why
we experience
the sudden
On 06/13/2013 09:41 AM, walter harms wrote:
Hello Manuel,
thx for your tip. We caught the problem when we moved to partitions. Strange is
that
while testing the problem did not show up and even now we no clue why we
experience
the sudden burst of use for file descriptors.
problem with
thread has
accessed every table on the machine
__
[root@localhost:~]$ lsof | grep mysqld | wc -l
471206
nobody but oracle knows why there are so much file handles
and this is MySQL 5.5.32
[--] Data in MyISAM tables: 481M (Tables: 4861)
[OK] Highest usage of available
Am 12.06.2013 12:03, schrieb walter harms:
i am trying to understand the incredible use of filepointers in our mysql
server (5.1.53).
under normal condition the server reports 10k-15k open files pointer
harmless :-)
[root@localhost:~]$ lsof | grep mysqld | wc -l
471206
nobody but oracle
is constant
It is an automatic system but a few human users, a happy mix of myisam and
innodb tables running
with no problems on mysqld 5.0 . But now sometimes i am
hit with an insane increase hitting the ceiling at 60k. I do not like the
idea to increase the
limit further because i do
@lists.mysql.com
Subject: Innodb, MySQL 5.5.28 - Would an incorrect setting in my.cnf
cause mysqld to randomly crash on high load?
We have a high-end server, 128GB RAM, 32 Core , Xeon, SSD RAID 10 -
running Ubuntu 12.04 with MySQL 5.5.28 . Doing random imports to large
InnoDB tables, over 50+ gigs, randomly
-
From: Tom [mailto:livefortheda...@gmail.com]
Sent: Wednesday, November 21, 2012 5:17 PM
To: mysql@lists.mysql.com
Subject: Innodb, MySQL 5.5.28 - Would an incorrect setting in my.cnf
cause mysqld to randomly crash on high load?
We have a high-end server, 128GB RAM, 32 Core , Xeon, SSD
--
121112 13:00:59 mysqld_safe Starting mysqld daemon with databases from
/usr/local/mysql/data
121112 13:00:59 [ERROR] An old style --language value with language
specific part detected: /usr/local/mysql/data/
121112 13:00:59 [ERROR] Use --lc-messages
On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu t...@cs.ucsd.edu wrote:
Hi, guys,
I'm new to MySQL. I installed MySQL step-by-step according to the manual
from source code. The version is mysql-5.5.28.
When I start the server using:
#bin/mysqld_safe --user=mysql
The server failed to start
/local,
/usr/local/mysql, /usr/local/mysql/data. The mysql user will need r-x
access to all of them.
I already did so. It's weird... From the log, it seems that mysqld
encountered some problem when reading the messagefile. But the file does
exist with permission.
2.
121112 13:00:59 [ERROR
/errmsg.sys
Check the permissions of all the dirs in that path: /usr, /usr/local,
/usr/local/mysql, /usr/local/mysql/data. The mysql user will need r-x
access to all of them.
I already did so. It's weird... From the log, it seems that mysqld
encountered some problem when reading the messagefile
i notice since this night all mysqld instances
suing innodb are running at very high CPU, there
is nothing in the mysqld-log and after restarting
the service the same again
i do not think this has to to with the reason taking
back 5.5.25 becasue no disk-IO, i more doubt this
has to do
Hi,
* On Sun, Jul 01, 2012 at 12:44:42PM +0200, Reindl Harald
h.rei...@thelounge.net wrote:
i notice since this night all mysqld instances
suing innodb are running at very high CPU, there
is nothing in the mysqld-log and after restarting
the service the same again
i do not think this has
, but not permamently
Am 01.07.2012 12:52, schrieb Raghavendra D Prabhu:
* On Sun, Jul 01, 2012 at 12:44:42PM +0200, Reindl Harald
h.rei...@thelounge.net wrote:
i notice since this night all mysqld instances
suing innodb are running at very high CPU, there
is nothing in the mysqld-log
I'll disagree with your disagreement.
Many web servers maintain persistent connections. This leads to
eventually exceeding max_connections, even if connections are rare.
Once he hits 41, he will be issuing 404s, or other bad stuff.
Also, having 1000 http threads hanging around is a waste
Am 29.03.2012 19:20, schrieb Rick James:
I'll disagree with your disagreement.
Many web servers maintain persistent connections.
this is a stupid idea for most workloads
i thought we are speaking about useful configured servers
persistent connections will not work on machines with
many
Hello:
We have a problem when we try to stop the mysql service (mysql Ver 14.14
Distrib 5.5.12, for Linux (x86_64) using readline 5.1) on a remote server
throught SSH.
The problem is that mysql_safe, start again mysqld before that mysql kill all
the connection and stop the process. So cannot
- Original Message -
From: AdmSA ad...@oepm.es
We have a problem when we try to stop the mysql service (mysql Ver
14.14 Distrib 5.5.12, for Linux (x86_64) using readline 5.1) on a
remote server throught SSH.
The problem is that mysql_safe, start again mysqld before that mysql
kill
Hey Guys
Yesterday I sent an email, about '1 client is using or hasn't closed the table
properly', but the problem is actually bigger than I realised.
We run Mysql replication, and on the second node, Mysql is crashing with
'mysqld got signal 6' every so often.
Other than the drives, we have
...@gmail.comwrote:
Hey Guys
Yesterday I sent an email, about '1 client is using or hasn't closed the
table properly', but the problem is actually bigger than I realised.
We run Mysql replication, and on the second node, Mysql is crashing with
'mysqld got signal 6' every so often.
Other than
Good day KarthiK.P.R
Other than the replication settings in '/etc/mysql/conf.d/replication.cnf' and
our /etc/mysql/conf.d/custom.cnf
xyz-web02:/data# cat /etc/mysql/conf.d/custom.cnf
[mysqld]
innodb_file_per_table
bind-address = 0.0.0.0
datadir = /data
binlog_format=mixed
key_buffer_size
Do you have 12GB of RAM?
Is this a 64-bit mysqld?
Let's see
SHOW VARIABLES LIKE '%buffer%';
SHOW GLOBAL STATUS LIKE 'Max%';
SHOW GLOBAL STATUS LIKE 'Up%';
What is Apache's MaxClients?
On 3/27/12 6:25 AM, Brent Clark wrote:
Good day KarthiK.P.R
Other than the replication settings
0139 11234
-/+ buffers/cache:586 11451
Swap: 2047 0 2047
Is this a 64-bit mysqld?
Linux hostname 2.6.32-5-amd64 #1 SMP Mon Jan 16 16:22:28 UTC 2012
x86_64 GNU/Linux
Let's see
SHOW VARIABLES LIKE '%buffer
0 2047
Is this a 64-bit mysqld?
Linux hostname 2.6.32-5-amd64 #1 SMP Mon Jan 16 16:22:28 UTC 2012
x86_64 GNU/Linux
Let's see
SHOW VARIABLES LIKE '%buffer%';
+-+-+
| Variable_name | Value
Am 27.03.2012 23:24, schrieb Rick James:
MaxClients 1000
could overwhelm max_connections = 41 . Strongly recommend you decrease
MaxClients to less than max_connections
(not the other way around).
totally wrong!
not every http-connection implies a myql-connection
a website
To: mysql@lists.mysql.com
Sent: Monday, 16 January, 2012 12:37:07 PM
Subject: help! mysqld cannot start!
I have download the
Linux - Generic 2.6 (x86, 32-bit), Compressed TAR Archive
binary edition
and I installed it all followed the INSTALL_BINARY
but at last step I start
the MySQL own files are. The flag
-b (--basedir) is used for that. It works also to start mysqld in the
directory where the default my.cnf was left. If that has everything that
MySQL needs, it works also to start with --defaults-file=/my.cnf--the
four dots stand for the rest of the full pathname
=mysql
I got following error message
cifer@Pig:/usr/local/mysql$ 120116 19:15:28 mysqld_safe Logging to
'/var/log/mysql/error.log'.
120116 19:15:28 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
120116 19:15:30 mysqld_safe mysqld from pid file /var/lib/mysql/Pig.pid
Dear all,
I am facing the below problem while installing mysql in a debian based
system from the last 2 days.
I tried the command apt-get install mysql-server but the server doesn't
start properly due to below exception in /var/log/syslog
41 [ERROR] /usr/sbin/mysqld: Can't find file
install mysql-server but the server doesn't
start properly due to below exception in /var/log/syslog
41 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno:
13)
Mar 14 10:36:41 sun-cloud mysqld[3500]: ERROR: 1017 Can't find file:
'./mysql/user.frm' (errno: 13)
Mar 14 10:36:41
, October 02, 2010 5:18 AM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: RE: Any way to change timezone WITHOUT mysqld restart?
As a matter of fact I did, the real question is : Did you even read my
email? I said WITHOUT a restart...
The manual states that a restart of the mysqld is required
with
this statement:
On Sat, Oct 2, 2010 at 2:18 PM, Bryan Cantwell bcantw...@firescope.comwrote:
As a matter of fact I did, the real question is : Did you even read my
email? I said WITHOUT a restart...
The manual states that a restart of the mysqld is required. The reason
for the post to such a list
As a matter of fact I did, the real question is : Did you even read my
email? I said WITHOUT a restart...
The manual states that a restart of the mysqld is required. The reason
for the post to such a list is because on many occasions, user have
suggestions on some workaround for things that do
Any way to change timezone WITHOUT mysqld restart?
It would be a lifesaver if there were some way for me not to have to
restart because if mysql restarts then I have to go through a lot of
other issues with my other apps.
Did you even look at the manual?
http://lmgtfy.com/?q=mysql+set+timezone
First link.
-Original Message-
From: Bryan Cantwell [mailto:bcantw...@firescope.com]
Sent: Friday, October 01, 2010 10:25 AM
To: mysql@lists.mysql.com
Subject: Any way to change tinezone WITHOUT mysqld
On Fri, Aug 20, 2010 at 10:09 PM, Tom Kleinpeter tomkleinpe...@gmail.comwrote:
I've been watching our mysqld procs in htop and the root thread is
using 75-100% of a CPU most of the time. I'm trying to understand
what that is being used for, and so I was hoping someone could tell me
what
I've been watching our mysqld procs in htop and the root thread is
using 75-100% of a CPU most of the time. I'm trying to understand
what that is being used for, and so I was hoping someone could tell me
what that thread does that might be using a lot of CPU.
We are using 5.5.4-m3, we use MyISAM
As soon as mysqld starts it goes 100% cpu. I can stop it, there is no
mysql_safe running, and I ran
mysqlcheck -A -a -c -o -g --auto-repair -u root -p
all is ok, syslog shows nothing important but I can't login to any account
with
mysql client it just sits there, using php it times out
Hi
My mysql server suddenly crashed. Not it does not start and dumps the
following stack trace. I suspect some table corruption. Please help me to
start it.
mysql@lists.mysql.comstack_bottom = (nil) thread_stack 0x4
/usr/sbin/mysqld(my_print_stacktrace+0x24) [0x84fd84]
/usr/sbin/mysqld
Jörg, thanks again for your help and your patience with this issue. You
also caught oversights with strace and clarified that this is not a PATH
issue.
I've filed it at:
http://bugs.mysql.com/bug.php?id=53667
You don't state it explicitly, but I take your text to mean
If the MySQL tools are
. For example, I am
trying to install it in /tmp/msource with the configure line:
./configure --prefix=/tmp/msource --exec-prefix=/tmp/msource
--bindir=/tmp/msource/bin --sbindir=/tmp/msource/sbin
--localstatedir=/tmp/msource/lib --sysconfdir=/tmp/msource
--enable-assembler --with-mysqld-ldflags=-all
21:53:35 [ERROR] /tmp/msource/libexec/mysqld: unknown option
'--skip-bdb'
... even after I manually search for the location where this flag is
passed, and manually edit that source to never issue it.
[[...]]
I am surprised to see that option still occurring in a file in 5.1, that
looks wrong
On Fri, 2010-05-14 at 10:28 +0200, Joerg Bruehe wrote:
The following error just won't go away:
100513 21:53:35 [ERROR] /tmp/msource/libexec/mysqld: unknown option
'--skip-bdb'
... even after I manually search for the location where this flag is
passed, and manually edit that source
Kris wrote:
Hello,
I am trying to produce an automated, reliable, and repeatable way of
testing mysql releases, and I am finding an error that makes this
impossible to accomplish.
I am trying to compile mysql and install it in a non-standard directory.
I do notwant mysql installed in /usr or
Kris, all,
Kris wrote:
On Fri, 2010-05-14 at 10:28 +0200, Joerg Bruehe wrote:
The following error just won't go away:
100513 21:53:35 [ERROR] /tmp/msource/libexec/mysqld: unknown option
'--skip-bdb'
... even after I manually search for the location where this flag is
passed, and manually
...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/tmp/msource/bin/mysqladmin -u root
Do not install software in /tmp in Linux.
/tmp is not guaranteed to survive a reboot.
Thank you for the heads up. Well... there is *another* bug
where if one specifies in their my.cnf filepaths that are over 100 characters,
the filenames are truncated at 100, hence making it impossible to really
Hi Kris, all,
Kris wrote:
Joerg, thanks again for the help.
I disagree with you.
that's perfectly fine - combining our two different viewpoints, we will
be able to show more of the issue at hand than from one point alone.
I doubt many more users try to create a clean test installation
Hi *
mysqld process consuming more 100% of cpu usage and execution time also very
high.
1. how to reduce CPU?
2. why mysqld process consuming high cpu utilization?
3. Wether need to fine tune sql application. then how to use plan table in
mysql?
4. which storage engine is better for transaction
what is your my.cnf setting.
Also did u check slowquery.log for any sql's not using index or not using
the right index.
On Mon, Jan 11, 2010 at 1:21 PM, F.A.I.Z.A.L sac.fai...@gmail.com wrote:
Hi
mysqld process taking high cpu utilization (100%), how to reduce the cup
utilization
Hi Kumar,
thanks for your reply.. here is my my.cnf file. i don't see anything here.
what is this slowquery.log?, where it will be?
---
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using
looks like u have not setup slow query log parameter.
If this is a non-production db, shut it down and add this parameter, unser
[mysqld]
log-slow-queries = /var/lib/slowqueries.log.
Or execute
SHOW ENGINE STATUS\G;
You will get to know what all activities are going on ur db and check
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Mon, Jan 11, 2010 at 3:27 PM, Ananda Kumar anan...@gmail.com wrote:
looks like u have not setup slow query log parameter.
If this is a non-production db, shut it down and add this parameter, unser
[mysqld]
log-slow-queries
parameter.
If this is a non-production db, shut it down and add this parameter, unser
[mysqld]
log-slow-queries = /var/lib/slowqueries.log.
Or execute
SHOW ENGINE STATUS\G;
You will get to know what all activities are going on ur db and check if
there is any IO contention happening
@lists.mysql.com
Subject: mysqld occupies 100$ cpu
Hi
mysqld process taking high cpu utilization (100%), how to reduce the cup
utilization
it is running under solaris 8 with 16GB ram and 1 multicore cpu (2 core)
anyone help please?
Cheers
Faizal S
GSM : 9840118673
Blog: http
Hi
mysqld process taking high cpu utilization (100%), how to reduce the cup
utilization
it is running under solaris 8 with 16GB ram and 1 multicore cpu (2 core)
anyone help please?
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
I'm trying to get started with running mysqld but I can't set up the
data directory. Any hints? Thanks in advance. Details follow:
$ uname -a
Linux hammer.csail.mit.edu 2.6.27.35-170.2.94.fc10.x86_64 #1 SMP Thu
Oct 1 14:41:38 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
$ mysql/bin/mysqld --version
Dear All,
Can anyone brief me about this error. I am unable to start the mysql so
please suggest me work around on how to fix this error.
I am installing mysql Ver 14.14 Distrib 5.1.38, for pc-linux-gnu (i686)
using readline 5.1
[ERROR] /usr/sbin/mysqld: unknown option '--ndbcluster
Edit your /etc/my.cnf file and remove the option.
Regards,
Gavin Towey
-Original Message-
From: Manoj Burande [mailto:manoj.bura...@artificialmachines.com]
Sent: Friday, September 18, 2009 7:17 AM
To: mysql@lists.mysql.com
Subject: [ERROR] /usr/sbin/mysqld: unknown option '--ndbcluster
I've been trying to make mysqld write a coredump following a crash, and
this morning I finally succeeded - according to mysqld.log anyway. It
clearly says Writing a core file - but where to? I've checked the
datadir /var/lib/mysql, whereelse might it be?
/Per Jessen, Zürich
--
MySQL General
Hi,
mysqld is not writing to err-log and i do not see any log generated upon
mysql service restart.
In my.cnf
=
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=16384
r...@server[~]# ll /var/log/mysqld.log
-rw-r--r-- 1 mysql root 0 Nov 24
It is probably writing to syslog. Try cat /var/log/messages | grep -i
mysqld to search for entries made by mysqld.
Walter
On Tue, Jun 16, 2009 at 11:48 AM, Madan Thapamadan.feedb...@gmail.com wrote:
Hi,
mysqld is not writing to err-log and i do not see any log generated upon
mysql service
On Wed, Jun 17, 2009 at 12:21 AM, lists-mysql
replies-lists-b3z1-my...@listmail.innovate.net wrote:
This might be an issue of permissions (/var/log is controlled by
root). So, you might try touch-ing /var/log/mysqld.log and setting
ownership to mysql.mysql. Then [re-]start mysqld and see
Thanks Eric, it worked.
=
On Tue, Jun 16, 2009 at 11:55 PM, Eric Bergen eric.ber...@gmail.com wrote:
Madan,
Try:
[mysqld]
log_error=/var/log/mysqld.log
On Tue, Jun 16, 2009 at 10:48 AM, Madan Thapamadan.feedb...@gmail.com
wrote:
Hi,
mysqld is not writing
Hi,
I must call a routine when mysqld start (to populate a heap table). I
did not find any related options in mysqld --help --verbose. Is there a
way to achieve this, without modifying the startup script ?
Thanks in advance.
--
MySQL General Mailing List
For list archives: http
There's an option called init-file that will invoke an sql script on start
up. That would probably work for you.
On Mon, Jun 15, 2009 at 5:17 AM, Gabriel Linder lin...@jeuxvideo.comwrote:
Hi,
I must call a routine when mysqld start (to populate a heap table). I
did not find any related
On Mon, 15 Jun 2009 10:00:00 -0400
Jim Lyons jlyons4...@gmail.com wrote:
There's an option called init-file that will invoke an sql script
on start up. That would probably work for you.
Thanks you, that is what I was searching for. I guess I should clean my
glasses :)
--
MySQL General
it is production I can't do
too much on the host itself and I have limited ability to reproduce.
Here is what the crash looks like:
Version: '4.1.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source
distribution
mysqld got signal 11;
This could be because you hit a bug. It is also possible
/mysql.sock' port: 3306 Source
distribution
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We
Quoth Walter Heck li...@olindata.com:
You could bring it down, but the real question is if you really want
to do that? Making the buffers and caches smaller will reduce the
memory used, but it also reduces performance.
Noted.
Could you tell us what you are hoping to use MySQL for and why you
Quoth wult...@gmail.com:
Through your conf file(s) you have told MySQL how much memory it may
consume. As long as the server does not go beyond what it is told it
may consume it is not doing anything wrong.
Thanks. I'll have a look in the conf file. At the moment it's running
as it came out
...@smolny.plus.com wrote:
Hi all,
I recently installed MySQL (version 5.0) on my Debian Lenny VPS and
mysqld uses 14.3% of memory when idle.
Is this a known issue?
I'm aware that version 5.0 is not the latest version but it's the one
currently shipped by Debian Lenny (testing) so I'm loathe
of RAM so mysqld is using about ~ 21 MB when
idle.
Sebastian
--
Emacs' AlsaPlayer - Music Without Jolts
Lightweight, full-featured and mindful of your idyllic happiness.
http://home.gna.org/eap
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Hi all,
I recently installed MySQL (version 5.0) on my Debian Lenny VPS and
mysqld uses 14.3% of memory when idle.
Is this a known issue?
I'm aware that version 5.0 is not the latest version but it's the one
currently shipped by Debian Lenny (testing) so I'm loathe to 'manually'
install a later
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Sun, Feb 1, 2009 at 2:35 PM, Sebastian Tennant
seb...@smolny.plus.com wrote:
Hi all,
I recently installed MySQL (version 5.0) on my Debian Lenny VPS and
mysqld uses 14.3% of memory when idle
Hello List,
mysqld fails to start, and emits the following
error messages in /var/log/mysqld.log
090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090127 10:00:30 [ERROR] Can't open the mysql.plugin
Hello JD,
You need to look beyond the first error messages:
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090127 10:00:30 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
but keep reading:
090127 10:00:30 InnoDB: Operating system error number 13
.) Make sure this is done, then MySQL will start, then you can run
mysql_upgrade.
HTH,
Andy
JD wrote:
Hello List,
mysqld fails to start, and emits the following
error messages in /var/log/mysqld.log
090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
/usr
JD wrote:
Hello List,
mysqld fails to start, and emits the following
error messages in /var/log/mysqld.log
090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090127 10:00:30 [ERROR] Can't open
I am running as root.
I dont understand what rights or permissions mysqld needs
beyond those of root. Also, ./ibdata1 is relative to what path?
I get this message no matter what dir is my current working dir.
I searched in my home dir and in /root home dir. There is no such
file or directory
. The second
error is the one about InnoDB not having access rights to the directory.
Check that /var/lib/mysql is writeable by the MySQL user (usually
MySQL.) Make sure this is done, then MySQL will start, then you can
run mysql_upgrade.
HTH,
Andy
JD wrote:
Hello List,
mysqld fails
, then you can
run mysql_upgrade.
HTH,
Andy
JD wrote:
Hello List,
mysqld fails to start, and emits the following
error messages in /var/log/mysqld.log
090127 10:00:30 mysqld_safe Starting mysqld daemon with databases
from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't
will start, then you can
run mysql_upgrade.
HTH,
Andy
JD wrote:
Hello List,
mysqld fails to start, and emits the following
error messages in /var/log/mysqld.log
090127 10:00:30 mysqld_safe Starting mysqld daemon with databases
from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't
Ah, try this:
chmod ug+rw ibdata1 and the same for your iblogfile0 and iblogfile1 files..
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Wed, Jan 28, 2009 at 12:48 AM, JD jd1...@gmail.com wrote:
ls -altr /var/lib/mysql
--
, then MySQL will start, then you can run
mysql_upgrade.
HTH,
Andy
JD wrote:
Hello List,
mysqld fails to start, and emits the following
error messages in /var/log/mysqld.log
090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
/usr/libexec/mysqld: Table
mysql mysql 2048 2007-12-17 00:03 user.MYI
-rw-rw-r-- 1 mysql mysql 4096 2007-12-17 00:03 db.MYI
drwxrwxr-x 2 mysql mysql 4096 2009-01-21 14:12 ./
-rw-rw 1 mysql mysql 12288 2009-01-21 14:12 .swp
drwxrwxr-x 5 mysql mysql 4096 2009-01-27 16:35 ../
I restarted mysqld (service mysqld
I stopped mysqld.
I removed those logfiles
I did not copy any databe between servers.
I only have one machine. I would not even know
what to copy, as I know nothing about databases.
I have no idea where the .pid and the .err files
came from.
I restarted the daemon, and this is what it wrote
OK, I located a weblog on how to change the password
and it worked.
I then stopped and started the serever, and this is what it belched out
in the mysqld.log:
090127 18:17:16 [Note] /usr/libexec/mysqld: Normal shutdown
090127 18:17:16 InnoDB: Starting shutdown...
090127 18:17:17 InnoDB
:
090127 18:17:16 [Note] /usr/libexec/mysqld: Normal shutdown
090127 18:17:16 InnoDB: Starting shutdown...
090127 18:17:17 InnoDB: Shutdown completed; log sequence number 0 44044
090127 18:17:17 [Note] /usr/libexec/mysqld: Shutdown complete
090127 18:17:17 mysqld_safe mysqld from pid file
at 3:21 AM, JD jd1...@gmail.com wrote:
OK, I located a weblog on how to change the password
and it worked.
I then stopped and started the serever, and this is what it belched out in
the mysqld.log:
090127 18:17:16 [Note] /usr/libexec/mysqld: Normal shutdown
090127 18:17:16 InnoDB: Starting
1 - 100 of 1405 matches
Mail list logo