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