RE: 6.5 seconds seems slow for the following search?

Big tables, a join and a LIKE on middleweight hardware - looks about right to me. Peter -Original Message- From: Kyle Renfro [mailto:[EMAIL PROTECTED] Sent: 27 March 2004 00:48 To: [EMAIL PROTECTED] Subject: 6.5 seconds seems slow for the following search? I am testing MySQL as a

Re: Deleting a database

Ola Would DROP DATABASE databasename; not do it? I beleive, and I may be wrong, the only other way to delete JUST the tables is as you mentioned ( delete table gl_story, gl_submit,... OR drop table gl_story, gl_submit,... ) -- Jeremy Oliver Bluejays PC Repair tel 0208 656 1056 mob 07 855

purge logs problem

hi listers i have 'log-bin' enabled in my.cnf for replication purposes. once in so many days i remove them using syntax purge master logs to 'logname'. this is fine and works ever time for all lognames i specify. but today i have a problem with 1 of the 7 i had to delete (the last 1 for that

Re: invalid zip file...

On 26.03.2004 17:12 (+0100), Bruno wrote: I tried to download mysqlgui-win32-static-1.7.5-2.zip, but it doesn't appear to be a valid archive... What should I do?? Depending on its size, re-download it and see if it was simply a download error. If this won't help, see the file's header. If it

TEST MAIL

This is a test amil, please ignore -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / /

RE: ORDER BY WITH NO PRINT

This may sound a little bit off, but what programming language are you using to print this. It might be easier to simply use a language like perl to print out the output that you are suggesting. From: Seena Blace [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: ORDER BY WITH NO PRINT Date:

Bug in MySQL with Correlated Subqueries?

MySQL 4.1.1-alpha incorrectly computes select-list correlated subqueries. See the explanation of the problem below. Is this a known problem? Thanks! Consider the following schema and data: CREATE TABLE person (pid INTEGER, name CHAR(5)); CREATE TABLE phone (pid INTEGER, num CHAR(10)); INSERT

Re: 6.5 seconds seems slow for the following search?

In the last episode (Mar 26), Kyle Renfro said: I am testing MySQL as a possible replacement for our proprietary db server for several large databases. I really want MySQL but I am getting what seems like slow search times. Does 6.5 seconds seem slow/typical/fast for the following search?

Installing MySQL

Dear all, Is it possible to install mysql locally on Sun Solaris 8 as I do not have root permission ? If so, what is the expected total size on disk and recommended steps (./configure, make, make --prefix=/my/home/ install : is this sufficient) ? Any hints or pointers are much appreciated.

Directory question for the masters...

I need to access a specific directory from within tomcat, but I'm having a specific problem and require some advice. I have a link to a file in the servlet, something like https://myserver.com/special-directory/file.zip; If I create the directory as follows:

Re: Bug in MySQL with Correlated Subqueries?

At 13:59 27/3/2004, Ed Smith wrote: Hi, Below the results from a server built with BK 4.1 tree 3 days ago: C:\mysql\binmysqld --standalone --console --ansi --default-table-type=innodb 040328 0:36:59 InnoDB: Started; log sequence number 0 43634 mysqld: ready for connections. Version:

Reading Binary Data

Hi Folks -- Been working on this issue for a while, and not making much headway, so I thought I'd throw it out to the list and see what wisdom came back :) Problem: I'm trying to find a way to store LOTS of scientific data (mostly 32-bit integers and floating point numbers) in a database for

Re: Your archive

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

Re: How stable is 4.0.18?

Pete Harlan wrote: My two cents: Just upgrade. We hammer on it pretty hard and the transition has not only been smooth, it's been a delight. The query cache, on our load, handles 60% of the queries, which I never imagined would happen. 4.0.18 feels as boringly stable as most released

Compiling MySQL 4.1.1 For New OpenSSL Version

I downloaded the Linux RPM binaries for MySQL 4.1.1 and all except MySQL-shared-4.1.1-0.i386.rpm and MySQL-shared-compat-4.1.1-0.i386.rpm installed correctly. The -shared RPM failed on missing dependencies, it was looking for openssl 0.9.6 and libcrypto 0.9.6 shared libraries and couldn't find

MY APOLOGIES!!!

Very Sorry!!! I sent a Tomcat request to this list by mistake. Please ignore it. Thanks, -Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]