Skip to content
MENUMENU
  • Why Matomo?
    • Flexibility
    • Privacy Protection
    • Product Features
    • Open Source
    • No Data Sampling
    • GDPR
    • Google Analytics Alternative
    • 100% Data Ownership
  • Use Cases
    • No Limitations
    • Intranet Analytics
    • Cookieless Tracking
    • Tracking Personal Data
    • Complete Analytics
    • Log Analytics
  • On-Premise
    • Matomo On-Premise
    • On-Premise vs Cloud
    • Download for free
    • Marketplace
    • Support Plans
  • Pricing
  • Live Demo
  • Resources
    • Blog
    • Help
    • Integrations
    • Contact the Matomo team
    • List of all features
    • Get involved
  • Log in >TRY IT FOR FREE
  • Home
  • Help
  • Installation & Maintenance
  • Matomo On-Premise (self-hosted)

Matomo On-Premise (self-hosted) - Troubleshoot Database

Fix the error “Mysql Server has gone away”Fix the Mysql error “Connection refused”Fix the Mysql “Error while sending QUERY packet”Fix the error “General error: 3 Error writing file /tmp/xyz (Errcode: 28 – No space left on device)”What should I do when I get the error message: SQLSTATE[HY000] [2002] Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (11)Fix the error “1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126.”I get the error: ERROR 1034 (HY000): Incorrect key file for table ‘matomo_log_visit’; try to repair it OR Table matomo_log_x is marked as crashed and last (automatic?) repair failedConvert the MySQL database tables from MyIsam to InnoDBFix “SQLSTATE[HY000][2054] The server requested authentication method unknown to the client” error

Support

  • Knowledge Base
  • Changelog
  • Glossary
  • Forums
  • Developers
  • Issue tracker
  • By industry
  • Contact support
  • Campaign URL builder

News

  • Blog
  • Newsletter
  • Matomo in the press

Compare

  • Google Analytics vs Matomo
  • Hotjar vs Matomo
  • WP-Statistics vs Matomo

About us

  • About Matomo
  • Contact us
  • Press
  • Contributors
  • Careers
  • History
  • Download Matomo
  • GitHub
  • Piwik is now Matomo
  • Open source

Privacy

  • Data ownership
  • GDPR
  • Security
  • Privacy policy
© 2022 matomo.org

Sign up for our newsletter

We are constantly adding new features and content to the leading All-In-One Analytics Platform that gives you control over your data. If you want to stay up to date with everything that is happening, feel free to subscribe below. You can unsubscribe at any time from it. The newsletter service uses MadMimi. Learn more about it within our privacy Policy page.


no thanks

{"cookieName":"wBounce","isAggressive":false,"isSitewide":true,"hesitation":"500","openAnimation":false,"exitAnimation":false,"timer":"","sensitivity":"","cookieExpire":"60","cookieDomain":"","autoFire":"","isAnalyticsEnabled":false}