RE: What is a good benchmark?

[Hubbard, Dan]

On my 2 * 2.8Ghz 2GB RAM, Redhat 8:

mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye"));
+--+
| BENCHMARK(100,ENCODE("hello","goodbye")) |
+--+
|0 |
+--+
1 row in set (0.66 sec)



-Original Message-
From: John Griffin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 8:02 AM
To: Bryan Koenig; [EMAIL PROTECTED]
Subject: RE: What is a good benchmark? 


On my 1.8GHz p4 with 512Gig of RAM I get:

mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye"));
+--+
| BENCHMARK(100,ENCODE("hello","goodbye")) |
+--+
|0 |
+--+
1 row in set (0.91 sec)

mysql>

John


-Original Message-
From: Bryan Koenig [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 10:46 AM
To: [EMAIL PROTECTED]
Subject: RE: What is a good benchmark? 


On my p4 2gig

mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye"));
+--+
| BENCHMARK(100,ENCODE("hello","goodbye")) |
+--+
|0 |
+--+
1 row in set (0.86 sec)

-Original Message-
From: Jake Johnson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 8:34 AM
To: Mysql
Subject: What is a good benchmark?

I ran this benchmark on my pIII 500 and was wondering what everyone else
was getting?

mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye"));

+--+
| BENCHMARK(100,ENCODE("hello","goodbye")) |
+--+
|0 |
+--+
1 row in set (2.59 sec)


Regards,
Jake Johnson
[EMAIL PROTECTED]

__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: What's up with this GATOR crap? unrelated to MySQL

[Hubbard, Dan]

My money is on that the person who is getting "this gator crap" has a a
peice of spyware installed on their machine (gator and/or savenow.exe). This
is an app that launches addware based on your surfing habits. I believe they
are the same people who were serving up the infamous X10 Camera adds.

My suggestion, check your applications list and look for the following:

savenow.exe
gator*.exe
weather.exe




-Original Message-
From: Taylor Lewick [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2003 8:34 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: RE: What's up with this GATOR crap?


Yes and think before you type,  "I may have to consider using another
database."
That shows real maturity.  First of all if you are really that important of
a customer and have the ability to influence your organizations database
useage decisions, and if this really angered you off that bad, then you
would contact MySQL directly, and voice your concerns with them.  Second, if
you are just a small site, or a one guy shop, or something like that, then
you threatening to end the use of thier product is really going ot have them
reeling.  Finally, no one on the lists cares.

Next time try this.  Hey all, I have noticed everytime I point my browser at
a mysql site I get gaterware popups and stuff.  Has anyone else noticed
this?  Is it something intentional done by MySQL or just a site the software
likes.  Anyone know of a good way to remove this software.  Its just really
annoying.  Thanks...


Please Note
The information in this E-mail message is legally privileged
and confidential information intended only for the use of the
individual(s) named above. If you, the reader of this message,
are not the intended recipient, you are hereby notified that 
you should not further disseminate, distribute, or forward this
E-mail message. If you have received this E-mail in error,
please notify the sender. Thank you
*

Encryption of user / pass in odbc.ini / alternatives

[Hubbard, Dan]

All;

Does anyone know of a more secure way than storing the username and password
to the database connection within the odbc.ini ? We are using PHP on one
server connecting to a MySQL 4.0 database ?

Thanks

Release timeframes --> need Internat. support

[Hubbard, Dan]

I am new to MySQL and was wondering if someone could share some past
experience on timeframes from alpha to full release ? We need full
Internationalization support and since 4.1 has it in it would like to get
some guesses on when it will be "production release".

Thanks

Archiving tables ranges

[Hubbard, Dan]

Passing mysql commands through mysqldump or BACKUP TABLE ?

We would like to perform backups on selective data within selective tables
and then purge the matching data in those tables. Is it possible to pass
mysql commands through either util above ? Which is better ?

Example: sql statement...

select * from tablename1 WHERE ((date_time > '2003-00-00 00:00:00') and
(date_time < '2003-06-31 00:00:00')); 

TIA !