Correct MySQL kernel compilation procedure

Compiling the MySQL kernel is often used. The following articles mainly introduce the correct method for compiling the MySQL kernel. If you are curious about compiling the MySQL kernel technology, the following articles will unveil its mysteries. I hope it will help you in this regard.

Keywords: MySQL kernel Database Security Configuration User Authentication Module password restoration Stored Procedure writing database index

Summary:

In the latest version, a set of code is used in windows and linux. This article takes the mysql-5.1.7 as the analysis object, explains in detail the method of compiling MySQL kernel.

In the latest version, a set of code is used in windows and linux. For example, the description of the INSTALL-WIN-SOURCE file in the mysql-6.0.4-alpha version:

 
 

  
  
TobuildMySQLonWindowsfromsource,youmustsatisfythe  
  
  
followingsystem,compiler,andresourcerequirements:  
  
  
*Windows2000,WindowsXP,ornewerversion.WindowsVistais  
  
  
notsupporteduntilMicrosoftcertifiesVisualStudio2005on  
  
  
Vista.  
  
  
*CMake,whichcanbedownloadedfromhttp://www.cmake.org.  
  
  
Afterinstalling,modifyyourpathtoincludethecmake  
  
  
binary.  
  
  
*MicrosoftVisualC++2005ExpressEdition,VisualStudio.Net  
  
  
2003(7.1),orVisualStudio2005(8.0)compilersystem.  
  
  
*IfyouareusingVisualC++2005ExpressEdition,youmust  
  
  
alsoinstallanappropriatePlatformSDK.Moreinformationand  
  
  
linkstodownloadsforvariousWindowsplatformsisavailable  
  
  
fromhttp://msdn.microsoft.com/platformsdk/.  
  
  
*IfyouarecompilingfromaBitKeepertreeormakingchanges  
  
  
totheparser,youneedbisonforWindows,whichcanbe  
  
  
downloadedfrom  
  
  
http://gnuwin32.sourceforge.net/packages/bison.htm.Download  
  
  
thepackagelabeled"Completepackage,excludingsources".  
  
  
Afterinstallingthepackage,modifyyourpathtoincludethe  
  
  
bisonbinaryandensurethatthisbinaryisaccessiblefrom  
  
  
VisualStudio.  
  
  
*Cygwinmightbenecessaryifyouwanttorunthetestscript  
  
  
orpackagethecompiledbinariesandsupportfilesintoaZip  
  
  
archive.(Cygwinisneededonlytotestorpackagethe  
  
  
distribution,nottobuildit.)Cygwinisavailablefrom  
  
  
http://cygwin.com.  
  
  
*3GBto5GBofdiskspace. 
 
 

In this way, the project file can be generated and compiled using the vs tool. .

For details about how to compile the MySQL kernel, I chose 5.1.7 as the analysis object.

Steps for installing the Code:

1.decompress the package mysql-5.1.7-beta-win-src.zip.

2. Use vs2003 to open the project file mysql. sln.

3. Set the mysqld project as the startup project.

4. On the properties page of mysqld, set the command parameter to -- console. In this way, you can debug the code in debug mode.

Configure Command Parameters

5. set breakpoints. For example, the total query entry is the handle_select function.

6.compile the mysqlproject and generate mysql.exe in the mysql-5.1.7-betaclient_debugdirectory.

7. Use "Start new instance" or "go to single step to execute new instance" for debugging.

Perform debugging

8. mysql-5.1.7-betaclient_debugdirectory to generate mysql.exe. The execution statement will be executed at the breakpoint for debugging.

Enter the debugging status

9. For the corresponding data file, see the mysql-5.1.7-betadata directory.

The above content describes how to compile the MySQL kernel in detail, hoping to help you in this regard.