MySQL DBA - An Oracle DBA's view

Posted Wed, 05/26/2010 - 23:44 by Creator

I am going to build a list of features, commands and concepts from MySQL and Oracle. This comparison will not go into the pros and cons or which database has more options or features. The goal is to give someone a feel for the differences. I am a big evangelist for Oracle and MySQL technologies. This is a list I will build over a period of time.

MySQL DBA - An Oracle DBA's view-II

Posted Wed, 05/26/2010 - 23:30 by Creator

Products

Below is a list of popular products used with MySQL and Oracle:

Drupal string functions

Posted Tue, 05/25/2010 - 11:53 by Creator

As you can see there is alot of comparison with the most used default
string functions. Within Drupal it is encouraged to use the drupal
string functions until PHP has core unicode support (maybe the biggest
feature change for PHP 6! Yay!).

Mysql Storage Engines

Posted Fri, 05/22/2009 - 17:56 by Creator

MySQL supports several storage engines that act as handlers for
different table types. MySQL storage engines include both those that
handle transaction-safe tables and those that handle
non-transaction-safe tables.

MySql Error 1030 [Got Error 28 From Storage Engine]

Posted Thu, 05/14/2009 - 17:50 by divinityexalt_admin

That error means you don't have any space left on the disk to complete the operation.
If you see same error again and again ' Re: ERROR 1030 (HY000): Got error 28 from storage engine ' coming back from MySQL, this almost certainly means your hard disk is 100 % full - you can check this with:

% df -h

MySQL Query Optimizations-I

Posted Tue, 04/28/2009 - 10:14 by Creator

Introduction

Query optimization is the often overlooked part of applications.  Development schedules being what they are, getting the right results and getting the application working are the main priorities.  So thoroughly testing, and benchmarking queries is often left as an afterthought.   

Syndicate content