Profile_bird

Hey there! MySQLExpert is using Twitter.

Twitter is a free service that lets you keep in touch with people through the exchange of quick, frequent answers to one simple question: What's happening? Join today to start receiving MySQLExpert's tweets.

Already using Twitter
from your phone? Click here.

MySQLExpert

  1. Just because the database can perform an operation, does not mean it's efficient. ORDER BY RAND() for example. There are better code ways! 8:21 AM Nov 25th from web
  2. Verifying MySQL db schema's in dev/test/prod or large replication topologies made easier with Schema Sync - http://schemasync.org 10:40 AM Nov 24th from web
  3. If you want to poll a large network for any MySQL servers, try polling the default port $nc -z hostname 3306 $?=0 indicates open MySQL port 11:30 AM Nov 23rd from web
  4. Plenty of great MySQL and MySQL related content being discussed at http://opensqlcamp.org in Portland #opensqlcamp 11:33 AM Nov 15th from web
  5. skip-name-resolve is a valuable parameter to know about. Eliminating DNS lookups can improve performance. http://bit.ly/skip_name_res... 10:17 AM Oct 7th from web
  6. SHOW PROCESSLIST can also provide valuable host stats. You should monitor per host connections,sleeping,max sleeping and >95pct sleep. 9:00 AM Oct 6th from web
  7. Know the different states in the SHOW PROCESSLIST that affect your performance. This article provides a good overview. http://bit.ly/mf285 9:18 PM Oct 4th from web
  8. The SHOW FULL PROCESSLIST provides a snapshot of current SQL activity.While not a complete transaction view, valuable info can be determined 6:36 PM Sep 28th from web
  9. EXPLAIN is an essential tool for MySQL developers. Check out this detailed presentation -- http://www.slideshare.net/l... 4:49 PM Sep 24th from web
  10. If you don't know what QEP means,if you don't use or know how to interpret EXPLAIN output,now is the time to start. An essential MySQL tool. 9:12 AM Sep 16th from web
  11. How consistent is your replication environment at crash time? innodb_support_xa, sync_binlog are two important and often unset variables 9:07 AM Sep 15th from web
  12. A very neat and simple 1 line command to determine per table INSERT/UPDATE/DELETE statistics on your server -- http://tr.im/mysql_dml_stats 5:13 PM Sep 9th from web
  13. The amount of Innodb auto recovery can be calculated with 'Log flushed up to' - 'Last checkpoint at'.Found in LOG part of SHOW INNODB STATUS 5:57 PM Sep 3rd from web
  14. Innodb does perform an automatic recovery on MySQL restart. The factors of how long include current load and innodb_log_file_size*group. 2:02 PM Aug 28th from web
  15. MyISAM does not perform automatic data recovery after a mysqld/server crash. A common option used is --myisam-recover=FORCE,BACKUP 10:00 AM Aug 19th from web
  16. Correct @chuckh1958, a partial index is the left most portion of a given character column. Read more at http://tr.im/mysql_index_types 5:41 PM Jul 22nd from web
  17. Understanding Different MySQL Index Implementations. Read more at http://tr.im/mysql_index_types 5:40 PM Jul 22nd from web
  18. Do you know the difference between single column indexes, concatenated indexes,covering indexes and partial indexes.Each affect performance. 10:13 AM Jul 20th from web
  19. Be sure to check out @MySQL_Librarian for a good collection of valuable reference and reading material. -- http://tr.im/mysql_librarian 9:38 AM Jul 16th from web
  20. What is your DR plan for disk full? Be sure to include MySQL binlog partition full in your scenarios. See http://tr.im/mysqlbinlogfull 1:04 AM Jul 16th from web
  • Name Ronald Bradford
  • Location New York
  • Web http://mysql-expe...
  • Bio Get great learning tips from MySQL Expert Ronald Bradford
12 Following 205 Followers 20 Listed
Venu Anuganti CoTweet Sakila The Librarian Ronald Bradford HootSuite MySQLConf MySQL Conference MySQL Community Team Oracle Sun Microsystems planetmysql Ronald Bradford