并发思考-actor和thread那个好点?

实验课题:测试actor和thread那个好?

实验方法:利用数据库连接池创建连接,交由线程去工作,在回收,看看程序运行状况。

实验步骤:

1.创建数据连接工具类:

import java.sql.{Connection, DriverManager}
import java.util.concurrent.LinkedBlockingQueue

import com.scala.spark.commen.util.StreamingConfigure


object DBUtil{
  private val dbConnectionPool = new LinkedBlockingQueue[Connection]()
  private var current_num = 0 //当前连接数


  private def before(){
    if (current_num > StreamingConfigure.executor_max_mysql_connection.toInt && dbConnectionPool.isEmpty()) {
      print("""
              |☆☆☆■■■■■■☆☆☆☆☆☆☆■■■■■■■
            """.stripMargin)
      Thread.sleep(2000)
      before()
    }else{
      Class.forName(StreamingConfigure.driver)
    }
  }

  private def initConn(): Connection = {
    val conn = DriverManager.getConnection(StreamingConfigure.url, StreamingConfigure.username, StreamingConfigure.password)
    conn
  }

  private def initConnectionPool(): LinkedBlockingQueue[Connection] = {
    AnyRef.synchronized({
      if (dbConnectionPool.isEmpty()) {
        before()
        for (i <- 1 to StreamingConfigure.executor_num_mysql_connection.toInt) {
          dbConnectionPool.put(initConn)
          current_num += 1
        }
      }
      dbConnectionPool
    })
  }

  def getInstance():Connection={
    var conn = dbConnectionPool.poll()
    if(conn==null){
      initConnectionPool()
      conn = dbConnectionPool.poll()
    }
    return conn
  }

  def releaseCon(con:Connection){
    dbConnectionPool.put(con)
  }

  def get_current_num()={
    current_num
  }
}

 2.创建thread访问数据库连接池

object DBUtilTest extends App{
for (i <- 1 to 10000){
ConnThread(i).start()
}
}

case class ConnThread(name:Int) extends Thread{
override def run(): Unit = {
val conn = DBUtil.getInstance()
DBUtil.releaseCon(conn)
println(s"$conn conn is $name,current_num is ${DBUtil.get_current_num()}")
}
}

 3.创建Actor访问数据连接池

class DBActor extends Actor{
  var count  = 0
  override def receive: Receive = {
    case "create" =>
      val conn = DBUtil.getInstance()
      count += 1
      println(s"$conn conn is $count")
      DBUtil.releaseCon(conn)
  }
}

object AkkaClient extends App{

  val system = ActorSystem("DBUtil")

  val dBActor = system.actorOf(Props[DBActor],"dBActor")

  for (i <- 1 to 10000) dBActor ! "create"

  println(">>> Press ENTER to exit <<<")
  try StdIn.readLine()
  finally system.terminate()
}

实验结果:运行两种访问,查看结果。

thread


