what is Pinterest and how it’s work

Pinterest is digital bookmarking website that allows users to create and manage theme-based image collections, and discover collections created by friends and other users. It is like a Virtual Pinboard. I have reviewed this website and analyzed it by using and testing on my own personal account. Let me brief you through what I have understood-and this site can be leveraged for brands.

Pinterest is essentially a virtual cork board where you post images from all over the web. The images are “pinned” and organized into collections called “boards” which you name based on themes, topics, or just about anything you want.

For instance, I’ve created a a board for my favorite iPhone & iPad apps linking to the apps in the iTunes App store. Also, as someone who likes to frequently cook (and eat) I created a board for dishes I want to cook and inspirational ways to present food. Each pin links to the original web site where it was originally published so I can possibly backtrack and find out how to make that great recipe I found or others who follow me on Pinterest can discover some new iPhone apps I’ve pinned.

Pinterest users can also do much of the standard stuff such as “like”, “repin” or comment on any image they find. Additionally, one of the ways Pinterest is different than other social networks in the way that users can follow individual boards that interest them instead of being forced to follow a user and everything they share. That allows folks who prefer to follow interests instead of a particular person an opportunity to do s

Note: For creating Pinterest account and using it you should first get an Invite from your friends or a person who are already using it so that he/she can invite you.

What I understood –

  • A pin is an image added to your Pinterest account & this image can be added from any website or upload it from your desktop.
  • The best part is each pin added using the “Pin It” button links back to the site it came from.
  • Board is a set of pins. Board can be created on any topics, such as you Like s and Interest..
  • Pinterest allows you to organize and share all the beautiful things you find on the web on one click “PIN IT” and that will be saved on the category you have created on your Pinterest account.
  • For example if you are surfing through any restaurant website and you found the tables, chairs and ambience great, you can “PIN IT” and save it to the category if it is created if not; you can create a category called Restaurant and save that images on specific category.
  • You can browse Pinboard created by other people to discover new things and get inspiration from people who share your interests
  • For example we can go through Pinboard created by other people and follow their whole profile or the specific category they have created.
  • Now what is “PIN IT”:- Pin IT is a button which is installed on the browser? What I understand “Pin It” works like a Print screen button. When you “PIN IT” specific image is been Pinned in the Pinboard of the Pinterest account you have created and save it on the category which you have created.

Repin is another feature which you can use, when you are browsing others Pinboard you can Repin if you like any of the image you like and that you want it on your board. The user who first pinned the image will also get credit. Repins maintain the source-link of the image no matter how many times it’s repined

Why brands should use Pinterest?

  • Pinterest includes the option for users to label each pin with its cost. This makes search within Pinterest more effective.
  • Pinterest is also effective for brands who want to use content marketing to amplify search. Interest is not where content is created, but rather where it is curated and categorized. Since all pins are links, they show up in Google search results.

Pinterest Visitors Stats –

