mysql

How to enable mysql 5 compatibility mode

Submitted by CoolGoose on

You can retrieve the current global or session sql_mode value with the following statements:

SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;

And set it with :
Replace in my.ini the current sql-mode line with sql-mode="MYSQL40"
Start MySQL with the option --sql-mode="MYSQL40"
Execute the query SET GLOBAL sql_mode='MYSQL40'

Technology: 

Web optimizations - cluster solution needed?

Submitted by johnny on

Ok, this is a very wide topic but I will try to touch some corners in the event somebody will need such ideas. This will be a series of articles that I will write as time permits.

What will be covered in these series:

- what is a cluster? http://www.at-byte.com/technology/web-optimizations-part-1-what-cluster
- why would i need a cluster? http://www.at-byte.com/technology/web-optimizations-part-2-why-would-i-n...
- web server optimizations

Technology: 

Subscribe to mysql