objc[10258]: Class JavaLaunchHelper is implemented in both /Library/Java/JavaVirtualMachines/jdk1.8.0_121.jdk/Contents/Home/bin/java (0x10782a4c0) and /Library/Java/JavaVirtualMachines/jdk1.8.0_121.jdk/Contents/Home/jre/lib/libinstrument.dylib (0x1079044e0). One of the two will be used. Which one is undefined.
Sun Feb 04 22:32:06 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2291,current_num is 1
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2280,current_num is 1
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2295,current_num is 1
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2293,current_num is 1
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2299,current_num is 2
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2287,current_num is 1
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2286,current_num is 1
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2298,current_num is 2
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2292,current_num is 1
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2289,current_num is 1
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2300,current_num is 2
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2301,current_num is 2
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2302,current_num is 2
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2290,current_num is 1
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2297,current_num is 2
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2303,current_num is 2
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2283,current_num is 1
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2304,current_num is 2
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2296,current_num is 2
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2281,current_num is 1
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2288,current_num is 1
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2284,current_num is 1
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2305,current_num is 2
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2294,current_num is 1
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2282,current_num is 1
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2285,current_num is 1
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2306,current_num is 2
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2307,current_num is 2
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2308,current_num is 2
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2309,current_num is 2
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2310,current_num is 2
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2311,current_num is 2
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2312,current_num is 2
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2313,current_num is 3
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2314,current_num is 3
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2315,current_num is 3
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2316,current_num is 3
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2317,current_num is 3
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2318,current_num is 3
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2319,current_num is 3
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2320,current_num is 3
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2321,current_num is 3
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2322,current_num is 3
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2323,current_num is 3
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2324,current_num is 4
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2325,current_num is 4
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2326,current_num is 4
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2327,current_num is 4
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2328,current_num is 4
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2329,current_num is 4
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2330,current_num is 4
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2331,current_num is 4
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2332,current_num is 4
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2333,current_num is 5
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2334,current_num is 5
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2335,current_num is 5
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2336,current_num is 5
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2337,current_num is 5
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2338,current_num is 5
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2339,current_num is 5
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2340,current_num is 5
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2341,current_num is 5
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2342,current_num is 5
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2343,current_num is 5
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2344,current_num is 5
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2345,current_num is 5
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2346,current_num is 5
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2347,current_num is 5
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2348,current_num is 5
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2349,current_num is 5
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2350,current_num is 5
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2351,current_num is 5
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2352,current_num is 5
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2353,current_num is 6
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2354,current_num is 6
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2355,current_num is 6
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2356,current_num is 6
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2357,current_num is 6
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2358,current_num is 6
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2359,current_num is 6
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2360,current_num is 6
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2361,current_num is 6
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2362,current_num is 7
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2363,current_num is 7
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2364,current_num is 7
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2365,current_num is 7
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2366,current_num is 7
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2367,current_num is 7
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2368,current_num is 7
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2369,current_num is 7
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2370,current_num is 7
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2371,current_num is 7
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2372,current_num is 7
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2373,current_num is 8
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2374,current_num is 8
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2375,current_num is 8
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2376,current_num is 8
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2377,current_num is 8
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2378,current_num is 8
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2379,current_num is 8
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2380,current_num is 8
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2381,current_num is 8
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2382,current_num is 9
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2383,current_num is 9
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2385,current_num is 9
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2384,current_num is 9
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2386,current_num is 9
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2388,current_num is 9
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2387,current_num is 9
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2389,current_num is 9
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2390,current_num is 9
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2391,current_num is 10
com.mysql.jdbc.JDBC4Connection@36039ec conn is 1,current_num is 10
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2279,current_num is 10
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2392,current_num is 10
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2278,current_num is 10
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2277,current_num is 10
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2276,current_num is 10
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2275,current_num is 10
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2393,current_num is 10
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2274,current_num is 10
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2273,current_num is 10
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2272,current_num is 10
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2271,current_num is 10
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2394,current_num is 10
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2269,current_num is 10
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2270,current_num is 10
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2395,current_num is 10
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2267,current_num is 10
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2266,current_num is 10
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2268,current_num is 10
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2396,current_num is 10
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2265,current_num is 10
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2264,current_num is 10
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2397,current_num is 10
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2263,current_num is 10
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2262,current_num is 10
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2261,current_num is 10
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2398,current_num is 10
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2260,current_num is 10
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2399,current_num is 10
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2259,current_num is 10
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2258,current_num is 10
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2256,current_num is 10
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2257,current_num is 10
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2255,current_num is 10
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2400,current_num is 10
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2254,current_num is 10
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2401,current_num is 10
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2253,current_num is 10
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2252,current_num is 10
com.mysql.jdbc.JDBC4Connection@18540478 conn is 21,current_num is 10
Exception in thread "Thread-2243" java.lang.NullPointerException
at java.util.concurrent.LinkedBlockingQueue.put(LinkedBlockingQueue.java:332)
at com.scala.spark.commen.pool.DBUtil$.releaseCon(DBUtil.scala:54)
at com.scala.spark.commen.pool.ConnThread.run(DBUtilTest.scala:15)
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2251,current_num is 10
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2245,current_num is 10
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2246,current_num is 10
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2247,current_num is 10
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2404,current_num is 10
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2249,current_num is 10
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2248,current_num is 10
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2250,current_num is 10
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2403,current_num is 10
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2402,current_num is 10
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2419,current_num is 10
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2420,current_num is 11
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2421,current_num is 11
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2422,current_num is 11
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2423,current_num is 11
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2424,current_num is 11
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2425,current_num is 11
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2426,current_num is 11
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2427,current_num is 11
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2428,current_num is 11
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2429,current_num is 11
com.mysql.jdbc.JDBC4Connection@27d1933f conn is 2430,current_num is 11
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2431,current_num is 12
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2432,current_num is 12
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2433,current_num is 12
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2434,current_num is 12
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2418,current_num is 12
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2435,current_num is 12
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2436,current_num is 12
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2437,current_num is 13
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2438,current_num is 13
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2439,current_num is 13
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@27d1933f conn is 2440,current_num is 13
com.mysql.jdbc.JDBC4Connection@1edcf564 conn is 2441,current_num is 13
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2442,current_num is 13
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2443,current_num is 13
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2444,current_num is 14
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2445,current_num is 14
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2446,current_num is 14
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2447,current_num is 14
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2448,current_num is 14
com.mysql.jdbc.JDBC4Connection@43b65c0c conn is 2449,current_num is 14
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2450,current_num is 15
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2451,current_num is 15
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2452,current_num is 15
com.mysql.jdbc.JDBC4Connection@27d1933f conn is 2453,current_num is 15
com.mysql.jdbc.JDBC4Connection@1edcf564 conn is 2454,current_num is 15
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2455,current_num is 15
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2456,current_num is 15
com.mysql.jdbc.JDBC4Connection@58010e0b conn is 2457,current_num is 15
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2458,current_num is 15
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2459,current_num is 15
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2460,current_num is 15
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2461,current_num is 15
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2462,current_num is 15
com.mysql.jdbc.JDBC4Connection@43b65c0c conn is 2463,current_num is 15
com.mysql.jdbc.JDBC4Connection@12266960 conn is 2464,current_num is 15
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2465,current_num is 15
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2466,current_num is 15
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2467,current_num is 15
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@27d1933f conn is 2468,current_num is 15
com.mysql.jdbc.JDBC4Connection@1edcf564 conn is 2469,current_num is 15
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2470,current_num is 15
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2471,current_num is 15
com.mysql.jdbc.JDBC4Connection@58010e0b conn is 2472,current_num is 15
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2473,current_num is 16
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2474,current_num is 16
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2475,current_num is 16
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2476,current_num is 16
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2477,current_num is 16
com.mysql.jdbc.JDBC4Connection@43b65c0c conn is 2478,current_num is 16
com.mysql.jdbc.JDBC4Connection@12266960 conn is 2479,current_num is 16
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2480,current_num is 17
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2481,current_num is 17
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2482,current_num is 17
com.mysql.jdbc.JDBC4Connection@27d1933f conn is 2483,current_num is 17
com.mysql.jdbc.JDBC4Connection@1edcf564 conn is 2484,current_num is 17
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2485,current_num is 17
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2486,current_num is 17
com.mysql.jdbc.JDBC4Connection@58010e0b conn is 2487,current_num is 17
com.mysql.jdbc.JDBC4Connection@4c1a4732 conn is 2488,current_num is 17
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2489,current_num is 17
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2490,current_num is 17
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2491,current_num is 17
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2492,current_num is 17
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2493,current_num is 17
com.mysql.jdbc.JDBC4Connection@43b65c0c conn is 2494,current_num is 17
com.mysql.jdbc.JDBC4Connection@12266960 conn is 2495,current_num is 18
com.mysql.jdbc.JDBC4Connection@28cef164 conn is 2496,current_num is 18
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2497,current_num is 18
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2498,current_num is 18
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2499,current_num is 18
com.mysql.jdbc.JDBC4Connection@27d1933f conn is 2500,current_num is 18
com.mysql.jdbc.JDBC4Connection@1edcf564 conn is 2501,current_num is 19
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2502,current_num is 19
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2503,current_num is 19
com.mysql.jdbc.JDBC4Connection@58010e0b conn is 2504,current_num is 19
com.mysql.jdbc.JDBC4Connection@4c1a4732 conn is 2505,current_num is 19
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2506,current_num is 19
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2405,current_num is 20
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2243,current_num is 20
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2242,current_num is 20
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2241,current_num is 20
com.mysql.jdbc.JDBC4Connection@43b65c0c conn is 2240,current_num is 20
com.mysql.jdbc.JDBC4Connection@6c8a3ac2 conn is 2239,current_num is 20
com.mysql.jdbc.JDBC4Connection@12266960 conn is 2238,current_num is 20
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2236,current_num is 20
com.mysql.jdbc.JDBC4Connection@28cef164 conn is 2237,current_num is 20
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2235,current_num is 20
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2234,current_num is 20
com.mysql.jdbc.JDBC4Connection@27d1933f conn is 2233,current_num is 20
com.mysql.jdbc.JDBC4Connection@526b99ab conn is 2232,current_num is 20
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2229,current_num is 20
com.mysql.jdbc.JDBC4Connection@58010e0b conn is 2231,current_num is 20
com.mysql.jdbc.JDBC4Connection@1edcf564 conn is 2230,current_num is 20
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2507,current_num is 20
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2227,current_num is 20
com.mysql.jdbc.JDBC4Connection@5a27184d conn is 2226,current_num is 20
com.mysql.jdbc.JDBC4Connection@4c1a4732 conn is 2228,current_num is 20
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2225,current_num is 20
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2224,current_num is 20
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2223,current_num is 20
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2222,current_num is 20
com.mysql.jdbc.JDBC4Connection@12266960 conn is 2219,current_num is 20
com.mysql.jdbc.JDBC4Connection@43b65c0c conn is 2221,current_num is 20
com.mysql.jdbc.JDBC4Connection@28cef164 conn is 2218,current_num is 20
com.mysql.jdbc.JDBC4Connection@6c8a3ac2 conn is 2220,current_num is 20
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2217,current_num is 20
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2216,current_num is 20
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2508,current_num is 20
com.mysql.jdbc.JDBC4Connection@27d1933f conn is 2215,current_num is 20
com.mysql.jdbc.JDBC4Connection@526b99ab conn is 2214,current_num is 20
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2213,current_num is 20
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2212,current_num is 20
com.mysql.jdbc.JDBC4Connection@1edcf564 conn is 2211,current_num is 20
com.mysql.jdbc.JDBC4Connection@58010e0b conn is 2210,current_num is 20
com.mysql.jdbc.JDBC4Connection@4c1a4732 conn is 2209,current_num is 20
com.mysql.jdbc.JDBC4Connection@1edcf564 conn is 2191,current_num is 20
com.mysql.jdbc.JDBC4Connection@58010e0b conn is 2192,current_num is 20
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2194,current_num is 20
com.mysql.jdbc.JDBC4Connection@526b99ab conn is 2195,current_num is 20
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2193,current_num is 20
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2197,current_num is 20
com.mysql.jdbc.JDBC4Connection@27d1933f conn is 2509,current_num is 20
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2198,current_num is 20
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2196,current_num is 20
com.mysql.jdbc.JDBC4Connection@28cef164 conn is 2199,current_num is 20
com.mysql.jdbc.JDBC4Connection@12266960 conn is 2200,current_num is 20
com.mysql.jdbc.JDBC4Connection@6c8a3ac2 conn is 2201,current_num is 20
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2202,current_num is 20
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2204,current_num is 20
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2205,current_num is 20
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2206,current_num is 20
com.mysql.jdbc.JDBC4Connection@5a27184d conn is 2208,current_num is 20
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2207,current_num is 20
com.mysql.jdbc.JDBC4Connection@43b65c0c conn is 2203,current_num is 20
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@4c1a4732 conn is 2528,current_num is 20
com.mysql.jdbc.JDBC4Connection@1edcf564 conn is 2527,current_num is 20
com.mysql.jdbc.JDBC4Connection@58010e0b conn is 2529,current_num is 20
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2530,current_num is 20
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2531,current_num is 21
com.mysql.jdbc.JDBC4Connection@526b99ab conn is 2532,current_num is 21
com.mysql.jdbc.JDBC4Connection@27d1933f conn is 2534,current_num is 21
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2533,current_num is 21
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2535,current_num is 21
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2536,current_num is 21
com.mysql.jdbc.JDBC4Connection@28cef164 conn is 2537,current_num is 21
com.mysql.jdbc.JDBC4Connection@12266960 conn is 2538,current_num is 21
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@6c8a3ac2 conn is 2539,current_num is 21
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2540,current_num is 21
com.mysql.jdbc.JDBC4Connection@43b65c0c conn is 2541,current_num is 22
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2542,current_num is 22
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2543,current_num is 22
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2544,current_num is 22
com.mysql.jdbc.JDBC4Connection@5a27184d conn is 2545,current_num is 22
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2546,current_num is 22
com.mysql.jdbc.JDBC4Connection@4c1a4732 conn is 2547,current_num is 22
com.mysql.jdbc.JDBC4Connection@1edcf564 conn is 2548,current_num is 22
com.mysql.jdbc.JDBC4Connection@58010e0b conn is 2549,current_num is 22
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2550,current_num is 22
com.mysql.jdbc.JDBC4Connection@613be7fa conn is 2551,current_num is 23
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2552,current_num is 23
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@526b99ab conn is 2553,current_num is 23
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2554,current_num is 23
com.mysql.jdbc.JDBC4Connection@27d1933f conn is 2555,current_num is 23
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2556,current_num is 24
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2557,current_num is 24
com.mysql.jdbc.JDBC4Connection@28cef164 conn is 2558,current_num is 24
com.mysql.jdbc.JDBC4Connection@12266960 conn is 2559,current_num is 24
com.mysql.jdbc.JDBC4Connection@6c8a3ac2 conn is 2560,current_num is 24
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 2561,current_num is 24
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@7ce6c879 conn is 2562,current_num is 25
com.mysql.jdbc.JDBC4Connection@43b65c0c conn is 2563,current_num is 25
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 2564,current_num is 25
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 2565,current_num is 25
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 2566,current_num is 25
com.mysql.jdbc.JDBC4Connection@5a27184d conn is 2567,current_num is 25
com.mysql.jdbc.JDBC4Connection@145449bd conn is 2568,current_num is 26
Sun Feb 04 22:32:07 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@4c1a4732 conn is 2569,current_num is 26
com.mysql.jdbc.JDBC4Connection@1edcf564 conn is 2570,current_num is 26
com.mysql.jdbc.JDBC4Connection@58010e0b conn is 2571,current_num is 26
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 2572,current_num is 26
com.mysql.jdbc.JDBC4Connection@23034a33 conn is 2573,current_num is 26
com.mysql.jdbc.JDBC4Connection@613be7fa conn is 2574,current_num is 26
com.mysql.jdbc.JDBC4Connection@18540478 conn is 2575,current_num is 26
com.mysql.jdbc.JDBC4Connection@526b99ab conn is 2576,current_num is 26
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 2577,current_num is 26
com.mysql.jdbc.JDBC4Connection@27d1933f conn is 2578,current_num is 26
com.mysql.jdbc.JDBC4Connection@6b6acc14 conn is 2579,current_num is 26
com.mysql.jdbc.JDBC4Connection@36039ec conn is 2580,current_num is 27
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 2581,current_num is 27
com.mysql.jdbc.JDBC4Connection@28cef164 conn is 2582,current_num is 27
com.mysql.jdbc.JDBC4Connection@12266960 conn is 2583,current_num is 27
com.mysql.jdbc.JDBC4Connection@6c8a3ac2 conn is 2584,current_num is 27
............
com.mysql.jdbc.JDBC4Connection@45208681 conn is 9894,current_num is 80
com.mysql.jdbc.JDBC4Connection@23034a33 conn is 9895,current_num is 80
com.mysql.jdbc.JDBC4Connection@77ead0db conn is 9896,current_num is 80
com.mysql.jdbc.JDBC4Connection@2a8b9fed conn is 9897,current_num is 80
com.mysql.jdbc.JDBC4Connection@27114133 conn is 9898,current_num is 80
com.mysql.jdbc.JDBC4Connection@68f70c3e conn is 9899,current_num is 80
com.mysql.jdbc.JDBC4Connection@29f3309a conn is 9900,current_num is 80
com.mysql.jdbc.JDBC4Connection@531759a9 conn is 9901,current_num is 80
com.mysql.jdbc.JDBC4Connection@7ce6c879 conn is 9902,current_num is 80
com.mysql.jdbc.JDBC4Connection@5ad0659d conn is 9903,current_num is 80
com.mysql.jdbc.JDBC4Connection@e62bd9b conn is 9904,current_num is 80
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 9905,current_num is 80
com.mysql.jdbc.JDBC4Connection@4c1a4732 conn is 9906,current_num is 80
com.mysql.jdbc.JDBC4Connection@42126bd2 conn is 9907,current_num is 80
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 9908,current_num is 80
com.mysql.jdbc.JDBC4Connection@7c1977e2 conn is 9909,current_num is 80
com.mysql.jdbc.JDBC4Connection@73de9c32 conn is 9910,current_num is 80
com.mysql.jdbc.JDBC4Connection@5327a66d conn is 9911,current_num is 80
com.mysql.jdbc.JDBC4Connection@1edcf564 conn is 9912,current_num is 80
com.mysql.jdbc.JDBC4Connection@6c8a3ac2 conn is 9913,current_num is 80
com.mysql.jdbc.JDBC4Connection@5840919c conn is 9914,current_num is 80
com.mysql.jdbc.JDBC4Connection@13b6f892 conn is 9915,current_num is 80
com.mysql.jdbc.JDBC4Connection@48e38207 conn is 9916,current_num is 80
com.mysql.jdbc.JDBC4Connection@6d95f874 conn is 9917,current_num is 80
com.mysql.jdbc.JDBC4Connection@58010e0b conn is 9918,current_num is 80
com.mysql.jdbc.JDBC4Connection@322b021f conn is 9919,current_num is 80
com.mysql.jdbc.JDBC4Connection@76d84c1 conn is 9920,current_num is 80
com.mysql.jdbc.JDBC4Connection@7079a300 conn is 9921,current_num is 80
com.mysql.jdbc.JDBC4Connection@28cef164 conn is 9922,current_num is 80
com.mysql.jdbc.JDBC4Connection@36039ec conn is 9923,current_num is 80
com.mysql.jdbc.JDBC4Connection@4b92531e conn is 9924,current_num is 80
com.mysql.jdbc.JDBC4Connection@3cb85f84 conn is 9925,current_num is 80
com.mysql.jdbc.JDBC4Connection@2c3a40e6 conn is 9926,current_num is 80
com.mysql.jdbc.JDBC4Connection@18540478 conn is 9927,current_num is 80
com.mysql.jdbc.JDBC4Connection@1b106c29 conn is 9928,current_num is 80
com.mysql.jdbc.JDBC4Connection@58d60bd6 conn is 9929,current_num is 80
com.mysql.jdbc.JDBC4Connection@2f78bc01 conn is 9930,current_num is 80
com.mysql.jdbc.JDBC4Connection@58f46dea conn is 9931,current_num is 80
com.mysql.jdbc.JDBC4Connection@3ee71dd0 conn is 9932,current_num is 80
com.mysql.jdbc.JDBC4Connection@4d7d0ba2 conn is 9933,current_num is 80
com.mysql.jdbc.JDBC4Connection@662d24b7 conn is 9934,current_num is 80
com.mysql.jdbc.JDBC4Connection@27d1933f conn is 9935,current_num is 80
com.mysql.jdbc.JDBC4Connection@2df0647c conn is 9936,current_num is 80
com.mysql.jdbc.JDBC4Connection@336f8f02 conn is 9937,current_num is 80
com.mysql.jdbc.JDBC4Connection@673bebd0 conn is 9938,current_num is 80
com.mysql.jdbc.JDBC4Connection@43b65c0c conn is 9939,current_num is 80
com.mysql.jdbc.JDBC4Connection@7f2fecf3 conn is 9940,current_num is 80
com.mysql.jdbc.JDBC4Connection@22532f08 conn is 9941,current_num is 80
com.mysql.jdbc.JDBC4Connection@12266960 conn is 9942,current_num is 80
com.mysql.jdbc.JDBC4Connection@45621f3c conn is 9943,current_num is 80
com.mysql.jdbc.JDBC4Connection@1c8126de conn is 9944,current_num is 80
com.mysql.jdbc.JDBC4Connection@613be7fa conn is 9945,current_num is 80
com.mysql.jdbc.JDBC4Connection@2cf9c34b conn is 9946,current_num is 80
com.mysql.jdbc.JDBC4Connection@2ebb6f9e conn is 9947,current_num is 80
com.mysql.jdbc.JDBC4Connection@259e4407 conn is 9948,current_num is 80
com.mysql.jdbc.JDBC4Connection@5a27184d conn is 9949,current_num is 80
com.mysql.jdbc.JDBC4Connection@2762a670 conn is 9950,current_num is 80
com.mysql.jdbc.JDBC4Connection@6d982ab9 conn is 9951,current_num is 80
com.mysql.jdbc.JDBC4Connection@12303cee conn is 9952,current_num is 80
com.mysql.jdbc.JDBC4Connection@70ce732e conn is 9953,current_num is 80
com.mysql.jdbc.JDBC4Connection@1bcda716 conn is 9954,current_num is 80
com.mysql.jdbc.JDBC4Connection@3e66caa3 conn is 9955,current_num is 80
com.mysql.jdbc.JDBC4Connection@4c4c85bd conn is 9956,current_num is 80
com.mysql.jdbc.JDBC4Connection@5f1e34bd conn is 9957,current_num is 80
com.mysql.jdbc.JDBC4Connection@172149a8 conn is 9958,current_num is 80
com.mysql.jdbc.JDBC4Connection@48b0856b conn is 9959,current_num is 80
com.mysql.jdbc.JDBC4Connection@51d7f778 conn is 9960,current_num is 80
com.mysql.jdbc.JDBC4Connection@738af3c0 conn is 9961,current_num is 80
com.mysql.jdbc.JDBC4Connection@6b6acc14 conn is 9962,current_num is 80
com.mysql.jdbc.JDBC4Connection@8b52a5e conn is 9963,current_num is 80
com.mysql.jdbc.JDBC4Connection@1dcfdbea conn is 9964,current_num is 80
com.mysql.jdbc.JDBC4Connection@5dc890c5 conn is 9965,current_num is 80
com.mysql.jdbc.JDBC4Connection@4797fbe9 conn is 9966,current_num is 80
com.mysql.jdbc.JDBC4Connection@145449bd conn is 9967,current_num is 80
com.mysql.jdbc.JDBC4Connection@11cbcb1c conn is 9968,current_num is 80
com.mysql.jdbc.JDBC4Connection@526b99ab conn is 9969,current_num is 80
com.mysql.jdbc.JDBC4Connection@e84f4e8 conn is 9970,current_num is 80
com.mysql.jdbc.JDBC4Connection@35a9df35 conn is 9971,current_num is 80
com.mysql.jdbc.JDBC4Connection@5ef1451f conn is 9972,current_num is 80
com.mysql.jdbc.JDBC4Connection@5e5c34ce conn is 9973,current_num is 80
com.mysql.jdbc.JDBC4Connection@45208681 conn is 9974,current_num is 80
com.mysql.jdbc.JDBC4Connection@23034a33 conn is 9975,current_num is 80
com.mysql.jdbc.JDBC4Connection@77ead0db conn is 9976,current_num is 80
com.mysql.jdbc.JDBC4Connection@2a8b9fed conn is 9977,current_num is 80
com.mysql.jdbc.JDBC4Connection@27114133 conn is 9978,current_num is 80
com.mysql.jdbc.JDBC4Connection@68f70c3e conn is 9979,current_num is 80
com.mysql.jdbc.JDBC4Connection@29f3309a conn is 9980,current_num is 80
com.mysql.jdbc.JDBC4Connection@531759a9 conn is 9981,current_num is 80
com.mysql.jdbc.JDBC4Connection@7ce6c879 conn is 9982,current_num is 80
com.mysql.jdbc.JDBC4Connection@5ad0659d conn is 9983,current_num is 80
com.mysql.jdbc.JDBC4Connection@e62bd9b conn is 9984,current_num is 80
com.mysql.jdbc.JDBC4Connection@7af6a47 conn is 9985,current_num is 80
com.mysql.jdbc.JDBC4Connection@4c1a4732 conn is 9986,current_num is 80
com.mysql.jdbc.JDBC4Connection@42126bd2 conn is 9987,current_num is 80
com.mysql.jdbc.JDBC4Connection@38a4ed22 conn is 9988,current_num is 80
com.mysql.jdbc.JDBC4Connection@7c1977e2 conn is 9989,current_num is 80
com.mysql.jdbc.JDBC4Connection@73de9c32 conn is 9990,current_num is 80
com.mysql.jdbc.JDBC4Connection@5327a66d conn is 9991,current_num is 80
com.mysql.jdbc.JDBC4Connection@1edcf564 conn is 9992,current_num is 80
com.mysql.jdbc.JDBC4Connection@6c8a3ac2 conn is 9993,current_num is 80
com.mysql.jdbc.JDBC4Connection@5840919c conn is 9994,current_num is 80
com.mysql.jdbc.JDBC4Connection@13b6f892 conn is 9995,current_num is 80
com.mysql.jdbc.JDBC4Connection@48e38207 conn is 9996,current_num is 80
com.mysql.jdbc.JDBC4Connection@6d95f874 conn is 9997,current_num is 80
com.mysql.jdbc.JDBC4Connection@58010e0b conn is 9998,current_num is 80
com.mysql.jdbc.JDBC4Connection@322b021f conn is 9999,current_num is 80
com.mysql.jdbc.JDBC4Connection@76d84c1 conn is 10000,current_num is 80

