Prometric is beginning to offer the MySQL Exams as part of the Sun catalog. Currently only the Associate and Developer exams are listed but the DBA 5.0 and cluster exams are on the way.

I find myself …

I was randomly browsing for some stuff and I stumbled across this post on binary literals. It proposed the following as an option for C++ which the article admits as being inefficient:unsigned long const mask = std::bitset<6>(std::string("111100")).to_ulong();I was thinking that C++ templates must be able to offer something more efficient...template <int N>struct Binary{ enum { value = Binary

In one of the servers we have an issue that happens to one of the servers that some itemsthat have the status of "freeing items" and "Sending data" are just stuck there, causing alot of locks on the server, and the load of the server drops to almost 0.The server then wouldn't restart, and the only solution is to kill the mysqld process, andfix the crashed tables that result from the kill.How to

The first decision to make is whether someone want to use a production (stable) release or a development release. In the MySQL development process, multiple release series co-exist, each at a different stage of maturity:

At the time of writing this:

• 
  MySQL 5.4 and 6.0 are the current development release series.
  
  
• 
  MySQL 5.1 is the current General Availability (Production) release series. New releases are issued for bugfixes only; no new features are being added that could affect stability.
  
  
• 
  MySQL 5.0 is the previous stable (production-quality) release series.
  
  
• 
  MySQL 4.1, 4.0, and 3.23 are old stable (production-quality) release series. MySQL 4.1 is now at the end of the product lifecycle. Active development and support for these versions has ended. …

Source - MySQL Manual

The most requested features and the versions in which they were implemented or are scheduled for implementation are summarized in the following table.

7TKU66CE8V5W

More than three years ago one prominent Wikipedia community member, who didn’t have enough time to work on our technology, but had enough of it to criticize it, had a problem. He was working for a super-computing lab that boasted one of fastest world’s clusters (IBM blue-something), and to relieve the stress of some of his hard work, was trying to solve a computer science mystery:

Given a dictionary, find words that have most anagrams. With few-hundred-thousand word dictionary, on 8-way machine this should complete in less than 12 hours.

The supercomputing lab inspired solution was something like this (I may be wrong, years pass though):

• Put all the words into an array
• Start generating letter sequences: aaaa, aaab, aaac, …
• For every generated word, traverse the array, find how many matches it hits
• Get sequences with most matches

See, the problem was not …

Yesterday I merged the BlitzDB tree with Drizzle‘s trunk for the first time in a long time (yeah…) and discovered some interesting changes made to the storage subsystem while I was away.

Previously all functions that caused an action to the storage engine was a member of the handler class but various things like table creation and transaction related functions have now moved to the StorageEngine class. These changes are somewhat drastic but makes good sense for Drizzle to grow further since it makes the subsystem easier to understand and frees Drizzle from the interface design that was strongly affected by MyISAM. For those that are interested, the StorageEngine class is located in “drizzled/plugin/storage_engine.h”.

For me it was pretty easy to update BlitzDB to work with the new …

Recently on a number of sites the benefits for and against have been debated with, on occasion, these conversations falling into abuse being thrown in both directions.

From a pure technical perspective, the TPC benchmarks make little sense and are probably not relevant to 99% of organizations looking to implement a database technology.  But as a tool for generating visibility, debate and improved public awareness of a vendors technology they still have an impact. 

This is marketing, pure and simple.  Having a great TPC result is akin to an author having a great review on Amazon.  Doesn’t mean it is relevant for you but if faced with a stack of titles you haven’t yet read you’ll probably look more closely at the ones you’ve heard something positive about.

TPC’s are a tool for the marketing department, just the same as any other form of …

So i got the T1000 working again (finally, after much screwing about trying to get the part). I then hit the ever annoying “no console” problem, where the console didn’t work – kind of problematic.

After a firmware upgrade, and passing “console=/dev/ttyS0″ to the kernel, things work.

So the T1000 firmware 6.3 doesn’t work with modern debian kernels. Thing swork with 6.7 though.

Very often people not expert ask me some simple detailed directions on how to install MySQL from fresh.

The following is a simple one that if you will follow step by step should give you a MySQL working installation.

this articule assume that you have the possibility to attach different storage for:

System and binaries

MySQLData

MySQLLogs

Prerequisite:

1) You need to have access to the client area for download the MySQL software from somwere possible points are: www.mysql.com www.askmonty.org www.percona.com

2) Perl DBI and DBD::mysql installed on the machine (See How to Install MySQL Perl module guide)

3) Root privileges

Steps:

1) Install the Perl modules

2) Create a directory layout as follow:

/mysql_data/
|-- data
|   |-- mysql
|   `-- test
`-- lost+found 
 …