Archive for the ‘Uncategorized’ Category

Sphinx search

Sunday, November 15th, 2009

Have a big website with millions of records? Is MySQL full-text search letting you down? Sphinx search http://sphinxsearch.com by Andrew Aksyonoff is probably gonna solve your problems. It is an awesome product (and yes it’s open source) with less than a second search results on a data set with millions of records.
I had the opportunity to author a sphinx based search engine for vBulletin. We use it for our huge forums at Internet Brands. A demo can be viewed here:

Tags: , ,
Posted in MySQL, Unix | 1 Comment »

mysqlslap to benchmark mysql queries

Monday, September 28th, 2009

mysqlslap is worth a look

mysqlslap --host=myhostname --user=myusername -p'mypassword' --create-schema=mydatabase --delimiter=';' --concurrency=10 --iterations=5 --query=/tmp/queriestobenchmark.sql

SAMPLE /tmp/queriestobenchmark.sql file

SELECT * FROM users; SELECT title FROM forum

Tags: ,
Posted in MySQL | No Comments »

Create a copy of a MySQL database on a different server

Sunday, September 20th, 2009

To create a copy of database mysource on Server A as database mydestination on Server B, I follow these two steps:

1) Create database mydestination on Server B.

CREATE database mydestination

2) Then, run this command

mysqldump -hipaddressofserverA -uusernameofserverA -ppasswordofofserverA mysource | mysql -hipaddressofserverB -uusernameofserverB -ppasswordofserverB -C mydestination

Tags: ,
Posted in MySQL | No Comments »