DB Tuner 6.x-1.0-alpha2

Date Added: June 01, 2013 | Visits: 306

Report Broken Link
Printer Friendly Version

Product Homepage
Download (45 downloads)

Wondering why your views run so slow? Why after switching to InnoDB, MySQL isn't running any better? This module has the answers!IndexesIt will show what CCK columns get used in a view filter or relationship and give you the option to add an index on it so the views query will run faster. Also can add indexes to core modules that could use one.EngineAbility to convert your database from MyISAM to InnoDB in order to eliminate table locks on data writes.CollationAre half your tables latin1_swedish_ci and the other half utf8_general_ci? Use this to change them all to utf8_general_ci.MySQL TunerHave you never edited your my.conf file? This will give you hints at what values to tweak in order to get MySQL running better. Special thanks to MySQL Tuner, since this part of the module is a port of that project.Future Plans: * Figure out which experimental indexes are good & which ones are bad * #798756: Better index suggestions with filters and sorts. Manage Multi Column Indexes * #799230: Run explain on every views query * #799236: Run explain on every query in the slow query log * #817688: Engine Selection Per Table; Suggest you put site into maintenance mode

Requirements: No special requirements

Platforms: PHP

Keyword: Experimental, Explain, Figure, Index, Indexes, Innodb, Module, Mysql, Order, Plans, Query, Running, Tweak, Values, Views

Users rating: 0/10

License: Freeware

Size: 20.48 KB

USER REVIEWS

More Reviews or Write Review

DB TUNER RELATED

Modules - Module Display Order Matches Sort Order in Admin 1.0 It's kind of confusing, and since in the case of the Order Total modules it actually determines the order in which order prices are calculated, this can be a pain in the neck. So I made a small tweak and now all modules in the Admin>Modules...
Libraries - What 1.01 What is a Perl module to find out about running services. SYNOPSIS $what = What->new( Host => my.domain.org, Port => 28, ); $what->mta; $what->mta_version; $what->mta_banner; The What class is interface to classes providing...	27.65 KB
Database Tools - LSM Explain Plan 1.0 LSM Explain Plan can retrieve the explanation of the execution of a given MySQL database SELECT query and compute a relative performance factor.LSM Explain Plan executes an EXPLAIN query to retrieve the information about the tables, columns,...	61.44 KB
Modules - Views Explain 6.x-1.x-de Views Explain is a very simple module that runs EXPLAIN on the query generated by views, and appends that information to the views preview table.	10 KB
Database Tools - PHP Generator for MySQL 7.10 PHP Generator for MySQL is a freeware but powerful MySQL GUI frontend that allows you to generate high-quality MySQL PHP scripts for the selected tables, views and queries for the further working with these objects through the web. Key features...	5.29 KB
Libraries - XML::DOM::XML_Base 0.02 XML::DOM::XML_Base Perl module can apply xml:base to attribute values. SYNOPSIS use XML::DOM::XML_Base; my $parser = XML::DOM::Parser->new(); my $xml = qq( ); # build the DOM my $dom = $parser->parse( $xml ); # get some...	3.07 KB
Libraries - Scalar::MultiValue 0.03 Scalar::MultiValue is a Perl module to create a SCALAR with multiple values. This module create a SCALAR with multiple values, where this values can be randomic or can change by a defined period. USAGE: With a period of 2: my $s = new...	3.07 KB
Libraries - Math::Logic::Predicate 0.03 Math::Logic::Predicate is a Perl module to manage and query a predicate assertion database. SYNOPSIS use Math::Logic::Predicate; $db = new Math::Logic::Predicate; # Enter some predicates into the database $db->add(<	17.41 KB
Libraries - Wily::Connect 0.02 Wily::Connect is a Perl module that connects to a running Wily text editor. SYNOPSIS use Wily::Connect; my $wily_socket = Wily::Connect::connect(); The connect sub connects to wily this involves creating a unix domain socket, listening on...	21.5 KB
Libraries - Be::Query 0.1 Be::Query is a Perl module to do a query for a given filesystem. SYNOPSIS use Be::Query; @files = Be::Query::Query($filesystem, $query); do a Query for a given filesystem USAGE @files = Be::Query::Query("/boot", "name=lib*.so");...	3.07 KB

NEW DOWNLOADS IN SCRIPTS, MODULES

Scripts - Free Ecommerce website creator 1.2 Free Ecommerce website creator is a free PHP shop creating script. This allows you to put a online shop on your own website. Create your own free ecommerce website for Your Business. Create an online shop using easyGUI online shop creator. The...	1.44 KB
Scripts - MochiGames PHP Script ZDR 1.00 MochiGames PHP Script ZDR is web site, ready for use, for flash games. These flash games are downloaded automatically by "MochiGames PHP Script ZDR" from MochiGames media. The use of the games is free, you can use your own Mochi Publisher ID and...	368.54 KB
Scripts - Php Chat 2.0 Add a free php site, single sign-on and multiple skins, 100% free 1. Server Modes: The chat server has paid mode and free mode. If the free chat mode, a free chat room will be assigned to your website with your domain as the room name. 2....	938.87 KB
Scripts - Nibbleblog 3.0.1 Nibbleblog it's a powerful engine for creation and manipulation of BLOG's completely free. Very simple to install and configure (Only 1 step). The database used is based on XML files and this way it is not necessary to use MySQL or similar DBMS....	371.09 KB
Scripts - PHP File Manager \| CloudOsys 2.9b8 CloudOsys is a PHP file manager, a tool that allows your visitors upload files such as media content directly to your website. Your visitors will upload files directly to your website, where they can share and comment on them. Through cloud...	1.41 MB
Modules - TinyMCE Node Picker 6.x-2.1 This module will de discontinued and replaced with Node Picker as soon as a stable release is available.TinyMCE Node Picker provides a button in TinyMCE that displays a list of links to content. Choosing a link inserts it into the editor.The...	20.48 KB
Modules - Fapilicious 5.x-1.x-de Fapilicious is a collection of FormAPI goodies.I hope to make it a repository of reusable FormAPI trickery and short cuts. Currently it has small collection of powerful FormAPI element validators.Please submit your favorite tricks as patches so we...	10 KB
Modules - Donation Goals 6.x-1.x-de The Donation Goals module lets you create nodes of the type "Donation Goal." These goals allow you to set an amount of money you'll need for whatever you're saving up for. Visitors of the site can then donate money through PayPal. Once the target...	20.48 KB
Modules - Plica Twitter 1.0.1 Plica TwitterInstallation : * Download, unzip, and install plugin dir in /wp-content/plugins * Activate * All right now	10 KB
Modules - Page Array 5.x-1.x-de The pagearray module is a small (single function) helper module that can be used whenever there is a need to load the output of any Drupal path in data form. Based on the code in index.php, Page Array bypasses the theme('page') call, instead...	10 KB

Windows Software	BeOS Software
Macintosh Software	Linux Software
PDA Software	OS/2 Software
Mobile Software	Scripts