A Problem of Accessing MySQL via JDBC using Pipe
Posted by: pamire un
Date: April 17, 2018 07:39PM

1. Whether JDBC can access MySQL using pipe under Linux
2. I tested retrieving 5 million rows of data under win10 using the same Java code in different URLs, the result is named pipe is 30-50% slower than tcp. The document says it is related with the system configuration. So I want to know the specific configurations that could affect the result and how?
3. How do the values of socketFactory - com.mysql.jdbc.NamedPipeSocketFactory and com.mysql.jdbc.StandardSocketFactory – in jdbc url work? And how would they affect the retrieval efficiency?

Options: ReplyQuote

Written By
A Problem of Accessing MySQL via JDBC using Pipe
April 17, 2018 07:39PM

