MYSQL : Tuning / Optimizing my.cnf file

Posted by Jiltin     Tags: , 16 August, 2009    23,154 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 : ,

XCACHE – The Great PHP opcode Performance Tool For Wordpress Bloggers

Posted by Jiltin     Tags: , 30 July, 2009    2,961 views    (1) Comment

Recently, I noticed that the response from my blog was very slow when I started getting 1000+ user hits daily. It was hosted on a Linux platform – dedicated Pentium core duo laptop processor with 2 GB memory. Hence, I upgraded to Power edge quad core processor with 12 GB memory. After I migrated, I found the response was not so great until I realized root cause of the issue – Performance tuning! For php, xcache is one of the best tools to accelerate the blog performance. You can Read Full Article (Click here)...

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

Wordpress – Mysql Performance tuner, a free Good Optimizer

Posted by Jiltin     Tags: , 30 July, 2009    9,014 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 : ,

Oracle scripts – Tuning & Performance – Gather Statistics importance

Posted by Jiltin     Tags: , 4 March, 2009    8,853 views    (0) Comment

Oracle performance tuning – Gather Statistics: Here is the one issue: I have same script using two tables as given below, running in two databases. The data, table names, indexes and the select statements are same. One database the query is running fast and another query is slow. SELECT              MAS.site_use_id,          MAS.currency,          DET.customer_id     FROM table_master Read Full Article (Click here)...

Categories : 11i Scripts, Oracle Applications Tags : ,

Handy tkprof sql creating script using bash shell unix, linux with oracle environment

Posted by Jiltin     Tags: , , , , 10 December, 2008    13,304 views    (0) Comment

Oracle gives you this program called TKProf that reads your trace file and spits out somewhat meaningful output. My favorite option to tkprof is sort=prsela,fchela,exeela. This sorts the statements from longest running to shortest running. I prefer this format because I can concentrate on the top two or three statements for the most impact. By tracing, I mean capturing all the SQL in a user’s session, or a SQL trace. As you can tell from the Oracle Performance Tuning Guide and Read Full Article (Click here)...

Categories : 11i DBA Scripts, 11i Scripts, Scripts Oracle, Scripts Unix Tags : , , , ,