Features of Mysql running on Win32 platform

Win95 and Win95 lose about 200 bytes of memory for each thread creation. Therefore, if you have many connections, you should not run mysqld IN Win95 for a long time, because every connection of MySQL creates a new thread! WinNT and Win98 cannot tolerate this bug. Blockingread MySQL is used for each connection

Win95 and Win95 lose about 200 bytes of memory for each thread creation. Therefore, if you have many connections, you should not run mysqld IN Win95 for a long time, because every connection of MySQL creates a new thread! WinNT and Win98 cannot tolerate this bug. Blocking read MySQL is used for each connection

Win95 and thread

Win95 loses about 200 bytes of memory for each thread creation. Therefore, if you have many connections, you should not run them in Win95. mysqldFor a long time, because MySQLCreates a new thread for each connection! WinNT and Win98 cannot tolerate this bug.

Blocked read(Blocking read)

MySQLUse a blocking read for each connection, which means:

• A connection will be automatically disconnected after 8 hours, just likeMySQL.
• If a connection is suspendedMySQLIt cannot be broken.
• mysqladmin killIt will not work on a sleep connection.
• As long as there is a sleep connection，mysqladmin shutdownIt cannot be interrupted midway through.

We plan to revise it in the near future.

UDF

Temporarily MySQL-Win32 does not support user-defined functions.

DROP DATABASE

You cannot discard a database that is being used by some threads.

Kill from Task ManagerMySQL

On Windows 95, you cannot kill from the task manager or by using the shutdown utility. MySQL. You must use mysqladmin shutdownClose it.

Case Sensitive name

The file name is case-insensitive on Win32, so MySQLThe names of databases and tables are case-insensitive. The only restriction is that the names of databases and tables must be the same in the upper and lower case of a given statement, because it uses my_tableAnd MY_TABLEAll point to the same table sub-, the following queries will not work:

SELECT * FROM my_table WHERE MY_TABLE.col=1; 

"\"Directory characters

The path name on Win95 is composed "\"Separated by characters. MySQLIs also an escape character. If you are using LOAD DATA INFILEOr SELECT ... INTO OUTFILEYou must use two "\"Character or Unix-Style File Name "/"Character:

LOAD DATA INFILE "C:\\tmp\\skr.txt" INTO TABLE skr;SELECT * FROM skr INTO OUTFILE 'C:/tmp/skr.txt';

Can't open named pipeError

If you use MySQL-Win32 shared software version. If you use the latest mysql client, you will get the following error:

error 2017: can't open named pipe to host: . pipe...

This is because NTMySQLThe formal version uses Named Pipes by default. You can useMySQLCustomer use--host=localhostOption or create a file containing the following information"C: \ my. cnf"To avoid this error:

[client]host = localhost

Access denied for userError

When accessing MySQLIf you get Access denied for user: 'some-user@unknown' to database 'mysql'Which means MySQLYour host name cannot be correctly interpreted. To fix it, you should create a file "\ Windows \ hosts", With the following information:

127.0.0.1  localhost