0 Cart
Added to Cart
    You have items in your cart
    You have 1 item in your cart
    Check Out Continue Shopping

    A few questions and the list of data that would be most useful for analysis.

    Questions for you or your team leader:

    HOW DID YOU FIND US?  web search, referral by ______________, Facebook, Instagram, can not remember,  ________________.

    EXISTING KNOWN PROBLEMS (one line, summary, please)
    such as
    A) Stop/Start services REQUIRED every nn hours to avoid crash/hanging instance
    B) Some data entered is missing in the tables the next day (all involved table_names and SHOW CREATE TABLE table_name;).  
    C) ....
    D) ....
    or the BEST one is

    Maximum time allowed for User Inactivity before CONNECTION should be disconnected?   Default is frequently 8 hours - 28800 seconds.

    Does your application have Logout/Signoff available to user?

    Yes or No - if No, how are resources released?

    Login will likely be required to get back online after disconnection (and resources will again be consumed).

    If every CONNECT is closely coupled with CLOSE (after query sequence is completed) you will observe threads_connected remaining a relatively consistent value and not growing every hour.  CLOSE will cause Quit to be recorded in your General Log, indicating this thread_id will NOT be sleeping when you look at SHOW FULL PROCESSLIST in 10 seconds.

    Is connection pooling in use?

    Yes or No will likely influence a few php.ini settings

    Rotating HD nnn of Spindles, nnn TB/GB/MB and nnn TB/GB/MB Free Space
    SSD nnn TB/GB and nnn TB/GB/MB Free Space of SSD
    NVME nnn TB/GB and nnn TB/GB/MB Free Space of NVME
    Random Write mfg or tested IOPS? _________ not read seq or RR.

    nnn TB/GB/MB row count LIMIT for SQL SELECT, JOIN, SORT, etc. for a single query processing LIMIT

    Do you really want to allow one query to JOIN a billions rows of information before concluding this is a MISTAKE?   Yes  or  No, please.
    Depending on your application, 1 Million rows LIMIT could be fine.

     HOSTED on what system?

    ___________ pendo.io, AWS, Google, In-house, local area hosting organization.

     RAM nnn TB/GB/MB on your Host server, indicate DEDICATED or SHARED w other apps?

    Power Plan in use?  
    High Performance recommended for busy server
    rather than Balanced or Power Saver.
    For Windows, Run, powercfg.cpl  to determine current setting.
    Search for Linux Power Plan Settings to find a way to determine your setting.
    BIOS settings could still be in your way of achieving high performance.
    End of initial questions about your operating environment to be included in your  email to mydatalinks@mysqlservertuning.com  with your order number as the subject (assigned later), please.

    If your only interested in log analysis, please skip to POST DATA DESTINATION

    TEXT results of following requests to be "Attached" to email to mydatalinks@mysqlservertuning.com with your Invoice/Order Number leading the Subject line please.

    current complete my.cnf or my.ini
    current complete php.ini (if used as part of your solution)

    TEXT results of: (If you choose to provide xlsx rather than TEXT data, our Suggestions COULD be DELAYED)
    A) SHOW GLOBAL STATUS;    minimum UPTIME 1 business day, 7 days or more preferred

    If you are in a crisis, this may be the extent of data you can provide.
    We will understand and do the best we can with the data you can provide. 

    If you are only interested in 4 or 10 Global Variable suggestions you may STOP here, for more detailed analysis, continue please
    C) complete current text of first 400 lines AND last 400 lines of error log. Named Beg400error.log and End400error.log, please.
    E) SELECT name, count FROM information_schema.innodb_metrics ORDER BY name;
    F) SHOW FULL PROCESSLIST;  which will include QUERY requests running, sleeping, other APPS in use, utility threads in use, etc.
    Optional very helpful information, if available includes -

    lscpu   for specs, including MHZ, cores + other info
    htop, top & mytop for most active apps (page 1 minimum, PNG is OK)
    ulimit -a  for a linux/unix list of limits 
    iostat -xm 5 3  for a linux/unix when BUSY for IOPS of hardware extended status
    mpstat -P ALL 5 3  for multiprocessor status 5 seconds 3 intervals
    df -h  for a linux/unix free space list by device
    free -h  for a linux/unix Total Used Free  Mem: and Swap:
    cat /proc/meminfo  for a Linux/unix report including VMAlloc information

    MySQLTuner.pl entire PERL report, please
    Why entire report? Because the report includes MySQL V nn, RAM, per Engine analysis of data space/table counts and additional very helpful information.

    Text results of
    globalstatusage10sec.sql      will be done in less than 15 seconds
    findfragtables.sql                   duration depends on number of tables
    find-redundant-indexes.sql    duration depends on number of tables

    from our Utility Scripts+ you may download and use at no charge.  This additional data will allow a deeper look into your current instance and table health.

    Text results of

    for current replication information.

    ALL suggestions for configuration changes
    should be carefully evaluated before taking action.

    For text files rather than images, please copy Command Prompt output  to clipboard (ctrl+c) and paste into Notepad New File (ctrl+v) for text files works great in Windows.
    Linux has similar tools available to save text files.

    If you need a delta analysis, please use our SHOP, select LOYALTY Global Status and Global Variable Analysis Delta to order.

    For delta analysis of a busy hour, after one hour (or two, or three very busy hours)
    repeat gathering the text results of ONLY 
    C) cat /proc/meminfo  for a Linux/unix report including VMAlloc information
    with accurate filenames including ccyymmddhhmm.

    You may wish to have a daily/weekly/monthly/quarterly/semi-annual/annual delta analysis
    which we can accommodate if you have your BASELINE start and end delta files available.


    After using SHOP to complete your Purchase and you have INVOICE/ORDER # make the Subject of your email  INVOICE/ORDER #(assigned at purchase), please so we know which INVOICE/ORDER # your data is to be associated with for analysis, please.
    TEXT results to be "Attached" to email to mydatalinks@MySQLServerTuning.com for your OFF CPU analysis processing.

    Receipt of these readable attachments STARTS (or RESTARTS) your 4 Business day clock for expected email delivery of our Suggestions.