Re: MySQL bottleneck

2005-04-16 Thread valentin_nils
Hi Wiley, I am still not sure if we are talking about 360k threats or clients, but I take your word from the first e-mail. basically I think its possible to setup a big DB (as Google, Yahoo etc. have shown already). About the hardware may I recommend 64 bit Opteron systems and scsi drives (array

Re: Relative Numeric Values

2005-04-16 Thread Peter Brawley
David, I agree with Kim. Trying to encode information into primary keys is a bit like trying to write a legal contract in chalk on a sidewalk. The contract is washed away next time it rains, the neat looking key order is washed away by errors, species discoveries & reclassifications. The PK doe

Re: MySQL not starting at boot-Fedora Core 3

2005-04-16 Thread Mark Sargent
Andy Pieters wrote: Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can use

Re: Relative Numeric Values

2005-04-16 Thread David Blomstrom
--- Kim Briggs <[EMAIL PROTECTED]> wrote: > David, > > In reading through miscellaneous database design > text on the web, I > read just the other day that you should not try to > include meaningful > data in your key values. I assume there will be > some kind of "lookup" > tables for species, p

Re: Relative Numeric Values

2005-04-16 Thread Kim Briggs
David, In reading through miscellaneous database design text on the web, I read just the other day that you should not try to include meaningful data in your key values. I assume there will be some kind of "lookup" tables for species, phylum, whatever. Trying to make your key field "smart" seems

Re: MySQL bottleneck

2005-04-16 Thread B Wiley Snyder
So is karma :) From: sol beach <[EMAIL PROTECTED]> Reply-To: sol beach <[EMAIL PROTECTED]> To: B Wiley Snyder <[EMAIL PROTECTED]> Subject: Re: MySQL bottleneck Date: Sat, 16 Apr 2005 20:56:08 -0700 Incompetence is its own reward. Simply put, 360K is NOT a big number or DB given today's hardware. O

Re: zip code search within x miles

2005-04-16 Thread Scott Gifford
Jeff Kolber <[EMAIL PROTECTED]> writes: > How are sites doing the search by zip and coming up with results within x > miles? Is there some OSS zip code download that has been created for this? The ones I'm familiar with use this: http://www.census.gov/geo/www/tiger/zip1999.html [...] > I

Re: MySQL bottleneck

2005-04-16 Thread B Wiley Snyder
Oh wait, I see what happend. I stepped on MY OWN thread. I hate when I do that ! Sorry From: [EMAIL PROTECTED] To: "B Wiley Snyder" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: MySQL bottleneck Date: Sun, 17 Apr 2005 01:21:36 - (UTC) Hello there, no offence but that questions is

Re: MySQL bottleneck

2005-04-16 Thread B Wiley Snyder
None taken, I'm sure it's a vague question but I had to start somewhere. I'm not an expert on anything that large as of today. 1) Is the data entered once and than mostly read access or is it frequently updated ? It's entered once but mostly(almost ALL 99%) read access. 2) Do you need transaction

Re: MySQL bottleneck

2005-04-16 Thread valentin_nils
Hello there, no offence but that questions is not answerable. I wouldnt expect many replies. Let me try to help you out by asking YOU a few questions which might point you into the correct direction: 1) Is the data entered once and than mostly read access or is it frequently updated ? 2) Do you

Re: 4==4something: equal vs identical