Process finished with exit code 0

 actor运行结果:


>>> Press ENTER to exit <<<
Sun Feb 04 22:36:48 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun Feb 04 22:36:48 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun Feb 04 22:36:48 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun Feb 04 22:36:48 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun Feb 04 22:36:48 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun Feb 04 22:36:48 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun Feb 04 22:36:48 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun Feb 04 22:36:48 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun Feb 04 22:36:48 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun Feb 04 22:36:48 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@75d54ea4 conn is 1,current_num is 10
com.mysql.jdbc.JDBC4Connection@26861a90 conn is 2,current_num is 10
com.mysql.jdbc.JDBC4Connection@594629ee conn is 3,current_num is 10
com.mysql.jdbc.JDBC4Connection@5d4fcba6 conn is 4,current_num is 10
com.mysql.jdbc.JDBC4Connection@2300ec5 conn is 5,current_num is 10
com.mysql.jdbc.JDBC4Connection@1474d689 conn is 6,current_num is 10
com.mysql.jdbc.JDBC4Connection@7c1594b0 conn is 7,current_num is 10
com.mysql.jdbc.JDBC4Connection@5f24626f conn is 8,current_num is 10
com.mysql.jdbc.JDBC4Connection@5d601968 conn is 9,current_num is 10
com.mysql.jdbc.JDBC4Connection@6f925cd3 conn is 10,current_num is 10
com.mysql.jdbc.JDBC4Connection@75d54ea4 conn is 11,current_num is 10
com.mysql.jdbc.JDBC4Connection@26861a90 conn is 12,current_num is 10
com.mysql.jdbc.JDBC4Connection@594629ee conn is 13,current_num is 10
com.mysql.jdbc.JDBC4Connection@5d4fcba6 conn is 14,current_num is 10
com.mysql.jdbc.JDBC4Connection@2300ec5 conn is 15,current_num is 10
com.mysql.jdbc.JDBC4Connection@1474d689 conn is 16,current_num is 10
com.mysql.jdbc.JDBC4Connection@7c1594b0 conn is 17,current_num is 10
com.mysql.jdbc.JDBC4Connection@5f24626f conn is 18,current_num is 10
com.mysql.jdbc.JDBC4Connection@5d601968 conn is 19,current_num is 10
com.mysql.jdbc.JDBC4Connection@6f925cd3 conn is 20,current_num is 10
com.mysql.jdbc.JDBC4Connection@75d54ea4 conn is 21,current_num is 10
com.mysql.jdbc.JDBC4Connection@26861a90 conn is 22,current_num is 10
com.mysql.jdbc.JDBC4Connection@594629ee conn is 23,current_num is 10
com.mysql.jdbc.JDBC4Connection@5d4fcba6 conn is 24,current_num is 10
com.mysql.jdbc.JDBC4Connection@2300ec5 conn is 25,current_num is 10
com.mysql.jdbc.JDBC4Connection@1474d689 conn is 26,current_num is 10
com.mysql.jdbc.JDBC4Connection@7c1594b0 conn is 27,current_num is 10
com.mysql.jdbc.JDBC4Connection@5f24626f conn is 28,current_num is 10
com.mysql.jdbc.JDBC4Connection@5d601968 conn is 29,current_num is 10
com.mysql.jdbc.JDBC4Connection@6f925cd3 conn is 30,current_num is 10
com.mysql.jdbc.JDBC4Connection@75d54ea4 conn is 31,current_num is 10
com.mysql.jdbc.JDBC4Connection@26861a90 conn is 32,current_num is 10
com.mysql.jdbc.JDBC4Connection@594629ee conn is 33,current_num is 10
com.mysql.jdbc.JDBC4Connection@5d4fcba6 conn is 34,current_num is 10
com.mysql.jdbc.JDBC4Connection@2300ec5 conn is 35,current_num is 10
com.mysql.jdbc.JDBC4Connection@1474d689 conn is 36,current_num is 10
com.mysql.jdbc.JDBC4Connection@7c1594b0 conn is 37,current_num is 10
com.mysql.jdbc.JDBC4Connection@5f24626f conn is 38,current_num is 10
com.mysql.jdbc.JDBC4Connection@5d601968 conn is 39,current_num is 10
com.mysql.jdbc.JDBC4Connection@6f925cd3 conn is 40,current_num is 10
com.mysql.jdbc.JDBC4Connection@75d54ea4 conn is 41,current_num is 10
com.mysql.jdbc.JDBC4Connection@26861a90 conn is 42,current_num is 10
com.mysql.jdbc.JDBC4Connection@594629ee conn is 43,current_num is 10
com.mysql.jdbc.JDBC4Connection@5d4fcba6 conn is 44,current_num is 10
com.mysql.jdbc.JDBC4Connection@2300ec5 conn is 45,current_num is 10
com.mysql.jdbc.JDBC4Connection@1474d689 conn is 46,current_num is 10
com.mysql.jdbc.JDBC4Connection@7c1594b0 conn is 47,current_num is 10
com.mysql.jdbc.JDBC4Connection@5f24626f conn is 48,current_num is 10
com.mysql.jdbc.JDBC4Connection@5d601968 conn is 49,current_num is 10
com.mysql.jdbc.JDBC4Connection@6f925cd3 conn is 50,current_num is 10
com.mysql.jdbc.JDBC4Connection@75d54ea4 conn is 51,current_num is 10
com.mysql.jdbc.JDBC4Connection@26861a90 conn is 52,current_num is 10
com.mysql.jdbc.JDBC4Connection@594629ee conn is 53,current_num is 10
com.mysql.jdbc.JDBC4Connection@5d4fcba6 conn is 54,current_num is 10
com.mysql.jdbc.JDBC4Connection@2300ec5 conn is 55,current_num is 10

