Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 14

Displaying posts with tag: mysqlsla (reset)

vBulletin session table and Hash index in MEMORY Engine
+1 Vote Up -0Vote Down
In vBulletin Board System there is session table contains online user information and tracking, in which forum now, what the current URL now, So it is have huge concurrent update statement, By default this table is MEMORY engine because its data not important in case MySQL restart. I notice early loaded in MySQL and server, So I do full tuning for the server then analyze slow query using
mysqlsla amazing tool
+0 Vote Up -0Vote Down
mysqlsla is interesting tool to analyze slow log query, aggregate same query in one and generate unique sql statement withCount, (max, min, avg) execute time, lock time, Rows sent, Rows examined for each unique one.you can use it to review indexes and drop unused index, and create another.Report for slow logs: slowquery1day.txt791 queries total, 85 uniqueSorted by 't_sum'Grand Totals: Time 23.05k
Hack MySQL status update
+0 Vote Up -0Vote Down

I haven’t posted any update in 2 months not because I haven’t been doing anything but rather the opposite: I have been exceptionally busy. As Baron has noted, I work with Percona doing the maintenance and development for Maatkit, of which release 2325 was just published. Consequently, I haven’t been working on my own scripts, though hopefully that will change, and in some ways it must. Here’s what I have in mind for my own scripts:

mysqlsla: I’m going to create a hybrid between this and mk-log-parser. Whereas mysqlsla does some things that mk-log-parser doesn’t, mk-log-parser has a better, more maintainable code base. Furthermore, I’m currently working on other log handling code

  [Read more...]
mysqlsla v2.00 released
+0 Vote Up -0Vote Down

mysqlsla v2 is finally “done” and released. About 3 months ago, when v1.8 was released, I said it would be coming “soon,” but time just flew by and here we are. Oh well. In any case, the v1 branch is dead to me and v2 is all the rave (at least for me). If you don’t care about the differences and all you want is your default top 10 report from a slow log, for example, then all you need to know is: mysqlsla -lt slow SLOW_LOG

For those interested in what has changed to warrant a new major version number, here’s the briefing of changes/overhauls:

  • Almost ALL new command line options (–log-type a.k.a. -lt is the most important); see the documentation
  • Customizable reports. In v1 the report was hard-coded. Now with
  •   [Read more...]
    mysqlsla: v1.8 released, v2 coming
    +0 Vote Up -0Vote Down

    mysqlsla v1.8 is available at:
    I am releasing it publicly without updating the mysqlsla web page or documentation because, instead, I am waiting until I finish mysqlsla v2. After working with v1.8 I realized the code needed a major re-think and overhaul. v2 will reflect this and will be a far superior log hacking and analyzing tool, capable of far more than v1.8 is now.

    But for now, 1.8 fixes several good (or bad?) bugs:

    • –only-hosts did not work for general logs
    • Multi-line comments using /* */ caused everything after the first line to be ignored in raw logs
    • “Change user” commands were not handled in general logs
    • CHANGE, DROP and RESET statements were filtered out
    • A certain variant of the Connect command

      [Read more...]
    MySQL Monitoring and Tuning
    +0 Vote Up -0Vote Down

    We recommend two open source tools to help with the regular tuning and monitoring of your MySQL database: mysqlreport and mysqlsla. Your website is made from many complex systems. Rapid growth, changes to your site, and other systems can change the load on your MySQL database. It is important that your internal staff become familiar with using these tools and implement routine maintenance. An initial review often leads to significant improvements, and will also help you to implement a monitoring solution for your ongoing performance efforts.

    read more

    Query Profiling Tools ? part 1, mysqlsla
    +0 Vote Up -0Vote Down
    The “sla” in mysqlsla stands for “statement log analyzer”. This does a much better job than mysqldumpslow of analyzing your slow query log. In fact, you can sort by many different parameters — by sheer number of times the query shows up in the slow query log, by the total or average query [...]
    MySQL Query Profiling Tools ? part 0, Ma?atkit Query Profiler
    +0 Vote Up -0Vote Down
    Today I’ve been checking out a new client environment. My mission is to figure out (cold) some of the characteristics of the queries being run, and particularly if they’re “good” or “bad”. In my arsenal of “tools I really want to check out” has been Ma’atkit’s Query Profiler. They’re very different tools. Ma’atkit’s query [...]
    mysqlsla v1.7a released
    +0 Vote Up -0Vote Down

    mysqlsla v1.7a has been released. It fixes a strange bug for general logs with connection IDs greater than 10 million.

    mysqlsla v1.7 released
    +0 Vote Up -0Vote Down

    mysqlsla v1.7 is ready because v1.6 (and v1.5) had a bug: numbers greater than 999 were printed wrong; internally, though, they were still used correctly. Therefore: do not use v1.6.

    Also, v1.7 has a –milliseconds option to make time values less than 1 second print as millisecond values. This option is necessary for slow logs from servers patched with the slow query log millisecond patch.

    mysqlsla v1.6 released
    +0 Vote Up -0Vote Down

    mysqlsla v1.6 is ready. It has four new options to allow better isolation/filtering of queries: –only-databases, –only-users, –only-hosts, –only-ids. Each option limits the queries under analysis to their respective properties (i.e., “–only-users root” only analyzes queries executed by root). See the documentation for which options work with which kinds of logs.

    Updated: Non-technical Guide to Isolating Slow MySQL Queries
    +0 Vote Up -0Vote Down

    It’s strange what articles on one’s site become “popular.” I wrote Non-technical Guide to Isolating Slow MySQL Queries some time ago when I was an internal system admin at a data center. I wasn’t “customer-facing” but I still got requests from customers who wanted me to look at their MySQL server. Since that wasn’t my primary responsibility, I had to enlist their help to save me time. Hence, I wrote this article to help not-technically-inclined customers through the first few steps.

    My webstats have shown this page to be hit more often than I would have expected. Consequently, I felt that I should update it, so I did.

    MySQL log analyzer - mysqlsla v1.5 finally done
    +0 Vote Up -0Vote Down

    mysqlsla (MySQL Statement Log Analyzer) v1.5 is finally done. Some people may recall a semi-release of v1.4 a few months ago, but that version wasn’t documented or otherwise mentioned at hackmysql.com.

    Now, the real next release of mysqlsla is finished, and with documentation too! (However, I have removed the guide for now; it still needs to be completely rewritten). From the old v1.3 to the present, a lot has changed due to a lot of feedback, suggestions, problems, and bugs reported from users. Essentially, the script has been completely written, but here is a brief list of the changes:

    • COMPLETE redesign from v1.3: more simple to use and more informative
    • Log types are now mutually exclusive (but multiple logs
      [Read more...]
    Tossing mysqlsla v1.4 Out There
    +0 Vote Up -0Vote Down

    Although I have not updated the website, documentation, or how to for mysqlsla, I am tossing mysqlsla v1.4 “out there” to view or wget at:


    I don’t like to release new versions without having everything else updated too, but for various reasons I’m making an exception this time.

    mysqlsla v1.4 is much better than v1.3 and a lot has changed. So much has changed that the entire script was essentially re-written. Without an updated doc or how to, I suggest starting with the –help command line op, then contact me if you have specific questions or issues. I will, eventually, update the website, doc, how to, and officially package this new version.

    Showing entries 1 to 14

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.