On Mon, Nov 12, 2012 at 1:47 PM, Tianyin Xu wrote:
> Hi, Larry,
>
> Thanks a lot for the reply!
>
>
> On Mon, Nov 12, 2012 at 1:27 PM, Larry Martell wrote:
>
>> 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
Hi, Larry,
Thanks a lot for the reply!
On Mon, Nov 12, 2012 at 1:27 PM, Larry Martell wrote:
> 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.
>
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
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 before that mysql
> kill all th
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
MaxClients 1000
could overwhelm max_connections = 41 . Strongly recommend you decrease
MaxClients to less than max_connections (not the other way around).
Uptime| 18492
Not very long to see stuff.
| innodb_buffer_pool_size | 8388608 |
| key_buffer_size | 8
Hi Rick
Thank you for replying.
Please see my answers to your questions.
On Tue, Mar 27, 2012 at 7:58 PM, Rick James wrote:
> Do you have 12GB of RAM?
total used free sharedbuffers cached
Mem: 12038 11959 78 0139 1
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 in '/e
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=8
HI Brent,
Can you please paste your configuration file settings (my.cnf) ? It will
help to identify where things went wrong.
Is there any other memory consuming application running on the server
beyond mysql ?
Regards,
KarthiK.P.R
On Tue, Mar 27, 2012 at 4:17 PM, Brent Clark wrote:
> Hey Guy
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
>-Original Message-
>From: F.A.I.Z.A.L [mailto:sac.fai...@gmail.com]
>Sent: Monday, January 11, 2010 2:51 AM
>To: mysql@
SHOW ENGINE innodb STATUS\G
On Mon, Jan 11, 2010 at 3:35 PM, F.A.I.Z.A.L wrote:
> i try this
> mysql> SHOW ENGINE STATUS\G;
> ERROR 1286 (42000): Unknown table engine 'STATUS'
> ERROR:
> No query specified
>
> after setting the parameter in my.cnf which u provided. it is not showing
>
> mysql> s
i try this
mysql> SHOW ENGINE STATUS\G;
ERROR 1286 (42000): Unknown table engine 'STATUS'
ERROR:
No query specified
after setting the parameter in my.cnf which u provided. it is not showing
mysql> show engine status;
ERROR 1286 (42000): Unknown table engine 'status'
what i have to do now?
Cheer
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 slowquery.log?, where it
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 th
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
>
> it is running under so
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,
> >
> > mysqld is not writing to err-log and i do not see an
Hi Rick,
It was't a permission issue though. I did compare with another server, that
had the same thing working.
[r...@server1 mysql]# ls -lh /var/log/mysqld.log
-rw-r--r-- 1 mysql root 60M Jun 16 18:40 /var/log/mysqld.log
[r...@server1 mysql]# grep err-log /etc/my.cnf
err-log=/var/log/mysqld.lo
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 service restart.
>
>
> In my.
Quoth Baron Schwartz :
> So I assume you have a terabyte of RAM in the server, since you didn't
> say... OMG, it's using 143GB of RAM when it's idle? Wow..
>
> :-) You need to provide some more details here. I can't judge
> whether there is any issue at all.
Sorry. My VPS has 144 MB of RAM so
So I assume you have a terabyte of RAM in the server, since you didn't
say... OMG, it's using 143GB of RAM when it's idle? Wow..
:-) You need to provide some more details here. I can't judge
whether there is any issue at all.
Baron
On Sun, Feb 1, 2009 at 8:35 AM, Sebastian Tennant
wrote:
> H
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
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.
Could you tell us what you are hoping to use MySQL for and why you
wanna bring the memory usage down?
Walter
OlinDa
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/mysq
Actually, just restarting the server should do the trick. It seems
like mysql_upgrade did it's job correctly.
Can you restart teh server and check the logs?
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Wed, Jan 28, 2009 at 4:
Problem with yum remove mysql is that it will also remove all it's
dependents,
whereas yum install mysql will not restore the dependents.
Also, you are probably right re: 5.0.x and 5.1.x
At anywho, I ran:
}# mysql_upgrade --user=root --password='theNewPassword'
Looking for 'mysql' as: mysql
mysql.user is a table name, it is in the form of database_name.table_name.
Mysql has a "system database" conveniently called mysql :)
> 090127 18:17:18 [ERROR] Column count of mysql.db is wrong. Expected 22, found
> 20. Created with MySQL 50045, now running 50130. Please use mysql_upgrade to
> f
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: Shu
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
I did the chmod. Then
# ls -latrR /var/lib/mysql
/var/lib/mysql:
total 20548K
drwxrwxr-x 2 mysql mysql 4096 2007-12-15 15:36 test/
-rw-rw-r-- 1 mysql mysql 5242880 2007-12-15 15:36 ib_logfile1
drwxrwxr-x 2 mysql mysql 4096 2007-12-15 16:10 ampache/
drwxrwxr-x 2 mysql mysql 4096 20
Hi JD,
just try a simple thing,
rm /var/lib/mysql/ib_logfile1
rm /var/lib/mysql/ib_logfile2
to remove the innodb log files, sometimes you can have this problems,
did you copy the database between servers?
where are the .pid and .err files?
Claudio
2009/1/28 JD
> ls -altr /var/lib/mysql
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
ls -altr /var/lib/mysql
total 20548K
drwxr-xr-x 2 mysql mysql 4096 2007-12-15 15:36 test/
-rw-r--r-- 1 mysql mysql 5242880 2007-12-15 15:36 ib_logfile1
drwxr-xr-x 2 mysql mysql 4096 2007-12-15 16:10 ampache/
-rw-r--r-- 1 mysql mysql 10485760 2007-12-17 00:03 ibdata1
drwxr-xr-x 2 mysq
JD,
please post the ouput from:
ls -altr /var/lib/mysql
thanks
Claudio
JD wrote:
Deamon runs as root.
ls -ld /var/lib/mysql/
drwxr-xr-x 5 mysql mysql 4096 2009-01-27 10:00 /var/lib/mysql/
So what other perms does root need?
Andy Shellam wrote:
Hi JD,
I believe the error about mysql.
Deamon runs as root.
ls -ld /var/lib/mysql/
drwxr-xr-x 5 mysql mysql 4096 2009-01-27 10:00 /var/lib/mysql/
So what other perms does root need?
Andy Shellam wrote:
Hi JD,
I believe the error about mysql.plugin is a red herring - it needs
fixing, but it's not the reason MySQL isn't starting.
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 cal
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 the mysql
Hi JD,
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.
Check that /var/lib/mysql is writeable by the MySQL user (usually
MySQL.) Make
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
I have 675 files with extension .log I do not have a master.log or a
bootstrap.log. I also cannot find a log subdirectory anywhere within MySQL.
What I did find is a file called YOUR-randomnumbers.err in C:\Program
Files\MySQL\MySQL Server 5.0\data\
When I ran the wizard, there was no defau
Hi.
I think you had a mistake for the server types.Mysql-nt.exe is the only
exexutable program on windows.So you just pay close attention about it.
On Mon, Oct 6, 2008 at 8:35 PM, Steven <[EMAIL PROTECTED]> wrote:
> > Steve
> (n)
> Martin!
>
>
> > if you want apache and mysql (and possibly PHP
> Steve
(n)
Martin!
> if you want apache and mysql (and possibly PHP for scripting) AND you want
> all 3 to run at once
> then d/l and implement with XAMP
> there are alot of XAMP specific bells and whistles that are installed that
> get in the way of tuning your MySQL and tuning your Apache inst
Andy!
Even Installing as a service and choosing Server Machine as Server type
does not install mysqld the settings I used are as follows. I even did a
search in the C drive
SetUp Type
Complete
The configuration choices made running Configuration Wizard
1Configuration Type
Detailed
2 S
Varuna,
Please also remember to copy the list back in to your response so others
can follow your steps if they're having trouble.
As I said in my e-mail, I would recommend installing as a Windows
service (you said in your e-mail that "Install as a Windows service" was
unchecked.) I don't us
Varuna,
A polite note - if you post the same question 6 times (especially in the
space of 24 hours) people are going to be more unlikely to help you.
Post the question once, and read people's responses.
Now onto your issues...
When you run "mysqld-nt" you were starting a standalone version
Hello Steven
I have installed it as an service, I first stopped the service form the
Service Control Manager and I went to the directory "C:\Program
Files\MySQL\MySQL
> Server 5.0\bin" ran the command "mysqld" --console.
and out put was
C:\Program Files\MySQL\MySQL Server 5.0\bin>"mysqld" --con
Good Morning!
2008/10/5 Varuna Seneviratna <[EMAIL PROTECTED]>:
> Hello Everybody
>
> 2 What is the difference between installing MySQL as a server and a service,
> Is it only that when installed as a service MySQL server starts when Windows
> starts and when Windows stops it stops?
That
Hi,
Thanks for your input. Yes I can logon to the server and I will try this
command next time it hangs. Will let you know what I see.
Best regards,
Andreas
---
On Sat, Aug 23, 2008 at 5:32 PM, Johnny Withers <[EMAIL PROTECTED]>wrote:
> There are all kinds of logs mysql will produce. You should
Joerg Bruehe wrote:
Yes, it does announce.
I wrote "any external event ... that Windows *would* monitor"
(emphasis added): Does the Windows ServiceManager really know which
file to monitor for which entry to announce the service as "running" ?
see below.
in practice we find the service co
Hi Les, all,
sorry - I attended to other things more than to this thread.
Les Schaffer wrote:
Joerg Bruehe wrote:
I assume Windows reports the status as "running" when the process(es)
got started, but that doesn't necessary imply they have passed their
own initialization / startup phase.
Joerg Bruehe wrote:
I assume Windows reports the status as "running" when the process(es)
got started, but that doesn't necessary imply they have passed their
own initialization / startup phase.
I doubt there is any external event (say, a file creation or some
such) that Windows would monit
Hi Les, all !
Les Schaffer schrieb:
[[...]]
perhaps i wasn't clear earlier. we checked the logs, and we see that
Innodb is started and accepting connections sometimes 1-6 seconds AFTER
we see the Windows ServiceManager report that the MySQL service is in
state SERVICE_RUNNING.
we had thou
Sebastian Mendel wrote:
did you take a look add the MySQL log?
there you can see what MySQL is doing, with times
perhaps i wasn't clear earlier. we checked the logs, and we see that
Innodb is started and accepting connections sometimes 1-6 seconds AFTER
we see the Windows ServiceManager repo
>-Original Message-
>From: Les Schaffer [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, June 04, 2008 9:23 PM
>To: mysql@lists.mysql.com
>Subject: mysqld-nt Windows service: delay btwn svc running and accepting
>conx
>
>We are having a small technical glitch about which we would like to have
>s
Les Schaffer schrieb:
We are having a small technical glitch about which we would like to have
some insight:
our application needs to start mysqld-nt as a Windows service after
which we fairly quickly try to make connections to the Server. we are
using the python wrappers, MySQLdb, and we suc
* Wolfram Schlich <[EMAIL PROTECTED]> [2008-02-05 15:50]:
> Hi,
>
> I have a MySQL 5.0.54 instance with a 5.0.22 datadir from a corrupted
> filesystem, backed up what was readable and am now trying to get it
> back to life. Unfortunately, mysqld segfaults on startup:
> [...]
> What should I do nex
On Dec 12, 2007, at 8:03 PM, jekillen wrote:
On Dec 12, 2007, at 6:41 PM, Ken Menzel wrote:
- Original Message - From: "Chris" <[EMAIL PROTECTED]>
To: "jekillen" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, December 11, 2007 9:12 PM
Subject: Re: mysqld s
On Dec 12, 2007, at 6:41 PM, Ken Menzel wrote:
- Original Message - From: "Chris" <[EMAIL PROTECTED]>
To: "jekillen" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, December 11, 2007 9:12 PM
Subject: Re: mysqld startup failure
jekillen wrote:
Hello:
Th
- Original Message -
From: "Chris" <[EMAIL PROTECTED]>
To: "jekillen" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, December 11, 2007 9:12 PM
Subject: Re: mysqld startup failure
jekillen wrote:
Hello:
The saga of this machine continues:
FreeBSD v6.2
lat
jekillen wrote:
Hello:
The saga of this machine continues:
FreeBSD v6.2
latest mysql version installed from ports:
mysql51 client, serve, and scripts.
There is no /usr/local/mysql
it did not create this dir.
No idea where it should put the files, a freebsd list might be able to
point you in th
Chris Africa wrote:
Hi Gerald.
Actually, mysql should have access, as it owns the entire directory.
drwxr-xr-x 19 mysql wheel 646 May 30 09:41
mysql-5.0.41-osx10.4- i686
and nested inside that is
drwxr-x--- 27 mysql wheel918 Jul 18 12:53 data
Thanks!
Error 13 is a permi
You have bin log enabled and it might be looking for the last bin log before
the last shutdown
('/usr/local/mysql-5.0.41-osx10.4-i686/data/me-web2-bin.27')
You can either:
- move the missing binlog file where mysql is looking for it
- delete the $hostname.index file that keeps track of binlo
Hi Gerald.
Actually, mysql should have access, as it owns the entire directory.
drwxr-xr-x 19 mysql wheel 646 May 30 09:41 mysql-5.0.41-osx10.4-
i686
and nested inside that is
drwxr-x--- 27 mysql wheel918 Jul 18 12:53 data
Thanks!
--
Chris Africa
Web Project Manager
Depa
Chris Africa wrote:
-
070717 22:44:12 mysqld started
070717 22:44:12 [Warning] Setting lower_case_table_names=2 because file
system for /usr/local/mysql/data/ is case insensitive
070717 22:44:12 [Warning] No argument was provided to --log-bin, and
--log-bin-index was not used; s
Michael Fernández M. wrote:
Remember that you have to stay under 2GB total memory allocation! I
think you hit that limit.
Sorry, but why do you say that?, because of the 32 bits kernel?
Yes exactly. Depending on kernel version you can allocate something
between 2 or 2.7GB. Until 2GB it's sa
El mar, 20-02-2007 a las 13:38 +0100, Nils Meyer escribió:
> Hi,
>
> Michael Fernández M. wrote:
> > i use 32 Bits kernel.
>
> Remember that you have to stay under 2GB total memory allocation! I
> think you hit that limit.
Sorry, but why do you say that?, because of the 32 bits kernel?
>
> >
Hi,
Michael Fernández M. wrote:
i use 32 Bits kernel.
Remember that you have to stay under 2GB total memory allocation! I
think you hit that limit.
innodb_additional_mem_pool_size = 500 MB.
innodb_buffer_pool_size = 8 MB
Before the innodb_additional_mem_pool_size was 1 MB, (the default va
El mar, 20-02-2007 a las 13:16 +0100, Nils Meyer escribió:
> Hi,
>
> Michael Fernández M. wrote:
> > key_buffer_size=402653184
> > read_buffer_size=2093056
> > max_used_connections=323
> > max_connections=800
> > threads_connected=55
> > It is possible that mysqld could use up to
> > key_buffer_s
Hi,
Michael Fernández M. wrote:
key_buffer_size=402653184
read_buffer_size=2093056
max_used_connections=323
max_connections=800
threads_connected=55
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
= 3666809 K
bytes of memory
Ho
Charlie Stanton wrote:
From: root
To: mysql@lists.mysql.com
Subject: mysqld won't start
>Description:
In an attempt to upgrade to MySQL 5.0.24 it was necessary to use
"rpm -e ..." to remove version 5.0.22 then "rpm -U ..." to install
the shared,server and client modules.
When I
Can you do a "show processlist" from the MySQL client? This might
help you to figure out if it is a specific query that's gumming up
the works.
Douglas Sims
[EMAIL PROTECTED]
On Jul 19, 2006, at 6:35 PM, Robinson, Eric wrote:
Our MySQL-based medical application has been running fine f
Robinson, Eric wrote:
Our MySQL-based medical application has been running fine for 3 years.
Last week, mysqld-nt started jumping up to 100% CPU and staying there
until someone restarts the service. mysqlcheck found no errors in the
database. I dumped it to disk and read it back in to create a fr
Karl Larsen wrote:
Duncan Hill wrote:
On Saturday 24 June 2006 12:49, Karl Larsen wrote:
Hi Joerg, I'm using Ferdora Core 4 of Red Hat and I have in
/etc/rc.d/init/ a file mysqld which when I use ./mysqld start does
start
the system. But it has to be done every time I turn on the comput
Hi Karl, Fredrik, all!
Karl Larsen wrote:
Joerg Bruehe wrote:
Hi Fredrik, all!
Fredrik Andersson wrote:
Hi all
I have problems getting MySQL autoboot on my RedHat installation.
[[...]]
In addition to permissions (see the other posts), there is another
possible problem: [[...]]
Try th
Duncan Hill wrote:
On Saturday 24 June 2006 12:49, Karl Larsen wrote:
Hi Joerg, I'm using Ferdora Core 4 of Red Hat and I have in
/etc/rc.d/init/ a file mysqld which when I use ./mysqld start does start
the system. But it has to be done every time I turn on the computer. I
do not understa
On Saturday 24 June 2006 12:49, Karl Larsen wrote:
> Hi Joerg, I'm using Ferdora Core 4 of Red Hat and I have in
> /etc/rc.d/init/ a file mysqld which when I use ./mysqld start does start
> the system. But it has to be done every time I turn on the computer. I
> do not understand your patch. I
Joerg Bruehe wrote:
Hi Fredrik, all!
Fredrik Andersson wrote:
Hi all
I have problems getting MySQL autoboot on my RedHat installation.
[[...]]
In addition to permissions (see the other posts), there is another
possible problem:
Depending on how your environment is set up, the MySQL server
Hi Fredrik, all!
Fredrik Andersson wrote:
Hi all
I have problems getting MySQL autoboot on my RedHat installation. [[...]]
In addition to permissions (see the other posts), there is another
possible problem:
Depending on how your environment is set up, the MySQL server may need
some other
Fredrik Andersson wrote:
Both datadir and basedir is owned by mysql and the mysql group.
I have hit rockbottom here it seems :(
first, check the error log for mysql. Should be in the datadir, named
localhost.localdomain.err I believe on RH. There will be an entry in
there explaining that s
Probably a permissions issue. Ensure that the directory in which the
pid file is created (I believe /var/run or /var/lib/mysql on RH) has
write permission for the mysql system user/group. Also, ensure
permissions/ownership on the datadir (/var/lib/mysql) for the mysql
owner/group.
Fredrik A
On 6/21/06, Fredrik Andersson <[EMAIL PROTECTED]> wrote:
Hi all
I have problems getting MySQL autoboot on my RedHat installation. I have
tried to add the mysql.server start script from the install dir to the
system with chkconfig --add mysql (I copied it to /etc/init.d/) and then
trying to add m
Hi Payne,
Payne wrote:
Hey,
I got a box that is dying, it is currently running MySQL-Max, I want to
move the DB from it to a box that is running just plain jane MySQL, what
will happen and will it work.
I know, strange but I am not sure what the Max does.
we cannot tell either, as you do
Privet!
> key_buffer_size + (read_buffer_size +
>sort_buffer_size)*max_connections = 441967 K
Check that you have enough virtual memory for MySQL processes.
Have a look at:
http://dev.mysql.com/doc/refman/5.0/en/freebsd.html
http://dev.mysql.com/doc/refman/5.0/en/crashing.html
What versio
Hello.
> [ERROR] Fatal error: Can't open privilege tables: Can't find file:
> './mysql/host.frm' errno: 13)"
perror 13
OS error code 13: Permission denied
Check that mysql user has rights on mysql directory.
Charles Gambrell wrote:
> I am running Whitebox linux 4 and have MyS
Hi Charles,
Did you create the MySql system tables by running the script
mysql_install_db which is located in the scripts folder?
This script will create the system tables for your mysql database.
After creation you can run the mysqld_safe as root
Login using mysql as user root , leave the pas
David -
Sorry for the delayed response. ulimit is unlimited.
I am using the RPMs for RH EL3 downloaded from a
mirror so I would assumed they have been built to
allow > 2GB archives.
I am most likely going a different route at this point
as my query response time is much too slow even with a
1GB
Hello.
It is strange for me that there isn't a stack trace. If you can
- switch to the debug version of MySQL and run it under gdb
to find out where it is crashing. See:
http://dev.mysql.com/doc/refman/5.0/en/crashing.html
http://dev.mysql.com/doc/refman/5.0/en/debugging-server.html
laide); mysql@lists.mysql.com
Subject: Re: mysqld crash with archive engine > 2gb
> Is there any message in the log files? or any error
> message from the OS?
David -
When the mysqld process restarts, there is nothing in
the logfile except the basic startup info. I have
listed it below:0:
> Is there any message in the log files? or any error
> message from the OS?
David -
When the mysqld process restarts, there is nothing in
the logfile except the basic startup info. I have
listed it below:0:33).
051116 10:06:33 [Note] /usr/sbin/mysqld: ready for
connections.
Version: '5.0
Hi Marc,
Is there any message in the log files? or any error message from the OS?
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Mar
Marc:
Define "crashing the server". Does the whole machine shut down? The
mysqld process? What do error logs say? What version of MySQL are
you using? What's the create table statement? what's the current
avg_row_length and max_rows? What is ulimit -f as the MySQL user say?
-Sheeri
On 11/
Hello.
> 051116 16:27:54 [ERROR] Fatal error: Can't open and lock privilege
tables:=
> Table 'mysql.host' doesn't exist
Have a invoked mysql_install_db? See:
http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html
Jörg Nowak wrote:
>
>
> Hello list,
>
> I compi
Gleb, thanks for the forcing-recovery pointer, thats what we ended up
using to recover the data for the corrupted table. After that we dropped
the table and recreated it, and imported the data and everything seems
fine for now.
Here are the OS/MySQL details:
brand new 64bit dual xeon w/ 6gigs of
Hello.
> nm: /usr/sbin/mysqld: no symbols
It seems strange because of your version - 4.1.14-debug-log.
Get MySQL which has symbols. See:
http://dev.mysql.com/doc/refman/5.0/en/compiling-for-debugging.html
Don Doumakes wrote:
> Gleb Paharenko wrote:
>
>> Follow links which have
Hello.
Please provide information about MySQL and operating system versions.
Include your configuration file. This link might be helpful in case you
want to save your data:
http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
Mayuran Yogarajah wrote:
> Mayuran Yogarajah wrot
Mayuran Yogarajah wrote:
Here is a small portion of the error log:
InnoDB: Error: trying to use a corrupt
InnoDB: table handle. Magic n 13459851911327004931, table name 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 w
Hello.
> this reads dropped in in a time-delay of about 10 sec.
I don't think this is a bug. Even after the KILL statement mysqld
threads don't die at once. Furthermore - CPU load was huge enough.
> to say that mysql after 16 hours run still was reading the tables...
It could be read
1 - 100 of 454 matches
Mail list logo
