Re: spreading the disk load

On Sep 14, 2005, at 6:16 PM, Chris Kantarjiev wrote: I'd like to spread the disk arm load across multiple drives. At the moment, we mostly use MyISAM tables, but we are also experimenting with InnoDB. What's the 'best practice' for doing this? There's no obvious configuration that lets me desig

Re: About database criterion

thanks gleb! I know tpc constitute a performance standard for database.For example,tpc-c,tpc-w. Now I want to know whether there are a standard for database system function.For example,maybe some describe in the standard : a good database must have view manage,index manage,trigger manage et

user and hostname connection priveleges

I had set up the following I have a MYSQL server running on let's say 123.xx.xx.xx User: user1 Host: 111.xx.xx.xx and gave that user the appropriate priveleges. So. I tried to connect to the MYSQL server from 111.xx.xx.xx using user1, but it won't allow my to. I then had to add this ent

Re: max Mysql database size

Andrew stolarz wrote: Hello Everyone, Hopefully easy question, What is the Max size of a MySQL server database? The answer to that question depends more on your OS than mysql. A quick search of the contents page of the documentation clearly list the limitations of this kind. -- Chris W

Re: max Mysql database size

I have a database, which is more than 120GB with about 500 million records. MySQL works well. Andrew stolarz wrote: Hello Everyone, Hopefully easy question, What is the Max size of a MySQL server database? -- Chenzhou Cui (Chi

max Mysql database size

Hello Everyone, Hopefully easy question, What is the Max size of a MySQL server database?

Re: spreading the disk load

Chris Kantarjiev wrote: I'd like to spread the disk arm load across multiple drives. At the moment, we mostly use MyISAM tables, but we are also experimenting with InnoDB. What's the 'best practice' for doing this? There's no obvious configuration that lets me designate one directory for index

spreading the disk load

I'd like to spread the disk arm load across multiple drives. At the moment, we mostly use MyISAM tables, but we are also experimenting with InnoDB. What's the 'best practice' for doing this? There's no obvious configuration that lets me designate one directory for index and another for data - am I

Re: spanned indexes

Gleb Paharenko wrote: You may want to think about the MERGE storage ENGINE, however it doesn't have a real spanned index. See: http://dev.mysql.com/doc/mysql/en/merge-storage-engine.html MERGE is not the case here, since it is JOIN of tables which are different in defintion. MERGE table wou

Re: spanned indexes

Hello. No. In the 'CREATE INDEX' syntax only a single table is allowed. You may want to think about the MERGE storage ENGINE, however it doesn't have a real spanned index. See: http://dev.mysql.com/doc/mysql/en/merge-storage-engine.html Eli <[EMAIL PROTECTED]> wrote: > Hi, > > Is

Installation

Hello, I hope you can help I installed mysql-4.1.14-ia64-11.23.depot on a HP-UX Itanium rx4640, 11.23 O.S. without a problem. I used the following install command: swinstall -s /tmp/mysql-4.1.14-ia64-11.23.depot The problem I'm noticing is that it appears I'm missing files - library files,

SAP Learning

Hi people, do you know any site with a tutorial from sap,or any good book, any resource? Thanks in advance -- lancer emotion 16 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: serial primary key produces two indexes

Thank Gleb, I misunderstood the meaning of the manual.. this is from the manual == |SERIAL| is an alias for |BIGINT UNSIGNED NOT NULL AUTO_INCREMENT|. |SERIAL DEFAULT VALUE| in the definition of an integer column is an alias for |NOT NULL AUTO_INCREMENT UNIQUE|.

Re: Connections with bad DNS cause lockups

Hi, Ok, I created the file and I looked and see absolutely nothing about the bad connection attempt, only good ones. I've posted it to : http://vjofn.tucs-beachin-obx-house.com/mysqltrace.txt does anyone see anything that would give any clues?

Re: unexpected EXPLAIN result with subselect

Matthias Pigulla wrote: Hi all, can someone explain me why this query gets executed the way it is? I simplified it as much as possible and think it's a conceptual/logical thing, so I'll omit - at least for now - the table definitions and sample data for brevity. -- "Superquery" EXPLAIN SELECT t

Re: spanned indexes

Eli wrote: The reason I thought about this is that I got several tables that hold their own specific data and are indexed inside themselves. But I got an issue to search on JOIN of 2 or more tables with comparison and/or ordering on combinations of fields from the various tables. This usualy

Problem with InnoDB backup

Hi! I have copied all the files from mysql/data folder and burned them on CD. Then i've formated old hard drive. Now i'm trying to copy them back on the fresh mysql installation. Unfortunately after I copy iblogs and ibdata1 mysql is not working anymore. What I can read in error log file is: Inno

Re: spanned indexes

OK.. Thanks for the fast replies.. The reason I thought about this is that I got several tables that hold their own specific data and are indexed inside themselves. But I got an issue to search on JOIN of 2 or more tables with comparison and/or ordering on combinations of fields from the vario

Re: how do I select among 2 columns ?

Scott Noyes wrote: I have a table like this : name, email_1, email_2 and I want to display in a web page name, email_1 if it exists, or email_2 if email_1 do NOT exist. What if email_2 does not exist, either? SELECT name, IF(email_1 IS NOT NULL AND email_1 != '', email_1, email_2) AS email F

EXISTS subquery optimization

Hi all, the manual says: "If a subquery returns any rows at all, then EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. ... Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with SELECT 5 or SELECT column1 or anything at all. MySQL ignores the SELECT list in such

Re: how do I select among 2 columns ?

> I have a table like this : > name, email_1, email_2 > > and I want to display in a web page > name, email_1 if it exists, or email_2 if email_1 do NOT exist. SELECT name, IF(email_1 IS NOT NULL AND email_1 != '', email_1, email_2) AS email FROM theTable; -- MySQL General Mailing List For list

how do I select among 2 columns ?

Hello, a simple question : I have a table like this : name, email_1, email_2 and I want to display in a web page name, email_1 if it exists, or email_2 if email_1 do NOT exist. of course I can do this inside a php script, by checking the content of the columns, BUT I had like to get the values t

Re: spanned indexes

Hi! Eli wrote: Hi, Is it possible, or probably will be possible, to define indexes spanned on more than one table? Short answer: AFAIK, it isn't, and it probably will never be. I mean that if I have column col_a from table tbl_A, and col_b from table tbl_B.. Can I define a KEY with both th

Re: spanned indexes

Eli wrote: Is it possible, or probably will be possible, to define indexes spanned on more than one table? I mean that if I have column col_a from table tbl_A, and col_b from table tbl_B.. Can I define a KEY with both those columns? Where will the index be saved? Just out of curiosity and to

Re: Last Update

Schalk <[EMAIL PROTECTED]> wrote on 09/14/2005 09:31:23 AM: > Greetings > > Is there a way to get the last update date for an entire table not just > a single row? More specifically, is there a way to do this with Java? > > -- > Kind Regards > Schalk Neethling > Web Developer.Designer.Programm

Re: spanned indexes

Eli <[EMAIL PROTECTED]> wrote on 09/14/2005 10:13:57 AM: > Hi, > > Is it possible, or probably will be possible, to define indexes spanned > on more than one table? > I mean that if I have column col_a from table tbl_A, and col_b from > table tbl_B.. Can I define a KEY with both those columns?

Last Update

Greetings Is there a way to get the last update date for an entire table not just a single row? More specifically, is there a way to do this with Java? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers -- MySQL General Mailing

Re: query

"N. Kavithashree" <[EMAIL PROTECTED]> wrote on 09/14/2005 02:07:01 AM: > > hello > > i hv one query as explained below : > > Table FIRST contains > > This is > What is this > how > whom > color > white > > Table SECOND contains > > WHOM > THIS IS > WHAT > WHITE AND BLACK > > i want the res

spanned indexes

Hi, Is it possible, or probably will be possible, to define indexes spanned on more than one table? I mean that if I have column col_a from table tbl_A, and col_b from table tbl_B.. Can I define a KEY with both those columns? Where will the index be saved? -thanks. -- MySQL General Mailing

Re: About database criterion

Hello. For a pity, your question isn't clear enough. Please, could describe the issue more widely. $ $ <[EMAIL PROTECTED]> wrote: > Hello,every one. > > Is there a current criterion about database function to evaluating a > database? > > _

Re: unexpected EXPLAIN result with subselect

Hello. See: http://bugs.mysql.com/bug.php?id=12106 "Matthias Pigulla" <[EMAIL PROTECTED]> wrote: > Hi all, > > can someone explain me why this query gets executed the way it is? I > simplified it as much as possible and think it's a conceptual/logical > thing, so I'll omit - at l

How To Pass a Collection/List/Map Through the iBatis to the Database?

I am currenly using JSF as the front end of a J2EE application. Data go through many business logic layers and reach the database through the iBatis. The iBatis is new to me. To pass a query "String" from the front end to the database and get a "Collection" back from the database through the iBati

Re: `gmake test` probs Solaris9 for M. 4.1.4.

Hi Hugh, all, sorry about the delay. Hugh Sasse wrote: On Fri, 9 Sep 2005, Joerg Bruehe wrote: Michael, you beat me in replying, and saved me from typing the analysis - thanks! Michael Stassen wrote: [[...]] The test suite is broken. Well, I would not put it that way - a diplomatic

Re: unexpected EXPLAIN result with subselect

On 14/09/2005, "Matthias Pigulla" wrote: > However - why do we need the dependent subquery at all? The subquery > can be executed on its own, as it does not depend on any information > of the "superquery". This is a subquery optimizer bug. See http://bugs.mysql.com/bug.php?id=10309 -- felix -

unexpected EXPLAIN result with subselect

Hi all, can someone explain me why this query gets executed the way it is? I simplified it as much as possible and think it's a conceptual/logical thing, so I'll omit - at least for now - the table definitions and sample data for brevity. -- "Superquery" EXPLAIN SELECT t1.id, t1.name FROM documen

Re: query

a simple select like this (if you know the order of tables): SELECT (tableb.valuea + " " + tableb.valueb + " " + tablea.valuec) FROM `tableb`, `tablea` where (tableb.valuea + " " + tableb.valueb + " " + tablea.valuec) = " XXX XX" N. Kavithashree wrote: hello i hv one query as expla

Re: Loading Decimal Values with load data infile

Hallo Thorsten, Op 14 Sep 05 schreef Thorsten Moeller aan MySQL Mailinglist: TM> i am trying to load a csv file with "LOAD DATA INFILE". This File TM> contains columns with decimal values with the german comma instead of TM> the dot as separator (e.g. 3.20 is 3,20). Is there an option to handl

Loading Decimal Values with load data infile

Hi, i am trying to load a csv file with "LOAD DATA INFILE". This File contains columns with decimal values with the german comma instead of the dot as separator (e.g. 3.20 is 3,20). Is there an option to handle this during or immediately before LOAD with MySQL Commands/Tools. Now we only see value

Loading Decimal Values with load data infile

Hi, i am trying to load a csv file with "LOAD DATA INFILE". This File contains columns with decimal values with the german comma instead of the dot as separator (e.g. 3.20 is 3,20). Is there an option to handle this during or immediately before LOAD with MySQL Commands/Tools. Now we only see value

select (sendind data)/update (locked)/select (locked) ??

queries locked in the following fashion: 1. SELECT on table OHMYGOD - "Sending data" state 2. UPDATE on the same table OHMYGOD - "Locked" state 3. SELECT on table OHMYGOD - "Locked" state and subsequently all the other SELECT queries on OHMYGOD table were locked. Its not clear, why mysql lock