Tutorials

Geeksww.com RSS Follow geeksww on Twitter

Prev | 1 2 3 4 5 | Next

MySQL unique key vs primary key constraints

Submitted by Shahryar on Wednesday September 15, 2010

Both primary and unique keys serve to identify one and only one row in a table. However, there are some differences that we are going to look at in this tutorial...(Read more)

Category:

Database Management Systems > MySQL > Tips and Tricks

Tags:

myisam mysql mysql-unique-key primary-key

Generating prime nos in PHP using multiprocessing - Geaman with PHP client Part I

Submitted by Shahryar on Sunday September 12, 2010

Gearman provides a generic application framework to farm out work to other machines or processes that are better suited to do the work. It allows you to do work in parallel, to load balance processing, and to call functions between languages...(Read more)

Category:

Web Development > PHP > Tips and Tricks

Tags:

development gearman linux multiprocessing multithreading php

Installing Gearman shared PECL extension for PHP on Debian/Ubuntu Linux

Submitted by Shahryar on Sunday September 12, 2010

Gearman provides a generic application framework to farm out work to other machines or processes that are better suited to do the work. It allows you to do work in parallel, to load balance processing, and to call functions between languages...(Read more)

Category:

Operating Systems > Linux > Installation

Tags:

debian gearman installation linux opensource pecl php ubuntu

Installing Gearman application framework on Debian Linux

Submitted by Shahryar on Saturday September 11, 2010

Gearman provides a generic application framework to farm out work to other machines or processes that are better suited to do the work. It allows you to do work in parallel, to load balance processing, and to call functions between languages...(Read more)

Category:

Operating Systems > Linux > Installation

Tags:

application debian framework gearman installation linux

MySQL table_cache, information_schema, and open files limit

Submitted by Shahryar on Tuesday September 07, 2010

Recently, on our production servers we started seeing strange behavior by MySQL server while running queries on information_schema. Before getting into the gory details, I'd first explain the environment then the problem and its solution...(Read more)

Category:

Database Management Systems > MySQL > Installation

Tags:

information_schema mysql performance slow tables table_cache

My list of important Linux commands

Submitted by Webmaster on Monday September 06, 2010

After working with Linux operating system for quite sometime now, I have compiled a list of some of the most useful commands to help perform the day-to-day administrative tasks...(Read more)

Category:

Operating Systems > Linux > Tools

Tags:

administration command filesystem linux os script unix

MySQL query to find all views in a database

Submitted by Shahryar on Sunday August 15, 2010

You might find it useful to list all the views/tables in a particular database. I am going to show you three different methods to get the lists using GUI and command line tools...(Read more)

Category:

Database Management Systems > MySQL > Tips and Tricks

Tags:

mysql mysql-administrator mysql-cli query sql

How to find all tables of a particular storage engine in MySQL?

Submitted by Shahryar on Sunday August 15, 2010

MySQL supports several storage engines with different features and functions. If you want to find out what tables are using a particular storage engine in MySQL then can run these simple queries in a MySQL command line interface...(Read more)

Category:

Database Management Systems > MySQL > Tips and Tricks

Tags:

database myisam mysql opensource storage-engine

How to check MySQL version number?

Submitted by Webmaster on Friday January 01, 2010

MySQL provides some features for particular version numbers and on particular platforms only. So, in some situations it gets really important to find the MySQL version number installed. If you are faced with such a problem you can use any of the following techniques to find MySQL version number...(Read more)

Category:

Database Management Systems > MySQL > Tips and Tricks

Tags:

check mysql tips tricks version

MySQL tables statistics (size, engine, no. of rows etc.)

Submitted by Shahryar on Tuesday October 27, 2009

MySQL provides statistical data for users to get more knowledge about the tables in databases. The command to get this useful information is "mysql table status"...(Read more)

Category:

Database Management Systems > MySQL > Administration

Tags:

database mysql size table table-status

Prev | 1 2 3 4 5 | Next