On Wednesday 22 January 2014 22:56, you wrote:
Hi Jørn,
But I must say I'm not very impressed by the speed. I'm running a test on
an application that do a lot of reads and writes queries and the general
performance has dropped to 50% of the what I had in 5.5.20.
I would say that this
Hi Jørn,
I would say that this sort of performance drop is not typical. Some
users have reported a smaller performance loss in single threaded
workloads in 5.6.
But dropping from an average of 1800 jobs per minute down to 300? I don't
think that should be expected.
I would agree with
On Tuesday 14 January 2014 21:51, Jesper Wisborg Krogh wrote:
Hi Jørn,
On 15/01/2014 04:36, Jørn Dahl-Stamnes wrote:
140114 18:20:08 InnoDB: Error: data file /data/mysql/data/ibdata3 uses
page size 1024,
140114 18:20:08 InnoDB: but the only supported page size in this release
is=16384
Hi Jørn,
But I must say I'm not very impressed by the speed. I'm running a test on an
application that do a lot of reads and writes queries and the general
performance has dropped to 50% of the what I had in 5.5.20.
I would say that this sort of performance drop is not typical. Some
users
/mysql/bin/mysqld: Shutdown complete
# Restart after umount/mount.
140114 18:17:59 mysqld_safe mysqld from pid
file /usr/local/mysql/data/hostname.pid ended
140114 18:20:05 mysqld_safe Starting mysqld daemon with databases
from /usr/local/mysql/data
140114 18:20:05 InnoDB: The InnoDB memory heap
Hi Jørn,
On 15/01/2014 04:36, Jørn Dahl-Stamnes wrote:
140114 18:20:08 InnoDB: Error: data file /data/mysql/data/ibdata3 uses page
size 1024,
140114 18:20:08 InnoDB: but the only supported page size in this release
is=16384
140114 18:20:08 InnoDB: Could not open or create data files.
That
, they are not activated until i restart mysql
right?
is above scenario safe? Do you think i messed up something?
Thank you for your help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
your MySQL server at the next restart, however; but that's pretty
much the case for any other daemon, too.
On Mon, Nov 8, 2010 at 11:06 AM, AHMET ARSLAN aarsl...@anadolu.edu.trwrote:
Hello MySQL Community,
Last Friday I changed /etc/mysql/my.cnf file (at server) accidentally.
I set
, 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.
restart?
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.
--
MySQL General Mailing List
For list archives: http
This is a correct description of behaviour. Did you have a question ? :-)
On Fri, Sep 17, 2010 at 5:52 AM, win.a win@gmail.com wrote:
I fond my mysql db os time was not correct so i sync with ntpdate
,when testing my app which depend on the date was not the current os
time .After
I fond my mysql db os time was not correct so i sync with ntpdate
,when testing my app which depend on the date was not the current os
time .After restarting Mysql ,the app goes well.
All you best
What we are struggling for ?
The life or the life ?
--
MySQL General
How are you shutting down the server during the restart.. have you
checked the logs? Might you be issuing a kill and crashing it?
MyISAM doesnot dealwith crashes very elegantly.
Also, what is some reason? Might thereason you need to restart be related?
- michael dykman
On Tue, Aug 24, 2010
On 25/08/2010 8:05 a, Michael Dykman wrote:
How are you shutting down the server during the restart.. have you
checked the logs? Might you be issuing a kill and crashing it?
MyISAM doesnot dealwith crashes very elegantly.
Also, what is some reason? Might thereason you need to restart
Hi List,
I have a very big size MyISAM table. For some reason I need to restart the
server periodically. But After restarting the server, the table always get
corrupt, and always need to run myisamchk. Don't know what cause the problem.
But it will be very helpful if somebody can give me some
Hello,
I have a quite loaded server with bin-log enabled. I'd like to disable
binary logging globally not for a single session without restarting
mysql. Is it possible? Any input is appreciated.
Best Regards,
George
--
MySQL General Mailing List
For list archives:
No George you will need to restart MySQL.
From: ext George Chelidze [wr...@geo.net.ge]
Sent: 11 June 2010 12:15
To: mysql@lists.mysql.com
Subject: Disable bin-log without restart
Hello,
I have a quite loaded server with bin-log enabled. I'd like
hi
as the title
thanks
--
-
Lin Chun
unless and until if the variable is read-only, you don't need Lin.
On Mon, May 31, 2010 at 3:17 PM, Lin Chun franks1...@gmail.com wrote:
hi
as the title
thanks
--
-
Lin Chun
--
Thanks
Suresh Kuna
MySQL DBA
Yes and No.
Its depend on the type of variable you have changed.
If its Dynamic , MySQL restart not required, else its required.
System variables can be set at server startup using options on the command
line or in an option file. Most of them can be changed dynamically while the
server
Hi,
I need to change the computer clock (changing the /etc/zoneinfo) but I would
not restart de MySQL service. The NOW() still returning the old time...
Thanks,
Jonas
Jonas,
your information is somewhat incomplete, but still:
Jonas Silveira wrote:
Hi,
I need to change the computer clock (changing the /etc/zoneinfo) but I would
From the file name, I assume it is some Unix platform.
not restart de MySQL service. The NOW() still returning the old
Before I simulate a total server failure, master1 is using binary file
msyql-bin1 position 2231467 and it's slave master2 is following the
correct file at the correct position. This is after initial setup. Once I
restart master1, it will then start to use msyql-bin2 position 98
position. In this
case you do have to intervene, but that's an easy enough case to write a script
to handle.
When restarting mysql normally, you shouldn't have this problem: i.e. service
mysql restart / /etc/ini.d/mysql restart
Regards,
Gavin Towey
-Original Message-
From: Cantwell
-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Friday, July 31, 2009 1:21 PM
To: Cantwell, Bryan; mysql@lists.mysql.com
Subject: RE: Replication recovery on restart
Bryan,
How are you restarting mysql? In the case a master crashes, it's definitely
common for the slave to miss the fact
...@firescope.com]
Sent: Friday, July 31, 2009 12:51 PM
To: mysql@lists.mysql.com
Subject: RE: Replication recovery on restart
Yes I am trying to simulate total failure. In this test case I am using 2
Virtual Machines and I just kill one and then when it comes back I have the
challenge described
direct the newly restarted boxes to the right position in the correct files on
restart?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi Bryan,
Please define out of whack. Tell us exactly what you're doing when you
restart, and what the replication state is before and after, and where the
updates are coming from.
Regards,
Gavin Towey
-Original Message-
From: Cantwell, Bryan [mailto:bcantw...@firescope.com]
Sent
Hi Baron,
I want to use mk-slave-restart (maatkit tool) to restart the slave if 1048
errors comes up.
[r...@linux18 ~]# mk-slave-restart --always --daemonize
--defaults-file=/etc/my1.cnf --error-numbers=1048 --host=localhost --port
3307 --user=root
[r...@linux18 ~]# ps aux | grep mk-slave
Hi,
On Mon, Jan 12, 2009 at 4:28 AM, Krishna Chandra Prajapati
prajapat...@gmail.com wrote:
Hi Baron,
I want to use mk-slave-restart (maatkit tool) to restart the slave if 1048
errors comes up.
[r...@linux18 ~]# mk-slave-restart --always --daemonize
--defaults-file=/etc/my1.cnf --error
: Unable to restart after crash
Hi,
My mysql server crashed last night, and when it rebooted, was unable to
restart. Here is the error log:
Jan 13 00:12:54 localhost mysqld_safe[1324]: started
Jan 13 00:12:55 localhost mysqld[1327]: 080113 0:12:55 InnoDB:
Database was not shut down
Or maybe the pid is still existing?
-Original Message-
From: Ross Crawford [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 12, 2008 5:13 PM
To: mysql@lists.mysql.com
Subject: Unable to restart after crash
Hi,
My mysql server crashed last night, and when it rebooted, was unable
Hi,
My mysql server crashed last night, and when it rebooted, was unable to
restart. Here is the error log:
Jan 13 00:12:54 localhost mysqld_safe[1324]: started
Jan 13 00:12:55 localhost mysqld[1327]: 080113 0:12:55 InnoDB:
Database was not shut down normally!
Jan 13 00:12:55 localhost
Have you looked at the results of
netstat -an
?
-Grant
- Original Message -
From: Ross Crawford
To: mysql@lists.mysql.com
Sent: Saturday, January 12, 2008 5:12 PM
Subject: Unable to restart after crash
Hi,
My mysql server crashed last night, and when it rebooted
Here is my errors in my locahost.locaodomain.err:
071217 14:02:12 mysqld_safe Starting mysqld daemon with databases from
/usr/local/mysql/data/
2 071217 14:02:12 InnoDB: Started; log sequence number 0 46429
3 071217 14:02:13 [Warning] NDB: server id set to zero will cause any
other
/lib/mysql
(note: i created the above directory and chown'ed it
to mysql:mysql). After that MySQL could not restart
any more.
Looking in syslog, I found the following:
Jul 25 10:29:09 gx200 mysqld_safe[14480]: started
Jul 25 10:29:09 gx200 mysqld[14483]: 070725 10:29:09
[ERROR] /usr/sbin/mysqld
Dear All,
I have problem that API node on cluster always auto restart mysql (every
30, 20, 15 or just 5 minutes). I see many error messages at message log
file:
Jun 20 15:27:18 PrivateData1 sshd(pam_unix)[30280]: session opened for
user root by root(uid=0)
Jun 20 15:51:24 PrivateData1 kernel
Hi,
We're running mysql 4.1.20. If I understand the manual correctly, I can
change max_connections while mysqld is running without restart mysqld to
make the change take effect. But what if mysqld restarts later in some
other situations, like machine reboot, would my (global) change
change max_connections while mysqld is running without restart mysqld to
make the change take effect. But what if mysqld restarts later in some
other situations, like machine reboot, would my (global) change on
max_connections remain? I'm just very clear when to make dynamic changes
and when is better
On Wed, March 14, 2007 9:35, Bing Du said:
Hi,
We're running mysql 4.1.20. If I understand the manual correctly, I can
change max_connections while mysqld is running without restart mysqld to
make the change take effect. But what if mysqld restarts later in some
other situations, like
We're running mysql 4.1.20. If I understand the manual correctly, I can
change max_connections while mysqld is running without restart mysqld to
make the change take effect
Correct.
But what if mysqld restarts later in some
other situations, like machine reboot, would my (global) change
4.1.20. If I understand the manual correctly, I can
change max_connections while mysqld is running without restart mysqld to
make the change take effect. But what if mysqld restarts later in some
other situations, like machine reboot, would my (global) change on
max_connections remain? I'm just
Hi,
In ur cnf file mention the log file path as
log=/mysql/logs/mysqllog/qry.log .
log-slow-queries=/mysql/logs/mysqllog/slowqry.log
and restart mysql.
Thanks Regards
Dilipkumar
- Original Message -
From: Adam Rosi-Kessel [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday
I'm running MySQL 4.0.23 on a Debian Sarge system.
Often, when I reboot twice in a short time period, MySQL doesn't seem to
shut down gracefully -- it takes a long time for it to come up fully, and
if I reboot before that, I get a lot of log messages. I think it takes
about an hour to come up
Hi,
If it is your default apache /usr/sbin/apachectl start
and mysql
/etc/init.d/mysql.server start
This might help you out.
Daniel da Veiga wrote:
On 5/9/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
found this:
/etc/rc.d/init.d/mysqld restart
/etc/rc.d/init.d/httpd2 restart
I think
hi again,
I have to restart as soon as possible mysql and apache on our web server
(mandrake cooker 10) - since our admin is out of office for today.
if someone can ive me some instructions, please?
1. what I have to restart first apaceh or mysql - or desn't matter?
2. I have sudo access (if I
hi again,
I have to restart as soon as possible mysql and apache on our web server
(mandrake cooker 10) - since our admin is out of office for today.
if someone can ive me some instructions, please?
1. what I have to restart first apaceh or mysql - or desn't matter?
2. I have sudo access (if I
found this:
/etc/rc.d/init.d/mysqld restart
/etc/rc.d/init.d/httpd2 restart
I think it should work?
-afan
On 5/9/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
hi again,
I have to restart as soon as possible mysql and apache on our web server
(mandrake cooker 10) - since our admin is out
On 5/9/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
hi again,
I have to restart as soon as possible mysql and apache on our web server
(mandrake cooker 10) - since our admin is out of office for today.
Are you sure you MUST restart those services? AFAIK you run Linux
exactly because you
On 5/9/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
found this:
/etc/rc.d/init.d/mysqld restart
/etc/rc.d/init.d/httpd2 restart
I think it should work?
Yeah, different systems, different locations, but the same purpose...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK
On 5/9/06, Edward Vermillion [EMAIL PROTECTED] wrote:
On May 9, 2006, at 1:50 PM, Daniel da Veiga wrote:
On 5/9/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
hi again,
I have to restart as soon as possible mysql and apache on our web
server
(mandrake cooker 10) - since our admin is out
Thanks Daniel!
-afan
On 5/9/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
found this:
/etc/rc.d/init.d/mysqld restart
/etc/rc.d/init.d/httpd2 restart
I think it should work?
Yeah, different systems, different locations, but the same purpose...
--
Daniel da Veiga
Computer Operator
: average access time is 30ms
3rd test: average access time is 15ms
Stop and restart MySQL
4th test: average access time is 15ms
Note that I stopped and restarted mysql between the 3rd and 4th test but the
average access time does not change.
What OS do you use ? It's quiet likely you hit the FS
The OS used are Mandriva and Fedora.
Can you explain more?
Thanks.
Charles
-Original Message-
From: Philippe Poelvoorde [mailto:[EMAIL PROTECTED]
Sent: Friday, April 07, 2006 2:43 AM
To: MySQL General
Subject: Re: MySQL 4.1.11 innodb cache can't be flushed after
restart
2006/4/7, Charles Q. Shen [EMAIL PROTECTED]:
The OS used are Mandriva and Fedora.
Can you explain more?
I'll make it quick, there is plenty of doc on a web that will explain
this better than I can.
Once you read few things from your hard drive (let's say the index
file for your table), it's
time is 15ms
Stop and restart MySQL
4th test: average access time is 15ms
Note that I stopped and restarted mysql between the 3rd and 4th test but the
average access time does not change.
I also tried another set of random records that are not in the table, the
average access time is about 2s
Please help, I can't start my server!!
I was running a query, and it seemed to be hanging. After waiting about 15
minutes, I finally did a 'CTRL+BREAK' to abort the process. This happened
about 3 times, and finally I decided to restart the MySQL service to see if
that would help. Well, when I
In Windows, you have 3 alternatives:
1 - wait untill it stops the service (can take very long time).
2 - restart the server (your users might cry a bit).
3 - Try to kill the task using Task Manager (this might not work,
depending on the service).
/Johan
Sara Woglom wrote:
Please help, I
this without bouncing the server, because
I really can't do that.
-Original Message-
From: Ariel Sánchez Mora [mailto:[EMAIL PROTECTED]
Sent: Friday, March 31, 2006 4:10 PM
To: Sara Woglom
Subject: RE: Cannot restart service MySQL
Have you tried
Command line: mysqladmin -u root shutdown -p
kill the same and try to start mysql.It may help.
leo huang wrote:
hi,
I met the MySQL restart error today.
First, I stopped the running mysql server using
/usr/local/mysql/bin/mysqladmin -uroot shutdown.
After the server shutdowned, I restarted it using
/usr/local/mysql/bin/mysqld_safe
hi,
I met the MySQL restart error today.
First, I stopped the running mysql server using
/usr/local/mysql/bin/mysqladmin -uroot shutdown.
After the server shutdowned, I restarted it using
/usr/local/mysql/bin/mysqld_safe .
Then, I got this error: [ERROR] Can't start server: Bind on TCP/IP port
wrote:
hi,
I met the MySQL restart error today.
First, I stopped the running mysql server using
/usr/local/mysql/bin/mysqladmin -uroot shutdown.
After the server shutdowned, I restarted it using
/usr/local/mysql/bin/mysqld_safe .
Then, I got this error: [ERROR] Can't start server
FreeBSD / UNIX platform, MySQL ver.4.0.16
Prob. of growing /tmp file, solved by introducing a cron job to clean up
the folder intermittently. Prob.solve but new one created - mysql socket
wiped out. Could not restart the server with all the standard methods.
Complained of other running processes
Joseph E. Maxwell wrote:
FreeBSD / UNIX platform, MySQL ver.4.0.16
Prob. of growing /tmp file, solved by introducing a cron job to clean up
the folder intermittently. Prob.solve but new one created - mysql socket
wiped out. Could not restart the server with all the standard methods.
Complained
Is it possible for mysqld to reload its configuration files without
doing an explicit stop/start? I've searched the online documentation
plus my copy of the DuBois book to no avail.
The fact that the Debian init scripts don't do a proper config reload
(just the GRANT tables) does not give me
be nice if MySQL had it.
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Monday, July 18, 2005 1:10 PM
To: mysql@lists.mysql.com
Subject: Re: Reload mysqld configuration without restart?
Hello.
I don't know a general way to force MySQL Server
Hello.
I don't know a general way to force MySQL Server to reread it's
configuration file, however you could dynamically change lots
of variables using SET @@global.xx syntax. FLUSH command could be
helpful as well. See:
http://dev.mysql.com/doc/mysql/en/system-variables.html
I made a change to my.cnf and want it to restart mysqld_safe so it will
re-read my.cnf. How do I do this?
Thanks,
Chip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a change to my.cnf and want it to restart mysqld_safe so it will
re-read my.cnf. How do I do this?
Thanks,
Chip
--
Scott Baker
Canby Telephone - Network Administrator - RHCE
Ph: 503.266.8253
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
In the last episode (Mar 04), Chip Wiegand said:
I made a change to my.cnf and want it to restart mysqld_safe so it
will re-read my.cnf. How do I do this?
/usr/local/etc/rc.d/mysql-server.sh restart
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list
Hi everyone,
Our server crashed the
Two questions :
1) is it normal to have a dramatic amount of UPDATES after a MySQL
restart after crash ?
2) how to get valuable information from the following? ;
Crash from 20/12/04 at 20.10(?)
from server.err :
mysqld got signal 11;
This could be because
Hello
Since that list is wonderfull to solve my problem, I will try again. But
this might not be the best place since the problem concerns mysql access
througt tomcat (jakarta-tomcat-5.0.28).
The java application we have, when start after a mysql restart (night
backup) , will give an error
Duhaime Johanne wrote:
Hello
Since that list is wonderfull to solve my problem, I will try again. But
this might not be the best place since the problem concerns mysql access
througt tomcat (jakarta-tomcat-5.0.28).
The java application we have, when start after a mysql restart (night
backup
using wget at the end of
your MySQL backup script?
Worth considering,
Andy
-Original Message-
From: Duhaime Johanne [mailto:[EMAIL PROTECTED]
Sent: 15 December 2004 19:22
To: [EMAIL PROTECTED]
Subject: Restart of Mysql and tomcat error
Hello
Since that list is wonderfull
I tried to browse through the documentation to figure out what happens
with prepared statements if the server is restarted while the prepared
statement is assigned an ID and is being used repeatedly. The client
then silently reconnects (reconnect flag is set). Is the expected
behaviour for the
Good Afternoon.
I'm interested if any DBAs on the list have a set of scripts they run
after a server restart to pull commonly accessed data into the the query
and key caches. I'm currently working on a script that will run various
queries from our application against the database servers
I'm running Windows 2000 and MySQL 5.0.1. When I tried to restart the
service, it won't start up again, error message saying to try again in 30
minutes. After waiting for 30 minutes, it still bring up same error message.
What might be the cause?
Scott
--
MySQL General Mailing List
For list
that MySQL isn't all the way
shutdown when it tries to start back up again.
When I manually have to restart the server it usually takes 10-20
seconds depending on it's current load; the above error message only
seems to give a fraction of a second for the server to shutdown. What
I can I do to fix
--user=root '. Still the same
thing. I even tried to restart the server again but it does not work
either. I have also tried to restore the my.cnf file and there is no effect.
Please help me. I need it to be fixed as soon as I can.
Thank you so much
ginger
--
MySQL General
To: [EMAIL PROTECTED]
Subject: Please HELP !!! Can not restart server
Hi, MySQL Gurus,
Version of mysql is Distrib 3.23.54, for redhat-linux-gnu (i386). I
started mysql server with 'safe_mysqld --user=root ' . Then I found some
variables needs to be optimized. SO I shut it down
What information is being logged in *.err?
-Original Message-
From: Ginger Cheng
To: [EMAIL PROTECTED]
Sent: 4/8/04 10:20 AM
Subject: Please HELP !!! Can not restart server
Hi, MySQL Gurus,
Version of mysql is Distrib 3.23.54, for redhat-linux-gnu
(i386). I
started mysql server
I don't have such files. Unfortunately. Am I hopeless?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Here is the error msg:
040408 08:47:14 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB
I got it fixed with the msg from --err-log. THank you so much for all your
help. I couldn't have made it without your hints.
ALl the best
ginger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ginger Cheng [EMAIL PROTECTED] wrote:
Here is the error msg:
040408 08:47:14 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your
perror 145
145 = Table was marked as crashed and should be repaired.
Run myisamchk on it.
David Rankin wrote:
I can't figure this out. I'm setting privileges for access on a local net to
a user [EMAIL PROTECTED] using grant and all of a sudden mysql is dead. I'm
running 3.23.31 on Mandrake 7.2.
-9333
(936) 715-9339 fax
--
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: David Rankin [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 8:37 AM
Subject: Re: MySql died a hard death after using grant and won't restart
perror 145
145 = Table was marked
, December 12, 2003 8:37 AM
Subject: Re: MySql died a hard death after using grant and won't restart
perror 145
145 = Table was marked as crashed and should be repaired.
Run myisamchk on it.
David Rankin wrote:
I can't figure this out. I'm setting privileges for access on a local net
to
a user
You might consider using Grant instead of editing the permissions table manually.
Follow this link for the appropriate section of the manual:
http://www.mysql.com/doc/en/GRANT.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
--
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: David Rankin [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 8:37 AM
Subject: Re: MySql died a hard death after using grant and won't restart
perror 145
145 = Table was marked as crashed and should
I can't figure this out. I'm setting privileges for access on a local net to
a user [EMAIL PROTECTED] using grant and all of a sudden mysql is dead. I'm
running 3.23.31 on Mandrake 7.2. I haven't had any problems in years.
Anybody got any thoughts on this? Please reply to [EMAIL PROTECTED]
What in
On Wed, Jul 09, 2003 at 01:08:56PM -0400, Dave [Hawk-Systems] wrote:
load). Is there a known issue (running on FreeBSD 4.8,
MySQL 3.23.55 MyISAM)?
its been a known issue for quite a long time
use linuxthreaded version and it should work fine.
although much of work has been done on
Occasionally in checking one of the servers, I noticed that mysql shows 85% + of
cpu usage essentially leaving the server at 0% idle. After monitoring it for a
few hours, the status did not change. After a stop and start of mysql, things
progessed normally. Checking back a few days later I
hi,
load). Is there a known issue (running on FreeBSD 4.8,
MySQL 3.23.55 MyISAM)?
its been a known issue for quite a long time
use linuxthreaded version and it should work fine.
although much of work has been done on threads implementation,
there are still such problems with mysql. it
On Wed, 2003-07-09 at 10:31, Dave [Hawk-Systems] wrote:
Is there a known issue (running on FreeBSD 4.8, MySQL 3.23.55 MyISAM)?
Is there something I should check when next I notice the high CPU usage?
I used to see the same kind of behavior a while back with a MySQL
installation I did for a
load). Is there a known issue (running on FreeBSD 4.8,
MySQL 3.23.55 MyISAM)?
its been a known issue for quite a long time
use linuxthreaded version and it should work fine.
although much of work has been done on threads implementation,
there are still such problems with mysql. it happens
Is there a known issue (running on FreeBSD 4.8, MySQL 3.23.55 MyISAM)?
Is there something I should check when next I notice the high CPU usage?
I used to see the same kind of behavior a while back with a MySQL
installation I did for a client. It turned out that what was happening
was a poorly
1 - 100 of 165 matches
Mail list logo