-
Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server
- saved on: 2011-01-18
- uri: http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-story-for.html
- about: Using a MySQL "HandlerSocket" plugin, Yoshinori Matsunobu achieved a 750K requests per second on a normal box, which was slightly more performant than with a memcached server
- tags:
-
Sequel Pro — MySQL database management app for Mac OS X
- saved on: 2010-06-29
- uri: http://www.sequelpro.com/
- about: A nifty and very usable MySQL desktop client for OSX.
- tags:
-
maatkit - Project Hosting on Google Code
- saved on: 2010-01-13
- uri: http://code.google.com/p/maatkit/
- about: Maatkit is a package which contains high-quality command-line tools for MySQL. The tools enable power users of MySQL to do their work more safely and quickly by relying on tested software instead of scripting things themselves. The toolkit includes functionality such as table checksums, a query profiler, and a visual EXPLAIN tool, a multiprocess version of mysqldump.
- tags:
-
mysql-workbench-doctrine-plugin - Project Hosting on Google Code
- saved on: 2009-11-26
- uri: http://code.google.com/p/mysql-workbench-doctrine-plugin/
- about: A MySQL workbench plugin, for designing Doctrine models from within MySQL workbench
- tags:
-
Jet Profiler for MySQL
- saved on: 2009-02-13
- uri: http://www.jetprofiler.com/
- about: "Jet Profiler for MySQL is real-time query performance and diagnostics tool for the MySQL database server". I love the Query ratings feature and the live query observation - should replace the weak use of MySQL proxy.
- tags:
-
Sphinx - Free open-source SQL full-text search engine
- saved on: 2008-02-16
- uri: http://www.sphinxsearch.com/about.html
- about: Sphinx is a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications. Sphinx was specially designed to integrate well with SQL databases and scripting languages. Currently built-in data sources support fetching data either via direct connection to MySQL or PostgreSQL, or using XML pipe mechanism (a pipe to indexer in special XML-based format which Sphinx recognizes).
- tags:
-
Database replication lag | Dries Buytaert
- saved on: 2007-08-25
- uri: http://buytaert.net/database-replication-lag
- about: Consider the following pseudo-code: $nid = node_save($data); $node = node_load($nid); Because node_save() executes a mutator query (an INSERT or UPDATE statement) is has to be executed on the master, so the master can propagate the changes to the slaves. Because node_load() uses a read-only query, it can go to the master or any of the available slaves. Because of the lack of synchronization between master and slaves, there is one obvious caveat: when we execute node_load() the slaves might not have been updated.
- tags:
-
Using Flex, PHP, and JSON to Modify a MySQL Database
- saved on: 2007-08-07
- uri: http://blog.paranoidferret.com/?p=43
- about: This tutorial should show a decent way to send data in a database to and from flex to php using json.
- tags:
-
mysql-filesystem-engine - Google Code
- saved on: 2007-05-03
- uri: http://code.google.com/p/mysql-filesystem-engine/
- about: This is a project for the MySQL Filesystem storage engine. It translates normal files on your server into relational tables inside of MySQL.
- tags:
-
~jk ORDER BY RAND()
- saved on: 2007-02-28
- uri: http://jan.kneschke.de/2007/2/15/order-by-rand
- about: If you read the MySQL manual you might have seen the ORDER BY RAND() to randomize the the rows and using the LIMIT 1 to just take one of the rows.
- tags:
-
Storing Passwords in MySQL
- saved on: 2007-01-25
- uri: http://mysqldatabaseadministration.blogspot.com/2006/08/storing-passwords-in-mysql.html
- about: Securing plain text passwords in MySQL is NEVER a good idea. As a DBA you should take great care in protecting the users' information. Fortunately MySQL provides you with several options to protect passwords.
- tags:
-
Conseils pour l'amélioration des performances InnoDB
- saved on: 2007-01-24
- uri: http://dev.mysql.com/doc/refman/5.0/fr/innodb-tuning.html
- about: Quelques conseils pour améliorer les perfs InnoDB
- tags:
-
ARC: ARC - RDF and SPARQL for PHP developers
- saved on: 2006-08-13
- uri: http://arc.web-semantics.org/home
- about: ARC facilitates the integration of RDF and SPARQL functionality in PHP/MySQL-driven frameworks.
- tags:
-
OpenMSS :: View topic - Howto install a webserver, php and mysql
- saved on: 2006-08-09
- uri: http://www.openmss.org/forum/viewtopic.php?p=1735
- about: How to build a linux + lighhttpd + PHP5 + MySQL platform over a simple Mactor Shared Storage network disk.
- tags:
-
Tutorial: ISP-style Email Service with Debian-Sarge and Postfix 2.1
- saved on: 2006-04-19
- uri: http://workaround.org/articles/ispmail-sarge/
- about: Un système de mails complet avec des utilisateurs virtuels gérés par MySQL
- tags: