Sun netra's and MySQL
Hi all I was thinking of hosting our MySQL database on a cluster of Sun Netra's either tmX1 or tmT1 and was wondering if anyone had any experience of these boxes and how well they work with MySQL. Our database has about 30 tables and about a million rows. Anyone have any ballpark figures on the number of concurrent connected clients and queries per second you can achieve on one of these? thanks and best wishes Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Sun netra's and MySQL
Thanks Matthew... Have you or anyone else tried running MySQL on them? thanks again Chris -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 12:12 PM To: Christopher Thorpe; [EMAIL PROTECTED] Subject: RE: Sun netra's and MySQL I have clustered Netra's together before using SUN HA and Vertias VCS. I found for large content avoid the Netra X1 - more so for webstuff, they run on a very slow IDE bus. They work excellently for say processing like the middleware box, or actual webservers but disk heavy apps I would avoid as the disks cannot keep up with the processing power. The Netra T1, what a box worth while in every way, small VERY fast got the new trendy prom cards as an option. Fast disks, excellent processing of an Enterprise Sparc Chip. Great machine. Be warned though sticking external disks on this is not as straight forward as other larger sun kit. There have both got to internal HME class cards in which work really well. Oracle didn't run to great with large ammounts of recrds, so much infact that a web customer we had we had to upgrade. take a look at smg.co.uk this runs 3 webservers on T1's load blanced in hash format, with a alteon load balancer. Connected on an internal address to a Sun 420R with a Disk array running Oracle. The netras run Java, PHP, sendmail, and a couple of other apps. They all had 512 meg of memory but where starting to strain a little. Hope this helps. Matt. -Original Message- From: Christopher Thorpe [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 11:07 To: [EMAIL PROTECTED] Subject: Sun netra's and MySQL Hi all I was thinking of hosting our MySQL database on a cluster of Sun Netra's either tmX1 or tmT1 and was wondering if anyone had any experience of these boxes and how well they work with MySQL. Our database has about 30 tables and about a million rows. Anyone have any ballpark figures on the number of concurrent connected clients and queries per second you can achieve on one of these? thanks and best wishes Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Need A book for dynamic website
I found this one was pretty good when I fancied learning PHP... http://www.wrox.com/Books/Book_Details.asp?ISBN=1861003730 Beginning PHP4 What does this book cover? Complete tutorial in the PHP language Installation guide and troubleshooting tips Introduction to relational databases and MySQL Practical worked examples throughout, including detailed case study All code written for both Windows and UNIX systems Detailed language reference included Technology Overview PHP is a rapidly growing Web technology which enables web designers to build dynamic, interactive web applications, incorporating information from a host of databases, and including features such as e-mail integration and dynamically generated images. PHP4 added tons of features to make web application development even easier, and this book will show you how to make the most of the language's powerful capabilities. This book is a complete tutorial in PHP's language features and functionality, beginning with the basics and building up to the design and construction of complex data-driven websites. Fully working examples in the book include a directory-style web search engine, a mailing list management system, a web based file editor, and a graphical online shopping mall guidebook. Who is this book for? Anybody who knows HTML can use this book. If you've done any programming, that will be useful, but it's not a requirement. You can run all of the code on either a Windows or UNIX (e.g. Linux) system, and the book explains how to set up a web server and database in both of these environments. Wrox provides on-line discussion for the above title and surrounding technologies on P2P. -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 3:38 PM To: [EMAIL PROTECTED] Subject: Need A book for dynamic website Hi, I need a book to teach me how to make a database driven website, I think php mySql is the way to go and have seen some on amazon and fat brain but don't know if any are any good, any ideas? Thanx in advance DavidJaymz Here are the books I'm thinking of: PHP and MySQL Web Development Luke Welling, Laura Thomson Database Driven Web Sites By Joline Morrison,Joline Morrison Sams Teach Yourself Active Web Database Programming in 21 Days By Dina Fleet,Matt Warren (Editor) Building Database Applications on the Web Using Php3 By Craig Hilton,Bjorn Borud,Jeff Willis Create Dynamic Webpages Using PHP and MySQL David Tansley PHP: Fast and Easy Web Development J. Meloni Thanx again: DavidJaymz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Fulltext search variable
Hi Sergei Thanks for the prompt reply... I've just tried AGAINST ('Jonat*') but get the same results... we've actually got the ft_min_length set to 2 as we have a few authors whose surnames are Li (and we've found no major performance issues). I'd tried a few longer words before like 'genom*' for genome/genomics etc but still get no results in our full length article fulltext index... we just can't seem to get the truncation operator to work at all... glad I'm trying to use it correctly!! It would be really cool if we could fix this soon... it's pretty critical to what we want to do with our search engine thanks Chris -Original Message- From: 'Sergei Golubchik' [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 11:37 AM To: Christopher Thorpe Cc: [EMAIL PROTECTED] Subject: Re: Fulltext search variable Hi! On Nov 13, Christopher Thorpe wrote: Hi Sergei Sorry to post off list to you, not sure what else to do... I've posted to the list twice but received no reply at all to my query. I'm doing a whole load of MATCH AGAINST queries, but have no luck at all in using the truncation operator. I can use the +word just fine to make sure that words are present, so I know that 4.0 is working fine for me (I'm on Win2K), but when I do the following query I get 239 records SELECT arx_title FROM arx WHERE MATCH (arx_authors) AGAINST ('Jonathan') when I do this I get none SELECT arx_title FROM arx WHERE MATCH (arx_authors) AGAINST ('Jon*') and when I do this (just to check!!) I get an error SELECT arx_title FROM arx WHERE MATCH (arx_authors) AGAINST ('Jon'*) Please can you tell me how to use the truncation operator, because it's really pretty vital for what we're trying to do with the Fulltext search (which we all think performs way better than Oracle's by the way) best wishes and sorry again Chris Try ...AGAINST ('Jonat*'), for example. I think 'Jon' is discarded by the engine because it's less then ft_min_len (not very smart for truncation operator, indeed). I cannot verify it, though, as in the development source tree fulltext search is completely rewritten now, so to test that for you I have to download and build 4.0.0 sources. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Fulltext search variable
Hi Sergei and everyone... Thanks for the help... looking forward to 4.0.1!! best wishes Chris -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 1:30 PM To: Christopher Thorpe Cc: [EMAIL PROTECTED] Subject: Re: Fulltext search variable Hi! On Nov 13, Christopher Thorpe wrote: Hi Sergei Thanks for the prompt reply... I've just tried AGAINST ('Jonat*') but get the same results... we've actually got the ft_min_length set to 2 as we have a few authors whose surnames are Li (and we've found no major performance issues). I'd tried a few longer words before like 'genom*' for genome/genomics etc but still get no results in our full length article fulltext index... we just can't seem to get the truncation operator to work at all... glad I'm trying to use it correctly!! It would be really cool if we could fix this soon... it's pretty critical to what we want to do with our search engine thanks Chris Then, I cannot help. The code you're tryung to use was removed from MySQL source tree several months ago. Wait for MySQL 4.0.1. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ASP with MySQL
Raymond, We run ASP with MySQL constantly using both ADO and a JDBC connections to it and experience great stability with it... this is with ASP on a WinNT/Win2K platform... we've never tried ChiliASP best wishes Chris Dr Christopher Thorpe Information Architect GenomeBiology - biology for the post-genomic era w http://www.genomebiology.com t +44 (0) 20 7631 9184 (direct) -Original Message- From: Woolsey, Fred [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 3:41 PM To: [EMAIL PROTECTED] Subject: RE: ASP with MySQL Raymond, I would expect so (although I haven't tried it), since both ODBC and OLEDB providers (MyODBC and MyOLEDB, respectively) exist for MySQL on Windows. I have used MyODBC with VBA in an Access 2000 front end to a MySQL database, and it works, albeit with a few minor glitches and less than stellar performance. Both drivers are, I believe, available from the MySQL site http://www.mysql.com. Cheers, Fred Woolsey -Original Message- From: Raymond Tsang [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 10:09 PM To: '[EMAIL PROTECTED]' Subject: ASP with MySQL Hi, I would like to ask if MySQL can work with ASP, providing I have installed ChiliASP on a Unix server. Thanks. Regards, Raymond Tsang Building Access Database Developer PowerTel Limited 55 Clarence Street, Sydney 2000 Tel: 8264 3839 Fax: 8264 4555 Email: [EMAIL PROTECTED] ** PowerTel Limited, winners of Broadband Wholesale Carrier of the year, CommsWorld Telecomms Awards 2001 Best Emerging Telco, Australian Telecom Awards 2001 ** This email (including all attachments) is intended solely for the named addressee. It is confidential and may contain commercially sensitive information. If you receive it in error, please let us know by reply email, delete it from your system and destroy any copies. This email is also subject to copyright. No part of it should be reproduced, adapted or transmitted without the prior written consent of the copyright owner. Emails may be interfered with, may contain computer viruses or other defects and may not be successfully replicated on other systems. We give no warranties in relation to these matters. If you have any doubts about the authenticity of an email purportedly sent by us, please contact us immediately. ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
setting ft_min_word_len
Is there any way of setting the ft_min_word_len variable in MySQL4.0 without having to recompile? I'm like other people finding problems with the 3 letter block on fulltext index inclusion as a few queries are for people's names which are three letters long. thanks Chris database, query Dr Christopher Thorpe Information Architect GenomeBiology - biology for the post-genomic era w http://www.genomebiology.com t +44 (0) 20 7631 9184 (direct) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: setting ft_min_word_len
Thanks Sergei, fantastic news... I like version4.0, thanks folks, big congratulations all round :-) Chris -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 4:18 PM To: Christopher Thorpe Cc: [EMAIL PROTECTED] Subject: Re: setting ft_min_word_len Hi! On Oct 25, Christopher Thorpe wrote: Is there any way of setting the ft_min_word_len variable in MySQL4.0 without having to recompile? I'm like other people finding problems with the 3 letter block on fulltext index inclusion as a few queries are for people's names which are three letters long. thanks Chris Why - every mysql variable can be set w/o recompilation. ft_min_word_len is in no way different. mysqld --set-variable ft_min_word_len=3 :-) Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
stopwords
Is there any way to remove the treatment of words three letters and under being treated as a stopword when performing a query of a full text index on a table. If it is a recompile of MySQL is there a good resource on how to do this... I'm a newbie to the world of compiling MySQL thanks Chris Dr Christopher Thorpe Information Architect GenomeBiology - biology for the post-genomic era w http://www.genomebiology.com t +44 (0) 20 7631 9184 (direct) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ADO/ODBC question
Hi all quick question if I use a query such as the one below INSERT INTO usq (usq_id,usq_querystring) VALUES(NULL,'test'); SELECT LAST_INSERT_ID(); how do I push this two part query through an ADO command object and how do I get the variable back from the select part of the query... alternatively should I do it as a recordset update? code samples and/or advice would be gratefully received... cheers all and thanks for a lovely stable database Monty and the team Chris Dr Christopher Thorpe Information Architect GenomeBiology - biology for the post-genomic era w http://www.genomebiology.com t +44 (0) 20 7631 9184 (direct) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql.org
I would like to whole heartedly add my support to this statement, I feel that Gerry has summed up perfectly everything I would like to say. We have been using MySQL for well over a year now and have found it to be a fast, reliable, efficient and scalable product. I happily recommend the use of it to colleagues and use it in my corporate work and when advising charities. The efforts of the developers shine through in the excellent performance of this product. It is sad to see people taking advantage of their efforts and I feel that MySQL AB has not in any way besmirched the principles of open source by taking the actions they have taken. best wishes and keep up the wonderful work, you are much appreciated Chris Dr Christopher Thorpe Information Architect GenomeBiology.com Middlesex House 34-42, Cleveland Street London W1P 6LB T 0207 631 9184 Whttp://genomebiology.com/ -Original Message- From: Gerry Sweeney [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 7:15 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: mysql.org Monty and all at MySQL, I am sorry to hear about this most unfortunate situation. It is sad to see that NuSphere have taken it upon themselves to attempt to steal your intellectual property and try to benefit from all of the MySQL team's hard work. My company has been licensing using MySQL for development of our products for the past 18 months or so and I have had nothing but good things to say about MySQL. You are a credit to the open source community and I believe you have found the perfect balance with MySQL for both open source and commercial users. Your comments that you totally rely on the trust of your users is admirable and very much appreciated by many people I am sure. However, being the human race, there are always people that are going to take liberties and abuse such trust. I hope that your legal defence is swift and successful and does not cause too much disruption to your day to day business. As far as I am concerned, if NuSphere are selling a product derived from MySQL, then they should be paying MySQL.com a license fee to ensure that the professionals that are responsible for the creation of MySQL can continue to develop MySQL. We *embed* MySQL into our products and pay commercial license fees for the use of MySQL. Having dealt with MySQL at a commercial level, I can honestly say that, there is absolutely no excuse for what NuSphere have done. Your licensing policies have been totally fair, non-restrictive and realistic. Needless to say, You have our full support and rest assured I, or anyone who works at my company will not have anything to do with either mysql.org or NuSphere now or in the future. Kind Regards Gerry Sweeney Hornbill Systems Limited - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: (win 2000 + mysql) = problem
it ran first time for me the other day when I comissioned a new box... does the service give any error messages when you tried to start it? -Original Message- From: Andrey Goncharenko [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 10:04 AM To: '[EMAIL PROTECTED]' Subject: (win 2000 + mysql) = problem I install mysql (v 3.23.39) on Windows 2000 pro, but server is not run:( Plese, help me... What I must to make? ó Õ×ÁÖÅÎÉÅÍ, áÎÄÒÅÊ. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Storing multi-page texts
You could store the data as XML and use XSL to transform it when you pull it out of the database -Original Message- From: Chris Lott [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 08, 2001 7:39 PM To: MySQL List (E-mail) Subject: Storing multi-page texts What kind of methods have any of you used for storing text that needs to be displayed as both multi-page (for reading) and single-page (for printing)? My plan is to store the articles with basic HTML formatting that will render based on the site stylesheet(s). I'm using MySQL. My main question is how to deal with the multiple pages. Higher-ups would prefer that article authors not have to split the file into various fields when composing. My idea is to have the authors insert a code/comment that indicates a page break in the text (something like, cryptically, PAGEBREAK) and then when pulling the article from the DB, create a menu for selecting pages (there has to be a small menu at the bottom of each article with a link to each article page and an indication where the user is), display the proper page, etc. I've still not got my head completely around how I am going to do this, so I am looking for suggestions on how other sites manage this need. c - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php