Failed to Load Data Using Sysbench 0.5

Symptom

When sysbench 0.5 is used to test the MySQL database, the following message is displayed during data loading:

FATAL: unable to connect to MySOL server, aborting...
FATAL: error 2026: SSL connection error: SSL_CTX_set_tmp_dh failed
FATAL: failed to execute  function prepare': /hpme/sysbench-0.5/sysbench/tests/db/common.lua: 103: Failed to connect to the database

Key Process and Cause Analysis

According to the error message, the cause is that the sysbench binary file does not match the versions of the libcrypto and libssl libraries.

Conclusion and Solution

Upgrade the libcrypto and libssl libraries to the latest versions and recompile sysbench on the local host.

Parent topic: MySQL