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'
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 s
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.co
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
&g
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 'In
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.
2
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
Hello Somnath,
On 9/4/2014 3:33 AM, Banerjee, Somnath wrote:
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
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
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 normal
is unlikely that in 3 days avery 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:
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 partit
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
>
.
>> I run a 'flush tables' every 2h 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 someti
er 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 to i
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
n
ssage-
>> 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?
>>
>&g
t; 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 RAID 10 -
> running Ubuntu 12.04 with MySQL 5.5.28 . Doing random imports to large
>
ocal/mysql/data/errmsg.sys
>> >
>> > I'm confused because I do have this file which is owned by user "mysql":
>> >
>> > #ll /usr/local/mysql/data/errmsg.sys
>> > -rw-r--r-- 1 mysql mysql 0 Nov 12 12:35 /usr/local/mysql/data/errmsg.sys
&g
ll /usr/local/mysql/data/errmsg.sys
> > -rw-r--r-- 1 mysql mysql 0 Nov 12 12:35 /usr/local/mysql/data/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
On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu 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 with the fo
ake a look at the error log?
Thanks a lot!
T
--
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
teresting CPU spikes, 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
> wrote:
>> i notice since this night all mysqld instances
>> suing innodb are running at very high CPU, there
>
Hi,
* On Sun, Jul 01, 2012 at 12:44:42PM +0200, Reindl Harald
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 to to with the reason
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 with the
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
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 wh
- Original Message -
> From: "AdmSA"
> 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 bef
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
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 ty
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 |
+-+-+
| bulk_ins
139 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 VARIAB
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
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_b
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'
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
sudo bin/mysqld_safe --user=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
> 1201
t;<<<<<<
Your means of starting does not show where 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
My
;mantianyu"
> 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
ommand 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: './mysql/user.frm' (errno:
> 13)
> Mar 14 10:36:41 sun-cloud mysqld[3500]: ERROR: 1017 Can't fin
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
...
http://www.ferdychristant.com/blog//archive/DOMM-84NEJN
_
From: Bryan Cantwell [mailto:bcantw...@firescope.com]
Sent: Saturday, 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 fa
e zone value at runtime with
> this statement:
>
On Sat, Oct 2, 2010 at 2:18 PM, Bryan Cantwell wrote:
> 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
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
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
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.
ug 20, 2010 at 10:09 PM, Tom Kleinpeter wrote:
> 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 doe
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
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 time
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.
stack_bottom = (nil) thread_stack 0x4
/usr/sbin/mysqld(my_print_stacktrace+0x24) [0x84fd84]
/usr/sbin/mysqld(handle_segfault+0x320
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
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 installa
>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
nt* from the paths one specifies in the ./configure line. To me
this seems wrong.
To verify this, after I remove /etc/mysql/my.cnf, installing the tables
works:
+++=
$ /tmp/msource/bin/mysql_install_db --basedir=/tmp/msource
--datadir=/tmp/msource/data
Installing MySQL system tables.
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'
>>>
>>&
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 /u
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 l
fails:
>
> [[...]]
>
> 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
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
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
gt;To: mysql@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?
>
&g
t 3:27 PM, Ananda Kumar 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 = >
>> Or execute
>> SHOW ENGINE STAT
27;
what i have to do now?
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Mon, Jan 11, 2010 at 3:27 PM, Ananda Kumar 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
>
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 = wrote:
> Hi Kumar,
>
> thanks for your reply.. here is my my.cnf file. i don't see anything here.
> what is this slowque
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
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 wrote:
> Hi
>
> mysqld process taking high cpu utilization (100%), how to reduce the cup
> utilization
>
&
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
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 '--ndbcl
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 &#x
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 Jesse
Thanks Eric, it worked.
=
On Tue, Jun 16, 2009 at 11:55 PM, Eric Bergen wrote:
> Madan,
>
> Try:
>
> [mysqld]
> log_error=/var/log/mysqld.log
>
>
>
> On Tue, Jun 16, 2009 at 10:48 AM, Madan Thapa
> wrote:
> > Hi,
> >
> >
d.log
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.
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 Thapa wrote:
> Hi,
>
> mysqld is not writing to err-log and i do not see any log generated upon
> mysql ser
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
On Mon, 15 Jun 2009 10:00:00 -0400
Jim Lyons 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 Mailing List
For list
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 wrote:
> Hi,
>
> I must call a routine when mysqld start (to populate a heap table). I
> did not find an
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
this? Since 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
> dist
.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 that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also
Sorry. My VPS has 144 MB 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
stian Tennant
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 shi
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 ou
Quoth Walter Heck :
> 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
> wanna bring
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Sun, Feb 1, 2009 at 2:35 PM, Sebastian Tennant
wrote:
> Hi all,
>
> I recently installed MySQL (version 5.0) on my Debian Lenny VPS and
> mysqld uses 14.3% of memory when idle.
&
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 'manua
Hey... Thanks a *LOT Walter!!!* *It WORKED!!!*
The mysqld.log file now says:
090127 19:16:10 [Note] /usr/libexec/mysqld: Normal shutdown
090127 19:16:10 InnoDB: Starting shutdown...
090127 19:16:10 InnoDB: Shutdown completed; log sequence number 0 44044
090127 19:16:10 [Note] /usr/libexec
ous with mysql. Depending on the
>> distro you are using, it can be as simple as yum remove mysql and yum
>> install mysql (removing /var/lib/mysql in between). Your choice though
>> :)
>>
>> good luck!
>>
>> Walter
>>
>> can you try running mys
pgrade
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Wed, Jan 28, 2009 at 3:21 AM, JD 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 b
s 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: Shutdown completed; log sequence number 0 44044
> 090127 18:17:17 [Note] /usr/libexec/mysqld: Shutdown
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
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 into
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 believe the error about mysql.plugin is a red herring - it needs
>>>> fixing, but it's not the reason MySQL isn't starting. The second error is
>>>> the one about InnoDB not having access rights to the directory.
>>>>
>>
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 wrote:
> ls -altr /var/lib/mysql
--
MySQL General
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.
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.
t starting. 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,
mysql
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
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]
1 - 100 of 1458 matches
Mail list logo
