Logged in as: Guest | Login/Register
 
 
Prev | 1 | Next
 

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

Added by Webmaster on Tuesday October 27, 2009 Discuss it| Favorite it
 
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"... (more)
 
Category: Tutorials > Database Management Systems > MySQL > Administration
Keywords: mysql, database, table, table-status, size
 

MySQL GUI Tools - Query Browser

Added by Webmaster on Tuesday October 27, 2009 Discuss it| Favorite it
 
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... (more)
 
Category: Tutorials > Database Management Systems > MySQL > Tools
Keywords: tools, mysql, database, gui, client, query-browser
 

How to find MySQL server uptime

Added by Webmaster on Friday September 25, 2009 Discuss it| Favorite it
 
Use mysqladmin utility to find MySQL server's uptime. Run the following command from command line... (more)
 
Category: Tutorials > Database Management Systems > MySQL > Tips And Tricks
Keywords: mysql, database, server, uptime, mysqladmin
 

Initializing MySQL database after installation

Added by Webmaster on Friday September 25, 2009 Discuss it| Favorite it
 
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... (more)
 
Category: Tutorials > Database Management Systems > MySQL > Configuration
Keywords: mysql, database, initialization, setup, configuration
 

Seeing indexes in a MySQL table

Added by Webmaster on Friday September 25, 2009 Discuss it| Favorite it
 
To show indexes on a MySQL table execute any of the commands mentioned in the tutorial in a MySQL client... (more)
 
Category: Tutorials > Database Management Systems > MySQL > Administration
Keywords: mysql, database, optimization, keys, index
 

MySQL Performance Optimization Part II

Added by Webmaster on Friday September 25, 2009 Discuss it| Favorite it
 
You can speed up index scans if you periodically perform a void ALTER TABLE operation, which causes MySQL to rebuild the table... (more)
 
Category: Tutorials > Database Management Systems > MySQL > Administration
Keywords: mysql, performance, optimization, optimize
 

MySQL Performance Optimization Part I

Added by Webmaster on Friday September 25, 2009 Discuss it| Favorite it
 
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... (more)
 
Category: Tutorials > Database Management Systems > MySQL > Administration
Keywords: mysql, performance, optimization, optimize
 

SQL: Union and Union All

Added by Webmaster on Friday September 25, 2009 Discuss it| Favorite it
 
UNION is used to combine the result from multiple SELECT statements into a single result set. By default, when it is applied to more than one queries, returns unique result sets only. UNION ALL on the other hand returns all rows in the result sets... (more)
 
Category: Tutorials > Database Management Systems > MySQL > Tips And Tricks
Keywords: mysql, database, sql-server, oracle, union, union-all
 

Microsoft Windows IIS FTP Part 3 - The Doorway Folder Trick

Added by Sarbjit Singh Gill on Friday February 06, 2009 Discuss it| Favorite it
 
Objective: To create a customized login with access to some of the folders in a site. In the previous two parts we learned how to leverage virtual directories and physical folders to offer a lot of control from IIS FTP. Now, what about when we want to have one site administrator have access to more than one, but not all, of the directories in a site? How is this accomplished from within IIS FT.. (more)
 
Category: Tutorials > Servers > Internet Information Services > Administration
Keywords: microsoft, administration, iis, ftp
 

Microsoft Windows IIS FTP Part 2 - Directories Virtual/Physical

Added by Sarbjit Singh Gill on Friday February 06, 2009 Discuss it| Favorite it
 
In previous section, we discussed the ways to use the hidden power of Microsoft's FTP server product. We talked about ways to leverage virtual directories along with Windows user accounts... (more)
 
Category: Tutorials > Servers > Internet Information Services > Administration
Keywords: microsoft, administration, iis, ftp
 

Linux kernel data structures (Part 1) - the current macro

Added by Shahryar Ghazi on Thursday January 29, 2009 Discuss it| Favorite it
 
The Linux kernel uses this macro to find the current process. The current macro is defined in include/asm-i386/current.h (line 13) in both 2.6.0 and 2.4.18 kernels. This macro calls another function get_current()... (more)
 
Category: Tutorials > Operating Systems > Linux > Tips And Tricks
Keywords: linux, kernel, linux-kernel, current, macro, data-structures
 

Some Tricks used by the Linux kernel

Added by Shahryar Ghazi on Thursday January 29, 2009 Discuss it| Favorite it
 
Linux kernel uses a number of advanced keywords, macros, and extensions to C language. Here is a description of some of these keywords, macros and extensions that I found troublesome to understand and had to investigate a little bit in order to understand them. I have used kernel versions 2.4.18 or 2.6.0 for this tutorial... (more)
 
Category: Tutorials > Operating Systems > Linux > Tips And Tricks
Keywords: linux, opensource, tricks, code, linux-kernel
 
Click here for more tutorials.
 
 
Tutorial Categories
Operating Systems
Database Management Systems
Web Development
Servers
Tools
Libraries
Miscellaneous

Popular Keywords:

linux(18)  mysql(12)  library(11)  php(9)  database(8)  javascript(8)  administration(5)  tools(4)  windows(4)  security(4)  macosx(3)  debian(3)  microsoft(3)  development(3)  optimization(3)  
Creative Commons License