How to erase mysql logs on a free account?

Status
Not open for further replies.

r3cocina

New Member
Messages
5
Reaction score
0
Points
1
I read that I need root acces, ssh. So is impossible with my account type?
 

Livewire

Abuse Compliance Officer
Staff member
Messages
18,169
Reaction score
216
Points
63
I'm not sure what you mean by mysql logs; can you clarify further? Depending on what it is, there's a possibility it either doesn't actually exist (we disable some forms of logging outright due to the additional IO usage), or doesn't require root/ssh to do. There's also no hosting account linked to this username.
 

r3cocina

New Member
Messages
5
Reaction score
0
Points
1
Thanks for attention!! You can see my problem posted previously here. Erase post I copy the content here:

My SQL database has only 100MB.
How can I clean my sql disk space? I have only a wiki on my account.
Commands? Querys (I'm not SuperSu)? Steps? I attach images
Is mysql binlogging? If yes how to change it on x10 server?
Thanks
Disk usage tree
public.php

Database

public.php

Left summary on cpanel
public.php

People create cron jobs to erase logs (if it was the problem). My user now is tsr. r3cocina is my forum user when I used another domain name.
How can I free mysql space rounded on a red circle? Thanks for help.
 

Livewire

Abuse Compliance Officer
Staff member
Messages
18,169
Reaction score
216
Points
63
That looks to be a synchronizing issue within cPanel; I'm running a server-side command to attempt to resolve that, as I was able to confirm it should only be showing about 113mb or so. It may take some time for the command to complete; assuming it works, it'll show the disk usage as back down to about 300-350mb (200 from public_html, and the 100 or so from the database).
 

essellar

Community Advocate
Community Support
Messages
3,295
Reaction score
227
Points
63
You may see something significantly higher than 100MB of MySQL usage, though, if you use full-text indexing (likely on a wiki) or if any of your tables are multiply indexed. It shouldn't be 900MB higher, but it will reflect more than the raw data size.
 

Livewire

Abuse Compliance Officer
Staff member
Messages
18,169
Reaction score
216
Points
63
Quotas aren't syncing properly on vox it looks like; for now I'd disregard it, you're on the infinity plan so it reporting the wrong disk usage shouldn't affect anything.
 

r3cocina

New Member
Messages
5
Reaction score
0
Points
1
Thanks Livewire, so definitely it is a server problem that don't affect me? Only is an error representing mysql quota? Thanks.
 

Livewire

Abuse Compliance Officer
Staff member
Messages
18,169
Reaction score
216
Points
63
Correct; other than it being a bit inconvenient because the numbers don't look right, it's all cosmetic and shouldn't affect you since you're on infinity and there's no hard-cap for disk space anyways.
 
Status
Not open for further replies.
Top