Unique visitors increased from 418,000 in May to 3.24 million in October,( (Compete.com, December 2011). meaning traffic increased for this site sevenfold in five months alone

Approximately 77% of visitors are in the United States.

Pinterest is used primarily by women (54-70% of user base, as estimated by comScore).

 

 

Search Engine Optimization SEO & Social Media Optimization SMO Training at Indore by SEO Expert

  • What is Search engine
  • How Search engine work
  • Process of Search engine working
    • Crawling
    • Indexing
    • Processing
    • Providing answers by calculating relevancy & serving results.
  • Important Html tags use in seo
  • Inbound and Outbound link
  • No Follow and Do Follow links
  • What is keyword
  • Keyword analysis and selection
  • Tools for keyword selection
  • Keyword density and keyword stuffing
  • Page rank and Keyword rank
  • What is Seo
  • Why Seo is important for websites
  • Seo Techniques [Onpage & Offpage]

SEO Onpage Techniques

  • Meta tag optimization
  • Image tag optimization
  • Ancher tag optimization
  • Link optimization
  • Heading tag optimization
  • Flash optimization
  • Video optimization
  • Content optimization
  • Sitemap creation
  • Robots.txt creation
  • 301 Redirection
  • Add canonical for crawler

SEO Offpage Techniques

  • Social Bookmarking
  • Directory Submission
  • Blog Commenting
  • Forum posting
  • Classified posting
  • Blog Creation and customization
  • Blog posting
  • Blog promotion
  • Article Submission
  • Press release submission
  • RSS feed submission
  • Pinging
  • Local Listing
  • Search engine submission
  • Yahoo Ques. and Ans.
  • Video submission

 

Social Media Optimization

  • Facebook
  • Twitter
  • Google+
  • LinkedIn
  • YouTube
  • MySpace

 

 

 

Other Important Topics:

  • sandbox effect or the Google penalty
  • Black hat and white hat seo
  • Spamming
  • Cloaking
  • Doorway pages
  • Spider simulator tool
  • Reciprocal Link (Link Swap)
  • Link Wheel Concept

Tool for Seo Analysis:

  • Google Analytics
  • Google Webmaster
  • Google Keyword Suggestion tool
  • Google Bookmarks
  • SeoMoz tools
100_1453

What lead developer or Architect should know before starting the Project/Product – Part2

I’m writing my post my post “What lead developer or Architect should know before starting the Project/Product ” – Part1 show you more detail about MYSQL storage engines. This will help employer to identify the right candidate and help to lead developer or Architect finding the right job.

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 nontransaction-safe tables:
MYISAM

  1.     Default MYSQL Engine
  2.     Fast for reading and inserting
  3.     Table level lock
  4.     Fulltext searching capabilities
  5.     No transactional integrity (ACID compliance)
  6.     No rollback abilities
  7.     No Foriegn keys and cascading deletes and updates
  8.     Row limit of 4,284,867,296 rows
  9.     Maximum of 64 indexes per row

When to use MyISAM? -MyISAM is designed with the idea that your database is queried far more than its updated and as a result it performs very fast read operations. If your read to write(insert|update) ratio is less than 15% then you should use MyISAM.

INNOBD

  1.     Fast for updating
  2.     Transactional integrity (ACID compliance)
  3.     Row level locks
  4.     Foriegn keys and cascading deletes and updates
  5.     No full text indexing
  6.     Cannot be compressed for fast, read-only

When to use INNOBD? -INNOBD is designed with the idea that your database is  concurrent insert/Update and raea data same time with the suppot of the Transaction and Foriegn keys. If your using any ecommarce or other sensitive information  then you should use INNOBD.

The EXAMPLE storage engine is a “stub” engine that does nothing. You can create tables with this engine, but no data can be stored in them or retrieved from them. The purpose of this engine is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. As such, it is primarily of interest to developers.

NDBCLUSTER (also known as NDB) is the storage engine used by MySQL Cluster to implement tables that are partitioned over many computers. It is available in MySQL 5.0 binary distributions. This storage engine is currently supported on a number of Unix platforms. Experimental support for Windows is available beginning in MySQL Cluster NDB 7.0; however, we do not intend to backport this functionality to MySQL 5.0

The ARCHIVE storage engine is used for storing large amounts of data without indexes with a very small footprint.

The CSV storage engine stores data in text files using comma-separated values format.

The BLACKHOLE storage engine accepts but does not store data and retrievals always return an empty set.

The FEDERATED storage engine was added in MySQL 5.0.3. This engine stores data in a remote database. Currently, it works with MySQL only, using the MySQL C Client API. In future releases, we intend to enable it to connect to other data sources using other drivers or client connection methods

Some Command for MYSQL Engine
MySQL command prompt login – mysql –hhost –uuser –ppassword;
How to change MYSQL Engine-  ALTER TABLE prosatya ENGINE = innodb;
Which MYSQL engine support you database – SHOW ENGINES;
Show database – show databases;
Select database – Use databaseName ;
Display all of tables in database -  Show tables ;
Display table structure – DESCRIBE TableName ; or DESC TableName;
For table or query performance – EXPLAIN select * from tbl_users where id=1 ;

What lead developer or Architect should know before starting the Project/Product – Part1

I’m writing my post my post “What lead developer or Architect should know before starting the Project/Product” – Part1 show you more detail about design pattern. This will help employer to identify the right candidate and help to lead developer or Architect finding the right job. If you like this post then you must read my next post on mysql engine. This will help you to building right database architecture.

Design Pattern –

  • What is design pattern?
  • When we should use design pattern?
  • Where we should use design pattern ?

A design pattern is a general reusable solution to a commonly occurring problem within a given context in software design. A design pattern is not a finished design that can be transformed directly into code. It is a description or template for how to solve a problem that can be used in many different situations. So patterns are formalized best practices that you must implement yourself in your application.

Creational Design Patterns:

Singleton – Ensure that only one instance of a class is created and Provide a global access point to the object.

When we should use – Singleton pattern should be used when we must ensure that only one instance of a class is created and when the instance must be available through all the code. A special care should be taken in multithreading environments when multible threads must access the same resources throught the same singleton object

Where we should use-  – Configuration, Database and  Logger Classes

Factory – Creates objects without exposing the instantiation logic to the client and Refers to the newly created object through a common interface.

When we should use: – a framework delegate the creation of objects derived from a common superclass to the factory – we need flexibility in adding new types of objects that must be created by the class

Where we should use- Database connectivity[MYSQL,ORACLE and SQL Serverr], XML Parsing [With different xml parser], Sever connectivity[FTP,SCP or Other]

  •      Factory Method – Defines an interface for creating objects, but let subclasses to decide which class to instantiate and Refers to the newly created object through a common interface.
  •     Abstract Factory-  Offers the interface for creating a family of related objects, without explicitly specifying their classes.

Builder - Defines an instance for creating an object but letting subclasses decide which class to instantiate and Allows a finer control over the construction process.

Prototype - Specify the kinds of objects to create using a prototypical instance, and create new objects by copying this prototype.

Object Pool – reuses and shares objects that are expensive to create..

 Behavioral Design Patterns:

Chain of Responsibiliy - It avoids attaching the sender of a request to its receiver, giving this way other objects the possibility of handling the request too. The objects become parts of a chain and the request is sent from one object to another across the chain until one of the objects will handle it.

Command - Encapsulate a request in an object, Allows the parameterization of clients with different requests and Allows saving the requests in a queue.

interpreter – Given a language, define a representation for its grammar along with an interpreter that uses the representation to interpret sentences in the language / Map a domain to a language, the language to a grammar, and the grammar to a hierarchical object-oriented design

Iterator – Provide a way to access the elements of an aggregate object sequentially without exposing its underlying representation.

Mediator – Define an object that encapsulates how a set of objects interact. Mediator promotes loose coupling by keeping objects from referring to each other explicitly, and it lets you vary their interaction independently.

Observer – Define a one-to-many dependency between objects so that when one object changes state, all its dependents are notified and updated automatically.

Strategy - Define a family of algorithms, encapsulate each one, and make them interchangeable. Strategy lets the algorithm vary independently from clients that use it.

Template Method – Define the skeleton of an algorithm in an operation, deferring some steps to subclasses / Template Method lets subclasses redefine certain steps of an algorithm without letting them to change the algorithm’s structure.

Visitor - Represents an operation to be performed on the elements of an object structure / Visitor lets you define a new operation without changing the classes of the elements on which it operates.

 Structural Design Patterns:

Adapter – Convert the interface of a class into another interface clients expect. / Adapter lets classes work together, that could not otherwise because of incompatible interfaces.

Bridge - Compose objects into tree structures to represent part-whole hierarchies. / Composite lets clients treat individual objects and compositions of objects uniformly.

Composite - Compose objects into tree structures to represent part-whole hierarchies. / Composite lets clients treat individual objects and compositions of objects uniformly.

Decorator – add additional responsibilities dynamically to an object.

 

Resources – http://www.oodesign.com/

What is nod.js and Why Use node.js and what industry expert say about node.js

Today i’m reading about NODE.JS and then decide sharing some information about node.js in one my blog post. It’s  amazing , Awesome, Super…  just have  a look  What is nod.js and Why Use node.js  and what industry expert say about node.js

What is nod.js

Node.js is a platform built on Chrome’s JavaScript runtime for easily building fast, scalable network applications. Node.js uses an event-driven, non-blocking I/O model that makes it lightweight and efficient, perfect for data-intensive real-time applications that run across distributed devices.

Why node.js

  • Performance and scalability for I/O workloads
  • Operability.
  • Low per-connection memory overhead
  • Dynamic language support.
  • other too

Some word about node.js by Leading industry expert

  • One best combination for your application/product  – Node.js and MongoDB
  • A server-side JavaScript development technology
  • “Cocktails” is a mix of HTML5, Node.JS, CSS3, JavaScript and a lot of ingenious, creative mind-bending tricks
  • node.js-based runtime to process scripts written in that language

More detail I will add in similar post or on other post ASAP

Resources –

http://venturebeat.com/2011/08/16/linkedin-node/

http://blogs.msdn.com/b/interoperability/

http://www.ebaytechblog.com/2011/11/30/announcing-ql-io/

http://developer.yahoo.com/blogs/ydn/posts/2011/11/yahoo-announces-cocktails-%E2%80%93-shaken-not-stirred/

Top 10 Pros and 5 Cons with Zend Framework basic for your product development

Today i’m  researching and writing my new post on the Zend Framework .  I’m thinking to start new product and not sure which technology i used. I know all of the PHP framework and open source CMS and other application. However as a architect before  starting to the project you should know all the  Pros and  Cons of the technology/ framework. Even not sure yet.  I will do more research on Symfony then decide which Framework i will use for my product developement.

Before starting any of the project you should do proper research for resources, timing ,costing which is very important for yourbest product plan.

Basic of Zend Framework:

  • Zend Framework is  based on PHP
  • Zend Framework Is object-oriented
  • Zend Framework is providing  MVC architecture
  • Zend Framework  is  open source contributors
  • Zend Framework  is   loosely coupled language
  • Zend Framework  is providing web and cli programming

10 reason to use zend framework for you product development

  1. Extend predefine Classes
  2. Object-oriented Goodness
  3. Use What you Need, Forget Everything Else
  4. It lets you do a Lot of Things!
  5. No Model Implementation – Choose your Own Adventure!
  6. Integrate with whatever you Want!
  7. Guidelines and Standards
  8. All Code is Guilty Until Proven Innocent (aka Test-Driven Development)
  9. Community and Documentation
  10. Become Certified professional

5 reason to not use zend framework for you product development probably

  1. Very good for advance php user but typical for beginners
  2. Typical to understand  right class and component  for developer
  3. Scaffolding tool not good like other framework Symfony or  CakePHP
  4. Not compatible with share hosting environment
  5. Typical to use in single object , however Everything is in separate class

 

Resources for more detail http://net.tutsplus.com/tutorials/php/10-compelling-reasons-to-use-zend-framework/

 

7 Tips before starting Magento e-commarce developement and building good e-commarce strore

If you are php developer and going tofor Magento or ecommerce interviewyoushould know below 7 things. Also if you are thinking for start Magento development you  must know all of the below point one by one. If you know all of the below point then you are Magento expert and can earn lot of money.

Now days E-commerce application market very hot and every company is finding good Magento developer and architect.  You can get a lot of freelancing job  in Magento/ ecommerce platform.

If you are thinking how to start Magento development or start business with the e-commerce platform you can contact me.  Maybe I can help you in term of technology. Also you can ask me any question on Magento platform I can help you.

Basics

  • General Programming , PHP and MVC concept’s
  • Event-driven architecture
  • Magento module-based architecture
  • Magento directory structure/naming conventions/code
  • class/namespaces/module structure
  • Configuration XML
  • Factory and functional class groups
  • Class overrides : overriding existing behavior
  • Event observer

Request Flow

  • Dev environment setup: Configure Eclipse with step-through capability
  • Application initialization
  • Front controller
  • URL rewrites
  • Request routing
  • Modules initialization
  • Design and layout initialization
  • Structure and  block templates
  • Flushing data (output)

 Rendering

  • Template structure
  • Blocks
  • Design layout XML schema, CMS content directives

Working with Database in Management

  • Models resource and collections
  • Management object Relational Mapping
  • Write install and upgrade scripts using set up resources

Entity-Attribute-Value model

  • Model concept’s
  • EAV entity
  • Database structure that supports EAV
  • Load and Save
  • Attributes management

Mobile development

  • Creating a mobile app
  • Web services exposed by Magento in XML and JSN

Admin Temple and Configuration

  • Common structure/architecture
  • Form and Grid Widgets
  • System configurations XML and configurations scopes
  • ACL (permissions)
  • Enabling and configuring extensions
  • Creating extensions
  • Creating and configuring corn jobs

 If you are advance trainer then you should know below point

 

1. Magento Performance and optimization
2. Magento solr Search engine Configuration
3. Magento – building customer Web Services
4. Dos and Don’t do in Magento

7 Tips before starting Magento e-commarce developement and building good e-commarce strore

How to set your e-commerce site goal in Google Analytics and calculate ROI – Prestashop

Today I’m sharing knowledge How to set your e-commerce site goal in Google Analytics and calculate ROI.  Prestashop is one open source e-commerce platforms which are popular in the e-commerce domain and provide good solution for your online business.

Create your Google Analytics account if you don’t have. Hope you know how to add you site in Google Analytics. If don’t know contact me I will setup your site free of cost.

To set up your goals, enter Goal Information

  1. Find the profile for which you will be creating goals.
  2. Select available  conversion option from right side
  3. Select  available goal slots option from right side
  4. Select available one of the 4 Goals (set 1) slots option

Then, define a funnel by following these steps:

  1. Enter the URL of the first page of your conversion funnel. This page should be a common page to all users working their way towards your Goal.
  2. Enter a Name for this step.
  3. If this step is a required step in the conversion process, mark the checkbox to the right of the step.
  4. Continue entering goal steps until your funnel has been completely defined. You may enter up to 10 steps, or only one step.

Demonstration: The order process

  1. After having enabled your e-commerce reports and selected the respective profile enter ‘order-confirmation.php’ as the targeted page URL.
  2. Name this goal (for example ‘Order process’)
  3. Activate the goal
  4. Add ‘product.php’ as the first page of your conversion funnel
  5. Give it a name (for example, ‘Product page’)
  6. Do not mark the ‘required’ checkbox because the customer could be visiting directly from an ‘adding to cart’ button such as in the homefeatured block on the homepage.
  7. Continue by entering the following URLs as goal steps:
    • order/step0.html (required)
    • authentication.php (required)
    • order/step1.html (required)
    • order/step2.html (required)
    • order/step3.html (required)
  8. Check the ‘Case sensitive’ option
  9. Save this new goal

Why I write this article – How to set your e-commerce site goal in Google Analytics tool

I got call from one of my college friend she said do you know prestashop open source e-commerce platform? I really don’t know about prestashop. Then decide install, research and see prestashop feature.  When I’m doing the research I got Google Analytics core module. Then I decide I should setup and write e-commerce site goal. You can calculate the ROI by Google Analytics

Google Analytics. Also you can find more information on twitter by hashtag for #ecommercetips and #analyticstips.

How to install Magento, Magento theme, sample data and verify server configuration

Today I’m writing first post on Magento. Magento is very good and powerful e-commerce platform for create your e-commerce site…

eCommerce Software for Online Growth - Magento is the ecommerce software platform for growth that promises to revolutionize the industry. Its modular architecture and unprecedented flexibility means your business is no longer constrained by your ecommerce platform. Magento is total control -”

How to install Magento -   For Magento installation you need to follow below 5 step then your e-commerce application is ready.   After reading these articles you still not able to install then contact me. I can install for you may be free of cost or in bear charge.

  1. Where I can download Magento installation zip file
  2. How to check server configuration ok before Magento installation
  3. Install Magento theme
  4. Install Magento sample data
  5. Clean Magento cache “Must do to see change in one shot”

Where I can download Magento installation zip file

Download latest stable release of the Magento Community Edition and Sample Data from given urn  http://www.magentocommerce.com/download

How to check server configuration ok before Magento installation

  • Download the magento-check.zip from below link
  • http://www.prosatya.com/download/magento/magento-check.zip
  • http://bit.ly/1crbzr
  • Extracte and upload  magento-check.php file to the Magento root directory on your server or other palace where you can run the file on browser.
  • Run the url – http://www.yourdomainname.com/ magento-check.php
  • If you get below message then you can install Magento in right way. Otherwise you need to contact your hosting provider.

Congratulations! Your server meets the requirements for Magento.
You have MySQL 4.1.20 (or greater)
You have PHP 5.2.0 (or greater)
Safe Mode is off
You have the curl extension
You have the dom extension
You have the gd extension
You have the hash extension
You have the iconv extension
You have the mcrypt extension
You have the pcre extension
You have the pdo extension
You have the pdo_mysql extension
You have the simplexml extension

How to install Magento theme

  • Download the free theme from http://www.templatemonster.com/magento-themes.php or any other place where you got good theme
  • Upload the “app” and “skin” folders from the template directory folder to your Magento root folder (all the file should be replace on server)

How to install Magento sample data

  • Create database by your PHPMYADMIN or by control panel.
  • Extract “magento-sample-data-1.2.0” the sample data zip file and
  • Import database magento_sample_data_for_1.2.0.sql database. You have created database before one step.
  • Copy media file on you server
  • Run your site. Now installation process begin
  • Enter all the required information [hostname, database name, username and password]
  • You sample data install
  • Now your site is ready for demo.

Clean the Magento cache:

  • Go to www.youdomainname.com/index.php/admin
  • Select System>Cache Management
  • In Cache Control box check all options and in All Cache dropdown select Refresh
  • Then click Save Cache Settings in the top right corner
  • Open your website and refresh the page (CTRL+F5)

Now your e-commerce website is ready. Now you need to do lot of things as an administrator. Next article I will share administration guide.

After Magento installation you should do wait some time for next articles.

 

How to improve website performance by MySQL Optimization

Website Performance is very important today I’m writing on How to improve website performance by MySQL optimization. By MySQL optimization you can increase website performance and decrease the server load. If you server performance is good then you can serve your site content to more users. Hope this help you lot if you are Developer or technology consultant then you can track MySQL and server performance. Some of developer doing client side cache and some of server side. MySQL provide own cache mechanism so use MySQL cache mechanism.

  •  hardware Optimization
  • disks Optimization
  • OS Optimization
  • application Optimization

    • Don’t use Select * from table name in your query
    • Use Persistent connection in your application
    • Don’t use columns which you don’t required in SQL
    • Use LOCK TABLES if you doing lot of changes on for example group delete or update
    • Benchmark all parts of your application
    • Don’t use columns which you don’t required in SQL
    • Optimize your table layouts and queries
    • Use replication to get more select speed.
  • MySQL Optimization
    • Maintain your tables (myisamchk, CHECK TABLE, OPTIMIZE TABLE).
    • Use EXPLAIN SELECT, SHOW VARIABLES, SHOW STATUS and SHOW PROCESSLIST.
    • Learn how the query optimizer works.
    • Optimize your table formats.
    • Benchmark all parts of your application
    • Don’t use GRANT on table level or column level if you don’t really need it.
  • SQL Optimization

    • Find rows based on WHERE clause
    • Use JOIN, GROUP BY, ORDER BY, DISTINCT
    • Don’t validate data (like date) and used as a calculator
    • Keys are good for searches, but bad for inserts / updates of key columns.
    • UPDATE table set count=count+1 where key_column=constant is very fast!
    • Take advantage of default values on INSERT.

You can change below configuration according to your requirement and server resources which includes server memory,processor etc. by this you can improve server side performance.
Decrease parameters value according to your application needs.
Name of Property    Suggested     default value
wait_timeout    100    28800
interactive_timeout    120    28800
wait_timeout

Increase parameters value according to your application needs.

Name of Property    Suggested     default value
connect_timeout    10    5
join_buffer_size    1M    131072
max_allowed_packet    16M    1M
sort_buffer_size    2M    1M
read_buffer_size    2M    1M
read_rnd_buffer_size    4M
sort_buffer_size
key_buffer
key_buffer_size

I’m giving one example how to update mysql configuration so that you have Idea how to other you can update.

How to enable Query Cache by MYSQL my.cnf file
query_cache_type=1
You can set below   query_cache_type option as per your requirement
0 : Don’t cache results in or retrieve results from the query cache.
1 : Cache all query results except for those that begin with SELECT S_NO_CACHE.
2 : Cache results only for queries that begin with SELECT SQL_CACHE
query_cache_size = 2728857434
To set the size of the query cache, set the query_cache_size system variable. Setting it to 0 disables the query cache. The default size is 0, so the query cache is disabled by default.
query_cache_limit=2194060
To control the maximum size of individual query results that can be cached, set the query_cache_limit   system variable. The default value is 1MB.

How to enable Query Cache by MYSQL command line
You need to login in your mysql account by using the below command
mysql –hHOSTNAME -uUSERNAME –pPASSWORD
mysql> SET GLOBAL query_cache_size = 16771072;
mysql> SHOW VARIABLES LIKE ‘query_cache_size’;

 

Interview Question covers in this post your interview defiantly ask you if you are going to LAMP/MYSQL DBA Interview

  • How to increase MYSQL performance
  • How to increase  MYSQL performance by server configuration
  • How to increase  MYSQL performance by Optimizing SQL
  • How to increase  MYSQL performance by Optimizing MYSQL
  • How to enable and increase mysql cache

Resources:

http://dev.mysql.com/tech-resources/presentations/presentation-oscon2000-20000719/

Proudly powered by WordPress
Follow

Get every new post delivered to your Inbox

Join other followers