Re: MySQL Performance Analysis tools

support for mysql graphing throughput, queries, threads and slow queries. Example here: http://munin.ping.uio.no/ping.uio.no/dahl.ping.uio.no.html mark | MARK ADDISON WEB DEVELOPER 200 GRAY'S INN ROAD LONDON WC1X 8XZ UNITED KINGDOM T +44 (0)20 7430 4678 F E [EMAIL PROTECTED

Re: MySQL - master/slave replation question

to check if the slaves are in sync I'd use the table checksum that is part of Baron's mysql toolkit: http://mysqltoolkit.sourceforge.net/ mark -- MARK ADDISON WEB DEVELOPER 200 GRAY'S INN ROAD LONDON WC1X 8XZ UNITED KINGDOM T +44 (0)20 7430 4678 F E [EMAIL PROTECTED] WWW.ITN.CO.UK P Please

Re: Use select within delete

can do instead is run the select into a temp table and then run the delete as a join with that temp table. mark -- MARK ADDISON WEB DEVELOPER 200 GRAY'S INN ROAD LONDON WC1X 8XZ UNITED KINGDOM T +44 (0)20 7430 4678 F E [EMAIL PROTECTED] WWW.ITN.CO.UK P Please consider the environment

Re: Transactions and locking

locking a SELECT ... FOR UPDATE should work. http://dev.mysql.com/doc/refman/4.1/en/innodb-locking-reads.html e.g. BEGIN TRANSACTION new_id := (SELECT MAX(id) FROM table FOR UPDATE) + 1 -- some more work here INSERT INTO table (id, ...) VALUES (new_id, ...) COMMIT mark -- MARK ADDISON WEB

RE: DB Schema Comparison Utility ?

to other dialects, html, images, templates etc but it also has a very handy sqlt-diff that does want you want from the command line. http://search.cpan.org/~jrobinson/SQL-Translator-0.08001/ http://sqlfairy.sourceforge.net/ # cpan SQL::Translater hth, mark MARK ADDISON WEB DEVELOPER 200

Re: Sorting numerically within a varchar

- Brendel Piano Sonata 21 (Waldstein) - Brendel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] MARK ADDISON WEB DEVELOPER 200 GRAY'S INN ROAD LONDON WC1X 8XZ UNITED KINGDOM T +44 (0)20 7430 4678 F E

Re: comparing two databases

. Easiest way to install on nix box is cpan: $ sudo cpan SQL::Translator). mark -- MARK ADDISON WEB DEVELOPER 200 GRAY'S INN ROAD LONDON WC1X 8XZ UNITED KINGDOM T +44 (0)20 7430 4678 F E [EMAIL PROTECTED] WWW.ITN.CO.UK Please Note: Any views or opinions are solely those of the author

Re: multiple table inserts

version 5 you can create a view accross the tables and insert into that. mark -- MARK ADDISON WEB DEVELOPER 200 GRAY'S INN ROAD LONDON WC1X 8XZ UNITED KINGDOM T +44 (0)20 7430 4678 F E [EMAIL PROTECTED] WWW.ITN.CO.UK Please Note: Any views or opinions are solely those of the author and do

RE: MySQL Replication Binary Logs - How Long to Keep?

processes using it. cheers, mark -- MARK ADDISON WEB DEVELOPER 200 GRAY'S INN ROAD LONDON WC1X 8XZ UNITED KINGDOM T +44 (0)20 7430 4678 F E [EMAIL PROTECTED] WWW.ITN.CO.UK Please Note: Any views or opinions are solely those of the author and do not necessarily represent those

Re: Running mysqld on certain interface

On Mon, 2006-08-14 at 00:27 -0700, The Nice Spider wrote: How do I set mysqld hears only on eth0? i am using FC linux. Add a setting for bind_address under the mysqld section in the my.cnf file, set to the IP of eth0 (then restart the mysql server). hth, mark -- MARK ADDISON WEB

Re: problem with decimal part

://dev.mysql.com/doc/refman/4.1/en/cast-functions.html for functions to use in the other cases. mark Thanks -- Com os melhores cumprimentos Jorge Martins - Wemake, Tecnologias de Informação, Lda. Tel. 223744827 MARK ADDISON WEB DEVELOPER 200 GRAY'S INN ROAD LONDON WC1X 8XZ UNITED KINGDOM T +44

RE: MySQL Replication Binary Logs - How Long to Keep?

meg so I could clean up more often. Note that you should not just delete the bin logs. Instead use PURGE MASTER LOGS. See http://dev.mysql.com/doc/refman/4.1/en/purge-master-logs.html hth, mark MARK ADDISON WEB DEVELOPER 200 GRAY'S INN ROAD LONDON WC1X 8XZ UNITED KINGDOM T +44 (0)20

Re: Adding Foreign Key Fails

-- MARK ADDISON WEB DEVELOPER 200 GRAY'S INN ROAD LONDON WC1X 8XZ UNITED KINGDOM T +44 (0)20 7430 4678 F E [EMAIL PROTECTED] WWW.ITN.CO.UK Please Note: Any views or opinions are solely those of the author and do not necessarily represent those of Independent Television News Limited

Re: Recommendations on new hardware

On Wed, 2005-09-07 at 08:30 -0600, Cory Robin wrote: Brent Baisley wrote: If you do go the new hardware route, I wouldn't go with SCSI is you only have $2K to spend. S-ATA2 based drives would give you similar performance to SCSI, but at a big cost savings. SCSI's big performance

Re: Compare two tables

On Fri, 2005-08-26 at 09:14 -0600, Alfredo Cole wrote: El Viernes, 26 de Agosto de 2005 08:16, Martijn Tonies escribió: You could check the table DDL. Or use a third party tool, like Database Workbench, that can do this for you and even generator a change script. Check