......
com.mysql.jdbc.JDBC4Connection@6f925cd3 conn is 9990,current_num is 10
com.mysql.jdbc.JDBC4Connection@75d54ea4 conn is 9991,current_num is 10
com.mysql.jdbc.JDBC4Connection@26861a90 conn is 9992,current_num is 10
com.mysql.jdbc.JDBC4Connection@594629ee conn is 9993,current_num is 10
com.mysql.jdbc.JDBC4Connection@5d4fcba6 conn is 9994,current_num is 10
com.mysql.jdbc.JDBC4Connection@2300ec5 conn is 9995,current_num is 10
com.mysql.jdbc.JDBC4Connection@1474d689 conn is 9996,current_num is 10
com.mysql.jdbc.JDBC4Connection@7c1594b0 conn is 9997,current_num is 10
com.mysql.jdbc.JDBC4Connection@5f24626f conn is 9998,current_num is 10
com.mysql.jdbc.JDBC4Connection@5d601968 conn is 9999,current_num is 10
com.mysql.jdbc.JDBC4Connection@6f925cd3 conn is 10000,current_num is 10

Thread2300~2400运行效果:

Sun Feb 04 22:50:27 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun Feb 04 22:50:28 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2284,current_num is 1
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2277,current_num is 1
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2290,current_num is 2
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2287,current_num is 2
Sun Feb 04 22:50:28 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2283,current_num is 1
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2279,current_num is 1
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2289,current_num is 2
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2280,current_num is 1
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2278,current_num is 1
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2276,current_num is 1
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2282,current_num is 1
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2288,current_num is 2
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2285,current_num is 2
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2291,current_num is 3
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2286,current_num is 2
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2293,current_num is 3
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2294,current_num is 3
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2292,current_num is 3
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2295,current_num is 3
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2296,current_num is 3
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2297,current_num is 3
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2298,current_num is 3
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2299,current_num is 3
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2300,current_num is 3
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2301,current_num is 3
Sun Feb 04 22:50:28 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2302,current_num is 3
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2303,current_num is 4
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2304,current_num is 4
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2305,current_num is 4
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 2306,current_num is 4
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2307,current_num is 4
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2308,current_num is 4
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2309,current_num is 4
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 2310,current_num is 4
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2311,current_num is 4
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2312,current_num is 5
Sun Feb 04 22:50:28 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2313,current_num is 5
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 2314,current_num is 5
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2315,current_num is 5
Sun Feb 04 22:50:28 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@7984dcf6 conn is 2316,current_num is 5
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2317,current_num is 5
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2318,current_num is 5
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 2319,current_num is 5
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2320,current_num is 5
com.mysql.jdbc.JDBC4Connection@7984dcf6 conn is 2321,current_num is 5
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2322,current_num is 5
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2323,current_num is 5
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 2324,current_num is 5
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2325,current_num is 5
com.mysql.jdbc.JDBC4Connection@7984dcf6 conn is 2326,current_num is 5
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2327,current_num is 5
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2328,current_num is 5
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 2329,current_num is 5
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2330,current_num is 5
com.mysql.jdbc.JDBC4Connection@7984dcf6 conn is 2331,current_num is 5
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2332,current_num is 5
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2333,current_num is 5
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 2334,current_num is 5
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2335,current_num is 6
com.mysql.jdbc.JDBC4Connection@7984dcf6 conn is 2336,current_num is 6
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2337,current_num is 6
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2338,current_num is 6
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 2339,current_num is 6
com.mysql.jdbc.JDBC4Connection@2ec303b conn is 2340,current_num is 6
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2341,current_num is 6
com.mysql.jdbc.JDBC4Connection@7984dcf6 conn is 2342,current_num is 6
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2343,current_num is 7
Sun Feb 04 22:50:28 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2344,current_num is 7
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 2345,current_num is 7
Sun Feb 04 22:50:28 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@2ec303b conn is 2346,current_num is 7
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2347,current_num is 7
com.mysql.jdbc.JDBC4Connection@7984dcf6 conn is 2348,current_num is 7
com.mysql.jdbc.JDBC4Connection@7acc608 conn is 2349,current_num is 7
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2350,current_num is 7
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2351,current_num is 8
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 2352,current_num is 8
com.mysql.jdbc.JDBC4Connection@2ec303b conn is 2353,current_num is 8
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2354,current_num is 8
com.mysql.jdbc.JDBC4Connection@7984dcf6 conn is 2355,current_num is 8
com.mysql.jdbc.JDBC4Connection@7acc608 conn is 2356,current_num is 8
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2357,current_num is 8
com.mysql.jdbc.JDBC4Connection@803a18f conn is 2358,current_num is 8
Sun Feb 04 22:50:28 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2359,current_num is 9
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 2360,current_num is 9
com.mysql.jdbc.JDBC4Connection@2ec303b conn is 2361,current_num is 9
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2362,current_num is 9
com.mysql.jdbc.JDBC4Connection@7984dcf6 conn is 2363,current_num is 9
com.mysql.jdbc.JDBC4Connection@7acc608 conn is 2364,current_num is 9
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2365,current_num is 9
com.mysql.jdbc.JDBC4Connection@803a18f conn is 2366,current_num is 9
Sun Feb 04 22:50:28 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
com.mysql.jdbc.JDBC4Connection@5afe8b7d conn is 2367,current_num is 9
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 2369,current_num is 10
com.mysql.jdbc.JDBC4Connection@2ec303b conn is 1,current_num is 10
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2281,current_num is 10
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2368,current_num is 9
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2274,current_num is 10
com.mysql.jdbc.JDBC4Connection@803a18f conn is 2273,current_num is 10
com.mysql.jdbc.JDBC4Connection@5afe8b7d conn is 2272,current_num is 10
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2269,current_num is 10
com.mysql.jdbc.JDBC4Connection@2ec303b conn is 2270,current_num is 10
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 2271,current_num is 10
com.mysql.jdbc.JDBC4Connection@7984dcf6 conn is 2268,current_num is 10
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2371,current_num is 10
com.mysql.jdbc.JDBC4Connection@7acc608 conn is 2373,current_num is 10
com.mysql.jdbc.JDBC4Connection@7984dcf6 conn is 2370,current_num is 10
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2265,current_num is 10
com.mysql.jdbc.JDBC4Connection@5780190e conn is 2372,current_num is 10
com.mysql.jdbc.JDBC4Connection@803a18f conn is 2267,current_num is 10
com.mysql.jdbc.JDBC4Connection@5afe8b7d conn is 2374,current_num is 10
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2266,current_num is 10
com.mysql.jdbc.JDBC4Connection@5780190e conn is 2264,current_num is 10
com.mysql.jdbc.JDBC4Connection@7acc608 conn is 2275,current_num is 10
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 2263,current_num is 10
com.mysql.jdbc.JDBC4Connection@2ec303b conn is 2261,current_num is 10
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2375,current_num is 10
com.mysql.jdbc.JDBC4Connection@7984dcf6 conn is 2262,current_num is 10
com.mysql.jdbc.JDBC4Connection@7acc608 conn is 2260,current_num is 10
com.mysql.jdbc.JDBC4Connection@6c7e8e89 conn is 2259,current_num is 10
com.mysql.jdbc.JDBC4Connection@5afe8b7d conn is 2257,current_num is 10
com.mysql.jdbc.JDBC4Connection@5780190e conn is 2256,current_num is 10
com.mysql.jdbc.JDBC4Connection@803a18f conn is 2258,current_num is 10
com.mysql.jdbc.JDBC4Connection@70e0ec40 conn is 2376,current_num is 10
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 2255,current_num is 10
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 2254,current_num is 10
com.mysql.jdbc.JDBC4Connection@7984dcf6 conn is 2253,current_num is 10
com.mysql.jdbc.JDBC4Connection@2ec303b conn is 2377,current_num is 10
com.mysql.jdbc.JDBC4Connection@7acc608 conn is 2378,current_num is 10
....
com.mysql.jdbc.JDBC4Connection@5afe8b7d conn is 144,current_num is 20
com.mysql.jdbc.JDBC4Connection@2ec303b conn is 145,current_num is 20
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 146,current_num is 20
com.mysql.jdbc.JDBC4Connection@78cc3e0f conn is 147,current_num is 20
com.mysql.jdbc.JDBC4Connection@803a18f conn is 148,current_num is 20
com.mysql.jdbc.JDBC4Connection@8a92dd0 conn is 149,current_num is 20
com.mysql.jdbc.JDBC4Connection@4b2bdb5e conn is 152,current_num is 20
com.mysql.jdbc.JDBC4Connection@55f825fa conn is 154,current_num is 20
com.mysql.jdbc.JDBC4Connection@207e87e conn is 155,current_num is 20
com.mysql.jdbc.JDBC4Connection@5521b93a conn is 159,current_num is 20
com.mysql.jdbc.JDBC4Connection@2ec303b conn is 165,current_num is 20
com.mysql.jdbc.JDBC4Connection@6d8646b5 conn is 166,current_num is 20
com.mysql.jdbc.JDBC4Connection@78cc3e0f conn is 167,current_num is 20

