Category Archives: Database

upgrading MySQL on debian lenny with apt-get or aptitude

Posted on by
Reply

To clarify things, the version currently on Debian lenny is 5.0.51, this DOES have the 4GB limit mentioned in the previous post, what you need is 5.0.52+ (See previous post)

To get that on debian lenny, You do not need to recompile or compile anything

Add the line below to your /etc/apt/sources.list

deb http://backports.debian.org/debian-backports lenny-backports main

apt-get update
apt-get -t lenny-backports install mysql-server-5.1

This should have you running with a key_buffer of any size you wish that your ram permits, and to overcome the 4GB limit on the MyISAM key buffer

Happy Databasing

mysql key_buffer_size not limited to 4GB on 64Bit systems

Posted on by
Reply

Even though originally, key_buffer_size (The MyISAM index buffer) should have been limited to 4GBs on 32 and 64 bit operating systems, the limit did not apply any more for whatever reason the designer wanted to set this limit, and therefore, there is no 4GB limit on the  key buffer size for MyISAM tables.

The 4GB limit stays for join_buffer_size, sort_buffer_size, and myisam_sort_buffer_size, But even those had the 4GB limit removed on 5.1.23/5.2.6
In any case, all the literature on the internet stating that there is a 4GB limit on the key_buffer_size are either outdated, or based on outdated literature.
Settings for read_buffer_size and read_rnd_buffer_size
are limited to 2GB on all platforms.

Stats infinity progress

Posted on by
Reply

I have been doing some work on Stats Infinity, and now i myself  can feel the benefits of using the website to find good domain names

In a few hours, the search script and search box will be ready so that you will be able to search for expired domain names by keyword, Something that sounds trivial but in reality it is not.

The problem is the search algorithm when you do not know the position of the keyword (s)  in the word.

For example, you can see Domains containing the word SMART (You can restrict this to expired domains if you like ), but you can not see those that have the word SMRT (With the A omitted) simply because the matching on this system works  for words in a list of 1 million words from English, Italian, Spanish and German. Words not on the word list will not work.

I am now looking for missing words and adding them to the list of words, but more of this activity is expected to come later, once i get more of the website done

Mixing keywords while searching for expired domains works as well, In the search box you should be able to enter any combination of words and our system will try to show you expiring domains by relevance.

Some of the good features of the website such as finding out what domain names are re-branded nameservers  and which ones are actual unique nameservers are not very obvious, I intend to write human edited clarifications such as the one about GoDaddy’s Domain Control and for example.

Other features such as (Real Nameservers) are very simple to use but the designer needs to get creative in making things clearer on the website, when you check for a nameserver, a list of alternative hostnames (rebranded nameservers) appears on the left, You can also reach such a list by entering the nameserver’s hostname or IP address in the box provided (Same box you would enter keywords into).

In any case, i will be keeping everyone posted on the progress of the project, and wishing everyone the best of luck in finding there new domains :)

MySQL Windows VS MySQL on Linux

Posted on by
Reply

Comming across Robin Schumacher’s “MySQL on Windows? Absolutely!” i have some stuff to say

First, I absolutly LOVE windows on my Desktop, and i LOVE Linux on my servers, and i have nothing against windows servers or Linux Desktops, i like Operating systems that get the Job done faster and with least effort, so what suits a job suits me, having never used a mac, i would jump to a mac if they tell me it can help you develop application X faster, why not, but the article here http://dev.mysql.com/tech-resources/articles/mysql_on_windows.html does not seem to make sense to me. Here is why

In the comparison of number of downloads, it clearly reads that windows has 600K downloads VS linux that has 200K downloads, but are you serious ?

On Linux, MySQL is hardly if ever downloaded from mysql.com , while on Windows it is always downloaded from MySQL.COM and therefore i beg an explanation on why you say this statistic tells anything, Also, most developers are like me, they use the Windows edition for development on there development PCs, and then deploy the actual application on a Linux server.

For example, on a debian system i would simply issue

apt-get install mysql-client mysql-server

this will get MySQL binaries from Debian, not from MySQL, and therefore making the statistic not available to you.

Then the article talks about how insignificant the differences between the Linux and Windows edition is, to tell you the truth, this is not the case at least for me, here are SOME examples

Most of my applications can not make good use of RAID because RAID does not help with disk seek time (And therefore latency), My answer to this is usually separating tables to more than 1 hard disk , and although having databases moved to other hard drives is supported in windows by creating a text file, moving individual tables on windows is not, On linux, i simply create a symbolic link to the MYD file, and one to the MYI file, i can even split a single table to 2 hard drives with the indexes on 1 drive and the actual data on the other.

Clustering anyone ??

For a longer list check out http://dev.mysql.com/doc/refman/5.0/en/windows-vs-unix.html , this is certainly is inferior to the Linux counterpart for something like a shared hosting environment (See number of open files and connection timeouts etc..)

Now to add more to that, Linux is a free OS, you install and upgrade it for free, and MySQL is also free, if your business uses many many MySQL servers, your savings on Windows Server licenses can be significant.

The bottom line is, when a company like Oracle (Since it has acquired SUN) gets hold of an open source database engine, you can rest assured objectivity will still be there only when it supports the paying product.

Thanks for listening.

Setting up MySQL on Ubuntu

Posted on by
Reply

Setting up MySQL to connect to from PLESK for example is very simple

apt-get install mysql-server

Then, you will need to allow mysql to listen to the outside world

Edit /etc/mysql/my.cnf

and comment out the line

bind-address = 127.0.0.1

then, you will need to allow the root user to connect from outside the server

On the command prompt

mysql -uroot –password=”aPassWord”

use mysql;
select host, user from user;

Now look for the root user with the hostname of the machine, assuming it came out as thishost

update user set host=’%’ where user=’root’ and host=’thishost’;

flush privileges;

quit

And you should be all set

If you don’t perform the above operations, PLESK will complain when you add the server to the list of database servers, You will probably see an error like

Error: Test connection to the database server has failed because of network problems:
Failed to connect to database: Can’t connect to MySQL server on ‘host.domain.com’ (10061)