Re: Mysql for Family History (genealogy)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 27 April 2004 01:40 pm, zzapper wrote: Hi, Anyone designed a MySql database for family history? Any ideas,recommendations, problems ? I know I've seen a few people with Gedcom to mysql stuff. So I'd use that as a basis for searching. - -- - -- Jayce^ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFAkEROA10/0O8cAHgRAgB1AJ4wvDpKg3OkuA9THKtjLxKmLOmPqwCeMkhJ S3asqfZ24J3CjSKn8xlMDGg= =R67R -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ancestry program
On Tuesday 28 October 2003 11:24 am, Dathan Vance Pattishall wrote: Think of a binary tree. Parent_id auto increment Child_id Details of the famly The head of the family has a child_id == parent_id All members of the family have different child_ids but the same parent_id Then you can do some really cool recursive fast searches. But this does NOT work well for real life genealogy. Think of step/half families, etc. No, better to look at system's that deal with this. Look at GEDCOM, genxml, or similar systems. I know I have seen several gedcom - sql schema's out there, some for mysql even. There are also several systems for archiving information such as family events or media, and linking those people to that data. -- Jayce^ pgp0.pgp Description: signature
Re: fulltext search
On Monday 24 March 2003 04:04 pm, Brian McCain wrote: Maybe they should set up some way to donate via PayPal. I'm sure there are plenty of developers around the world who'd be willing to chip in $10 here or $20 there in order to be able to use fulltext searching on InnoDB tables. I know I would. I actually like that idea a lot myself. I know I always try and get $current_company to get support contracts, but that doesnt' always happen. I think it'd be cool to 'vote' for future enhancements with our money. -- --Jayce^ pgp0.pgp Description: signature
Re: Transaction Support in mysql13.23.54
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 22 January 2003 08:56 pm, Nirmal Shah wrote: hi, i have installed mysql3.23.54 on windows and have followed all instructions as required for using mysqld-max to have transaction support. i have created a table using TYPE=INNODB, but cannot use rollback on it. the error i get in my jsp is transactions not supported. please advice me on how i can use commit - rollback on mysql database tables. You might check your connection to, I received a similar on a machine connecting through perl/DBI, and the problem was that the DBI package merely needed upgrading, mysql had been set up correctly. If your mysql really is set up right, you could verify this by trying to perform a transaction via command line. If it works there, it's your connection most likely. - -- - --Jayce^ -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+MCoIA10/0O8cAHgRAgRWAKC1sZxyOoV+He8dZSe+vHbmTwlyMgCfVqrs c6+peQEq9/gIBwOxASBfYDk= =Y/8s -END PGP SIGNATURE- - 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 db as filesystem.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Actually, I remember reading about a mysqlfs system, like that, cd to a table, ls for records.. rm to remove and such. that was over a year ago at least.. check sourceforge or google, I bet they'd be able to tell more. Archives might too. Jayce^ On Thursday 10 October 2002 10:32 pm, Joel Rees wrote: At 12:58 +0200 10/10/02, Alex Polite wrote: Is there any way I could display a MySQL database as a filesystem under Linux? To which, on Thu, 10 Oct 2002 at 17:56:31 -0500, Paul DuBois asked What does that mean? Should we guess that he wants to be able to log into a database with csh, run ls and get a list of tables, run cat on a table and get a tab-delimited listing of the contents of the table? On the surface it didn't seem like such an unreasonable question, ... - -- - --Jayce^ -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9pxhyA10/0O8cAHgRAp7kAJ972XyI6+ys+X3rzc13/2mprw2HTwCeOy2m iuG//UzD37flqBKMVwvcDrg= =bT50 -END PGP SIGNATURE- - 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: Load problems with 3.23.51
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and tried 51. No dice. It does not handle load, CPU and the load average go through the roof. I'm using Red Hat Linux 7.2 and the official mysql binaries. It appears to be slow to connect, causing 0.5 to 1.0 second delay on connection. We have had the exact opposite reaction on our RH 7.2 boxes. .49 would consistently crash every hour under load (the innodb high avail_cc thingy). But since upgrading to .51 our load has been down, and we've only restarted once, to enact some .cnf changes. For us, the upgrade has been a godsend. This is using the official binaries (not RPM if that makes a difference at all). Jayce^ -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE9F0YmoTgdT9hhlCIRAtTSAJ49rm81dRjAfLq7qWQbyzXJTccWQgCfR/K9 rsRDVWUd3UssqzMcvk1RB64= =C/uf -END PGP SIGNATURE- - 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: Attn: MySQL AB: we need 3.23.5x NOW !
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I know my company is having a similar problem, the reason we're not building our own anymore, and the same reason we're having trouble with the rpms is the gcc on RH which is causing us serious stability problems. Might have the same problem we're having. Jayce^ On Wednesday 05 June 2002 03:27 pm, Jeremy Zawodny wrote: On Wed, Jun 05, 2002 at 11:31:56AM -0700, j.random.programmer wrote: If any folks from MySQL AB are reading this: I need to go into production *today* with 3.23.5x. I am using InnoDB heavily (and need the newer fixes). 3.23.50 hasn't even been released yet (the pre-release version is not stable) and based on posts on this list, we know that there are several bug fixes and versions after 3.23.50 (for example 3.23.52 is rumored to exist). We're running a custom-compiled 3.23.51 (or .52-pre, depending how you look at it) in production now. It's been up for about 6 days (details below) and has been rock solid. Why not build your own? I can send you a binary that works for us. But you'd really need to do some testing locally. I'm guessing that you're not a paid support customer of MySQL? If you were, you might be able to get a binary out of them (but I don't know for sure--I've never had to ask). Jeremy -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE8/omhoTgdT9hhlCIRAoEgAJ9TYTT9HrppPTZ5HtBdsxchsrHNOQCgqc2X IxEYLSIyMxZRLljF3PEly+o= =yRIL -END PGP SIGNATURE- - 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: Results relevance
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Well, you could just base the 100% off the highest returned value. eg, if 3.95 is the highest return, then, that's your 100%, the others are just percentages of that. Jayce^ On Monday 29 April 2002 01:44 pm, Mouratidis wrote: Actually, that is exactly what I wanted to do! A bar graph for showing the relevance between the term I am searching for and the results I get from Mysql for a library system. I just don't know how to draw the bar (which is going to be a table cell in a table) if I cannot have something to compare it's value with. I mean, it is easy to dynamically draw a bar with Perl using HTML, but, what is the 100% ? - Original Message - From: Jim Philips [EMAIL PROTECTED] To: Paul DuBois Mouratidis [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 29, 2002 8:15 PM Subject: Re: Results relevance If the final goal of this is a visual display, maybe it would make more sense to display relevance as a horizontal bar graph that is longer or shorter based on the relevance number. There is no reason to get hung up on percentages. On Monday 29 April 2002 02:21 pm, Paul DuBois wrote: At 17:50 +0100 4/29/02, Mouratidis wrote: Doing that will not give back a percentage or anything that can be used to calculate one (right?). I meant if there was a way to actually get a result that could be interpreted into a percentage somehow. No. The values returned by a FULLTEXT search are simply non-negative floating-point numbers. The larger the number within a result set, the higher the relevance, but that doesn't map onto percentage. - Original Message - From: Gurhan Ozen [EMAIL PROTECTED] To: Mouratidis [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 29, 2002 3:58 PM Subject: RE: Results relevance Hi, You can just do SELECT MATCH(column name) AGAINST ('searchstring') AS relevance FROM tablename; There is an example at: http://www.mysql.com/doc/F/u/Fulltext_Search.html Gurhan -Original Message- From: Mouratidis [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 6:38 AM To: [EMAIL PROTECTED] Subject: Results relevance Anybody knows how to get a percentage out of the Relevance Mysql returns when queried with the match() function? I am using Perl, so if there are any scripts or modules that you know of, those are also welcome. Alex - 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 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE8zaqMoTgdT9hhlCIRAqZrAKCWX61dxha/Louf3jDaNkYDsQl0SwCfeAyY Prpdjct4M6gwawISnibxArA= =xfGx -END PGP SIGNATURE- - 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: InnoDB frightens me...
On Monday 04 March 2002 09:32 pm, you wrote: On Mon, Mar 04, 2002 at 09:30:16AM -0500, Ken Menzel wrote: Hi Heikki, I don't know if this has been requested, but what about a tool to 'pre-create' dataspace? This tool would allow someone to create a new dataspace, then a quick restart (After adding the name of the space to 'my.cnf') and the new dataspace is available! Maybe just extract the pieces from MySQL code and make it a separate tool? I know I don't want to have a server shutdown while it creates 10GB of Dataspace! Of course autoextending is one answer. One could just create a small dataspace and let it autoextend. I'll second the request. I'm planning to test InnoDB with large tablespaces soon (on the order of .5TB) and would love to be able to create the data files off-line and add them as needed. Jeremy Ditto, I know this is one thing keeping us from going to Innodb full scale. Jayce^ - 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