ProjectGoals - vitess - Vitess project goals - Scaling MySQL databases for the web - Google Project Hosting
12 weeks ago by rcrowley
YouTube, riffing on MySQL. Perhaps most interesting because they use Go.
mysql
ha
golang
12 weeks ago by rcrowley
MySQL Sandbox
january 2012 by rcrowley
Tool Ryan pointed me to for easily installing multiple MySQL servers.
mysql
mysqlsandbox
packaging
january 2012 by rcrowley
The MySQL “swap insanity” problem and the effects of the NUMA architecture « Jeremy Cole
january 2012 by rcrowley
For reference. I always lose track of this one.
mysql
linux
numa
swap
january 2012 by rcrowley
mihasya/ishmael - GitHub
october 2011 by rcrowley
(Dumping GitHub watches into Pinboard.)
GUI for mk-query-digest from Maatkit. Helps find whale-sized queries (get it?) against MySQL servers.
mysql
maatkit
GUI for mk-query-digest from Maatkit. Helps find whale-sized queries (get it?) against MySQL servers.
october 2011 by rcrowley
Poor man’s query logging - MySQL Performance Blog
september 2011 by rcrowley
For to tcpdump MySQL. Remember to connect via TCP, not Unix-domain.
mysql
tcpdump
logging
september 2011 by rcrowley
DBSlayer - Trac
december 2010 by rcrowley
MySQL connection pooling proxy that exposes an HTTP JSON API rather than the MySQL protocol.
mysql
db
http
json
proxy
december 2010 by rcrowley
Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server
october 2010 by rcrowley
This is "NoSQL" done incredibly right.
mysql
ndbapi
october 2010 by rcrowley
jcole’s weblog: Jeremy Cole’s take on life. » Blog Archive » The MySQL “swap insanity” problem and the effects of the NUMA architecture
october 2010 by rcrowley
Worth it for the overview of the NUMA architecture alone.
linux
numa
kernel
mysql
swap
october 2010 by rcrowley
Abusing MySQL: The Federated Engine « mikhail panchenko / blog
february 2010 by rcrowley
If I ever stumble into the federated engine, this seems like the way to do it. I presume the particular style of replication doesn't matter.
mysql
federated
replication
february 2010 by rcrowley
firstworks: sql relay - sqlrelay persistent database connection pool pooling proxy load balance balancing odbc oracle mysql msql postgresql sybase db2 interbase sqlite access c++ perl DBD DBI python php zope ruby tcl java jni unix linux persistant
september 2009 by rcrowley
Like MySQL-Proxy but (importantly) not.
mysql
sqlrelay
mysqlproxy
db
loadbalancer
september 2009 by rcrowley
jcole’s weblog: Jeremy Cole’s take on life. » Proposal for Constraining Memory Usage
august 2009 by rcrowley
MySQL memory usage cheat sheet.
mysql
db
memory
august 2009 by rcrowley
http://faemalia.net/mysqlUtils/dbmon.pl
july 2009 by rcrowley
Probably not a bad idea to start running this.
dbmon
perl
db
mysql
monitoring
july 2009 by rcrowley
How much overhead is caused by on disk temporary tables | MySQL Performance Blog
april 2009 by rcrowley
"As you can see I'm using ORDER BY NULL clause as otherwise MySQL will sort the data after performing group by which is overhead we're not looking to measure. This is actually good trick to use for cases when you do not need GROUP BY results sorted - it can significantly improve performance in some cases."
mysql
io
april 2009 by rcrowley
mySQL DBA: Walking an INNODB table Fast
march 2009 by rcrowley
Been doing about the same thing except selecting by a prefix of the binary(20) primary key.
mysql
innodb
db
march 2009 by rcrowley
~jk Async MySQL Queries with C-API
february 2009 by rcrowley
This is seemingly the least hacky way to do asynchronous MySQL from C. It works beautifully!
c
mysql
async
february 2009 by rcrowley
percona-xtradb:innodb_io [Percona DokuWiki]
february 2009 by rcrowley
I want innodb_write_io_threads.
innodb
xtradb
percona
mysql
february 2009 by rcrowley
Opening Tables scalability | MySQL Performance Blog
january 2009 by rcrowley
Noah's hunch appears more and more correct. Altering the ulimit -n line in mysqld_safe allows you to set high table_cache, which will default open_files_limit to 2 * table_cache (provided you don't try to set it yourself).
mysql
january 2009 by rcrowley
MySQL Performance Tuning and Benchmarking
january 2009 by rcrowley
Page 10 mentions a "profiling" mode I've never heard of before.
mysql
innodb
myisam
profiling
january 2009 by rcrowley
Screenshots of improved MySQL Cacti templates at Xaprb
january 2009 by rcrowley
Don't use Cacti. If you have to, though, use these.
cacti
rrd
mysql
monitoring
january 2009 by rcrowley
High-Performance Click Analysis with MySQL | MySQL Performance Blog
december 2008 by rcrowley
Other ways to skin my cat.
mysql
aggregation
december 2008 by rcrowley
http://www.wafflegrid.com/
november 2008 by rcrowley
An L2 cache using remote memory for InnoDB. Maybe instead of manually asking memcached for things before going to the database, one could just ask the database and repurpose the memcached instances already available for WaffleGrid. This definitely introduces some inefficiencies but essentially teaches memcached to speak SQL.
memcached
mysql
innodb
wafflegrid
cache
november 2008 by rcrowley
MySQL :: MySQL native driver for PHP - mysqlnd
november 2008 by rcrowley
I hear there's a way to do asynchronous MySQL queries in here. Must have a look.
mysql
php
async
november 2008 by rcrowley
MySQL :: MySQL 5.0 Reference Manual :: 13.2.11 InnoDB Performance Tuning Tips
september 2008 by rcrowley
"If you can afford the loss of some of the latest committed transactions if a crash occurs, you can set the innodb_flush_log_at_trx_commit parameter to 0. InnoDB tries to flush the log once per second anyway, although the flush is not guaranteed."
Oh lord, help me.
innodb
mysql
performance
db
Oh lord, help me.
september 2008 by rcrowley
Useful MySQL Stuff
september 2008 by rcrowley
The Cacti monitoring stuff could make me happy.
cacti
mysql
monitoring
db
september 2008 by rcrowley
Applied Partitioning And Scaling Your Database System Presentation
may 2008 by rcrowley
I had to upload this to look at it. Good stuff on making MySQL play nicely with large tables.
mysql
db
may 2008 by rcrowley
MySQL :: MySQL 5.0 Reference Manual :: 12.2.4.3 INSERT ... ON DUPLICATE KEY UPDATE Syntax
april 2008 by rcrowley
ON DUPLICATE KEY UPDATE your face
mysql
sql
db
insert
update
index
unique
primarykey
april 2008 by rcrowley
www.richarddcrowley.org
march 2006 by rcrowley
Portfolio and testing ground of web programmer Richard Crowley of St. Louis, MO.
programming
web
html
xhtml
css
php
gentoo
linux
mysql
crowley
washu
wustl
blog
tech
technology
richardcrowley
me
rcrowley
richarddcrowley
march 2006 by rcrowley
related tags
aggregation ⊕ apache ⊕ api ⊕ async ⊕ audit ⊕ backup ⊕ blog ⊕ brianaker ⊕ c ⊕ c++ ⊕ cache ⊕ caching ⊕ cacti ⊕ conference ⊕ crowley ⊕ css ⊕ db ⊕ dbmon ⊕ ddos ⊕ dns ⊕ drizzle ⊕ dvp ⊕ federated ⊕ flickr ⊕ ganglia ⊕ gentoo ⊕ golang ⊕ ha ⊕ html ⊕ http ⊕ index ⊕ innodb ⊕ insert ⊕ io ⊕ johnallspaw ⊕ json ⊕ kernel ⊕ lamp ⊕ linux ⊕ loadaverage ⊕ loadbalancer ⊕ logging ⊕ maatkit ⊕ master ⊕ master-master ⊕ mastermaster ⊕ me ⊕ memcached ⊕ memory ⊕ mongodb ⊕ monitoring ⊕ myisam ⊕ mysql ⊖ mysql++ ⊕ mysqlar ⊕ mysqlard ⊕ mysqlproxy ⊕ mysqlsandbox ⊕ ndbapi ⊕ netstat ⊕ numa ⊕ opensolaris ⊕ ops ⊕ packaging ⊕ pbxt ⊕ percona ⊕ performance ⊕ perl ⊕ php ⊕ postgresql ⊕ powerdns ⊕ primarykey ⊕ profiling ⊕ programming ⊕ proxy ⊕ python ⊕ rails ⊕ rcrowley ⊕ redundancy ⊕ replication ⊕ richardcrowley ⊕ richarddcrowley ⊕ rrd ⊕ sharding ⊕ slides ⊕ socket ⊕ sphinx ⊕ sql ⊕ sqlrelay ⊕ swap ⊕ tcpdump ⊕ tech ⊕ technology ⊕ tokudb ⊕ unique ⊕ update ⊕ wafflegrid ⊕ washu ⊕ web ⊕ wustl ⊕ xhtml ⊕ xtrabackup ⊕ xtradb ⊕ zfs ⊕Copy this bookmark: