Mysql is larger than wamp

MySQLwamp

Wamp which includes mysql,php,apache is only 24.7 MB but the only Mysql is 207 MB here.Why?

Best Answer

In a WAMP environment, a developer is probably more focused on

Coping PHP/Perl/Python
Configuring Apache to get the WebServer going
Using MySQL to store data, far less concern for the MySQL Utilities and other Bells and Whistles
Getting Windows to coordinate the use of Apache, PHP, and MySQL (If you use IIS instead of Apache, that means the environment is a WIMP).

WAMP/LAMP environments was set up with this mind. MySQL would come with the bare essentials for installing MySQL and storing and backing up data. Such bare essential utilities may include:

mysql : Command-Line Client Program
mysqldump : For taking Textual Backups

MySQL comes with utilities for doing

Replication
Table Repair
Load Testing (such as mysqlslap)
Reporting on Stats
things like these (See all the Major Utilities for MySQL)

If a serious Developer wants to be just as serious at prepping and optimizing the database as a Developer/DBA, then MySQL has everything a DBA could want in that bigger download. Downloading both would be just fine in that instance.

my_huge.ini

does not have max_connections set
has innodb settings commented out
values preset
- sort_buffer_size = 2M
- read_buffer_size = 2M
- read_rnd_buffer_size = 8M
- myisam_sort_buffer_size = 64M

my-innodb-heavy-4G.ini

has max_connections set at 100
has innodb settings enabled
values preset
- max_allowed_packet = 16M
- binlog_cache_size = 1M
- max_heap_table_size = 64M
- read_buffer_size = 2M
- read_rnd_buffer_size = 16M
- sort_buffer_size = 8M
- join_buffer_size = 8M
- thread_cache_size = 8
- thread_concurrency = 8
- query_cache_size = 64M
- query_cache_limit = 2M

Default values are used if not specified. Whichever one you want to use, you must copy it over my.ini and restart mysqld to take effect.

If using my-huge.ini, you must shutdown mysqld, copy my-innodb-heavy-4G.ini to my.ini then startup mysqld.
If using my-innodb-heavy-4G.ini, you must shutdown mysqld, delete the innodb log files (ib_logfile0,ib_logfile1), copy my-innodb-heavy-4G.ini to my.ini then startup mysqld.

Since you said the number of DB Connections is expected to grow, you must raise max_connections to higher values but you must balance the usage of RAM. The best way to balance it would to run some diagnostic program like mysqltuner.pl and get recommendations adjusting settings per connection and per instance.

Since you are running MySQL in a WAMP environment, I would not surpass 25% of RAM for total memory because you must give Windows, Apache, and PHP (or Perl or Python) their due in terms of RAM. (I am glad you are using Apache and not IIS, otherwise this would be a WIMP environment !!!)

Mysql – microsoft webmatrix deleted the wamp databases

Here is the only thing I can advise for now:

Open a DOS Window and run the following

C:\> dir mysql.user /s

If you see two mysql.user files, then you may have two DB setups.

You would just have to point datadir in my.cnf back to the old setup.

Please find out and let me know ...

Best Answer

Related Solutions

Mysql – WAMP server performance tuning for MySQL

my_huge.ini

my-innodb-heavy-4G.ini

Mysql – microsoft webmatrix deleted the wamp databases

Related Question