Organizational Research By

Surprising Reserch Topic questions - Question:MySQL Client Connection Has Delay When Connecting via SSL

0 down vote favorite

I am having a problem with various clients for MySQL where the speed for connecting to a database is dramatically lower than I'd like. Basically I have a Python script running MySQLdb that connects with cient SSL certificates then inserts one row into the database and quits. That being said, even the mysql command is experiencing this delay.

The problem is, it takes about 2.4 seconds to complete a single SSL connection. Normally I wouldn't care, but I have been reading posts by people saying that the addition of SSL should be negligible in terms of speed. If this is possible, I would definitely need it.

Server is running Solaris 10 on x86 using packages off of There are 2 relevant zones, one has MySQL server, the other is running the client. Connection is made over TCP.

MySQL client version:

    mysql Ver 14.14 Distrib 5.5.24, for solaris10 (i386) using readline 5.1

MySQL server version:

    mysqld Ver 5.5.27 for solaris10 on i386 (MySQL Community Server (GPL))

Two test GRANTs:

    mysql> GRANT SELECT ON wdia_user_scheduler.command TO 'jojo'@'l5-cisswdia.IRRELEVANT_REMOVED';

    Query OK, 0 rows affected (0.00 sec)


    Query OK, 0 rows affected (0.00 sec)

Two test connections using client software:

    bscable@l5-cisswdia:~/mysql$ time mysql -u jojo -h -e exit

    0.00s user 0.00s system 0% cpu 0.010 total

    bscable@l5-cisswdia:~/mysql$ time mysql -u jaja --ssl --ssl-key=ssl/bscable-key.pem --ssl-cert=ssl/bscable-cert.pem -h -e exit

    1.22s user 0.00s system 50% cpu 2.421 total

asked Sep 13, 2013 in Java Interview Questions by anonymous
edited Sep 12, 2013
0 votes

Related Hot Questions

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.