Re: MySQL Performance Analysis tools

d includes good 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 [

Re: MySQL - master/slave replation question

to the master. If you want 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 74

Re: Transactions and locking

As your using InnoDB, which has row level 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, ..

Re: Use select within delete

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. Do you really need to print this email? Please Note: Any vie

RE: DB Schema Comparison Utility ?

need command line tools that run on linux. > > :( :) Theres a perl tool called SLQ Fairy. Its main use is translating DDL 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/S

Re: Sorting numerically within a varchar

iano Sonata 10 - Brendel > >Piano Sonata 11 - Brendel > >Piano Sonata 12 - Brendel > >Piano Sonata 13 - Brendel > >Piano Sonata 14 - Brendel > >Piano Sonata 15 - Brendel > >Piano Sonata 16 - Brendel > >Piano Sonata 17 - Brendel > >Piano Sonata 18 - Brendel

Re: comparing two databases

alter statements. 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

Re: multiple table inserts

e tables > simultaneously... If your using 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:

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 ADDIS

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

uch easy to read. e.g. mysql> SHOW SLAVE STATUS\G Also you might find running SHOW PROCESSLIST; on the servers usefull, if the bin log is in use you should be able to see the replication processes using it. cheers, mark -- MARK ADDISON WEB DEVELOPER 200 GRAY'S INN ROAD LONDON WC1X

Re: problem with decimal part

till treat the field as a number in most cases and see http://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. 22374

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

ize option in my.cnf to a 100 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 WC

Re: Adding Foreign Key Fails

u on windows (case insensative table names) or a *nix machine (case sensative)? hth, 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 tho

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 > > perf

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 ww