Re: Very large database

On Mon, May 20, 2002 at 04:13:36PM -0400, Rick Shifman wrote: My OS is Linux, running Apache. Do I have to go with Alpha architecture ? I need to keep 64Gb index in RAM to maintain quick response for web users. I heard of index clustering across multiple machines - is that an option ?

SQL query

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I have a simple SQL problem: I have two tables (two different log files): tbl1 TimeStamp, Code, OrderType ... 10:22:01, , N 10:23:02, , N 10:23:19, , N 10:24:11, 1222, N 10:25:11, , D 10:27:33, , N ... tbl2 TimeStamp Code

RE: Evaluating a String

I think I will describe the problem in detail. I using Container-Managed Persistence (CMP) beans in J2EE RI 1.3. I will like to specify the SQL for one of the finder methods to be: SELECT * FROM table1 WHERE ( ? ) This is to faciliate me manipulating the WHERE clause b4 sending it as a

Re: SQL query

This seems like a fairly straight forward and simple query, however you run into the max row information problem as described in the manual at http://www.mysql.com/doc/e/x/example-Maximum-column-group-row.html Finding the first part is fairly easy and straight forward, it is just getting the

About index in my sql!

Create a table like this: CREATE TABLE itg_passwd ( Username char(20) NOT NULL default '', Password char(20) NOT NULL default '', PRIMARY KEY (Username), KEY (Password(4)) ) TYPE=MyISAM; And insert some data; insert into itg_passwd values('1','h1'), ('2','h2'), ('3','h1/a'); Then

Having problem installing.

Yep, I'm a n00b, or whatever you want to call it. I'm having a problem installing MySQL version 4.0.1-2 (or any other version for that matter). I'm starting a rather large project where our funds are limited and we want a high performance database, so we chose to go with MySQL. Since we

MySQL InnoDB startup problem

I'm running MySQL 3.23.49. Everything was going good until today. I did a couple of large table reads/inserts/deletes on the InnoDB tables which appeared to go fine. I then restarted MySQL which also appeared to go fine. From that point on, however, I kept losing connection with the DB, and

About index in my sql

Create a table like this: CREATE TABLE itg_passwd ( Username char(20) NOT NULL default '', Password char(20) NOT NULL default '', PRIMARY KEY (Username), KEY (Password(4)) ) TYPE=MyISAM; And insert some data; insert into itg_passwd values('1','h1'), ('2','h2'), ('3','h1/a'); Then

Re: InnoDB, possible bug?

Andrei, this is probably not a bug in InnoDB. In theory, 4000 random disk seeks would use more time than scanning the whole table of 700 000 rows. The optimizer was tuned .48 (not yet in 4.0.1) to favor index searches over table scans. That may solve the problem here. On the other hand, the

Subselect or other way?

Hi, i have a table like this: Fields: id,nr I want now a query like this: SELECT id FROM Table WHERE nr=3D123 and (SELECT id FROM Table WHERE nr=3D456). Must i do this with a temp Table or ist there any other way to do this with Joins? I hope someone can help me.. regards Micha

SV: Subselect or other way?

This is a simple SELECT statement: SELECT id FROM Table WHERE nr=3D123 AND id = 3D456 this gives you probably one record, or you could use OR: SELECT id FROM Table WHERE nr=3D123 OR id = 3D456 this gives you all records with nr 3D123 OR id 3D456 // Jonny

AW: Subselect or other way?

I think my english ist too bad My table looks like this id nr --- 1 123 1 456 1 678 2 457 2 897 2 123 I want to select in a query only these id that have nr=123 and nr=456. In the example its only id 1. regards Micha -Ursprüngliche

<    1   2