Introduction to MySQL on Windows
Short Description
MySQL is an open source relational database management system which is quite popular for light-weight web applications. Over the last few years, the product has also added some features which allow it to be used for larger business tools. This paper will provide an overview of this software on Windows. MySQL does not have as many features as PostgreSQL, and while many of the more advanced features are not as mature. However one would expect it to perform substantially better than PostgreSQL on Windows because of its thread-based architecture (PostgreSQL uses a process-based architecture instead).
Website: port25.technet.com | Filesize: 350kb
No of Page(s): 11
Content
…
Planning
- The typical install of MySQL 5.0 on Windows takes about 90MB plus space for data
+ Approximately 60MB for the software
+ Approximately 30MB for the database skeleton
- The software is installed t+ C:Program FilesMySQL by default
- The data files are installed at C:Program FilesMySQLMySQL Server 5.0data by default. This can be changed using the Server Configuration Wizard (see below).
- The amount of space required t+ store a given amount of data depends on the table type used and other factors. InnoDB uses the most storage while archive uses the least.
General guidelines for storage capacity planning are difficult t+ arrive at because they are dependant on the storage engine used and, in some cases, on the level of concurrency expected in the application.
…
Get the file Download here
Related Searches: relational database management, relational database management system, database management system, storage engine, configuration wizard
Comments
Leave a Reply
