The server is mainly a Web server (Linux RedHat 7.3, P3 1GHz, server
chipset, 500M) with CPU usage <5%
CPU states: 1.7% user, 0.3% system, 0.0% nice, 97.8% idle
Mem: 513900K av, 502676K used, 11224K free, 0K shrd, 114640K
buff
Swap: 522072K av, 0K used, 522072K free 321032K
cached
The used RAM moves from 470M tp 510M up and down.
---
my.cnf is very basic:
[root@webserv1 etc]# more my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
---
>From phpMmyAdmin SHOW STATUS I get:
Max_used_connections 9
Other info sounds complicated but I could dump here.
---
SHOW VARIABLES
back_log 50
basedir /usr/
bdb_cache_size 8388600
bdb_log_buffer_size 32768
bdb_home /var/lib/mysql/
bdb_max_lock 10000
How can I change bdb_home /var/lib/mysql/ to avoid link to
/home/database/ ?
Then shall I have to changed datadir /var/lib/mysql/ as well? (I want my
DBs to be in /home/database/)
Also get:
max_allowed_packet 1048576
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 100
max_connect_errors 10
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_sort_length 1024
max_user_connections 0
max_tmp_tables 32
max_write_lock_count 4294967295
myisam_max_extra_sort_file_size 256
myisam_max_sort_file_size 2047
myisam_recover_options 0
myisam_sort_buffer_size 8388608
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
open_files_limit 0
---
In phpMyAdmin I saw an "optimize table" but don't find detail in the
doc...is it worth it?
---
I also find phpMyAdmin slow to display table content...
---
Any idea?
JM
-----Original Message-----
From: Simon Windsor [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 12:26 PM
To: MySQL
Subject: Re: Optimizing
Hi
What else is running on the machine ?
What processes are using the computers resources ? Use top to find out.
What are the memory parameters used in my.cnf ?
The answers to these questions will provide some helpfull answers to
your
problem.
Simon
On Monday 30 Dec 2002 11:16 am, BPF Webmaster wrote:
> I migrated my site from a low end PC mutualized hosting to a brand new
> P3 1GHz 512M server I now manage myself. Unfortunately I found MySQL
> slower now, the time for a PHP page is now about 6 seconds and was
> about .6 before!!!
>
> I haven't done any optimization and the DB is the same, so the size
> (about 10,000 records).
>
> The only 2 weaknesses I saw is that:
> 1- I use a RedHat 7.3 RPM (haven't compiled myself)
> 2- the database folder is on another partition linked from /var/... to
> /home/... but on the same disk (a fast 10Krpm UW-SCSI).
>
> What would you advise?
>
> JM
>
> An example at http://www.labdv.com/forum/index.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
