Re: how things get messed up

2010-02-16 Thread Paul McCullagh
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 On Feb 16, 2010, at 3:23 PM, Johan De Meersman wrote: On Mon, Feb 15, 2010 at 10:53 AM, Martijn Tonies wrote: databases are made

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

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 Mailing

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 int(11

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 M

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 tinyint(4)

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 Si

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

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

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 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 servers won't ho

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 th

Re: how things get messed up

2010-02-16 Thread Johan De Meersman
On Mon, Feb 15, 2010 at 10:53 AM, Martijn Tonies wrote: > 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 >> serving, >> > >

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 person

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 wrote: > Hi All > > > >I hope that someone can assist me with this. > > > >We have a client