MySQL

MYSQL: Base 64 Function call Reference

Posted by Jay     Tags: 20 October, 2009    2,370 views    Comments Off

I tried to use base64 function in mysql, but could find only a freeware/open source procedure to use it. Herewith I share the content and download-able file for you! Give the credit to the original Author. If you need ‘What is base64?”, here is the Wikipedia Reference: The term Base64 refers to a specific MIME content transfer encoding. It is also used as a generic term for any similar encoding scheme that encodes binary data by treating it numerically and translating it into a Read Full Article (Click here)...

Categories : MySQL Tags :

MYSQL : Tuning / Optimizing my.cnf file

Posted by Jiltin     Tags: , 16 August, 2009    20,747 views    (4) Comment

In my new server, I Have to do some fine tuning of MySQL 5 and here is what my.cnf file looks like for a 2GHz machine with 12GB of memory. Below are notes on some of the important variables, I took down while tuning the config file. 1. query_cache_size: * MySQL provides one feature that can prove very handy – a query cache. In a situation where the database has to repeatedly run the same queries on the same data set, returning the same results each time, MySQL can cache the Read Full Article (Click here)...

Categories : MySQL, Web & Scripts Tags : ,

Wordpress – Mysql Performance tuner, a free Good Optimizer

Posted by Jiltin     Tags: , 30 July, 2009    7,391 views    (0) Comment

Even after upgrade of my server to poweredge with quad core and 8GB memory, I did not see any improvement on my blog performance. In my new server, I have also installed a trial oracle applications and noticed a substantial performance in oracle applications response while it was developed over high memory hog java! As an expert in oracle applications and its architecture, it took no minute to understand that I need to look at the performance tuning of my blog on the LAMP components such as Read Full Article (Click here)...

Categories : MySQL, Web & Scripts, wordpress Tags : ,

How to Default Timestamp and/or Update timestamps with MySQL?

Posted by Jiltin     Tags: 9 July, 2009    3,428 views    (1) Comment

A lot of relational tables need created and update timestamps columns. I prefer having them for all tables with no exception. However, most of applications I am working on are running MySQL. MySQL has minor limitation on timestamps. Unfortunately you can create only one time stamp column that has DEFAULT NOW() value. Read more to see how to avoid this limitation. The simplest way to do this is create the following columns in the table: stamp_created timestamp default now(), stamp_updated Read Full Article (Click here)...

Categories : MySQL Tags :

Common MySQL Queries with MySQL 5&6

Posted by Jiltin     Tags: 17 April, 2009    1,065 views    (2) Comment

This is not my own script. I found this very useful from the net and copied here or my reference: Basic aggregation This is the simplest grouping query pattern. For column foo, display the first (smallest), last (largest) or average value of column bar: SELECT foo, MIN(bar) AS bar FROM tbl GROUP BY foo Return the highest bar value for each foo, ordering top to bottom by that value: SELECT foo, MAX(bar) AS Count FROM tbl GROUP BY foo ORDER BY Count DESC; Ditto for AVG(), COUNT() etc. The Read Full Article (Click here)...

Categories : MySQL Tags :