I suppose you're doing this on your workstation (Windows?)? Ideally, Mysql should be on it's own machine - it (or any database) is designed to suck up resources. Also, you definitely need to tweak the configuration file. MySQL's default config is very anemic (annoying I know) as opposed to Oracle or SQL Server where they gear the configuration towards heavy/large databases by default. Here is my configuration (probably not optimal, but a step in the right direction) for a dedicated dual 2.8GHz Xeon with 1GB ram and dual channel raid running RedHat Enterprise Linux 2.1:
[EMAIL PROTECTED] adam]$ cat /etc/my.cnf # my.cnf [mysqld] user=mysql set-variable = sort_buffer=2M set-variable = thread_cache_size=40 set-variable = record_buffer=2M set-variable = table_cache=730 set-variable = key_buffer=256M set-variable = tmp_table_size=256M set-variable = interactive_timeout=7200 set-variable = wait_timeout=40 set-variable = max_connections=200 set-variable = max_user_connections=195 set-variable = max_connect_errors=20 # innodb stuff added 05/16/02 innodb_data_home_dir = innodb_data_file_path = /data/mysql/ibdata:1G innodb_log_group_home_dir = /var/lib/mysql/iblogs set-variable = innodb_buffer_pool_size=1G set-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_log_files_in_group=7 set-variable = innodb_log_file_size=50M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=0 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 set-variable = innodb_thread_concurrency=8 default-table-type=innodb > > blackrat said: > > I've just started using mySql. I'm an experience programmer with SQL > > based database, but know nothing about mySql. I'm setting > up a single > > user database to be accessed with some Perl programs, with one main > > table, which will contain about 3 million lines. I'm running on an > > Athlon 1250 with 384meg ram, and finding the response time > too slow. > > > > Just getting a count of the number of records by typing in > an SQL query > > [not using Perl] takes over a minute, also when access is > going on, I > > can't do anything else on them machine like access the > web, it becomes > > too slow to be usable. > > > > Am I better setting up the database on another computer and > accessing > > it through TCP/IP. I have available a spare machine which > is a Celeron > > 450. > > > > > > -- > > 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]
