How to increase mariabd disk space



  • I am getting this error and yes i tried to edit my.ini file its empty the hosting panel is cyberpanel and I cant edit it even with "VIM" and I am facing this error

      (/tmp/#sql-temptable-33e-26b-19a.MAI); waiting for someone to free some space... (errno: 28 "No space                              left on device")
    Jan 12 14:14:01 hidden mariadbd[830]: 2022-01-12 14:14:01 619 [ERROR] mariadbd: Disk full                              (/tmp/#sql-temptable-33e-26b-19b.MAI); waiting for someone to free some space... (errno: 28 "No space                              left on device")
    Jan 12 14:14:01 hidden mariadbd[830]: 2022-01-12 14:14:01 619 [ERROR] mariadbd: Disk full                              (/tmp/#sql-temptable-33e-26b-19c.MAI); waiting for someone to free some space... (errno: 28 "No space                              left on device")
    Jan 12 14:14:01 hidden mariadbd[830]: 2022-01-12 14:14:01 619 [ERROR] mariadbd: Disk full                              (/tmp/#sql-temptable-33e-26b-19d.MAI); waiting for someone to free some space... (errno: 28 "No space                              left on device")
    Jan 12 14:14:01 hidden mariadbd[830]: 2022-01-12 14:14:01 619 [ERROR] mariadbd: Disk full                              (/tmp/#sql-temptable-33e-26b-19e.MAI); waiting for someone to free some space... (errno: 28 "No space                              left on device")
    Jan 12 14:14:01 hidden mariadbd[830]: 2022-01-12 14:14:01 619 [ERROR] mariadbd: Disk full                              (/tmp/#sql-temptable-33e-26b-19f.MAI); waiting for someone to free some space... (errno: 28 "No space                              left on device")
    Jan 12 14:14:01 hidden mariadbd[830]: 2022-01-12 14:14:01 619 [ERROR] mariadbd: Disk full                              (/tmp/#sql-temptable-33e-26b-1a0.MAI); waiting for someone to free some space... (errno: 28 "No space                              left on device")
    Jan 12 14:14:01 hidden mariadbd[830]: 2022-01-12 14:14:01 623 [ERROR] mariadbd: Disk full                              (/tmp/#sql-temptable-33e-26f-13f.MAI); waiting for someone to free some space... (errno: 28 "No space   
    


  • The disk is full.
    You need to free up some space on the disk - by deleting files - or extend the disk volumes involved.

    Given that a temporary table is involved, this could be caused by an errant query creating a very large, in-memory, resultset that it wants to join to something else.
    If your database is still running and you can connect to it, see if you can locate this query. If you can then two actions are required:

    • Kill the query, which may get your system stable again, then
    • Tune the query to reduce its [temporary] space requirements.

    If you can't get into your database at all, then restarting the database process and/or its hosting server will kill this (and every other!) query and should release the temporary disk space back to the operating system.

    If the problem recurs, you may need to extend the temporary (/tmp) file system further but I'd suggest keeping this in hand as a last resort.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2