Databases

 
Who holds the data
Oct 22

Installing sphinx on Ubuntu

Sphinx is a full-text search engine, distributed under GPL version 2

Check out the home page: http://sphinxsearch.com/

sphinx needs mysql_config program, install it with:

sudo apt-get install libmysqlclient15-dev
wget http://sphinxsearch.com/downloads/sphinx-0.9.8.tar.gz
tar xvf sphinx-0.9.8.tar.gz && rm sphinx-0.9.8.tar.gz
cd sphinx-0.9.8
./configure
make
sudo make install

Sep 21

MySQL Performance Tuning Primer Script

MySQL Performance Tuning Primer Script
http://www.day32.com/MySQL/
http://www.day32.com/MySQL/tuning-primer.sh

This script takes information from "SHOW STATUS LIKE..." and "SHOW VARIABLES LIKE..."
to produce sane recomendations for tuning server variables.
It is compatable with all versions of MySQL 3.23 and higher (including 5.1).

Currently it handles recomendations for the following:

  • Slow Query Log
  • Max Connections
  • Worker Threads
  • Key Buffer
  • Query Cache
  • Sort Buffer
  • Joins
  • Temp Tables
  • Table (Open & Definition) Cache
  • Table Locking
  • Table Scans (read_buffer)
  • MyISAM Status
Syndicate content