MySQL
Using PBXT 0.9.5
Paul has released Version 0.95 of his PBXT MySQL Transactional Storage Engine. Here is what I did to get it operational under CentOS 4.3. su - useradd pbxt su - pbxt wget http://www.
Read moreUsing the MySQL Test Suite
MySQL provides two different tools to test the MySQL Server with SQL statements. One is mysqltest and in 5.1 mysqlslap. Both of these tools have quite different purposes. This is a quick review of the usage of mysqltest.
Read moreUsing Cascade in Foreign Keys
For those that are using a Referential Integrity based Storage Engine in MySQL, the use of Foreign Keys can provide an extra level of data integrity within your application. There are of course caveats to this statement, such as correct design, proper transactional use etc, but that’s a topic for another time.
Read moreWhat constitutes a good error message to the user?
Today, will go down in my professional history as quite possibly the lowest I would ever think of a software developer. I’ve carefully avoided the term “fellow coder”, speaking of a IT industry sticking by fellow IT people, but not today.
Read moreMySQL Ideas
Seems I have over time, thought of many ideas, jotted some notes on some, and even done some work, but everybody knows that “home projects” can take a long time.
Read moreHow I work
My work life is really fragmented at present, so I’ve decided a split approach in answer to Dave Rosenberg’s How I Work–what I have learned so far . What is your role?
Read moreA better VNC
I’ve been using VNCViewer from RealVNC under Linux to remote connect to an older machine running windows. Two reasons, I don’t need yet another screen on my desk, and I need windows to adequately test and use the MySQL GUI products, in particular MySQL Workbench.
Read moreImproving Open Source Databases – WordPress
As part of both my UltimateLAMP side project, and my greater involvement with MySQL Workbench, I’ve been wanting to review and document the database schemas of Open Source products. Indeed, as part of discussions with Mike Zinner of MySQL AB at the recent MySQL Users Conference, I suggested an idea used in the Java World, for example by Clover and Agitar, where to promote the usefullness of their respective tools (in this case code coverage), they provide results against Open Source Products.
Read moreMigrating an MyISAM schema to use Referential Integrity
Here are some steps involved. Using the current MySQL defacto engine InnoDB. Of course, Falcon, PBXT and others will enable alternative engines to be used. Convert Table Storage Engine Types
Read moreRestyling a Mediwiki Installation – Lesson 1
Following my implementation of UltimateLAMP , read heaps more at this thread , I undertook to provide customizations of a MediaWiki Installation. Here is the first lesson that you can undertake if you wish to beautify the default MediaWiki Installation.
Read moreUltimateLAMP
This product is no longer available. This was created over 6 years ago and software is too out of date. As I discussed earlier in [A picture can tell a thousand words][1], I outlined briefly what the intention of **UltimateLAMP** was for.
Read moreA picture can tell a thousand words
I’m a keen advocate of MySQL. However, while I use it and promote it within my limited IT circles, I often wonder how MySQL can get better traction and exposure, especially within both the industry sectors and physical locations where I am presently.
Read moreMySQL GUI Products
I’ve started now to actively use more of the MySQL Workbench, MySQL Administrator and MySQL Query Browser and MySQL Migration Toolkit. I am traditionally a very command line person, and it’s important that these skills are never put on the back burner.
Read moreWordPress Blog Upgrade Time
Time to Upgrade my WordPress Blog software from Version 1.5.2 to Version 2.0.2 after my latest spam attacks and Combating Blog Spam attempt. Here is what I did. cd /home/arabx/www tar cvfz blog.
Read more