Page History
Scrollbar | ||
---|---|---|
|
...
Page info | ||||
---|---|---|---|---|
|
Panel | ||||
---|---|---|---|---|
| ||||
|
MySQL Properties Settings
These properties are usually located in the file {MYSQL_HOME}/my.ini
.
Property Name | Description |
---|---|
| Flush the transaction logs at each commit. |
| Additional memory pool that is used by InnoDB to store metadata information. |
| Buffer pool used to cache both indexes and row data. |
| Maximum size for internal (in-memory) temporary tables. |
| Query cache is used to cache SELECT results and later return them without actually executing the same query once again. |
| This buffer is allocated when MySQL needs to rebuild the index in REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE into an empty table. |
MySQL Properties Guide
There are some commands that we have found useful in the MySQL environment. You can investigate this database software more at the MySQL web site.
...
If you have root or administrator access to your server you can change the password for the root
user ID if you have forgotten or lost it.
mysqladmin -u root password {mypassword
}
...wheremypassword
is your new passwordInfo title Note MySQL can be passed a JDBC option for the Windows local environment that may improve perfomance 30 to 50%.
...
This uses Windows Named Pipe function and avoids use of the TCP/IP protocol. It only works when connecting with a local iteration of the MySQL database on Windows.
...
Scrollbar | ||
---|---|---|
|