Re: SCSI vs IDE
Thomas S. Iversen wrote: Back to the question: we're on a limited budget, and have to choose between either inexpensive but large IDE disk or fast but small SCSI disks. The machine has 1GB memory. First thought would be IDE disks since we have enough memory to cache the DBs. If you're on a budget, check out some of the IDE RAID options. You can build a RAID 0 using a fairly cheap card (I would have suggested a MB with RAID 0, but you probably already have one without). Promise's SuperTrak SX 6000 will also do RAID 0, 1, 0+1, 3, 5 and JBOD on six disks with up to 128 MB cache (you buy one $20 SDRAM chip), but it is a bit pricier at ~$450. You can save your money by getting multiple $100 IDE drives. Do NOT get the SuperTrak 100, it is almost as slow as one drive in RAID 5. Anyone actually have experience running MySQL on a large-ish IDE RAID? Frank. - 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: Info Needed to Promote MySQL!!
Adam Douglas wrote: 1. Replication between 2 sites via the internet over a VPN or just using a secure connection. Chapter 11 in the manual (p. 354 of the PDF). You're set. SSH will get you the secure connection. 2. Transaction processing capabilities with the ability to roll-back a transaction. I've been informed that the innodb table type supports transactions. 3. A Windows based interface that is easy to use, similar to Access look/feel. Others are answering this. Of course, if it's just for users to pull info out of, you could build an intranet front-end with your favorite scripting (PHP/ASP/Perl) or tag-based (Blueworld Lasso) language. 4. ODBC compliant database and drivers Lots of 'em: http://www.mysql.com/downloads/index.html 5. Ability to provide connections to website via PHP And it does it extremely well and blazing fast. 6. Commercial support.. consultants, services, etc. Just ask on this list, plus there are links at the MySQL site. Of course, I'd wait until 4.0 is out in a week or so and then ask these questions again. The answers are sure to be even more positive then. Frank. - 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: Size of DB
Ian Barwick wrote: In Windows you can probably do something involving the mouse and some icon-thingies, or maybe a simple DIR at the command line. Right-click on the MySQL database folder, selecting Properties. Under DOS, substitute your Unix command with DIR and look at the total at the end of the list, and use backslashes instead of forward slashes. Of course, you could do the icon-thingy with KDE, Gnome, etc. Frank. - 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: Let's approach stored procedures
Adams, Bill TQO wrote: The other thing about all of this is that MySQL is feature rich so most people might not have a use for stored procedures. Unlike, say, Informix which has not build in MIN or MAX function. Depending on the way you define things, MIN and MAX are essentially stored procedures that were programmed into MySQL. Why not let us make our own? Frank. - 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: Use of the MySQL logo - licensing agreement
And then there's the sad situation I'm in. I'm using MySQL to do a site for the U.S. Army, but I am not allowed to put the logo up as it would be considered an endorsement of a commercial product, which is a major no-no. And I'd like so much to do it. I'm thinking of a way, but I'll have to consult Legal to see if I'm okay (contact/about this site page with logo, and with required disclaimer that we don't endorse, etc.). Frank. - 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: Good references for Theory??
John Coggeshall wrote: Hey all I've been a bit of a dweller on this list for quite some time now. I'd like to throw a question out for all of you.. I have at least a decent understanding of the concepts behind a relational database, but I'd like a little more information on the theory, etc... does anyone know of any good sources?? Do a simple Internet search for database normal form and you should get about everything you need to design your MySQL DB. Frank. - 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
Speaking of tree searches
I have an upcoming project which will require me doing a recursive function in PHP, doing a tree calculating optimum route between defined points in the database. The function is going to have to do a SELECT on the MySQL database on each iteration. It could concievably do thousands of iterations on about a hundred points in the database. Anyone think MySQL can handle the load, or do I have to try a workaround and put the whole database in an array first? No two SELECTs should be the same, so I'd have to play with that array a lot if I did that. Frank. - 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: Speaking of tree searches
Hans Zaunere wrote: Maybe it's just me, but it sounds like you need to reconsider you're database structure. I can't think of any reason that such a schema would be required. It's simply a database of locations on the globe, and I need to calculate how to get to one place from another using any locations in between. The database layout is one simple table with all of the point info, such as latitude and longitude, on each record. The recursive calculation to search all possible routes and pick the best one isn't too hard, I'm just worried that the number of database queries all at one time as the function digs down into itself might overload the server. Frank. - 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: Downsides of MySQL?
Steve Edberg wrote: Do these people even know what they mean by 'enterprise management functionality', or did they just crib from an Oracle brochure? DO they have any specifics about what they require? Managers do that all to often when comparing software. They look at the feature sheets and then take the one with the highest count and coolest names. I think the Oracle advertising people write better than the MySQL people. When I once wanted to get Photoshop, I had a manager with a recent PC World (or one of those rags) article comparing it with Corel PhotoPaint. He wanted to get Corel based on the extensive (mostly eye candy) feature list. Forget about how well the program actually performs. Frank. - 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: Retrieving Auto-increment index after insertion.
Charles Williams wrote: Hello, I am trying to figure out how I can retrieve an automatically incremented index after I insert data into the table. The index is the ONLY information that is unique in the entry at times and additions are quite often. Any ideas would be appreciated. In the manual, page 129, use the function LAST_INSERT_ID() Frank. - 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: Downsides of MySQL?
Boget, Chris wrote: --Begin Quote-- MySQL - as I said at our meeting, we would not be comfortable with this as an enterprise strength solution. MySQL is unsupported freeware and lacks enterprise management functionality. It has a small limited feature set compared to ORACLE, DB/2 and is lacking the functionality to support Well, do they want to spend massive amounts of money or don't they? Where are the bean counters when you need them? data replication and has little capability for generating management info. Someone's been listening to FUD again How much time has the Oracle rep spent wining and dining this guy? That it replicates is well established. There are question marks around the scalability of the product, I'm not Have you seen the system Slashdot runs with MySQL? Wow! If anyone has a heavy load, it's Slashdot. The fact that it is unsupported freeware would mean that an end user would Someone needs to get defininitions straight. freeware does not equal GPL, and that is if you get the GPL rather than the *supported* version. potentially be held to ransom by a DBA with specific knowledge. The mySQL MySQL is so widely used that it shouldn't be a problem to get another knowledgeable DBA, and probably cheaper than an Oracle one. Also, check the todo list and see what's coming out in 4 that address any other problems. From what I've heard, a large number of people running Oracle are on serious overkill. I'm about to put a database on Oracle (as directed from high) when I know MySQL can handle it. Man, the MySQL employees are going to go off on this one. Frank. - 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
Migrating to MS SQL Server
My company just stole my web server running MySQL. I will now have to host my site on a consolidated server that has MS SQL Server. How do I migrate? I think my SQL code will be good except for auto_increment, but are there any migration tools? Frank Fisher - 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