php forum
php mysql forum
php mysql smarty
 
Topic Options
#93296 - 06/26/04 03:45 PM MySQL Optimization
cdavis Offline
Lurker

Registered: 06/26/04
Posts: 6
I need someone to optimize MySQL on my Apple Xserve.

Here are the specs:
1. Mac OS X Server 10.2.8
2. MySQL 4.0.18 - 2 Databases (24MB & 197MB)
3. Apache 2.0.49 - 55 Virtual Hosts

Occasionally, the larger database become inaccessible - pages in the forums cannot be accessed. During this time, there are usually quite a few "locked" MySQL processes relating to this database. As soon as MySQL is restarted, the forums function properly for several more hours.

I have optimized a couple of the largest tables in this database several times, but that doesn't seem to have an effect.

I can provide 24 hour system-wide access via SSH in order to optimize MySQL.

Top
#93297 - 07/07/04 05:16 PM Re: MySQL Optimization
1QuickSI Offline
Coder

Registered: 06/10/01
Posts: 705
Loc: CT
Backup your my.cnf and try this...

Code:
[mysqld]
datadir=/usr/local/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=450
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=9600
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
 
[mysql.server]
user=mysql
basedir=/usr/local/mysql
 
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit=8192
 
[mysqldump]
quick
set-variable = max_allowed_packet=16M
 
[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
_________________________
...Steven
Hostboard.com
Running UBB v6.1.0.4
Doing what NO other UBB in the world is doing.
The first & only production UBB powered by MySQL.

Top



Moderator:  Deb 
Latest Posts
[7.2.1] - Naked shoutbox
by bellaonline
05/05/12 05:00 PM
[7.x] Stop Forum Spam Integration v0.4
by bellaonline
05/05/12 03:53 PM
Shout Box

(Views)Popular Topics
Known public proxy servers 1689885
Integrated Index Page (IIP) 5.3.1 555705
Finished-[6.5.2] Games Arcade Deluxe v1.9 501236
Integrated Index Page (IIP) 5.1.1 415112
TLD Bv2.1 Released - Threads Links Directory 396822
[6.0x] Who's Online 4.0.0 [Finished] 389412
Finished-[6.5.1] Integrated Index Page (IIP) 6.5 330423
Q & A 298663
Slash UBB 266936
[6.3.x] [beta] Hit Hack 2.0 227970
Forum Stats
13621 Members
59 Forums
37191 Topics
295716 Posts

Max Online: 686 @ 06/28/07 07:04 AM

 

 

 
fusionbb message board php hacks