46°F

Aaron Parecki

  • Articles
  • Notes
  • Photos

#MySQL

  • Aaron Parecki
    🤯 TIL MySQL is aware of daylight savings time, and considers any times between 2am-3am when the clocks skip forward an invalid date!

    In one session, it might throw an error, and in another session, it might store 3:00am instead of 2:05! 🤯
    Portland, Oregon, USA • 46°F
    27 likes 2 reposts 12 replies
    Sat, Mar 11, 2023 7:08pm -08:00 #mysql #time #til
  • How To Get ohlc Value In mysql (www.oodlestechnologies.com)
    Thu, May 14, 2020 2:23pm -07:00 #mysql #ohlc #stocks
  • Dumping and importing from/to MySQL in an UTF-8 safe way - makandra dev (makandracards.com)
    Fri, Aug 24, 2018 5:32pm -07:00 #mysql
  • MySQL 8.0: Changes and Expectations for Developers (www.soliantconsulting.com)
    Thu, Apr 5, 2018 9:33am -07:00 #mysql
  • TOP 10 MySQL 8.0 features for DBAs & OPS – lefred's blog: tribulations of a MySQL Evangelist (lefred.be)
    Sat, Feb 17, 2018 7:26am -08:00 #mysql
  • ProxySQL | Scaling with ProxySQL Query Cache (www.proxysql.com)
    Sat, Feb 17, 2018 7:26am -08:00 #mysql #cache #querycache #proxysql
  • Finding out largest tables on MySQL Server - MySQL Performance Blog (www.percona.com)
    "SELECT CONCAT(table_schema, '.', table_name),
           CONCAT(ROUND(table_rows / 1000000, 2), 'M')                                    rows,
           CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G')                    DATA,
           CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G')                   idx,
           CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size,
           ROUND(index_length / data_length, 2)                                           idxfrac
    FROM   information_schema.TABLES
    ORDER  BY data_length + index_length DESC
    LIMIT  10;"
    Sun, Jan 31, 2016 4:02pm -08:00 #mysql
  • How to support full Unicode in MySQL databases (mathiasbynens.be)
    Tue, Dec 8, 2015 9:32am -08:00 #mysql #utf8 #emoji #utf8mb4 #unicode
  • How We Partitioned Airbnb's Main Database in Two Weeks - Airbnb Engineering (nerds.airbnb.com)
    Tue, Oct 6, 2015 10:13pm -07:00 #scaling #ops #database #mysql
  • PDO utf-8 character issue (stackoverflow.com)
    Sat, Jun 15, 2013 3:16pm -07:00 #encoding #mysql #pdo #php #utf8
  • MySQL in the cloud at Airbnb (nerds.airbnb.com)
    Sun, Jun 2, 2013 8:53am -07:00 #airbnb #amazon #ec2 #mysql
  • Mysql slave server-id selection (www.semicomplete.com)
    Two slaves with the same server id will replicate successfully, but when they reach the end of the master's binary log, something freaks out and forces them to disconnect. This causes both slaves to reconnect, sync (no data needed), and have the connection die off quickly again. The result of this is rapid connection/disconnection by both slaves driving the load to 1+ on both slaves, and to around .3 on the master even in a completely idle system. This is bad. Therefore, server id collisions are bad.
    Sat, May 25, 2013 5:38pm -07:00 #databases #mysql #replication
  • Converting MySQL to PostgreSQL (en.wikibooks.org)
    Sun, Feb 10, 2013 3:17pm -08:00 #convert #database #mysql #postgres #tips #tutorial
  • Taps for Easy Database Transfers (adam.heroku.com)
    Sun, Feb 10, 2013 3:16pm -08:00 #database #mysql #postgres #sqlite #taps #tools #utilities
  • Loading half a billion rows into MySQL (derwiki.tumblr.com)
    Tue, Jun 5, 2012 2:07pm -07:00 #db #mysql #performance #scaling #tips
  • (My)SQL mistakes. Do you use GROUP BY correctly? (www.dbasquare.com)
    Wed, May 16, 2012 8:09am -07:00 #db #mysql #sql
  • Goodbye, CouchDB (saucelabs.com)
    Here at Sauce Labs, we recently celebrated the completion of a significant project to improve our service uptime and reliability, as we transitioned the last of our CouchDB databases to MySQL.
    Thu, May 10, 2012 10:39am -07:00 #couchdb #hackernews #mysql
  • Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server (yoshinorimatsunobu.blogspot.com)
    Fri, Mar 16, 2012 4:51am -07:00 #mysql #nosql #scaling
  • MySQL/Galera is synchronous multi-master cluster for MySQL/InnoDB database (codership.com)
    Mon, Feb 20, 2012 7:58am -08:00 #database #multi-master #mysql #replication
  • Introducing Additional Slaves to an Existing Replication Environment (dev.mysql.com)
    Fri, Sep 30, 2011 10:33pm -07:00 #mysql #replication
older

Hi, I'm Aaron Parecki, Director of Identity Standards at Okta, and co-founder of IndieWebCamp. I maintain oauth.net, write and consult about OAuth, and participate in the OAuth Working Group at the IETF. I also help people learn about video production and livestreaming. (detailed bio)

I've been tracking my location since 2008 and I wrote 100 songs in 100 days. I've spoken at conferences around the world about owning your data, OAuth, quantified self, and explained why R is a vowel. Read more.

  • Director of Identity Standards at Okta
  • IndieWebCamp Founder
  • OAuth WG Editor
  • OpenID Board Member

  • 🎥 YouTube Tutorials and Reviews
  • 🏠 We're building a triplex!
  • ⭐️ Life Stack
  • ⚙️ Home Automation
  • All
  • Articles
  • Bookmarks
  • Notes
  • Photos
  • Replies
  • Reviews
  • Trips
  • Videos
  • Contact
© 1999-2025 by Aaron Parecki. Powered by p3k. This site supports Webmention.
Except where otherwise noted, text content on this site is licensed under a Creative Commons Attribution 3.0 License.
IndieWebCamp Microformats Webmention W3C HTML5 Creative Commons
WeChat ID
aaronpk_tv