Merge pull request #1668 from wp-cli/mysql-no-hash

danielbachhuber · danielbachhuber · commit b09a45a4e41d · 2015-02-19T22:52:58.000-08:00
Use `mysql` with `--no-auto-rehash` for perf boost
diff --git a/php/commands/db.php b/php/commands/db.php
@@ -78,7 +78,7 @@ function repair() {
 	 * @alias connect
 	 */
 	function cli() {
-		self::run( 'mysql --no-defaults', array(
+		self::run( 'mysql --no-defaults --no-auto-rehash', array(
 			'database' => DB_NAME
 		) );
 	}
@@ -109,7 +109,7 @@ function query( $args ) {
 			$assoc_args['execute'] = $args[0];
 		}
 
-		self::run( 'mysql --no-defaults', $assoc_args );
+		self::run( 'mysql --no-defaults --no-auto-rehash', $assoc_args );
 	}
 
 	/**
@@ -192,7 +192,7 @@ function import( $args, $assoc_args ) {
 			);
 		}
 
-		self::run( 'mysql --no-defaults', array(
+		self::run( 'mysql --no-defaults --no-auto-rehash', array(
 			'database' => DB_NAME
 		), $descriptors );
 
@@ -244,7 +244,7 @@ private static function get_create_query() {
 	}
 
 	private static function run_query( $query ) {
-		self::run( 'mysql --no-defaults', array( 'execute' => $query ) );
+		self::run( 'mysql --no-defaults --no-auto-rehash', array( 'execute' => $query ) );
 	}
 
 	private static function run( $cmd, $assoc_args = array(), $descriptors = null ) {

Original file line number	Diff line number	Diff line change
`@@ -78,7 +78,7 @@ function repair() {`
`78`	`78`	`* @alias connect`
`79`	`79`	`*/`
`80`	`80`	`function cli() {`
`81`		`- self::run( 'mysql --no-defaults', array(`
	`81`	`+ self::run( 'mysql --no-defaults --no-auto-rehash', array(`
`82`	`82`	`'database' => DB_NAME`
`83`	`83`	`) );`
`84`	`84`	`}`
`@@ -109,7 +109,7 @@ function query( $args ) {`
`109`	`109`	`$assoc_args['execute'] = $args[0];`
`110`	`110`	`}`
`111`	`111`
`112`		`- self::run( 'mysql --no-defaults', $assoc_args );`
	`112`	`+ self::run( 'mysql --no-defaults --no-auto-rehash', $assoc_args );`
`113`	`113`	`}`
`114`	`114`
`115`	`115`	`/**`
`@@ -192,7 +192,7 @@ function import( $args, $assoc_args ) {`
`192`	`192`	`);`
`193`	`193`	`}`
`194`	`194`
`195`		`- self::run( 'mysql --no-defaults', array(`
	`195`	`+ self::run( 'mysql --no-defaults --no-auto-rehash', array(`
`196`	`196`	`'database' => DB_NAME`
`197`	`197`	`), $descriptors );`
`198`	`198`
`@@ -244,7 +244,7 @@ private static function get_create_query() {`
`244`	`244`	`}`
`245`	`245`
`246`	`246`	`private static function run_query( $query ) {`
`247`		`- self::run( 'mysql --no-defaults', array( 'execute' => $query ) );`
	`247`	`+ self::run( 'mysql --no-defaults --no-auto-rehash', array( 'execute' => $query ) );`
`248`	`248`	`}`
`249`	`249`
`250`	`250`	`private static function run( $cmd, $assoc_args = array(), $descriptors = null ) {`