ave will use non-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:/
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 s
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 the
(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 the
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 the slaves' latest position by looking
at a
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 it's
27
*** 2. row ***
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 Pr
reports 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
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
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
performanc
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Marc Prewitt
>Organization:
Wall Street Source
>MySQL support: extended login support
>Synopsis: Replication not staying connected
>Severity: critical
>Priority: high
>Category: my
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?
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:
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
x)
>
> -Original Message-
> 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
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 M
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 o
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
> t
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 to
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:
http://www.mysql.com/doc/C/o/Command-
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:
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 ac
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 t
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 Yo
24 matches
Mail list logo
