Re: Enabling Slow query log in Mysql 5.0

2010-02-16 Thread Krishna Chandra Prajapati
Hi Machiel, The below link will help you. mk-query-digesthttp://www.xaprb.com/blog/category/maatkit/ Regards, Krishna On Tue, Feb 16, 2010 at 12:51 PM, Machiel Richards machi...@rdc.co.zawrote: Hi All I hope that someone can assist me with this. We have

My SQl Master -Slave Setup

2010-02-16 Thread Vikram A
Dear Sirs, I would like to have the MYSQL master and slave on my application setup. I am using windows vista and mysql 5.1.x what are the needed things for this master salve setup? So that, I can proceed further with manuals available. Thank you VIKRAM A The INTERNET now has a

Re: how things get messed up

2010-02-16 Thread Johan De Meersman
On Mon, Feb 15, 2010 at 10:53 AM, Martijn Tonies m.ton...@upscene.comwrote: databases are made for storing data - it saves you on both database and PHP requests, as (from a web point of view) you can't return the image data inside your HTML - it requires a second HTTP call. Filesystem image

Re: Enabling Slow query log in Mysql 5.0

2010-02-16 Thread Shawn Green
Machiel Richards wrote: Hi All I hope that someone can assist me with this. We have a client with a production MySQL database running MySQL 5.0. Their slow query counts have skyrocketed over the last week and I found

Re: how things get messed up

2010-02-16 Thread Johan De Meersman
On Mon, Feb 15, 2010 at 6:11 PM, Ann W. Harrison a...@mysql.com wrote: And here's a comment from a very experienced MySQL DBA http://sheeri.com/archives/39 Not so much a comment as her starting up the same discussion we're having :-) If you have the kind of needs where replicating NFS

RE: how things get messed up

2010-02-16 Thread Jerry Schwartz
-Original Message- From: Ann W. Harrison [mailto:a...@mysql.com] Sent: Monday, February 15, 2010 12:12 PM To: Martijn Tonies Cc: mysql@lists.mysql.com Subject: Re: how things get messed up There are lots of ways to screw up storage. [JS] As the one who started this topic, I can't agree

RE: how things get messed up

2010-02-16 Thread Jerry Schwartz
-Original Message- From: Vikram A [mailto:vikkiatb...@yahoo.in] Sent: Friday, February 12, 2010 4:13 AM To: Johan De Meersman Cc: MY SQL Mailing list Subject: Re: how things get messed up Sir, Thanks for your suggestion, I will go for blob storage, because our application will maintain

RE: how things get messed up

2010-02-16 Thread Martin Gainty
i agree with jerry put date/timestamps on each record..(that way you know when the record was created/modified) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten

count children nodes

2010-02-16 Thread David Arroyo Menendez
Hello, I've the next table structure: CREATE TABLE tx_cc20_mensajes ( uid int(11) NOT NULL auto_increment, pid int(11) DEFAULT '0' NOT NULL, tstamp int(11) DEFAULT '0' NOT NULL, crdate int(11) DEFAULT '0' NOT NULL, cruser_id int(11) DEFAULT '0' NOT NULL, deleted

RE: count children nodes

2010-02-16 Thread Gavin Towey
Trees can be complex in SQL; these articles will give some different ideas to handle it: http://hashmysql.org/index.php?title=Trees_and_hierarchical_data_in_SQL http://dev.mysql.com/tech-resources/articles/hierarchical-data.htm Regards, Gavin Towey -Original Message- From: David Arroyo

Re: count children nodes

2010-02-16 Thread Peter Brawley
David, I need count the messages don'tread in a thread. Have a look at the edge list examples at http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html. PB - David Arroyo Menendez wrote: Hello, I've the next table structure: CREATE TABLE tx_cc20_mensajes ( uid

Information_schema permission error

2010-02-16 Thread Zakai Kinan
I am getting this error - mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES. I am using 5.1.45. I don't understand what is causing this problem. Does anyone have a clue? TIA, Zak -- MySQL General

mysql and tomcat

2010-02-16 Thread Ted Yu
Hi, In our deployment, mysql needs to be started before tomcat automatically after server restart. If you know how this order can be specified, please share. We use tomcat6 on Linux tyu-linux 2.6.18-128.2.1.el5 #1 SMP Tue Jul 14 06:36:37 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux Thanks

Re: how things get messed up

2010-02-16 Thread Paul McCullagh
plug Just like to mention that http://www.blobstreaming.org was created to solve this problem in MySQL. The Launchpad project is here: https://launchpad.net/pbxt /plug On Feb 16, 2010, at 3:23 PM, Johan De Meersman wrote: On Mon, Feb 15, 2010 at 10:53 AM, Martijn Tonies