Hi David,
In your database on the countries of the world think you were able to
mostly avoid using numeric keys however in this case, they will save you a
world of headaches.
My suggestion to you: Create one table per taxonomic level, starting at
Kingdom and working all of the way down to spe
David-
generate a composite index on a unique combination such as genus/species
Regards
Martin
- Original Message -
From: "David Blomstrom" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 17, 2004 1:03 PM
Subject: Animals Database Questions
I'm working on a big animals database and have a
question that's a little hard to explain, though I
suspect it will make sense to the pros.
First, a little background. I'm tentatively setting up
a parent-child relationship and putting all the basic
mammal data in a separate table. Below are some s
At 11:59 +0800 3/6/03, Terence wrote:
Hi All,
Can MySQL give some indication of how many questions are being asked to each
database?
Using the show variables, I can get the total questions, but was wondering
if it's possible to get
it broken down on a per database view?
No.
Rgds
Terence
query s
Hi All,
Can MySQL give some indication of how many questions are being asked to each
database?
Using the show variables, I can get the total questions, but was wondering
if it's possible to get
it broken down on a per database view?
Rgds
Terence
query sql
-
* [EMAIL PROTECTED]
> 1. Is it a good idea to have all the columns in one big table ?
This will depend on the nature of your data. You say you have many varchar
columns. If many of them contains the same value, you could get substantial
speed/space improvements by splitting (normalizing) the tabl
Dear Mr. Jeremy D. Zawodny,
I am subscriber of the mysql.com MailingList and have received some of your
mails.
From the mails I get the idea that you have quite some experience with mysql.
We are planning to migrate our database (currently oracle) to mysql.
Our database consists of about 150
Hello Roger;
[snip]
> * Emmanuel van der Meulen
> > I'm certain InnoDB is 100% safe. My concern is probably
> related to being
> > unfamiliar with MySQL/InnoDB. However, I take Heikki's point of
> > the access impact of DEV on PROD - never thought of that.
>
> This impact also very much appli
* Emmanuel van der Meulen
> I'm certain InnoDB is 100% safe. My concern is probably related to being
> unfamiliar with MySQL/InnoDB. However, I take Heikki's point of
> the access impact of DEV on PROD - never thought of that.
This impact also very much applies to the cpu... I would highly reco
Hello Roger,
[snip]
> Yes, but is there really a big difference as long as the data is
> on the same
> disk & computer? I would keep PROD on a separate physical
> machine...
Yes, either on a separate physical machine or a different HDD (to curtail
costs, I'd first go for HDD).
> If the
> databa
Hello Heikki,
Thank you very much for this note and your valued assistance.
I have the different instances of MySQL running with your proposal to add
the lot to
a bat file.
And yes, if such a option as you propose exists, others would possibly get
multiple instances / my.cnf files working more
* Emmanuel van der Meulen
> I got this to work, I suspect a typo resulted that it did not
:)
> Well, i.r.o. the matter of risk, if different websites's data is
> in one set of files, and especially with DEV, where programs which
> still have bugs or with finger trouble, could damage the data in
Hello Roger,
[snip]
> > Roger, I attempted adding additional space with a new file under
> > innodb_data_file_path as follows;
> > Before: innodb_data_file_path = ibdata1:50M;ibdata2:50M
> > After : innodb_data_file_path = ibdata1:50M;ibdata2:50M;ibdata3:50M
> > Stopped and restarted MySQL, but
* Emmanuel van der Meulen
> Roger, I attempted adding additional space with a new file under
> innodb_data_file_path as follows;
> Before: innodb_data_file_path = ibdata1:50M;ibdata2:50M
> After : innodb_data_file_path = ibdata1:50M;ibdata2:50M;ibdata3:50M
> Stopped and restarted MySQL, but this d
Hello Roger,
Thank you for your note and feedback. With your assistance and reading up
on InnoDB, I'm getting closer. Further inline;
On 29 December 2001 22:21, Roger Baklund wrote;
[snip-1]
> I think you would need to restart the mysqld server daemon, but
> this is very
> fast, and can be
* Emmanuel van der Meulen
> Roger, assuming the database space as allocated is used up and I
> do not want to remove the data, but I have lots more space to
> allocate, is there a way to extend allocated space in flight?
> Or, does MySQL automatically (and inflight) extend beyond
> allocated space
Hello Roger,
Thank you for your note and replies. Please see my further points inline;
On 29 December 2001 16:21, Roger Baklund wrote;
> * Emmanuel van der Meulen
> > 1. Assuming the website grows very large with high volumes and
> a database
> > exceeds disk space, please advise what is the
* Emmanuel van der Meulen
> 1. Assuming the website grows very large with high volumes and a database
> exceeds disk space, please advise what is the remedy?
Add HW or remove data...? Not sure if I understand your question...
> 2. Seeing as for the said website I use transactions, thus also the
Hello all,
I have several questions in general since I recently started using MySQL.
>From the manual I cannot find where these questions are covered. I hope
someone can assist me.
Firstly though, if this is not the correct mailing list for my questions,
please advise correct one.
Secondly, t
19 matches
Mail list logo
