-transactional MyISAM tables instead of BDB
tables to get more speed.
2/ Is there any documentation on handling and configuring large tables?
Hope this is not too confusing...
Many thanks
Todd Burke
phbnyc.com
Marc Prewitt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
mtop (MySQL top) monitors a MySQL server showing the queries which are
taking the most amount of time to complete. Features include 'zooming' in
on a process to show the complete query, 'explaining' the query optimizer
information for a query and 'killing' queries. In addition, server
performance
Here's another way to do it which works well with multiple slaves:
http://mtop.sourceforge.net/utils/purge_replication_log
This script is run on the slave and the master. When run on the slave it
updates a table in the master which keeps track of the log position for
each slave. When run on
(This is a repost of an ealier answer):
Here's one which takes log rotation a step further than mysql provides
for. It is run on the slaves to keep track of their position and then run
on the master to purge up to the earliest slave position. This is useful
because you can't reliably get all
I'm trying to put together some statistics on our queries and am wondering
what percentage of our queries involve a full table scan. The variable
which kind of tracks this is Handler_read_rnd_next. However, since a
query may cause multiple Handler_read_rnd_next events to occur to get all
of
***
Id: 2
User: mysql
Host: localhost
db: NULL
Command: Killed
Time: 167
State: waiting for slave to die
Info: slave stop
mysql kill 1;
Fix:
Submitter-Id: Marc Prewitt
Originator:Marc Prewitt [EMAIL PROTECTED]
Organization:
Wall Street Source
MySQL support
no errors in
it's logs.
Mysql support suggests that it might be a hardware or os bug. I'd like to
rule this out and get them to look further into the problem. Can you
describe your hardware/os setup of the master and slave and the network
connecting them?
Thanks,
Marc Prewitt
--
Marc Prewitt
Eric Frazier wrote:
Hi,
That kind of bothers me. But I can see how it might be better in some way
than using a time function. My idea was to use the perl Time::HiRes to make
a unique key adjusted by timezone. As long as the clocks of the two
machines are fairly in since, it should work
mtop (MySQL top) monitors a MySQL database showing the queries which are
taking the most amount of time to complete. Features include 'zooming' in
on a process to show the complete query, 'explaining' the query optimizer
information for a query and 'killing' queries. In addition, server
:
Originator:Marc Prewitt
Organization:
Wall Street Source
MySQL support: extended login support
Synopsis: Replication not staying connected
Severity: critical
Priority: high
Category: mysql
Class: sw-bug
Release: mysql-3.23.46 (Source distribution)
Server: /usr
FLUSH LOGS safely rotates the binlog.
Davide Giunchi wrote:
You are right, but my master generate about 150Mb of binlog x day, i a slave
fail after 4 day it will reexec a lot of query and take some time. how can i
safely rotate the log in master+slaves without restarting them?
The Mysql
-
From: Davide Giunchi [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 5:37 PM
To: Marc Prewitt
Cc: [EMAIL PROTECTED]
Subject:Re: binlog and replication stuff
You are right, but my master generate about 150Mb
We have a slightly smarter script which checks each slave to find the
furthest one behind and purges up to that number. However, it currently
figures out who the slaves are by checking a process status on the
master. Unfortunately, this doesn't work if one of your slaves is down.
So, I'm going
Yes.
Davide Giunchi wrote:
FLUSH LOGS in the master and all is ok? binlog will be rotate and slaves will
see it, continue to work and update master.info?
Regads
Il 15:31, giovedì 11 aprile 2002, hai scritto:
FLUSH LOGS safely rotates the binlog.
Davide Giunchi wrote:
You are
A couple of questions below:
Wendell Dingus wrote:
...
cron entries:
-
Server2:
20 4 * * * /etc/rc.d/init.d/mysql stop 1/dev/null 2/dev/null
#
25 4 * * * /bin/rm -f /var/lib/mysql/master.info 1/dev/null 2/dev/null
Why are you deleting master.info? It's my
When a slave crashes or reboots, it should start replicating from where it
left off--at least ours do work that way. The current replication state
is saved in master.info on the slave and when it starts up again, it
should read that file and resume reading the binlog on the master where it
left
Looks like mysql was compiled to use a shared version of zlib. You'll
need to get it from:
http://www.gzip.org/zlib/
Andrea Soracchi wrote:
Hello,
When i try to launch my server mysqld I have the follwing result:
ld.so.1: ./bin/my_print_defaults: fatal: libz.so.1: open failed: No
Without setting up replication, you could use 'UPDATE LOW PRIORITY':
http://www.mysql.com/doc/U/P/UPDATE.html
If you do setup replication, you can set the replica database to use low
priority updates too by using the --low-priority-updates option to mysqld:
We run a CHECK TABLE nightly on every table (see:
http://www.mysql.com/doc/C/H/CHECK_TABLE.html) and I would HIGHLY
recommend doing so. If the check table fails, we run a REPAIR TABLE. We
also used to do a REPAIR TABLE EXTENDED on weekends to optimize indexes
until our db got too big for that
And here's a script that will do the check/repair for you. It has some
custom logging libs in it that you'll have to remove to make it work
(Admutil and Getpassword), but you'll get the general idea.
Alex Pilson wrote:
Do MySQL server administrators recommend running a cron script daily
to
You might want to use the mysqlbinlog utility to look at the binlog. The
binlog format has changed at least once in past versions and could change
again. However, the output from mysqlbinlog just a straight text format
of updates/inserts/deletes which happen to a database.
-Marc
Konstantin
James Riordon wrote:
At 15:07 +0800 03/28/2002, Sammy Lau was thought to have said :
?http://www.mysql.com/doc/C/R/CREATE_INDEX.html
Granted, I should have looked before I spoke for the first question.
2 - Do I have to do anything special like stop requests to the
If I understand you correctly, you are interested in backing up a database
without using the mysqldump command, correct?
You have a couple of options:
1) Issue a 'flush tables with read lock', backup the binary files of the
database, issue a 'unlock tables'. However, no one will be able to
23 matches
Mail list logo