Databases
StackOverflow2013
Postsdbo
POThe most efficient way to setup MySQL on Ubuntu Server 10 LTS?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POThe most efficient way to setup MySQL on Ubuntu Server 10 LTS?
    text
    copied!<p>Very soon I will setting up a web server for a client who has a very busy site. He has a forum (run on <a href="http://www.simplemachines.org/" rel="nofollow noreferrer">Simple Machines Forum</a> SMF written in PHP) that cannot really be changed. I want to move this to a separate virtual private server on it's own, as it's very busy at around 40,000 hits a day with 400+ posts a day. With the version of SMF it has (the best, most stable production version 1.1) it needs MySQL to run, so I can't change it to PostgreSQL (which I would maybe prefer)</p> <p>When installing MySQL Server on Ubuntu Server 10 LTS, I'm curious to know if there is anything I can do to ensure it's the most efficient it can be. I'm wanting to run as fast as possible to keep resources down and to ensure we can stay under our resource limit for the server. With a virtual private server, I have the option of switching up the resources in a flash, but I'm wanting to ensure MySQL Server is setup as efficiently as possible as I'm not exactly an expert at that type of thing.</p> <p>I was doing some research and found <a href="http://bryanhelmig.com/setting-up-ubuntu-10-04-with-apache-memcached-ufw-mysql-and-django-1-2-on-linode/" rel="nofollow noreferrer">this article</a> which suggests doing this to ensure it's efficient:</p> <pre><code># open mysql conf and set these settings: # key_buffer = 16k # max_allowed_packet = 1M # thread_stack = 64K nano /etc/mysql/my.cnf # restart mysql /etc/init.d/mysql restart </code></pre> <p>Can anyone provide me with some tips, hints, links, knowledge on this subject?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload