Re: Replication Performance

2003-06-25 Thread Marc Prewitt
-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

New mtop/mkill version available

2003-06-23 Thread Marc Prewitt
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

Re: Managing replication logs

2003-02-13 Thread Marc Prewitt
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

Re: how do i savely delete replication bin-logs ?

2002-11-12 Thread Marc Prewitt
(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

looking for handler_read value

2002-08-27 Thread Marc Prewitt
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

slave stop command doesn't work if slave thread is blocked

2002-07-18 Thread Marc Prewitt
*** 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

Re: Replication (possible) problems | 'show binlog' command is broken?

2002-07-10 Thread Marc Prewitt
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

Re: AUTO_INCREMENT with Replication

2002-07-04 Thread 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) v0.6.2 released

2002-07-01 Thread Marc Prewitt
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

Replication not staying connected

2002-06-04 Thread Marc Prewitt
: 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

Re: binlog and replication stuff

2002-04-11 Thread Marc Prewitt
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

Re: binlog and replication stuff

2002-04-11 Thread Marc Prewitt
- 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

Re: How to automate bin-log clean-up with replicated MySQL servers?

2002-04-11 Thread Marc Prewitt
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

Re: binlog and replication stuff

2002-04-11 Thread Marc Prewitt
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

Re: Replication incompleteness problem

2002-04-11 Thread Marc Prewitt
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

Re: binlog and replication stuff

2002-04-09 Thread Marc Prewitt
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

Re: Problem with Sun Os

2002-04-07 Thread Marc Prewitt
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

Re: How can I kill the slow query automatically?

2002-04-07 Thread Marc Prewitt
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:

Re: Keeping MySQL Databases Heathly

2002-04-07 Thread Marc Prewitt
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

Re: Keeping MySQL Databases Heathly

2002-04-07 Thread Marc Prewitt
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

Re: Mysql binary logs

2002-03-29 Thread Marc Prewitt
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

Re: Adding an index to a table

2002-03-29 Thread Marc Prewitt
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

Re: =?iso-8859-1?Q?Capacité_Mysql?=

2002-03-29 Thread Marc Prewitt
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