NEXUCOM - Support / Knowledge Base
Search:     Advanced search
Browse by category:
Contact Us
Support / Control Panel / DirectAdmin / How to Optimize MySQL [DirectAdmin]

How to Optimize MySQL [DirectAdmin]
Print
Email to friend
Views: 199
Votes: 0
Posted: 11 Jan, 2008
by: Tech A.
Updated: 14 Jan, 2008
by: Tech A.

Referenced from the Forum
 

vi /etc/my.cnf [ENTER]

 


Press 'i' to enter insert mode, then paste:

 

[mysqld]
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=64M
log-bin
server-id=1

[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

 


Press ctrl-c to exit insert mode. Then press shift-Z shift-Z to save and quit. Restart mysqld:
 

Redhat:

/sbin/service mysqld restart


FreeBSD:

/usr/local/etc/rc.d/mysqld restart



Note that this guide is only for MySQL 4. There is a default my.cnf that comes with mysql that will work fine

 

cp -f /usr/share/mysql/my-huge.cnf /etc/my.cnf

Others in this Category
document How to view Log [DirectAdmin]
document How to Updating Apache to the latest version [DirectAdmin]
document How to Using a custom VirtualHost template [DirectAdmin]
document How to Adding custom httpd.conf code to the VirtualHosts of a domain [DirectAdmin]
document CGI files Generate Internal Server Error [DirectAdmin]
document How to Running CGI script from any directory or via /~username/cgi-bin [DirectAdmin]
document How to Using an external Mailserver [DirectAdmin]
document Apache Stops Responding but is Running [DirectAdmin]
document How to use SSH [DirectAdmin]
document How to view Log File Paths [DirectAdmin]
document Partition /var is Full [DirectAdmin]
document How to Change Email Password without logging in [DirectAdmin]
document Error connecting to IMAP server: localhost. 115 : Operation now in progress [DirectAdmin]
document How to Setting up DA with an SSL certificate [DirectAdmin]
document How to Setup the Mail System [DirectAdmin]
document Apache won't start and there is nothing in the logs [DirectAdmin]
document IMAP not working. Can't connect to 143 [DirectAdmin]
document Error to /usr/include/krb5.h:2606:24: et/com_err.h: No such file or directory [DirectAdmin]
document How to Add Reverse IP Lookup on your IP's [DirectAdmin]
document How to Showing files in a directory [DirectAdmin]
document How to Adding Custom Modules to php [DirectAdmin]
document Proftpd won't start [DirectAdmin]
document I do not want to run DNS services on my DirectAdmin Server [DirectAdmin]
document How to Updating and Compiling Apache and PHP [DirectAdmin]
document How to Customize the Output of Webalizer [DirectAdmin]
document How to Updating DirectAdmin Manually [DirectAdmin]
document How to Updating your DirectAdmin License Manually [DirectAdmin]
document Apache won't restart: [crit] (98)Address already in use: make_sock: could not bind to port 8090 [DirectAdmin]
document How to Allow Webalizer Stats to be Viewable through the web [DirectAdmin]
document Hotlink Protection: How to Prevent People from Stealing your Files [DirectAdmin]
document Webmail Quotas don't match actual quotas [DirectAdmin]
document How to Creating a Language Pack for DirectAdmin [DirectAdmin]
document How to Enable SpamAssassin on your Server [DirectAdmin]
document How to Forward a Website to Another URL [DirecAdmin]
document Spamassassin : Can't locate HTML/Parser.pm in @INC [DirectAdmin]
document New user using over 100 meg of space and nothing has been added yet [DirectAdmin]
document Named is not reloading correctly when I add a domain [DirectAdmin]
document Server replied: 421 Unexpected failure, please try later [DirectAdmin]
document Disk Usage is showing 0.00 [DirectAdmin]
document My /etc/virtual/domainowners file is empty. How do I rebuild it? [DirectAdmin]
document Error connecting to MySQL: Access denied for user: 'da_admin@localhost' (Using password: YES) [DirectAdmin]
document How to setup /~username/domain.com [Directadmin]
document I've deleted /home, how do I recreate the directories? [DirectAdmin]
document Make the bandwidth, disk uage and webalizer stats update more often [DirectAdmin]
document Installing DBD::mysql from source [DirectAdmin]
document Adding Custom Modules to Apache [DirectAdmin]
document How to Update your exim.conf [DirectAdmin]
document Setting the System Date and Clock [DirectAdmin]
document How to reset a user on the same day of the month his account was created [DirectAdmin]
document How to Downgrade from Apache 2 back to Apache 1.3 [DirectAdmin]
document Frontpage on FreeBSD 5.x [DirectAdmin]
document Webalizer produces: error while loading shared libraries: libgd.so.2 [DirectAdmin]
document How to Server to Server Transfer of All Accounts [DirectAdmin]
document How to Transfer a Domain from one User to Another [DirectAdmin]
document 550-Verification failed for user@email.com [DirectAdmin]
document Permission Denied: Creating Lock File Hitching Post [DirectAdmin]
document How to Create a Login Page for DirectAdmin on your Website [DirectAdmin]
document Get Exim to Listen on Another Port on Top of Port 25 [DirectAdmin]
document How to Downloading a New Webalizer Binary [DirectAdmin]
document How to Creating your Own Service Monitor [DirectAdmin]
document Connecting to www.directadmin.com[66.51.122.131]:443... failed: Cannot assign requested address [DirectAdmin]
document How to Completely Rebuild your /etc/virtual directory [DirectAdmin]
document Share a domain between 2 users [DirectAdmin]
document /usr/libexec/ld-elf.so.1: Shared object libm.so.2 not found, required by my_print_defaults [DirectAdmin]
document view.c:347: REQUIRE((&view->references)->refs > 0) failed [DirectAdmin]
document What ports do I need to open in my firewall? [DirectAdmin]
document The data in /usr/local/directadmin/data/users is gone. I need to create it again [DirectAdmin]
document Warning: Illegal offset type in /path/to/somefile.php after php upgrade [DirectAdmin]
document Translating hardcoded DirectAdmin results [DirectAdmin]
document I can't login to DirectAdmin on port 2222 [DirectAdmin]
document How to Create an Email Account that Deletes Incoming Mail [DirectAdmin]
document Error with wget: use `--no-check-certificate` for licenses/updates [DirectAdmin]
document How to Add Frame Forwarding to your Website [DirectAdmin]
document www.domain.com doesn't work, but domain.com works fine [DirectAdmin]
document Increase the max upload filesize in apache/php [DirectAdmin]
document How to Limit the Number of Emails Sent by Each User (Prevent Spammer) [DirectAdmin]
document How to Compiling Proftpd [DirectAdmin]
document Synchronization Error [DirectAdmin]
document How to Running DirectAdmin through Apache on port 80 [DirectAdmin]
document How to Updating Mysql on FreeBSD [DirectAdmin]
document Setting up Outlook to send through SMTP on port 587 [DirectAdmin]
document How to Lower your TTL Just Before an IP Change [DirectAdmin]
document When Compiling vm-pop3d: Error: `UINT16_MAX' undeclared (first use in this function) [DirectAdmin]
document Why do I need an owned IP for my own SSL Certificate? [DirectAdmin]
document How to Setup Jailed SSH and Jailed CGI (beta) [DirectAdmin]
document How to Track which Site is using the Apache Processes. [DirectAdmin]
document Setting Up webmail.domain.com as Default for New Domains [DirectAdmin]
document Moving Users between Resellers [DirectAdmin]
document How to Setup vm-pop3d to Run Through xinetd [DirectAdmin]
document Apache won't Start After Update on FreeBSD [DirectAdmin]
document How to Downgrade to MySQL 4.0 from 4.1 (Linux/rpms) [DirectAdmin]
document How the Multi Server DNS Clustering Works [DirectAdmin]
document Mysql rpm install: Error: Failed dependencies: perl(DBI) is needed by MySQL-server-4.0.26-0.i386 [DirectAdmin]
document Error: Cannot Find SSL Binaries Under /usr [DirectAdmin]
document ERROR (2): Header May Not Contain more than a Single Header, New Line Detected. (/webmail/inc/inc.php:169) [DirectAdmin]


RSS
Powered by KBPublisher (Knowledge base software)

Services d'Hébergement: Hébergement Web | Serveurs Dédiés | Streaming | Colocation Serveurs | Nom de Domaine | Support |

Hosting Services: Web Hosting | Dedicated Servers | Streaming | Servers Colocation | Domain Name | Support |

Services: | Hébergement | Serveurs | Colocation |

Copyright © 2003-2008. All Rights Reserved.

Mascot - DirectAdmin - big - mf - Boiler Biomass - Mascot - Mascotte - Webmail - gt - eq - Chaudière Biomasse - Mascotte -