Process finished with exit code 0

 actor在40000000级上数据运行情况

com.mysql.jdbc.JDBC4Connection@2d02c2a4 conn is 39999985,current_num is 10
com.mysql.jdbc.JDBC4Connection@792b0c3a conn is 39999986,current_num is 10
com.mysql.jdbc.JDBC4Connection@9444bb7 conn is 39999987,current_num is 10
com.mysql.jdbc.JDBC4Connection@7cc94733 conn is 39999988,current_num is 10
com.mysql.jdbc.JDBC4Connection@47e5adec conn is 39999989,current_num is 10
com.mysql.jdbc.JDBC4Connection@660e23f6 conn is 39999990,current_num is 10
com.mysql.jdbc.JDBC4Connection@557601c1 conn is 39999991,current_num is 10
com.mysql.jdbc.JDBC4Connection@3f4d7608 conn is 39999992,current_num is 10
com.mysql.jdbc.JDBC4Connection@5564bf6f conn is 39999993,current_num is 10
com.mysql.jdbc.JDBC4Connection@4096bdd9 conn is 39999994,current_num is 10
com.mysql.jdbc.JDBC4Connection@2d02c2a4 conn is 39999995,current_num is 10
com.mysql.jdbc.JDBC4Connection@792b0c3a conn is 39999996,current_num is 10
com.mysql.jdbc.JDBC4Connection@9444bb7 conn is 39999997,current_num is 10
com.mysql.jdbc.JDBC4Connection@7cc94733 conn is 39999998,current_num is 10
com.mysql.jdbc.JDBC4Connection@47e5adec conn is 39999999,current_num is 10
com.mysql.jdbc.JDBC4Connection@660e23f6 conn is 40000000,current_num is 10

 

实验结论:

 由上面运行效果得出:actor模型几乎运行10000次点用即时结束,thread模型确实慢了好久,整体感觉有一秒,大家可以试着运行感觉一下;当中thread在运行时(为了页面加载没有粘出所有数据太多)

线程中不存在连接的查询使用,只是打印对象地址,thread在2300 - 2400 之间就存在当前连接数的增加,即表明在线程调用时,连接不能及时回收,导致了联接的创建。而actor模型在10000级连接数不变,则说明在并发稳定上,actor支持更高的并发和稳定性。

actor模型在40000000级别连接数依然是10,这说明的不言而喻。

上面的结论如果有异议的话,可以讨论。

 

posted @ 2018-02-04 23:31    阅读(786)  评论(0编辑  收藏  举报