banner_tracks table in database is huge

Discussion regarding Joomla! 3.x Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Post Reply
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Jul 18, 2019 6:14 pm

banner_tracks table in database is huge

Post by mediumcr » Wed Jul 08, 2020 12:54 am


I have a website and lately is having performance troubles. I tried to back it up but the database is huge due to the banner_tracks table which is almost 300 MB.

Is there any way to empty that table?
What happens if emptied?
Captura de pantalla 2020-07-07 a la(s) 18.53.16.png
You do not have the required permissions to view the files attached to this post.

Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4141
Joined: Tue Aug 23, 2005 1:56 pm
Location: South coast, UK

Re: banner_tracks table in database is huge

Post by gws » Wed Jul 08, 2020 7:56 am

You should be able to empty the table with no problems (unless you are selling advertising banners on your site). Simply click on the Vaciar in the table headers for banners in phpmyadmin and it should empty the table.

Joomla! Ace
Joomla! Ace
Posts: 1761
Joined: Fri Jul 05, 2013 10:35 am
Location: Parts Unknown

Re: banner_tracks table in database is huge

Post by SharkyKZ » Wed Jul 08, 2020 8:02 am

Or you could use "Delete Tracks" button in Banners components.


Post Reply

Return to “Performance - Joomla! 3.x”