I'm doing some tests on a small Sun server, a 280R to demo MySQL vs. Oracle. For the demo I using a subset of a test table.
The destination server will be a Sun 880 with 8 1.2 GHz CPU's, 16 GB RAM, Sun T3+ RAID Array. Any suggestions on settings or other changes would be helpful. Also what would be the best variables/settings to compile a binary for a server of this type ? Gcc 3.3.2, Solaris 9. number of rows is only 10,735,291 MYD is 6.7 GBytes, and MYI is 1.4 GBytes. This table is a subset of the real table of about 120 Gb. the test/lab server is a small sun box with 2 each 900 MHz CPUs, and 8 GB of RAM. I'm trying to avoid using disk until I get a better performance disk subsystem. The version is the website binary, solaris 64 bit. the setting i currently have [mysqld] set-variable = myisam_sort_buffer_size=4096M set-variable = sort_buffer_size=4096M set-variable = read_buffer_size=512M set-variable = key_buffer_size=4096M set-variable = table_cache=1024 tmp_table_size = 1024M max_heap_table_size = 1024M a search on text fields such as select substring_index(request_uri,'/',-1) jsp, count(*) from apache_jan where request_is_jsp = 1 group by jsp; takes 8 1/2 minutes. A rebuild of the indexes takes over 8 hours. the table format CREATE TABLE `apache_jan` ( `dt` datetime NOT NULL default '0000-00-00 00:00:00', `hostname` varchar(125) default NULL, `ip` varchar(15) default NULL, `ipn` int(10) unsigned default NULL, `user` varchar(125) default NULL, `timetaken` float default NULL, `auth` varchar(255) default NULL, `request` text, `request_type` varchar(255) default NULL, `request_uri` text, `request_file` varchar(255) default NULL, `request_is_jsp` tinyint(1) default NULL, `request_is_servlet` tinyint(1) default NULL, `request_query` text, `request_version` varchar(255) default NULL, `status` smallint(3) unsigned default NULL, `status_orig` smallint(3) unsigned default NULL, `bytes` int(11) default NULL, `bytes_i` int(11) default NULL, `bytes_o` int(11) default NULL, `header` text, `header_uri` text, `header_file` varchar(255) default NULL, `header_is_jsp` tinyint(1) default NULL, `useragent` varchar(255) default NULL, `biz_obj` varchar(255) default NULL, KEY `dt` (`dt`), KEY `hostname` (`hostname`), KEY `ip` (`ip`), KEY `status` (`status`), KEY `request_is_jsp` (`request_is_jsp`), KEY `request_is_servlet` (`request_is_servlet`), KEY `request_file` (`request_file`), KEY `header_file` (`header_file`), KEY `header_is_jsp` (`header_is_jsp`), KEY `ipn` (`ipn`) ) TYPE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=200000000 AVG_ROW_LENGTH=600 INDEX DIRECTORY='/DISK1/MYSQL/pdm/' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
