Jump to Navigation
Home

Languages

  • English

Login

Search form

  • About us
  • Services
  • Tools
  • Resources
  • Download

Trouble Shooting

MySQL trouble shooting

Mon, 2010-03-15 11:46 — oli

Table of Contents

  • max_open_files warning during mysqld startup
  • Troubles after NON recommended upgrade path
  • Com_* counters not updated in SHOW STATUS
  • ERROR 1300 (HY000): Invalid utf8 character string
  • MySQL crashes during import
  • MySQL workbench gives an openGL error

max_open_files warning during mysqld startup

Problem

[Warning] Changed limits: max_open_files: 1024  max_connections: 100  table_cache: 457

[Warning] Could not increase number of max_open_files to more than 1024 (request: 1070)

Explanation …

tags: 
trouble shooting
open_files_limit
table_open_cache
limitnofile
  • Read more about MySQL trouble shooting
Subscribe to RSS - Trouble Shooting

  • About us

    • News
    • About FromDual
    • Contact
    • Partner
    • References
    • Newsletter
    • Press

  • Services

    • Consulting
    • Support
      • MySQL
      • DB Development
    • Remote-DBA
    • Training
      • Training Modules
      • Class Schedule
      • for Developer
      • for Administrators
      • Galera Cluster

  • Tools

    • Performance Monitor
    • Ops Center
    • MyEnv
    • SQL Formatter
    • Database Health Check
    • Performance Tuning Key
    • Consulting tools
    • MySQL Configuration

  • Resources

    • Blog
    • Forum
    • Presentations

  • Download

  • Recent content

Trademarks

RSS LinkedIn X / Twitter Facebook Flickr Bluesky YouTube Mastodon Matrix PeerTube Codeberg twitter

MySQL, InnoDB and Oracle are registered trademarks of Oracle Corp. MariaDB®, the sea lion logo and MaxScale® are registered trademarks of MariaDB Corp. All other trademarks are property of their respective owners. Other product or company names mentioned may be trademarks or trade names of their respective owner.