This is a code example of this command:
SET_DATABASE_PORT OF MYSQL TO PORT
(more…)
Posts Tagged ‘Tuning’
Using Multiple MySQL Ports in the Same Application
Monday, February 25th, 2008Issues With Oracle’s Recyclebin
Sunday, February 24th, 2008Oracle introduced since 10g a new feature the Database Recyclebin, which as a Operative System recyclebin brings the ability to restore tables (files in OS) that are dropped (deleted).
Configuring PostgreSQL
Sunday, February 24th, 2008The Windows parameters for configuring PostgreSQL server are located in two configuration files. A few parameters in these files have to be adjusted before the server can be used in production. Pg_hba.conf a.k.a. PostgreSQL Client Authentication Configuration File The purpose for this file is to identify all of the machines that are able to access PostgreSQL remotely. This is a direct quote from the comments section of the file. “If you want to allow non-local connections, you need to add more “host” records. Also, remember TCP/IP connections are only enabled if you enable “tcpip_socket” in postgresql.conf.” 47. The arguments required are: (more…)
Using INNODB in MySQL
Sunday, February 24th, 2008While configuring MySQL for using innodb table handler, the following settings (in the my.ini file) have impact on performance:
(more…)