Some people who know I’ve used Gentoo asked me my thoughts on using it for MySQL servers. Here are my opinions and experiences while using Gentoo, both for desktop systems and for servers. This is long, but hopefully the brain dump is useful to you. I have so many thoughts on this subject that I’m having a hard time really organizing them well, and I’m censoring myself too because I know I represent only a very small, focused viewpoint on Gentoo.

I posted this over the weekend:
http://download.tangent.org/memcache_engine-0.3.tar.gz

Table spaces are now supported and it works with multiple servers out of the box. This is still very experimental.

Project URL:
http://tangent.org/index.pl?node_id=506

Few days ago I’ve started new site which name is BestTechVideos.com. I’ve created this site because there are lots really interesting videos on the Net, but if you’d like to fine some good tech video, it is not so simple to find them because of tons of crappy “funny videos” like “funny cats” and so on.

So, If you like to attend technical conferences and watch conference sessions on video, if you like idea of screencasts, etc, then this site is for you! Welcome to Best Tech Videos you’ll be impressed by amount of hi-quality and useful videos on the Net.

P.S. If you like this site idea, support it on Digg.com, please. Great thanks in advance.

MySQL offers one of the most complete selection of application programmer interface support. Some of these are in the form of a library (such as the MySQL C API library) while others are in the form of a driver (such as the ODBC driver). For most people/situations - the choice of which interface to use is obvious as it is often dictated by the programming language in use (JDBC for Java for example).

Here are some reasons for considering the ODBC interface. Note; some of these reasons can apply to more than one interface.

• Cross-database
• Cross-platform
• SQL Standard
• C/C++ Programming Language

Cross-database

The ODBC standard was created primarly to provide an application developer with a database vendor neutral way to work with a database. In other words the source code does not have to change just because one decides to switch from (for …

So I am currently working on a MySQL server that is showing behavior as depicted in the following graph.


There can be several possible reasons for these sudden drops. I am working on the issue and will be posting the results. Have you experienced something similar?

A quick refresher on the locations MySQL uses to load up configuration options on Unix:

1. /etc/my.cnf
2. $MYSQL_HOME/my.cnf (sometimes this is your datadir, other times it's basedir)
3. command line arg (defaults-extra-file)
4. user's home directory (~/user/.my.cnf)

It's available in the MySQL docs, and there's a section on it in Pro MySQL, but it seems a need to remember the exact order only comes often enough to confirm that I haven't committed it to long-term memory.

A current project which now includes the use of PHP, MySQL Stored Procedures, recursion, temporary tables, etc., and some of the issues encountered along the way, leads me to write up these notes to share with others. Hierarchical datasets have been discussed before, and the means to traverse them in SQL. This current dataset is not hierarchical, not even a partial ordering, but a network, somewhat along the lines of a social network. In this instance it is musicians who play for bands, and creating an extended network by following up on other bands that musicians played for, and also researching all members of a particular band that a musician is a member of, ad infinitum or at least to maximum recursion depth, currently set at 25.

Right now the stored procedures consist of two: a non-recursive function that creates a temporary table and makes the initial call to the recursive procedure. No resultsets are returned; the PHP script that …

It's really hard for me to believe how time has just been flying. Ever since I got back from the very awesome MySQL Camp at Google headquarters, I have been planning to write about it but for one reason or another, I couldn't.

Short version is that I had a great time at the MySQL Camp. I got to meet a lot of new and old friends. It was like a dream come true to hang out with everyone. Very special thanks to everyone I met at the conference as I had some very good discussions. Also thanks to:

Kevin Burton of TailRank for his idea
Jay Pipes for his intense hard work to make this event a big success
Leslie "Hacker Herder" Hawthorn, Mickey, Kynan, Chris and others for their excellent hospitality
Jeremy Cole and …

It seems, people are clammering for a more consolidated help guide for SQL Performance tips.

Jay Pipes at the MySQL Camp ran a session Interactive Top 10 SQL performance Tips. There was plenty of input and discussion, and at the time Sheeri simply typed them into a wiki page for later work.

Well it seems even that rough list is popular at Del.icio.us ranking near the top of the Hot List on the front page. I saw it earlier and it was second or third, but didn’t think of taking a screen shot until now, but it’s still high.

I’d say that we could easily …