Home > mysql > Understanding mysqltuner Recomendations w/ Unused Catalogs

Understanding mysqltuner Recomendations w/ Unused Catalogs

October 19Hits:2
Advertisement

I have a MySQL 5.0.77 instance running with three catalogs in it.

Two of the catalogs contain all InnoDB tables and are actively used.

The third is all MyISAM and is basically unused, and is only still in the server as a precaution. Basically, it is an old version of one of the other catalogs that used to be referenced to ensure that data migration was correct.

I have been running mysqltuner periodically so I can get a decent baseline configuration before I begin real profiling on whole system.

Even though I am not querying or even opening connections to the MyISAM catalog, is its presence throwing off the mysqltuner recommendations?

For example, can I truly ignore the warnings about key_buffer_size, or will bad values for this negatively impact the whole server even when I am not really using MyISAM?

Is having this unused catalog negatively impacting the memory footprint of the server? If so, is there any way to mitigate this, other than moving the catalog somewhere else and doing a DROP?

Thanks.

Answers

If you know that the MyISAM tables are not being actively queried, not only can you ignore recommendations for key_buffer_size, you could actually lower it.

What can you do with the extra RAM you just reclaimed? One or more of the following options:

After restarting mysqld, rerun mysqltuner and evaluate the resulting recommendations. Taking key_buffer_size out of the equation is enough in your instance.

Tags:mysql

Related Articles

  • Understanding mysqltuner Recomendations w/ Unused CatalogsOctober 19

    I have a MySQL 5.0.77 instance running with three catalogs in it. Two of the catalogs contain all InnoDB tables and are actively used. The third is all MyISAM and is basically unused, and is only still in the server as a precaution. Basically, it is

  • Show processlist / Max concurrent connections seem to max out at 131January 30

    When I put my database under a load test (basically just a basic write and basic read from our app), and run show processlist; in the middle of it, there is always 131 rows in the set and that's it. I'm running a master slave with 16GB of memory on e

  • Should I increase max_connections in AWS RDS t1-micro for MySQL?May 9

    I have an AWS RDS t1-micro running MySQL 5.5. It gives me too many connections error. I checked and it allows 34 maximum connections concurrently. What I have read is that i can increase this max value by creating a DB parameter group for this Micro

  • Which hardware you suggest?June 10

    I'm completely new to buying a database hosting and I would greatly appreciate your opinion about the following situation. I just created an App and I want to go live this weekend. I want to be prepared as good as possible so I will write some statis

  • When building a catalog file against a image file in WAIK does it need to be the image you intend to deploy?December 28

    When building a catalog file against a image file in WAIK, does it need to be the image you intend to deploy? I have a unattend.xml answer file created in SIM, for WDS. I originally had a problem with it asking for locale and credentials for connecti

  • Sharing Lightroom CatalogAugust 15

    My setup is this: I have an iMac that is my main computer, running Lightroom 5. I have subscribed to Adobe Creative Cloud so that allows me to install Lightroom on another computer. I would like to have the Lightroom catalog either on a NAS/Server (o

  • How to make a large codebase easier to understand for new programmersJuly 31

    Suppose that I am developing a relatively large project. I have already documented all my classes and functions with Doxygen, however, I had an idea to put a "programmer's notes" on each source code file. The idea behind this is to explain in la

  • Pointless Code In Your SourceAugust 20

    I've heard stories of this from senior coders and I've seen some of it myself. It seems that there are more than a few instances of programmers writing pointless code. I will see things like: Method or function calls that do nothing of value. Redunda

  • How do I find what's eating up all of my system's memory? (not SuperFetch)

    How do I find what's eating up all of my system's memory? (not SuperFetch)June 17

    How does one diagnose/discover memory-related problems, if Task Manager appears to not be reporting correctly? I must have a memory leak or something -- I'm at 75% usage of my 12 GB of memory, but Task Managers listings of processes' memory usage isn

  • How do I precisely analyse the memory usage in Windows 7?

    How do I precisely analyse the memory usage in Windows 7? June 17

    How does one diagnose/discover memory-related problems, if Task Manager appears to not be reporting correctly? I must have a memory leak or something -- I'm at 75% usage of my 12 GB of memory, but Task Managers listings of processes' memory usage isn

  • Hundred of Thousands of database records and how to safely delete them?March 11

    Hi I've been asked to work on a Drupal commerce site and I'm not very familiar with this module. The idea is to use an existing database and export it to 'quickstart' a new site. I'm to keep all the products but delete all the customers and transacti

  • Windows System Image Manager can't validate my answer

    Windows System Image Manager can't validate my answerMay 24

    Problem When I do my modifications and I apply to "validate answer" I get a lot of errors In the picture you can see the WSIM version I'm using (6.2.9200), ...The errors in the picture are saying this more or less : "The configuration was n

  • Which files are cached by linux?January 18

    I understand that linux uses unused RAM to keep some files cached. But I wonder, which files it actually caches! If you take a look at free : Gesamt Belegt Frei Gemeinsam Puffer Cached Speicher: 5,8G 3,7G 2,1G 0B 259M 1,7G -/+ Puffer/Cache: 1,8G 4,0G

  • Understanding unusable documentation of reactJSFebruary 3

    I needed to get scroll position of div, so I found onScroll event in react documentation, use it in my code and in developer tool found properties that I needed. In documentation I found some words: Event names: onScroll Properties: number detail DOM

  • Overhaul Your Online Catalog For More SalesOctober 4

    Ok. You've built your site. Found a good host. Promoted your URL and submitted to search engines. You constantly trawl resources like SitePoint for the latest ways to boost traffic, generate loyalty, and build a community. But sales are still slow. W

  • Truly understanding networking?October 22

    I understand the basics of networking such as Lan and stuff. I know what many of the protocols are and how to build a client/server socket program in C. But what I really want is a very good understanding of how networks actually work. Not only from

  • Active Directory without global catalogOctober 27

    Are there any Active Directory configurations supported, where forest contains no Global Catalog? EDIT: Since it was a prevalent comment to the question, I will answer it here: I am working on a product and QA requested that it must work in environme

  • Drive Genius says: "Invalid catalog btree reverse link in node" is this fixable?January 21

    No obvious problems with my Mac OS X 10.5 system, but Drive Genius 1.5.1 says: "Invalid catalog btree reverse link in node" when doing a "Verify" The "repair" and "rebuild" options fail. I did some googling, and the

  • Does anyone really understand how HFSC scheduling in Linux/BSD works?

    Does anyone really understand how HFSC scheduling in Linux/BSD works?January 21

    I read the original SIGCOMM '97 PostScript paper about HFSC, it is very technically, but I understand the basic concept. Instead of giving a linear service curve (as with pretty much every other scheduling algorithm), you can specify a convex or conc

  • why is some of my swap space being used, when I still have unused RAM?March 4

    More of a curiosity than a problem; and, I admit, something of an embarassingly basic question: I've noticed that on many occasions, on my Linux machine I will have ~500MB of swap space in use, even though I have ~600MB of unused RAM. My naive high-l

Copyright (C) 2018 ceus-now.com, All Rights Reserved. webmaster#ceus-now.com 14 q. 0.454 s.