A Fluid Grid

A blog about water, spatial analysis, Open Source, and anything else

Thursday, March 24, 2011

Some notes about MySQL configuration

MySQL is so easy to just "get running" and my applications are often quite basic. So, I only get around to actually "configuring" MySQL every couple of years, during which time I've forgotten the guidelines. So this is this year's refresher reading list:

http://www.mysqlperformanceblog.com/2006/05/17/mysql-server-memory-usage/

http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html
http://www.mysqlperformanceblog.com/2011/03/21/what-causes-downtime-in-mysql/
http://www.mysqlperformanceblog.com/2011/02/17/how-to-syntax-check-your-my-cnf-file/
http://fts.ifac.cnr.it/cgi-bin/dwww/usr/share/doc/mysql-server-5.0/examples/my-large.cnf.gz
http://mysqldatabaseadministration.blogspot.com/2005/11/mysql-5-optimization-and-tuning-guide.html
http://brian.moonspot.net/2008/05/06/example-mycnf-files/
http://forge.mysql.com/tools/tool.php?id=138
http://forge.mysql.com/tools/tool.php?id=137
http://www.pythian.com/news/1067/difference-between-innodb_data_file_path-and-innodb_file_per_table/
http://forum.percona.com/index.php/t/1493/

More to follow...


Posted by John Z at 12:22 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Search

About Me

John Z
I grew up in Youngstown, NY with a deep respect and fascination for the Laurentian Great Lakes and all things water. After a dabbling with interests in sports medicine, and being a professional potter, undergraduate work at CU - Boulder led me back to my passion for water and science. Undergrad degree in tow I worked as an aquatic toxicologist and GIS/RS analyst in the Front Range. Graduate work at Wisconsin – Milwaukee fed my curiosity about the Great Lakes extended my interests in data analysis and management. My projects involved climate change modeling, phytoplankton physiology, riding research vessels in the frigid Lake Michigan, managing an environmental database development effort, and of course GIS/RS. My next job found me in Fairfax, Virginia where I was able to continue with most of my professional interests. The chaos of Greater D.C and a need to be closer to family brought us to Portland, Maine. I am still passionate about all things water, environmental, and spatial and am a strong advocate for Open Source software (for a variety of reasons). I lead software development and data management projects for Tetra Tech and focus on things geospatial.
View my complete profile

Watched Projects

  • GDAL/OGR
  • Geoserver
  • GeoWebCache
  • Mapnik
  • Mapserver
  • Maptiler
  • OSGeo
  • PostGIS

Blog List

  • James Fee GIS Blog
    25 Years of SRTM
    3 months ago
  • Surveying, Mapping and GIS
    EPA ARRA Mapper
    14 years ago
  • Fuzzy Tolerance

Links

  • North Redoubt

Blog Archive

  • ▼  2011 (10)
    • ►  May (1)
    • ▼  March (3)
      • Free citation managers
      • Some notes about MySQL configuration
      • Some notes about MySQL configuration
    • ►  February (6)
  • ►  2009 (6)
    • ►  June (1)
    • ►  April (3)
    • ►  March (2)
  • ►  2007 (2)
    • ►  December (2)
Picture Window theme. Powered by Blogger.