From 0732d32f508045da40fe9df607b9ef20ce2d198f Mon Sep 17 00:00:00 2001
From: xaver <xaver@ispconfig3>
Date: Tue, 06 Mar 2012 10:03:23 -0500
Subject: [PATCH] join fix - disappered in commit + Switch traffic joins, because its faster - Tested in a productive system (MySQL 5.1) as query few tausend domains 1-3 sec for Webtraffic sort, faster SQL = faster and MySQL 5.5 is much faster with joins (standard is not sorted with slow traffic querys) -> slowest part is coping the tables into temp -> more tweeks on cache... -> faster by heavy use

---
 helper_scripts/setup_in_openvz/diff_openssl.cnf |   50 +++++++++++++++++++++++++-------------------------
 1 files changed, 25 insertions(+), 25 deletions(-)

diff --git a/helper_scripts/setup_in_openvz/diff_openssl.cnf b/helper_scripts/setup_in_openvz/diff_openssl.cnf
index b1973a4..4a3c7e6 100644
--- a/helper_scripts/setup_in_openvz/diff_openssl.cnf
+++ b/helper_scripts/setup_in_openvz/diff_openssl.cnf
@@ -1,25 +1,25 @@
-# diff openssl.cnf /usr/lib/ssl/openssl.cnf
-68c68
-< default_days	= 3653			# how long to certify for
----
-> default_days	= 365			# how long to certify for
-125c125
-< countryName_default		= YOURCOUNTRY
----
-> countryName_default		= AU
-130c130
-< stateOrProvinceName_default	= YOURPROVINCE
----
-> stateOrProvinceName_default	= Some-State
-135c135
-< 0.organizationName_default	= YOURDOMAIN
----
-> 0.organizationName_default	= Internet Widgits Pty Ltd
-142c142
-< organizationalUnitName_default	= ISP
----
-> #organizationalUnitName_default	=
-145d144
-< commonName_default		= YOURHOSTNAME
-149d147
-< emailAddress_default		= postmaster@YOURDOMAIN
+# diff openssl.cnf /usr/lib/ssl/openssl.cnf
+68c68
+< default_days	= 3653			# how long to certify for
+---
+> default_days	= 365			# how long to certify for
+125c125
+< countryName_default		= YOURCOUNTRY
+---
+> countryName_default		= AU
+130c130
+< stateOrProvinceName_default	= YOURPROVINCE
+---
+> stateOrProvinceName_default	= Some-State
+135c135
+< 0.organizationName_default	= YOURDOMAIN
+---
+> 0.organizationName_default	= Internet Widgits Pty Ltd
+142c142
+< organizationalUnitName_default	= ISP
+---
+> #organizationalUnitName_default	=
+145d144
+< commonName_default		= YOURHOSTNAME
+149d147
+< emailAddress_default		= postmaster@YOURDOMAIN

--
Gitblit v1.9.1