Percona: Instalasi mengganti MySQL - Revision history

Onnowpurbo: /* Step Four — Configuration */

2015-05-27T08:22:52Z

Step Four — Configuration

← Older revision		Revision as of 08:22, 27 May 2015
Line 233:		Line 233:

	service mysql restart		service mysql restart

			Akan keluar

			* Starting MySQL (Percona Server) database server mysqld

	If the server fails to start with this config, try reducing innodb-buffer-pool-size to a smaller value and repeating the above command.		If the server fails to start with this config, try reducing innodb-buffer-pool-size to a smaller value and repeating the above command.
Line 243:		Line 247:
	Enter password:		Enter password:
	Welcome to the MySQL monitor. Commands end with ; or \g.		Welcome to the MySQL monitor. Commands end with ; or \g.
	Your MySQL connection id is 45		Your MySQL connection id is 47
	Server version: 5.5.38-35.2 Percona Server (GPL), Release 35.2, Revision ~~674~~		Server version: 5.6.24-72.2 Percona Server (GPL), Release 72.2, Revision 8d0f85b

	Copyright (c) 2009-~~2014~~ Percona LLC and/or its affiliates		Copyright (c) 2009-2015 Percona LLC and/or its affiliates
	Copyright (c) 2000, ~~2014~~, Oracle and/or its affiliates. All rights reserved.		Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

	Oracle is a registered trademark of Oracle Corporation and/or its		Oracle is a registered trademark of Oracle Corporation and/or its
Line 253:		Line 257:
	owners.		owners.

	Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.		Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

	mysql>		mysql>
Line 261:		Line 265:
	SHOW VARIABLES LIKE "version%";		SHOW VARIABLES LIKE "version%";

	+-------------------------+--------------------------------------------------+		+-------------------------+------------------------------------------------------+
	\| Variable_name \| Value \|		\| Variable_name \| Value \|
	+-------------------------+--------------------------------------------------+		+-------------------------+------------------------------------------------------+
	\| version \| 5.5.38-35.2 \|		\| version \| 5.6.24-72.2 \|
	\| version_comment \| Percona Server (GPL), Release 35.2, Revision ~~674~~ \|		\| version_comment \| Percona Server (GPL), Release 72.2, Revision 8d0f85b \|
	\| version_compile_machine \| x86_64 \|		\| version_compile_machine \| x86_64 \|
	\| version_compile_os \| debian-linux-gnu \|		\| version_compile_os \| debian-linux-gnu \|
	+-------------------------+--------------------------------------------------+		+-------------------------+------------------------------------------------------+
	4 rows in set (0.00 sec)		4 rows in set (0.00 sec)

Line 281:		Line 285:

	...		...

	************************* 8. row *************************		************************* 6. row *************************
	Engine: InnoDB		Engine: InnoDB
	Support: DEFAULT		Support: DEFAULT
Line 289:		Line 293:
	XA: YES		XA: YES
	Savepoints: YES		Savepoints: YES
			************************* 7. row *************************
	...		...

	9 rows in set (0.00 sec)		9 rows in set (0.01 sec)


	The comment field within the response shows that the XtraDB engine has been loaded as the engine for InnoDB based tables. As a final check, it is advised that you ensure all of your databases and tables are being read properly in the new server.		The comment field within the response shows that the XtraDB engine has been loaded as the engine for InnoDB based tables. As a final check, it is advised that you ensure all of your databases and tables are being read properly in the new server.

Onnowpurbo: /* Step Three — Installing Percona Server */

2015-05-27T07:54:09Z