Comparison between Win32 and Unix MySQL

Source: Internet
Author: User
Tags mysql command line

MySQL-Win32 has proved its stability. This version of MySQL has the same features as the corresponding Unix version, except the following:
Win95 and thread
Win95 loses 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 uses one blocking read for each connection, which means that a connection will be automatically disconnected after 8 hours, it is like the Unix version of MySQL. If a connection is "suspended", MySQL cannot be broken if it is not killed. Mysqladmin kill will not work on a sleep connection. Mysqladmin shutdown cannot be interrupted as long as there is a sleep connection. We plan to revise it in the near future.
UDF
The temporary MySQL-Win32 does not support user-defined functions. Drop database you cannot discard a DATABASE that is being used by some threads. Kill MySQL from task manager on Windows 95. You cannot kill MySQL from Task Manager or by using the shutdown utility. You must use mysqladmin shutdown to close it. Names of case-sensitive names are case-insensitive on Win32. Therefore, names of MySQL Databases and tables on Win32 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 my_table and MY_TABLE both point to the same table sub, the following query will not work: SELECT * FROM my_table WHERE MY_TABLE.col = 1;
"\" Directory character
The pathnames on Win95 are separated by "\" characters, which are also escape characters in MySQL. If you are using load data infile or SELECT... into outfile, you must use two "\" characters or Unix-Style File Name "/" characters: load data infile "C: \ tmp \ skr.txt" into table skr; SELECT * FROM skr into outfile 'C:/tmp/skr.txt ';
Can't open named pipe Error
If you use the MySQL-Win32 sharing software version on NT, with the latest mysql client, you will get the following error: error 2017: can't open named pipe to host :. pipe... this is because the named pipe is used by default in the MySQL official version of NT. You can avoid this error by using the -- host = localhost option for new MySQL customers or creating a file "C: \ my. cnf" that contains the following information: [client] host = localhost
Access denied for user error
If you get an Access denied for user: 'Some-user @ unknown 'to database 'mysql' error when accessing a MySQL server on the same machine, this means that MySQL cannot correctly interpret your host name. To fix this problem, you should create a file "\ windows \ hosts" with the following information: 127.0.0.1 localhost for anyone who may want to help us prepare the Win32 version, there are some open questions: create a single user MYSQL. DLL server. This should include everything on a standard MySQL server, except thread creation. This makes MySQL easier to use when it does not need a real client/server or applications that do not need to access the server from other hosts. Add some nice "start" and "shutdown" icons for MySQL installation. Create a tool for MySQL startup options to manage registry entries. The missing degree of the registry entry has been encoded into mysqld. cc, but it should be re-encoded and more oriented to "Parameters". This tool should also be able to update "\ my. cnf file, if you prefer to use it instead of the Registry. When you use -- install to register mysqld as a service on NT), if you can add the default option on the command line, it will be better. The current solution is to update "C: \ my. cnf file. When you suspend a laptop running Win95 and the laptop is restored, the mysqld daemon does not accept new connections. We do not know whether this is a problem with Win95, TCP/IP, or MySQL. Killing mysqld from the task manager is definitely a good thing. Currently, you must use mysqladmin shutdown. Port readline used in mysql command line tool to Win32. The standard GUI version of MySQL (mysql, mysqlshow, mysqladmin, and mysqldump) will be better. It would be better if the socket "read" and "write" functions in "net. c" could be interrupted. This will possibly kill the opened thread with mysqladmin kill on Win32. Create a document about which Windows programs can work in MySQL-Win32/MyODBC and what must be done in order to make them work. Mysqld is always started at "C" instead of the default location. We want mysqld to use the current location for sorting order. Port sqlclient to Win32 (almost complete) and add more features! Add more options to Mysql Manager. Change the communication protocol between the server and the customer, and use Windows internal communication instead of socket and TCP/IP. Use. DLL to implement UDF. Add macros to use the faster increase/decrease method for thread security provided by Win32. Other Win32-specific issues are described in the README file distributed by the MySQL-Win32.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.