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
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
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
--- 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
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
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
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
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
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
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
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
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
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
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
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
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,
>...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
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
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
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
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
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
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
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
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
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.
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
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
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 '\
29 matches
Mail list logo
