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
    #mysql #time
    Sat, Mar 11, 2023 7:08pm -08:00
  • How To Get ohlc Value In mysql (www.oodlestechnologies.com)
    #mysql #ohlc #stocks
    Thu, May 14, 2020 2:23pm -07:00
  • Dumping and importing from/to MySQL in an UTF-8 safe way - makandra dev (makandracards.com)
    #mysql
    Fri, Aug 24, 2018 5:32pm -07:00
  • MySQL 8.0: Changes and Expectations for Developers (www.soliantconsulting.com)
    #mysql
    Thu, Apr 5, 2018 9:33am -07:00
  • TOP 10 MySQL 8.0 features for DBAs & OPS – lefred's blog: tribulations of a MySQL Evangelist (lefred.be)
    #mysql
    Sat, Feb 17, 2018 7:26am -08:00
  • ProxySQL | Scaling with ProxySQL Query Cache (www.proxysql.com)
    #mysql #cache #querycache #proxysql
    Sat, Feb 17, 2018 7:26am -08:00
  • 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;"
    #mysql
    Sun, Jan 31, 2016 4:02pm -08:00
  • How to support full Unicode in MySQL databases (mathiasbynens.be)
    #mysql #utf8 #emoji #utf8mb4 #unicode
    Tue, Dec 8, 2015 9:32am -08:00
  • How We Partitioned Airbnb's Main Database in Two Weeks - Airbnb Engineering (nerds.airbnb.com)
    #scaling #ops #database #mysql
    Tue, Oct 6, 2015 10:13pm -07:00
  • PDO utf-8 character issue (stackoverflow.com)
    #encoding #mysql #pdo #php #utf8
    Sat, Jun 15, 2013 3:16pm -07:00
  • MySQL in the cloud at Airbnb (nerds.airbnb.com)
    #airbnb #amazon #ec2 #mysql
    Sun, Jun 2, 2013 8:53am -07:00
  • 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.
    #databases #mysql #replication
    Sat, May 25, 2013 5:38pm -07:00
  • Converting MySQL to PostgreSQL (en.wikibooks.org)
    #convert #database #mysql #postgres #tips #tutorial
    Sun, Feb 10, 2013 3:17pm -08:00
  • Taps for Easy Database Transfers (adam.heroku.com)
    #database #mysql #postgres #sqlite #taps #tools #utilities
    Sun, Feb 10, 2013 3:16pm -08:00
  • Loading half a billion rows into MySQL (derwiki.tumblr.com)
    #db #mysql #performance #scaling #tips
    Tue, Jun 5, 2012 2:07pm -07:00
  • (My)SQL mistakes. Do you use GROUP BY correctly? (www.dbasquare.com)
    #db #mysql #sql
    Wed, May 16, 2012 8:09am -07:00
  • 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.
    #couchdb #hackernews #mysql
    Thu, May 10, 2012 10:39am -07:00
  • Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server (yoshinorimatsunobu.blogspot.com)
    #mysql #nosql #scaling
    Fri, Mar 16, 2012 4:51am -07:00
  • MySQL/Galera is synchronous multi-master cluster for MySQL/InnoDB database (codership.com)
    #database #multi-master #mysql #replication
    Mon, Feb 20, 2012 7:58am -08:00
  • Introducing Additional Slaves to an Existing Replication Environment (dev.mysql.com)
    #mysql #replication
    Fri, Sep 30, 2011 10:33pm -07:00
next

Hi, I'm Aaron Parecki, Senior Security Architect 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 and dabble in product design.

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.

  • Security Architect at Okta
  • IndieWebCamp Founder
  • OAuth WG 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-2023 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