* 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
* 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
11 matches
Mail list logo