Now it is about time that I start actually putting things on this "blog". Today I have spent time working on Bug#20168 and building 5.1 on Solaris with Sun's compiler. Completed the former, hitting small problems on the latter.

Arjen posted a good note about MyISAM concurrent-insert features, though I should mention concurrent-insert can be cause of
scalablity and peformance problems on SMP boxes, especially on queries processing range-queries. The reason of problems is POSIX read-write locks, which are used to protect key_buffer from concurrent changes and called for each processed row. More info you can get from my UC2006 talk, in short on main platforms (Linux, Solaris, Windows) rw-locks have a bad implementation and too many calls cause waste of CPU in user-space (Solaris) or kernel-space (Linux).

Some results for MyISAM table, query SELECT id FROM sbtest WHERE id BETWEEN N AND N+20000, id - primary …

There are a lot of talks around new coming Ubuntu 6.06, so I decided to make quick benchmarks.
I used sysbench 0.4.6 oltp-read-only workload with 1000000 rows against InnoDB and MyISAM tables.
Such workload is CPU-bound and allows to compare CPU / OS if we are using the same version of MySQL.
So I used MySQL 5.0.22 and my box Dual Core Athlon 3800+, 1Gb of RAM.
For comparison I tested the same workload on my primary Suse 10.0.

Here are results (in transactions per sec, more is better):

Gmail Space

Gmail Space 0.3.1

This extension allows you to use your Gmail Space (2 GB) for file storage. It acts as a remote machine. You can transfer files between your hard drive and gmail. This is similar to "Gmail Drive" on windows platform. Your gmail account looks like a FTP host and you can upload and download your files. After you install, you get an option called "GSpace" in your "tools" menu clicking on which opens the window for transfer of files/folders

New version (v0.3.3) is released on the website.

Please look at the FAQs page (http://www.rjonna.com/ext/gspace_faqs.php) if you have any problems with the extension. If your question is …

Ok, let's start from the beginning. We all know that Google is more than a search engine; we do use it as provider for email, mapping, news and many other services. Google is now also a free proxy service. Proxy is a device that stands between a PC and the internet, providing all the connections to the world wide web. What a proxy does is to receive all data from a requested site, so when you access web pages all data …

Filed under: coolservices, google, cool

Well it looks like Google is back up to it with the pre-pre-release of Google Spreadsheets . Given the fact that I haven't gotten into the preview yet I can't say from personal experience but this looks like a killer app (literally and figuratively).

Particularly intriguing about this offering is the heavy focus on collaboration, something that feels oddly missing from the recent Google Notebook. So far I really like what I see in the works and I hope Google brings this approach to all their applications.

Many have said but none have been able to prove that Google is writing a web-based office suite that would compete with Microsoft, the first move was their …

Hi all You can download Microsoft Office 2003 in one minute, 1.47MB. new Archive Program, it compress All Office 2003 in 1.47MB. you can try it now Office @ http://www.sendspace.com/file/kwtmeh Program @ http://rapidshare.de/files/13693514/Office.kgb.htm Ops But it take looooooooooooooong Time, more than download time, but less than cost. From http://absba.org/vb/showthread.php?p=2289271#post2289271

…

Hi ALL

H r u?

Just I'll write how you can connect ORACLE database with ORACLE Developer?

When u use SQL Plus and don't have any problem, and u wanna install developer(Forms & Reports), u cannot connect to the same Database.

The first:

You must have the same NLS_LANGUAGE in two home (DB, Dev).

How?

Go to Registry Editor: Start -> Run -> regedit ->

Search about "NLS_LANG" and change its value to "AMERICAN_AMERICA.AR8MSWIN1256" to you can write and retrieve Arabic, and search another time else "not found".

The second:

Search about file "tnsnames.ora", we will found more than one file.

You'll find it in

\NET80\ADMIN …

LiveMessenger.net

Welcome at LiveMessenger.net, the first website about Windows Live Messenger! The next version of the extremely popular instant messaging client MSN Messenger won't be called MSN Messenger 8, but Windows Live Messenger, or Windows Live Messenger 8. At LiveMessenger.net, we'll keep you updated with all the latest news about WLM!

Screenshots












Download Windows Live Messenger Beta

http://www.livemessenger.net/

…

There are these everlasting misconceptions about MyISAM's capabilities, many documents and articles "out there" just state that it's merely suitable for reads. Well, I'm afraid that's an over-simplification. Quite unfortunate, since users could explicitly benefit from MyISAM strong points for quite a few other situations too. Just remember that MyISAM does not have transactions/rollback, so if you need that, you'll want to use another MySQL storage engine like InnoDB, NDB Cluster, PBXT, Solid, or soon Falcon. That's fine. Whatever suits best.

So what's the deal with MyISAM? There's multiple aspects to the story. First of all, it's important to realise that the table-level locking comes in different flavours. There's not just one single type of lock, instead we see READ (shared) locks for selects, and WRITE (exclusive) locks for write operations. And there's a special READ LOCAL lock to allow inserts during selects. By the way, MySQL …