… by safe upgrade procedures – dump your data and reload. Little tip to mention – upgrading to the new major version make sure… gone now. mysql user removed I’m not sure if this one is done by RedHat uninstall script or MySQL install script but simply I find no mysql user after upgrade. MySQL Does not start after upgrade…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… ships by default with many server installations) or a system administration mistake to delete one of MySQL‘s log or data files…-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as contention that crosses a tipping point… down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in…
Comment: Choosing innodb_buffer_pool_size
January 24, 2010 By 39 Comments
I’m asking your tip to prevent another issue like the one happen to our …. Quite everything copied fine expecially the mysql directory… Cool (I thought) now with a working mysql installation + the exact logs file size + all… crash recovery? Our server is similar. Thank you for any tip and or answer… and also any help if you have…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… well known with customers like Google, Yahoo, LiveJournal,Technocarati MySQL has installations with many billions of rows and delivers great performance. What… large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO requests one by… with large data sets and complex queries here are few tips Try to fit data set you’re working with in…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…/entry/server_defaults_changes_in_mysql , in documentation now at http://dev.mysql.com/doc/refman/5.6… have some small value but efficiency on smaller installations (the most common case) makes it desirable not…Dimitri (and our QA) use, accompanied by more tips about how and when to change the values….
Comment: About This Blog
December 13, 2006 By 48 Comments
… new to MySQL and was hoping you might be able to give me some tips for optimizing it. I am using MySQL for data mining (i.e. reads, no inserts, updates etc.) and have it installed… am finding queries take a long time (12-24hrs). Any tips? Ps. Its indexed.
Comment: What to tune in MySQL Server after installation
September 30, 2006 By 118 Comments
…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 howto tutorial scalability SQL tips…
Comment: Choosing innodb_buffer_pool_size
September 9, 2011 By 39 Comments
… 16GB RAM. Have installed mysql and it shows innodb_buffer_pool_size=1173G. Tried increasing it to 2048M and restarted mysql. When I checked the status of mysql it is not Running. Again if go back to 1173M it is functioning properly. Any troubleshooting tips would be…
Comment: What to tune in MySQL Server after installation
July 23, 2007 By 118 Comments
[...] What to tune in MySQL Server after installation 10 Tips for Optimizing MySQL Queries (That don’t suck) [...]
