 Your new post is loading...
Your new post is loading...
|
Scooped by
Mickael Ruau
March 8, 2013 6:11 AM
|
Percona Live is an intensive two-day MySQL summit on Oct 24th and 25th, 2011 in London.
|
|
Scooped by
Mickael Ruau
March 8, 2013 6:11 AM
|
Percona Live is an intensive two-day MySQL summit on Oct 24th and 25th, 2011 in London.
|
|
Scooped by
Mickael Ruau
March 8, 2013 6:08 AM
|
The slides of my talk on B+Tree Indexes and InnoDB are now available for download. This slide was presented during Percona Live London 2011. You can download the slides from here.
|
|
Scooped by
Mickael Ruau
March 8, 2013 6:06 AM
|
The more I go through others SQL, there are some common mistakes that I see developers making over and over again, so I thought why not start a series of tips that can help developers optimize their queries and avoid common pitfalls.
|
|
Scooped by
Mickael Ruau
March 8, 2013 6:05 AM
|
Although MyISAM has been the default storage engine for MySQL but its soon going to change with the release of MySQL server 5.5.
|
|
Scooped by
Mickael Ruau
March 8, 2013 6:04 AM
|
Liste de tutoriels classés par catégorie (introduction au langage PHP, environnements de travail, les bases, bonnes pratiques, xml, poo, bases de données, concepts avancés...)
|
|
Scooped by
Mickael Ruau
March 8, 2013 6:02 AM
|
I'm writing a PHP / MySQL application. PHP 5.2 / MySQL 5.1 It's rather large and there are 34 MySQL tables. I found that I had the same SQL statements with table joins being repeated in different...
|
|
Scooped by
Mickael Ruau
March 8, 2013 5:59 AM
|
|
|
Scooped by
Mickael Ruau
March 8, 2013 5:58 AM
|
Integrating MySQL stored procedures and views into PHP can go a long way towards separating web site logic and the domain
|
|
Scooped by
Mickael Ruau
March 7, 2013 11:58 AM
|
MySQL Notifier is a quick tool for Windows installations to help you manage your instances. It provides a quick way to start, stop or restart your Windows based instances. It also provides easy acc...
|
|
Scooped by
Mickael Ruau
March 7, 2013 11:57 AM
|
VISUAL EXPLAIN will be come a standard tool in your DBA toolbox but you will need later versions of both MySQL Workbench and MySQL Server. The examples here were created with Workbench 5.2.44 and M...
|
|
Scooped by
Mickael Ruau
March 7, 2013 11:56 AM
|
|
|
Scooped by
Mickael Ruau
March 6, 2013 11:19 AM
|
|
|
|
Scooped by
Mickael Ruau
March 8, 2013 6:11 AM
|
Percona Live is an intensive two-day MySQL summit on Oct 24th and 25th, 2011 in London.
|
|
Scooped by
Mickael Ruau
March 8, 2013 6:11 AM
|
Percona Live is an intensive two-day MySQL summit on Oct 24th and 25th, 2011 in London.
|
|
Scooped by
Mickael Ruau
March 8, 2013 6:08 AM
|
Indexes are a very important part of databases and are used frequently to speed up access to particular data item or items.
|
|
Scooped by
Mickael Ruau
March 8, 2013 6:06 AM
|
The default configuration file for MySQL is intended not to use many resources, because its a general purpose sort of a configuration file. The default
|
|
Scooped by
Mickael Ruau
March 8, 2013 6:04 AM
|
|
|
Scooped by
Mickael Ruau
March 8, 2013 6:02 AM
|
The most basic and most oft-repeated task that a DBA has to accomplish is to look at slow logs and filter out queries that are suboptimal, that consume lots of unnecessary resources and that hence slow down the database server.
|
|
Scooped by
Mickael Ruau
March 8, 2013 6:01 AM
|
A great talk by Jay Pipes! Must-read for DBAs and webdevs.
|
|
Scooped by
Mickael Ruau
March 8, 2013 5:59 AM
|
Thoughts on PHP, MySQL and JavaScript/AJAX Web Development
|
|
Scooped by
Mickael Ruau
March 8, 2013 5:56 AM
|
Need a simple way to manage access to your Web content? The open source Apache Web server and MySQL database have everything you need.
|
|
Scooped by
Mickael Ruau
March 7, 2013 11:58 AM
|
Stuck with bugs, performance problems, crashes, data corruption, and puzzling output? If you’re a database programmer or DBA, they’re part of your life. The trick is knowing how to quickly recover from them.
|
|
Scooped by
Mickael Ruau
March 7, 2013 11:57 AM
|
Optimizing MySQL Queries is often wrongly viewed by many DBAs as a 'dark art'. For years we have been pre-pending EXPLAIN to SELECT statements in hopes of looking into the entrails of our offered c...
|
|
Scooped by
Mickael Ruau
March 7, 2013 11:56 AM
|
MySQl 5.6.10 is easily buildable from source code. In an earilier post I discussed the differences in using pre-packaged builds versus binaries bersus source code and had a few readers ask for deta...
|
Scoop.it!
