Feature #17957

Improve database performance for external database host

Added by Dmitry Dulepov over 14 years ago. Updated almost 12 years ago.

Status:
Closed
Priority:
Should have
Category:
-
Target version:
-
Start date:
2007-12-29
Due date:
% Done:

0%

Estimated time:
PHP Version:
5.0
Tags:
Complexity:
Sprint Focus:

Description

According to [1] MySQL performance may be greatly improved by using compression if MySQL is on the external host and connection link speed is less than 1Gbps. Attached patch adds an option to TYPO3 to enable compression and modifies database layer to use it for external database hosts.

[1] http://www.mysqlperformanceblog.com/2007/12/20/large-result-sets-vs-compression-protocol/

(issue imported from #M7059)


Files

mysql_ext_db_perf.patch (4.45 KB) mysql_ext_db_perf.patch Administrator Admin, 2007-12-29 11:57
7059.diff (4.39 KB) 7059.diff Administrator Admin, 2008-10-03 11:06

Related issues

Related to TYPO3 Core - Bug #23066: mysql_pconnect() has too many parametersRejectedSteffen Gebert2010-07-01

Actions
Related to TYPO3 Core - Bug #23346: dbClientCompress crashes with pconnectClosedOliver Hader2010-08-04

Actions
#1

Updated by Dmitry Dulepov over 13 years ago

rev 4279

Also available in: Atom PDF