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
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
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
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
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
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
* [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
* 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 did
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 this did
* 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 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
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
databases
* 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
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 applies to 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,
* 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 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
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 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
19 matches
Mail list logo