RE: Graphical modelling
I tried half a dozen or so different ones a while back and settled on CASEStudio, www.casestudio.com. Mark Chalkley Beneficial Systems, Inc. *** REPLY SEPARATOR *** On 3/22/2001 at 3:35 PM claire csoka wrote: Dezign looks useful, but does anybody know any others - then I'll stop bugging you all. Thanks in advance, Claire. From: "Cal Evans" [EMAIL PROTECTED] To: "claire csoka" [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Graphical modelling Date: Thu, 22 Mar 2001 08:59:59 -0600 http://www.mysql.com/documentation/dezign/index.html There are several other tools available but I don't remember them off the top of my head. Cal http://www.calevans.com -Original Message- From: claire csoka [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 8:35 AM To: [EMAIL PROTECTED] Subject: Graphical modelling Hi, I'm new to the list so please excuse my ignorance! Does anybody know of any graphical ways of modelling the tables, keys, relationships etc which will then automatically generate the appropriate database? I'm looking at RAD with a MySQL back end. Thanks Claire. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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 END OF ORIGINAL TEXT * - 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: Trojan Horse Virus in MySQL?
I just dl'ed the file from mysql.com and checked it with a current version of Symantec AntiVirus with the latest virus definitions. Result: No viruses. Mark Chalkley - 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
Sample .cnf files
Can anyone tell me where I can download the sample .cnf configuration files mentioned in the documentation. I downloaded the Win32 source package (I paid for a license) and they're not in it. Are they only in the Unix source package or are they somewhere else? Or, perhaps, if someone has a copy of them they could email me, I'd be grateful. Thanks, Mark Chalkley - 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: Sample .cnf files
Nope, not that I could find. I've deleted it, already, but I searched for *.cnf and came up with a couple of files, but they were sample db specific. Mark *** REPLY SEPARATOR *** On 2/27/2001 at 11:44 AM Jeremy D. Zawodny wrote: Really? Is there no "support-files" subdirectory (or something similar) as their is on the Unix side of things? Jeremy -- - 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: Index Usage weirdness
I got to wondering about that after your question about how many rows were there. I was just playing with a test copy of the db, preparing to set the log options on the production one, and noticed that. I rummaged around in the .pdf version of the manual for over an hour before posting the question. Obviously, I missed it. Maybe I should've gone to bed earlier instead. It certainly makes sense for MySQL not to use the index in that case, of course. As for me, it's another situation of: If you're gonna train a dog, it helps to be smarter than the dog. Thanks! Mark Chalkley *** REPLY SEPARATOR *** On 2/25/2001 at 12:30 AM Jeremy D. Zawodny wrote: MySQL won't use an index on tables with so few rows. It is simply faster to scan the whole table. As you tables grow, however, MySQL will begin to use the indexes. This is documented in the manual (though maybe not with hard numbers). Jeremy - 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
Index Usage weirdness
I have a question about index usage. I've got a query that's showing up in the -slow log (it's taking less than long_query_time seconds, but I've got --log-long-format set), indicating that it's not using an index, and I don't understand why. Given two tables: CREATE TABLE c1 (id INT(8) NOT NULL UNIQUE, txt VARCHAR (10) NOT NULL UNIQUE, PRIMARY KEY (id) ); CREATE TABLE c2 (id INT(8) NOT NULL UNIQUE, PRIMARY KEY (id) ); CREATE UNIQUE INDEX c1_txt_idx ON c1 (txt); And the query: SELECT * FROM c1, c2 WHERE c1.id=c2.id ORDER BY c1.txt; Now, the question: Why is this query showing up in the -slow log? Thanks, Mark Chalkley - 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: Index Usage weirdness
At this point, there's only 1 row in companies, and 8 in contacts. table typepossible_keys key key_len ref rowsExtra companies system PRIMARY,comp_id 1 Using filesort contactsALL cont_comp_id_idx8 where used The query that produced the above is: EXPLAIN select * from contacts, companies where contacts.comp_id=companies.comp_id order by contacts.short_name; Mark Chalkley - 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: Data modeling tool
I agree that a time-limited, but otherwise fully functional demo is better, especially in the case (pardon the pun) of database modelling. It would certainly be worth sending them a message telling them so. You never know - they might agree with you. Mark Chalkley - 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: Data modeling tool
I haven't tried ERWin, but CASE Studio (www.casestudio.com) is extremely good, offers a trial download, and does support MySQL. Mark Chalkleyi - 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
Win mysqlc client anomaly - 2nd request
Does anyone know why the Windows version of mysqlc (the command line client with READLINE support) doesn't support the SOURCE command? Thanks, Mark Chalkley - 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