2005-04-16 Thread Paul DuBois
At 22:18 +0200 4/16/05, Andy Pieters wrote: Hi everone I ran into some situation where MySql selects a row by using the following query: SELECT `id` FROM `shop_products` WHERE `id`="4aef" LIMIT 1; ++ | id | ++ | 4 | ++ Granted the field IS of type int but 4 is not identical to 4aef (it

Relative Numeric Values

2005-04-16 Thread David Blomstrom
I think my question is more oriented towards PHP, but I'd like to ask it on this list, as I suspect the solution may involve MySQL. I'm about to start developing an enormous database focusing on the animal kingdom and want to find a key system more user friendly than the traditional scientific nam

Re: Database load and table design ?

2005-04-16 Thread Dan Nelson
In the last episode (Apr 16), Michael Gale said: > Currently I am using syslog-sql to store syslog data in a mysql > database. The table format is something like: > > IDhostnamefacilityprioritydatemessage > > Now I am writting a perl app to calculate stats based on

Database load and table design ?

2005-04-16 Thread Michael Gale
Hello, Currently I am using syslog-sql to store syslog data in a mysql database. The table format is something like: ID hostnamefacilityprioritydatemessage ID is auto incrementing Now I am writting a perl app to calculate stats based on the data in the table w

Re: Size of BLOB types?

2005-04-16 Thread Dan Bolser
Beautiful! Cheers, (one and all), Dan. On Sat, 16 Apr 2005, Dan Nelson wrote: >In the last episode (Apr 16), Dan Bolser said: >> The manual dosn't specify the maximum number of characters in the >> >> TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. >> >> http://dev.mysql.com/doc/mysql/en

Re: Size of BLOB types?

2005-04-16 Thread Dan Nelson
In the last episode (Apr 16), Dan Bolser said: > The manual dosn't specify the maximum number of characters in the > > TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. > > http://dev.mysql.com/doc/mysql/en/blob.html At the top of that page: The four TEXT types, TINYTEXT, TEXT, MEDIUMTEXT,

Re: Size of BLOB types?

2005-04-16 Thread Robert Dunlop
>...my question is what are the maximum >sizes (in characters) of each of the BLOB / TEXT types, I assume the reason the sizes are not given in characters is that these are binary fields - it's in bits because that's what relevant to binary data. >and why isn't that >information on the manual

Re: Size of BLOB types?

2005-04-16 Thread Hassan Schroeder
Dan Bolser wrote: FWIW? For What It's Worth... Naturally I followed that link, but was unable to understand (or piece together) the information there in. Storage Requirements for String Types: (or maximum length of BLOB types for dummies) Not exactly -- "storage requirements" include the DB overhe

Re: Size of BLOB types?

2005-04-16 Thread Dan Bolser
On Sat, 16 Apr 2005, Robert Dunlop wrote: >Your question was would a TINYBLOB hold 1,000 characters. >TINYBLOB (TINYTEXT) = 257 characters. 1,000 > 257 = No. >Your next option, BLOB (TEXT) = 64K. 1,000 < 64K = Yes. Yeah, I got that part, more generally my question is what are the maximum sizes

Re: Size of BLOB types?

2005-04-16 Thread Robert Dunlop
Your question was would a TINYBLOB hold 1,000 characters. TINYBLOB (TINYTEXT) = 257 characters. 1,000 > 257 = No. Your next option, BLOB (TEXT) = 64K. 1,000 < 64K = Yes. - Original Message - From: "Dan Bolser" <[EMAIL PROTECTED]> To: "Hassan Schroeder" <[EMAIL PROTECTED]> Cc: Sent: Sat

Re: Size of BLOB types?

2005-04-16 Thread Dan Bolser
On Sat, 16 Apr 2005, Hassan Schroeder wrote: >Dan Bolser wrote: >> The manual dosn't specify the maximum number of characters in the >> >> TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. >> >> http://dev.mysql.com/doc/mysql/en/blob.html >> >> Are these valid synonyms, TINYBLOB, MEDIUMBLOB

Re: Size of BLOB types?

2005-04-16 Thread Hassan Schroeder
Dan Bolser wrote: The manual dosn't specify the maximum number of characters in the TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. http://dev.mysql.com/doc/mysql/en/blob.html Are these valid synonyms, TINYBLOB, MEDIUMBLOB and LONGBLOB? The very beginning of the cited page is: A BLOB is a bi

Re: MySQL not starting at boot-Fedora Core 3

2005-04-16 Thread Andy Pieters
Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can use there: stop re

4==4something: equal vs identical

2005-04-16 Thread Andy Pieters
Hi everone I ran into some situation where MySql selects a row by using the following query: SELECT `id` FROM `shop_products` WHERE `id`="4aef" LIMIT 1; ++ | id | ++ | 4 | ++ Granted the field IS of type int but 4 is not identical to 4aef (it may be equal to the eyes of MySql) Is

Size of BLOB types?

2005-04-16 Thread Dan Bolser
The manual dosn't specify the maximum number of characters in the TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. http://dev.mysql.com/doc/mysql/en/blob.html Are these valid synonyms, TINYBLOB, MEDIUMBLOB and LONGBLOB? I have a field with just under 1000 characters, am I OK with a TINYTEX

MySQL bottleneck

2005-04-16 Thread B Wiley Snyder
Hello there, let's say I have 365,000 users I need to enter their data, pull from it and modify it regularly. Is MySql the way to go ? Or do I need to buy an oracle or ms server ? thanks in advance for a clue From: [EMAIL PROTECTED] To: "B Wiley Snyder" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.

MySQL not starting at boot-Fedora Core 3

2005-04-16 Thread Mark Sargent
Hi All, attempting another mysql install, on a 3rd machine. Extracted the tar.gz file to /usr/local/mysql. Followed the install docs here, http://dev.mysql.com/doc/mysql/en/installing-binary.html and successfully ran the MySql grant tables script, 6. If you haven't installed MySQL before, you mus

Include repeats in query

2005-04-16 Thread Martin Gallagher
Hi, I have the following query: SELECT person FROM people WHERE ORDER BY RAND() * (1 / score) LIMIT 1 This returns a person randomly, but the chance of the person being selected is increased with a higher `score`. What I want to do is make a single query that will return 10 results

Access denied-phpMyAdmin

2005-04-16 Thread Mark Sargent
Hi All, I can access the database from the terminal on Fedora 3, [EMAIL PROTECTED] bin]# ./mysql -h localhost -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.1.10a-standard Type 'help;' or '\h' for help. Type '\