June 20, 2013

Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4

whatmysql:2 ] After the update and after fixing some small issues like the one bellow, you are able toTuningto find the command install crmsh (crm shell from another repository) or just install pcs (Pacemaker Configuration System) [root@percona2 percona]# yum -y install

Post: What to tune in MySQL Server after installation

to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server straight after installation, assuming it was installed with default settings. I’m surprised how many people fail to

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM full-text search, in the sense that the SQL required toto traditional MyISAM FTS. We’ll get to performance in the third installment. For now, the important number here is to

Comment: What to tune in MySQL Server after installation

MySQL Performance Blog » What to tune in MySQL Server after installation Even though you can tune quite a lot of variables in MySQL Servers only few of them are really important for most common workload (tags: mysql performance database tuning

Comment: What to tune in MySQL Server after installation

[...] MySQL Performance Blog » What to tune in MySQL Server after installation (tags: mysql performance database tuning howto tutorial scalability) [...]

Comment: What to tune in MySQL Server after installation

[...] that in mind, we tune MySQL with a read-intensive strategy. I found some of the best guidance in Peter Zaitsev’s “What to tune in MySQL Server after installation” and the ez.no documentation on Optimizing for read [...]

Comment: What to tune in MySQL Server after installation

[...] Hier findet sich eine etwas älterere Beschreibung über die verschiedenen Einstellungemöglichkeiten im MySQL my.ini (oder my.cfg): http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ [...]

Comment: What to tune in MySQL Server after installation

[...] MySQL Performance Blog: What to tune in MySQL Server after installation [...]

Comment: What to tune in MySQL Server after installation

[...] What to tune in MySQL Server after installation 10 Tips for Optimizing MySQL Queries (That don’t suck) [...]

Comment: What to tune in MySQL Server after installation

What to tune in MySQL Server after installation 當你安裝完 MySQL Database Server 後該做怎樣的調校…‘Šè¨´ä½ ï¼ä¸€å€‹å°ˆé–€åœ¨è¨Žè«– MySQL 效能的網站,是個取ç…