 Find various MySql Coding related articles contributed by various user, to contribute you can become membor or send your article to publisher@tutorialsforu.info.
|
Connecting to MySQL database with C code MySQL databases may be used by programs written in the C programming language on Socrates and Plato and on the IS Solaris workstations. Full details of the C API (Application Program Interface) are given in the MySQL manual at http://www.mysql.com/doc/en/C.html.
|
|
Read more...
|
|
MySQL: The SHOW Commands MySQL users often wonder how to find out what their server is actually doing at any point in time—usually when things start to slow down or behave strangely. You can look at operating system statistics to figure out how busy the server is, but that really doesn't reveal much. Knowing that the CPU is at 100% utilization or that there's a lot of disk I/O occurring provides a high-level picture of what is going on, but MySQL can tell far more.
|
|
Read more...
|
|
Client/Server Communication in MySql : Packet Format In this chapter we will discuss the details of the client/server communication in MySQL. The goal is to give you the ability to look at a binary dump of the client/server communication and be able to understand what happened. This chapter can also be helpful if you are trying to write a MySQL proxy server, a security application to audit MySQL traffic on your network, or some other program that for some reason needs to understand the low-level details of the MySQL client/server protocol.
|
|
Read more...
|
|
Preparing the System to Run MySQL in a Debugger
To fully enjoy the study of MySQL internals, and to be able to execute the examples in the subsequent sections of this chapter, you must have gdb (http://www.gnu.org/software/gdb/) installed on your system, and be present in your PATH. You also need to have the X Window System, including a terminal program such as xterm. There are a number of X standard implementations, perhaps the most popular of them being X.org (http://www.x.org).
|
|
Read more...
|
|
Building MySql from Source Distribution Although it is preferred that you use the BitKeeper repository, in some cases it might be desirable for you to use another method to build MySQL. You can use the source distribution in such cases. Although in most of the situations you will need only gcc, gdb, and GNU make, there are times when other tools mentioned in the section “Preparing the System to Build MySQL from BitKeeper Tree” are necessary. For example, you will need Bison to change the parser, and adding another file to the source will require the use of autoconf, automake, and m4. Therefore, it is still recommended that you follow the same procedures outlined in that section to prepare your system to the fullest extent possible.
|
|
Read more...
|
|
|
|
MySql Coding 
