On Mon, Aug 18, 2003 at 09:42:51AM -0500, mos wrote:
>
> External RAM disks that are around 8g are extremely
> expensive. Some have built in in battery protection and operate
> independently from the OS so if the OS reboots, you still have your data. A
> couple of years ago I priced t
At 10:19 AM 8/18/2003, you wrote:
Mike,
This is very helpful.
Database consists of approximately 220,000,000 records. Raw data total
(roughly) 5.5 GBytes. I don't know how large the database will be loaded
(don't know about overhead, etc.)
Running InnoDb. Probably split 90% read and 10% wri
Your MySQL installation should have a directory called "support-files".
In there are a couple of configuration files you can use with obvious
names like my-huge.cnf, my-large.cnf, ..., my-small.cnf.
There are comments in each file about what kind of system they were
designed for. You can read up
Sorry the MySQL list server seems to have bounced my attachment. I have
include the text below.
my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# skip_innodb
innodb_data_file_path=idbdata1:200M:autoextend
set-variable = innodb_buffer_pool_size=80M
set-variable = innodb_a
Mike,
This is very helpful.
Database consists of approximately 220,000,000 records. Raw data total
(roughly) 5.5 GBytes. I don't know how large the database will be loaded
(don't know about overhead, etc.)
Running InnoDb. Probably split 90% read and 10% writees.
If nothing else replication
If you can post your current my.cnf + box configuration I'm sure we can
come up with some suggestions..
On Mon, 18 Aug 2003, Creigh Shank wrote:
> How would I tune my.cnf for a larger memory box? (Running on UPS;
> production machine(s) will go into Co-Lo with UPS and generator.) I
> realize
How would I tune my.cnf for a larger memory box? (Running on UPS;
production machine(s) will go into Co-Lo with UPS and generator.) I
realize there is some risk here. I am more concerned with the system
failing and some kind of mirroring solution to protect data.
Creigh
At 10:34 AM 8/18/200
At 09:17 AM 8/18/2003, you wrote:
Have a very large database and due to performance requirements it seems
that running MySQL in RAMDisk might be a good solution. Access to the
database is through PHP. Any suggestions or experiences?
Creigh
305-541-1122
Creigh,
How large is the database
Depends on db size... kinda risky putting it in memory if it's being
updated and power goes bye-bye..
You should be able to get alot more performance just tuning my.cnf for a
larger memory box..
On Mon, 18 Aug 2003, Creigh Shank wrote:
> Have a very large database and due to performance requi
