Even at 1.6G, which seems to work (though, -not- why we got 4G of expensive ram), does anyone have any advice for optimizing the settings? Or are they pretty optimized as it is? (according to benchmarks, anyways)
-- Adam Goldstein White Wolf Networks http://whitewlf.net
On Jan 26, 2004, at 10:13 AM, Brent Baisley wrote:
You may be hitting an OSX limit. While you can install more than 2GB on a system, I don't think any one process is allowed to allocated more than 2GB of RAM to itself. It's not a 64-bit OS yet. You should be able to search the Apple website for this limit.
On Jan 26, 2004, at 6:10 AM, Adam Goldstein wrote:
I cannot seem to allocate any large amounts of memory to Mysql on our system...
Can anyone suggest any settings/changes/etc to get this running to the best of it's ability?
Dual 2Ghz G5, 4G ram, OSX 10.3.2, 73G-10Krpm Sata Raptor drives
Using both the 'Complete Mysql4.0.15" and Standard binary package 4.0.17 I cannot seem to get the daemon to accept using a large Key_buffer setting, such as 1900M or 2600M (though 1600M seemed to work the first startup).
I get this error:
Version: '4.0.17-standard-log' socket: '/tmp/mysql.sock' port: 3306 040126 05:40:16 mysqld started *** malloc: vm_allocate(size=2597892096) failed (error code=3) *** malloc[14345]: error: Can't allocate region /usr/local/mysql/bin/mysqld: ready for connections. Version: '4.0.17-standard-log' socket: '/tmp/mysql.sock' port: 3306 040126 05:43:00 mysqld started *** malloc: vm_allocate(size=1984614400) failed (error code=3) *** malloc[14378]: error: Can't allocate region /usr/local/mysql/bin/mysqld: ready for connections. Version: '4.0.17-standard-log' socket: '/tmp/mysql.sock' port: 3306
This is a dedicated mysql backend server using MyISAM tables (currently) and we need it to run a fairly heavy load.
This is only the relevant conf data:
[mysqld] skip-locking key_buffer = 1990M max_allowed_packet = 8M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M join_buffer_size = 3M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size = 32M thread_concurrency = 8 max_connections = 1200 skip-name-resolve skip-bdb skip-innodb ft_min_word_len = 2 tmpdir = /tmp/ log-bin = /var/log/mysql/raptor-bin.log
These are the largest tables in the db (other clipped):
Raptor: ../data root# ls -lhS /Library/MySQL/var/db1/
total 9177432
-rw-rw---- 1 mysql mysql 975M 21 Jan 20:30 axxx_search.MYD
-rw-rw---- 1 mysql mysql 619M 21 Jan 20:30 axxx_search.MYI
-rw-rw---- 1 mysql mysql 571M 21 Jan 20:05 td_visitor_archive.MYD
-rw-rw---- 1 mysql mysql 492M 21 Jan 20:37 message.MYD
-rw-rw---- 1 mysql mysql 435M 21 Jan 20:30 axxx_description.MYD
-rw-rw---- 1 mysql mysql 412M 21 Jan 20:37 enxxx.MYD
-rw-rw---- 1 mysql mysql 336M 21 Jan 20:37 enxxx.MYI
-rw-rw---- 1 mysql mysql 200M 23 Dec 09:05 axxx_title_images.MYD
-rw-rw---- 1 mysql mysql 97M 21 Jan 20:06 rating.MYD
-rw-rw---- 1 mysql mysql 81M 21 Jan 20:06 rating.MYI
-rw-rw---- 1 mysql mysql 49M 21 Jan 20:24 bxx.MYI
-rw-rw---- 1 mysql mysql 28M 21 Jan 20:24 bxx.MYD
...clip...
These are our best benchmarks:
alter-table: Total time: 6 wallclock secs ( 0.03 usr 0.04 sys + 0.00 cusr 0.00 csys = 0.07 CPU)
ATIS: Total time: 21 wallclock secs (17.20 usr 3.37 sys + 0.00 cusr 0.00 csys = 20.57 CPU)
big-tables: Total time: 15 wallclock secs ( 4.30 usr 3.60 sys + 0.00 cusr 0.00 csys = 7.90 CPU)
connect: Total time: 4 wallclock secs ( 0.61 usr 0.29 sys + 0.00 cusr 0.00 csys = 0.90 CPU)
create: Total time: 98 wallclock secs (11.63 usr 3.02 sys + 0.00 cusr 0.00 csys = 14.65 CPU)
insert: Total time: 1405 wallclock secs (312.96 usr 78.26 sys + 0.00 cusr 0.00 csys = 391.22 CPU)
select: Total time: 122 wallclock secs (33.21 usr 7.03 sys + 0.00 cusr 0.00 csys = 40.24 CPU)
wisconsin: Total time: 8 wallclock secs ( 5.00 usr 0.49 sys + 0.00 cusr 0.00 csys = 5.49 CPU)
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]