public marks

PUBLIC MARKS with tags mysql & performance

2016

2013

2012

2011

Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server

by Xavier Lacot & 2 others
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

2010

2009

drizzle.org

by webs & 1 other
The Drizzle project is building a database optimized for Cloud and Net applications. It is being designed for massive concurrency on modern multi-cpu/core architecture. The code is originally derived from MySQL.

Jet Profiler for MySQL

by Xavier Lacot & 2 others
"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.

2008

Check Your Mysql Server Performance with MySQLTuner -- Debian Admin

by camel & 1 other
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved. It’s key to remember that MySQLTuner is a script which can assist you with your server, but it is not the solution to a badly performing MySQL server. The best performance gains come from a thorough review of the queries sent to the server, and an evaluation of the MySQL server itself. A qualified developer in your application’s programming or scripting language should be able to work with a MySQL database administrator to find improvements for your server. Once the server and application are optimized well, you may need to consider hardware upgrades to the physical server itself. This is a really useful tool for helping to optimize MySQL performance.Understanding the various my.cnf variables and how they affect performance can seem really complicated but this tool takes some of the pain away and makes it easier to understand the effects of each variable.It is especially useful to be able to see the global memory usage, memory usage per thread and the maximum possible memory usage - that is really valuable information that is otherwise complex to calculate.

PUBLIC TAGS related to tag mysql

admin +   apache +   backup +   base de donnée +   bdd +   cloud +   database +   db +   dba +   debian +   dev +   development +   developpement +   docker +   innodb +   innodb_file_per_table +   javascript +   linux +   logiciel libre +   mac +   mamp +   MariaDB +   mongodb +   NoSQL +   optimisation +   optimize +   ovh +   package +   password +   percona +   performance +   php +   piwik +   postgresql +   root +   ruby +   scalability +   sgbd +   sgdb +   sql +   sqlite +   sysadmin +   tool +   tools +   twitter +   ubuntu +   unattended +   utf-8 +   web +   wordpress +  

Active users

mfaure
last mark : 29/04/2016 18:15

astrochoupe
last mark : 04/08/2013 13:35

Nicolas Lescure
last mark : 17/11/2011 08:09

Xavier Lacot
last mark : 18/01/2011 12:44

ghis
last mark : 20/10/2010 20:28

nhoizey
last mark : 30/03/2010 15:48

krachot
last mark : 12/03/2010 19:28

dzc
last mark : 18/02/2010 14:57

webs
last mark : 15/12/2009 11:35

rodo
last mark : 23/10/2009 22:03

piouPiouM
last mark : 04/10/2009 13:45

CharlyBr
last mark : 29/04/2009 15:14

camel
last mark : 09/11/2008 16:35