Obviously doesn't work for extremely large datasets, but nothing stops you
from stuffing a server full of memory, assigning a huge block to ramfs, and
using that as the second leg of a mirror, with the first leg a real disk
device set to write-mostly.
Obviously you'll need to create an init script
JD,
Not have. pls input Error infomation from you r erro file. And ls
check your HDD space.
yours,
fire9
在 2009-2-10，上午4:42， JD King 写道：
I am running MySQL 5.1.30 on AIX 5.3. When a table reaches 1GB the
table
gets marked as corrupt. Is there a setting that limits table size to
1GB?
At 05:03 PM 2/9/2009, Michael Addyman wrote:
Dear Geniuses,
I have an application requiring ~30 InnoDB tables, which needs to scale up
to at least 500 application instances (500 instances * ~30 tables = 15,000
tables).
Some of the questions people are going to ask are:
How large are each of th
Good Morning to all
being a newbie to mysql, I'm a little confused about how to deal with
the following:
I am access to mysql server set up in my computer and also access to
the other computer to
the other computer in the network.
but when I am access mysql from my computer and then other server in
Good Morning to all
being a newbie to mysql, I'm a little confused about how to deal with
the following:
I am access to mysql server set up in my computer and also access to
the other computer to
the other computer in the network.
but when I am access mysql from my computer and then other server in
I am running MySQL 5.1.30 on AIX 5.3. When a table reaches 1GB the table
gets marked as corrupt. Is there a setting that limits table size to 1GB?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.or
Claudio,
Thank you. I do agree with you. I need to read up on it. I only work with
MySQL databases and queries and have never heard of it until today. Maybe
after I learn more about them, I will find them useful. Guess they must be
useful or it wouldn't be part of SQL.
Thank You
Steve
Dear Geniuses,
I have an application requiring ~30 InnoDB tables, which needs to scale up
to at least 500 application instances (500 instances * ~30 tables = 15,000
tables).
Discussions in the archives suggest I would be better off having independent
databases for each of the application instance
Steven,
I would suggest you the reading of a basic book about SQL and Databases, I
explain you why.
Views are a very fundamental concept in database theory that you would love
to study in deep.
This mailing list, though the most professional on MySQL, is not suitable to
explain such basic and impor
> Your subquery is not in the select list, it is in the where. A
> subquery in the select list would be:
> CREATE VIEW v_aa AS
> SELECT
> *
> , (SELECT MAX(x) FROM y) AS z
> FROM flight
>
> This is not updatable because there is no sensible way to propagate
> changes to the y base table.
Gre
PJ,
As I understand it, I have one table "books" it lists all the info for
the book other than the author(s) or the categories ; for these I need
an authors table and a category table... I'll continue with the authors
as categories will surely be the same thing.
>BTW, I cannot use ISBN as
>PK sin
I just found something else out and did a test. So a view is a table in a
database that can be shared. The example I found was if you have multiple
people that need a database for something, but it still has to keep the
information separate, instead of having multiple databases, you can create
on
Book table:
book id : 1, name: some book name
Author table
Author id: 1, name: author 1
Author id: 2, name: author 2
Rel_author_book table:
Book id: 1, author id: 1
Book id: 1, author id: 2
Same with categories and other 1:N relations
Olaf
On 2/9/09 2:01 PM, "PJ" wrote:
> Peter Brawley
Peter Brawley wrote:
> PJ
>
>> Why do I need a third table?
>
> The clue is "author (could be 2 or more)" in your books column list.
> It is incorrect to store two author names or IDs in one column. The
> relationship is 1:many. So you need a bridge table:
>
> books(id PK, etc...)
> authors(id PK,
See normalization...
You don't need to do this but it is considered good practice for many
reasons
On 2/9/09 12:04 PM, "Peter Brawley" wrote:
> PJ
>
>> Why do I need a third table?
>
> The clue is "author (could be 2 or more)" in your books column list. It
> is incorrect to store two author
My current understanding of the delta between Views and Temporary Tables
Views are read only results from 1 or more tables ..in Oracle they are stored
in TEMP tablespace
http://www.psoug.org/reference/views.html
Temporary Tables are tables which are created/updated/inserted and exist only
for t
I used to make Unix soft links of mysql tables back on mysql 3.23.
Say that I do an arbitrary sequence of CREATE TABLE, LOAD LOCAL DATA
INFILE, INSERT, UPDATE etc. on a table "x".
At some stage (after the CREATE) I do (outside of mysql)
foreach i (MYD MYI frm)
ln -s x.$i xdup.$i
PJ
Why do I need a third table?
The clue is "author (could be 2 or more)" in your books column list. It
is incorrect to store two author names or IDs in one column. The
relationship is 1:many. So you need a bridge table:
books(id PK, etc...)
authors(id PK, etc...)
books_authors(id PK, bid
Olaf Stein wrote:
> Just about the authors
>
> You need a separate table for them and then an table linking authors and
> books.
>
>
You lose me here... :-(
Why do I need a third table?
I may have 2 or three books with 3 authors, quite a few with 2 authors
and many with just 1 author.
I can't se
The only thing I can tell you is you are using 64bit package instead of the
32bit one.
Issue this /usr/bin/isainfo –kv
and see if you have 32 or 64 bit architecture os.
In case download the right one!
Solaris 8 (SPARC, 32-bit)
Cheers
Claudio
2009/2/9 bunti
> Yes Claudio,
>
> It is correct.
On Mon, Feb 9, 2009 at 1:17 PM, wrote:
> mysql> CREATE VIEW v_aa AS
>-> SELECT *
>-> FROM flight AS f
>-> WHERE f.RouteID IN
>-> (SELECT r.RouteID
>-> FROM route AS r
>-> WHERE r.To=
>-> (SELECT a.AirportID
>-> FROM airport AS a
>-
> -Original Message-
> From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
> Behalf Of Baron Schwartz
> Sent: Monday, February 09, 2009 9:19 AM
> To: Steven Buehler
> Cc: mysql@lists.mysql.com
> Subject: Re: MySQL View
>
> On Mon, Feb 9, 2009 at 9:41 AM, Steven Buehler
>
Just about the authors
You need a separate table for them and then an table linking authors and
books.
So you have table books, authors and rel_books_authors where rel_books
authors has 3 entries for a book with 3 authors just using the book id and
the author is's
Olaf
On 2/9/09 10:25 AM, "PJ"
Just about the authors
You need a separate table for them and then an table linking authors and
books.
So you have table books, authors and rel_books_authors where rel_books
authors has 3 entries for a book with a authors just using the book id and
the author is's
Olaf
On 2/9/09 10:25 AM, "PJ"
being a newbie to mysql, I'm a little confused about how to deal with
the following:
I am creating a database of books and have come down to this - table for
books (books) including fields for
id (primary key, auto-incr.)
title
author (could be 2 or more)
category (could be several - eg. youth, fic
On Mon, Feb 9, 2009 at 9:41 AM, Steven Buehler wrote:
> Ok, I just saw a post about using view's in mysql. I tried to look it up
> and found how to use it, but my question is: what is a view and why would
> you use it? Is it like a temporary table? Does it write a new database to
> the disk or
Ok, I just saw a post about using view's in mysql. I tried to look it up
and found how to use it, but my question is: what is a view and why would
you use it? Is it like a temporary table? Does it write a new database to
the disk or use memory?
Thanks
Steve
Yes Claudio,
It is correct. I am using Solaris 8 on Sparc 64bit package.
My server is : SunOS 5.8 Generic_108528-18 sun4u sparc SUNW,Ultra-250
If I am using the wrong package, could you please guide me to the correct one?
Bunti.
> Hi, I just try to guess because you don't post much informatio
Yes Claudio,
It is correct. I am using Solaris 8 on Sparc 64bit package.
My server is : SunOS 5.8 Generic_108528-18 sun4u sparc SUNW,Ultra-250
If I am using the wrong package, could you please guide me to the correct one?
Bunti.
> Hi, I just try to guess because you don't post much informatio
Hi!
On Mon, Feb 9, 2009 at 7:17 AM, wrote:
> Hi
>
> I am able to create an updatable view using a subquery in MySQL 5.1.29
>
> mysql> CREATE VIEW v_aa AS
>-> SELECT *
>-> FROM flight AS f
>-> WHERE f.RouteID IN
>-> (SELECT r.RouteID
>-> FROM route AS r
>->
>> I don't know what your data or your needs are, but I just thought I'd
>> make you aware of this; MySQL is *not* the answer to a great many
>> problems, regardless of the storage engine. Use the right tool for
>> the job.
>
> Right. I've used other databases that were faster than MySQL for some
Hi
I am able to create an updatable view using a subquery in MySQL 5.1.29
mysql> CREATE VIEW v_aa AS
-> SELECT *
-> FROM flight AS f
-> WHERE f.RouteID IN
-> (SELECT r.RouteID
-> FROM route AS r
-> WHERE r.To=
-> (SELECT a.AirportID
->
Hi!
SQL Maestro Group announces the release of SQL Maestro for MySQL 9.2,
a Windows GUI solution for MySQL administration and database
development. The new version is immediately available for download at
http://www.sqlmaestro.com/products/mysql/maestro/
New features:
1. Starting with this vers
33 matches
Mail list logo
