Server-side

Free Cheat Sheet: GlassFish Application Server v3

Getting Started with GlassFish Application Server v3 begins by introducing you to what GlassFish is and how to get it.  Then it goes on to prove its worth as...

0 replies - 785 views - 11/16/09 by lyndsey in Announcements

Open Source : How Do You Stay Up To Date?

I Love the concepts and beliefs behind Open Source. I use Open Source libraries, applications etc. all the time. One of the things I have always found a...

18 replies - 11122 views - 01/10/09 by Schalk Neethling in News

When To Use Hardware Upgrade Instead Of Software Optimization

One typical question which frequently pops up is whenever it is better to use hardware upgrade or optimize software more. I already wrote about it, for example...

1 replies - 2293 views - 12/08/08 by PeterZaitsev in News

Computing 95 Percentile In MySQL

When doing performance analyzes you often would want to see 95 percentile, 99 percentile and similar values. The "average" is the evil of performance...

0 replies - 2869 views - 12/03/08 by PeterZaitsev in News

Making Your MySQL Tables More Effecient By Using Correct Fieldtypes

One of the biggest mistakes of today's fledgling MySQL programmers is their field type definitions, also known as data type or column type. Many are too quick...

1 replies - 5228 views - 12/02/08 by Mike Bernat in News

A Simple Clustered Task Distribution System

This article will introduce the basic concepts of JGroups and then implement a task distribution system (on top of JGroups), where tasks can be placed into the...

4 replies - 19131 views - 10/06/08 by Bela Ban in Articles

ANALYZE: MyISAM vs Innodb

Following up on my Previous Post I decided to do little test to see how accurate stats we can get for for Index Stats created by ANALYZE TABLE for MyISAM and...

0 replies - 2897 views - 09/11/08 by Schalk Neethling in News

Troubleshooting Relay Log Corruption in MySQL

Have you ever seen the replication stopped with message like this: Last_Error: Could not parse relay log event entry. The possible reasons are: the master's...

0 replies - 4099 views - 09/09/08 by Schalk Neethling in News

Podcast: Writing LUA Scripts for MySQL Proxy - MySQL University

This session will introduce the basics of the Lua language, with particular emphasis on the features of immediate use with MySQL Proxy. The lecture will...

0 replies - 2351 views - 09/08/08 by Schalk Neethling in News

How to find duplicate row in a table - MSSQL

The below given query will fetch the duplicate rows in MSSQL with number of occurance of each row.SELECT <all column names - comma seperated>,...

0 replies - 2298 views - 09/01/08 by arunbiji in Tips and Tricks

Why Data As A Service Isn't A Bad Idea

Early this week I encountered the post "Why the Database as a Service is a Bad Idea" written by Arnon Rotem-Gal-Oz in DZone. The title caught my eye...

0 replies - 1790 views - 08/21/08 by gilf in News

How adding another table to JOIN can improve performance

JOINs are expensive and it most typical the fewer tables (for the same database) you join the better performance you will get. As for any rules there are...

1 replies - 3642 views - 08/14/08 by Schalk Neethling in News

Backup Your LAMP With Rsync

Continuing with the backup theme of my last post, I've needed to back up our local LAMP server because its starting to hold some important data. Maybe...

0 replies - 2828 views - 08/05/08 by Schalk Neethling in News

Seam and Hibernate Development with JBoss

JBoss Developer Studio includes brand new tools for Seam, a powerful application framework for building next generation Web 2.0 applications. These Seam...

0 replies - 11407 views - 06/11/08 by James Sugrue in Videos