Good day! I have a problem in MySQL and PHP. I have a script with only 16 data in the table. and I have a simple script. Sometimes querying is slow and it takes to 2minutes to display. I have 128 RAM installed in windows server 2019.

How to optimize mysql. Thank you

enter image description here

  • 1
    Where is: query text, DDL for all tables, EXPLAIN?
    – Akina
    Jun 10 at 11:36
  • 2
    Please consider reading this advice
    – mustaccio
    Jun 10 at 12:05
  • Additional information request, please. Any SSD or NVME devices on MySQL Host server? Post on pastebin.com and share the links. From your SSH login root, Text results of: A) SELECT COUNT(*) FROM information_schema.tables; B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; AND very helpful OS information, includes - htop OR top for most active apps, ulimit -a for list of limits, iostat -xm 5 3 for IOPS by device & core/cpu count, for server workload tuning analysis to provide suggestions. Jun 17 at 16:01
  • 128 RAM -- If that is "bytes", then your machine must date from the late 1970s, long before Windows 3.0 was released !!
    – Rick James
    Jun 21 at 0:45
  • The info on table_open_cache explains something that is probably irrelevant to your problem. Let's see your queries.
    – Rick James
    Jun 21 at 0:48


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.