Setting up a new server for vB.
Any recommendations re: using the mySQL Config Wizard on Win2003?
Six questions come to mind:
1 - Server Type: since mySQL is being set up to run off the second (dedicated) drive, should I select "dedicated" or should I stick with "Server machine"?
Computer Bookshelf: installing PHP, Apache & MySQL::
The MySQL Server Instance Configuration Wizard leads you through all the settings that used to have to be done by hand. In virtually every case,
http://computerbookshelf.com/phpdw/install5.phpHOME |
2 - Database Usage: Is VB considered a "multifunction" database or a "transaction" database?
3 - Should I use InnoDB or MyISAM?
4 - Concurrent connections: although our peak activity was 1225 people online (15 min window) a more typical target is 600 users. How many "concurrent connections" does this equate to?
5 - Networking Options: do I connect via TCP/IP or a named pipe?
6 - The Wizard recommends setting a 'root' password. Is this the $dbpassword specified in config.php?
================================
Installing PHP 5.2.3, MySQL 5.0.5, and IIS 6.0! We provide Custom ::
We do PHP development, MySQL Database design, IIS Congifuration. it was installed to go into the "MySQL Server Instance Configuration Wizard" and click
http://www.atksolutions.com/articles/install_php_mysql_iis.htmlHOME |
Using MySQL::
This chapter describes the steps necessary to use a MySQL 5.0 database with WebLogic To perform the remaining steps using the Configuration Wizard,
http://download.oracle.com/docs/cd/E13155_01/wlp/docs103/db/mySQL.htmlHOME |
Our site:
600,000 posts
800,000 searches
23,000 members
40,000 threads
New server:
Win 2003
2.8 GHz x 2 (Intel)
4 GB RAM
73 GB SCSI x2 (non-RAID)
Activity:
1,225 peak visitors (15 min window)
300-600 more typical
5 - Networking Options: do I connect via TCP/IP or a named pipe?Using named pipes in a Windows environment is apparently bad. Per the MySQL manual:
http://dev.mysql.com/doc/mysql/en/windows-vs-unix.html
Blocking read
MySQL uses a blocking read for each connection, which has the following implications if named pipe connections are enabled:
A connection is not disconnected automatically after eight hours, as happens with the Unix version of MySQL.
If a connection hangs, it's impossible to break it without killing MySQL.
mysqladmin kill does not work on a sleeping connection.
mysqladmin shutdown can't abort as long as there are sleeping connections.
We plan to fix this problem when our Windows developers have figured out a nice workaround.
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market
|
mysql Instance Configuration Wizard