categories
Database Management Systems
- MS SQL Server
- MySQL
- Oracle Berkeley DB
Libraries
- Apache Portable Runtime
- Apache Portable Runtime Utility
- Flex
- Freetds
- Libiconv
- Libmcrypt
- Libmhash
- Libpng
- Libxml
- Libxslt
- m4
- Neon (webdav)
- OpenSSL
- zLib
Miscellaneous
- Bison
- Byacc
- UML
- Varnish Cache
Operating Systems
- Linux
- MacOS X
- MS Windows
Servers
- Apache Web Server
- Internet Information Services
- Node.js
- vsftpd FTP Server
Tools
- Development
- Security
Web Development
- AJAX
- Dart
- Javascript
- PHP
- Python
tags cloud
Tutorials
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:
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:
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:
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:
MySQL GUI Tools - Query Browser
Submitted by Webmaster on Tuesday October 27, 2009
MySQL Query browser is a freely available client tool to run queries and commands on MySQL servers. It comes as part of the MySQL GUI tools package, which can be installed on several platforms...(Read more)
Category:
Database Management Systems > MySQL > Tools
Tags:
How to find MySQL server uptime?
Submitted by Webmaster on Friday September 25, 2009
Use mysqladmin utility to find MySQL server's uptime. Run the following command from command line...(Read more)
Category:
Database Management Systems > MySQL > Tips and Tricks
Tags:
Initializing MySQL database after installation
Submitted by Shahryar on Friday September 25, 2009
If you have an empty data folder or you want to initialize/reinitialize MySQL server from scratch (possibly after dropping all existing databases) then use these instructions...(Read more)
Category:
Database Management Systems > MySQL > Configuration
Tags:
Seeing indexes in a MySQL table
Submitted by Webmaster on Friday September 25, 2009
To show indexes on a MySQL table execute any of the commands mentioned in the tutorial in a MySQL client...(Read more)
Category:
Database Management Systems > MySQL > Administration
Tags:
MySQL Performance Optimization Part II
Submitted by Webmaster on Friday September 25, 2009
You can speed up index scans if you periodically perform a void ALTER TABLE operation, which causes MySQL to rebuild the table...(Read more)
Category:
Database Management Systems > MySQL > Administration
Tags:
MySQL Performance Optimization Part I
Submitted by Webmaster on Friday September 25, 2009
If you have deleted a large no. of records from a table or if you have made many changes to a table with variables length rows, you should run OPTIMIZE TABLE command...(Read more)
Category:
Database Management Systems > MySQL > Administration
