Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Stan Jensen Posted December 31, 2021 Posted December 31, 2021 I can't find my database in my cPanel. ie myphp. Ido see one but it is not that where on the admin side of my IPB cn I see the location? might sound silly. Thanks Stan
Solution Randy Calvert Posted December 31, 2021 Solution Posted December 31, 2021 It’s not displayed in the UI that I’m aware of, but the database would be stored in your conf_global.php file in your main public_html folder. SeNioR- 1
Jim M Posted January 1, 2022 Posted January 1, 2022 I would advise contacting your hosting provider if you cannot find the database for your installation as specified in the conf_global.php.
Stan Jensen Posted January 4, 2022 Author Posted January 4, 2022 I my previous software package, ubbthreads, we could melted form the control panel posts over however amount of days. Is that not an option? my mysql file is 1.5 gigs. I send to shrink that. Thoughts?
Marc Posted January 4, 2022 Posted January 4, 2022 Sorry, Im not sure what you mean there. Please could you reword this? Miss_B 1
Miss_B Posted January 4, 2022 Posted January 4, 2022 (edited) 3 hours ago, Marc Stridgen said: Sorry, Im not sure what you mean there. Please could you reword this? That makes 2 of us. I am assuming that the OP perhaps means that he could delete topics that did not have a reply since x amount of days ?????? If that is the case @Stan Jensen, you will need a custom app for that with Ipb. If you meant something else, please be very clear and specific as to what you mean. Ipb support is great, but they are not mind readers 😄 Edited January 4, 2022 by Miss_B
Stan Jensen Posted January 6, 2022 Author Posted January 6, 2022 So sorry. I had written this "I my previous software package, ubbthreads, we could melted form the control panel posts over however amount of days." I meant "With my previous software package, unthreads, we could removed from the Control Panel posts after a certain amount of days" ie delete all posts that have not been active in two years or more. Is there not an option to do something similar here?
Miss_B Posted January 6, 2022 Posted January 6, 2022 9 minutes ago, Stan Jensen said: So sorry. I had written this "I my previous software package, ubbthreads, we could melted form the control panel posts over however amount of days." I meant "With my previous software package, unthreads, we could removed from the Control Panel posts after a certain amount of days" ie delete all posts that have not been active in two years or more. Is there not an option to do something similar here? Not out of the box a.f.a.i.k. This will require a custom plugin/app.
Stan Jensen Posted January 6, 2022 Author Posted January 6, 2022 OK thanks. then how do others remove old post. via cPanel?
Miss_B Posted January 6, 2022 Posted January 6, 2022 9 minutes ago, Stan Jensen said: OK thanks. then how do others remove old post. via cPanel? I do not know how, or even if others do that, but the best way to do that imo is through a custom app. Deleting posts directly from the database at the phpmyadmin is not recommended.
Mark H Posted January 6, 2022 Posted January 6, 2022 36 minutes ago, Stan Jensen said: "With my previous software package, unthreads, we could removed from the Control Panel posts after a certain amount of days" ie delete all posts that have not been active in two years or more. That's not currently possible in our software, but as Miss_B noted this might be able to be done with a custom app. Miss_B 1
Mark H Posted January 6, 2022 Posted January 6, 2022 Apologies, I hid a reply that had some incorrect details. While you can use a second database for Archived items, you cannot simply manually empty the database for those archived items. The contents within that database are still being referenced by the software when anyone visits one of those archived topics. They can read it, but cannot reply (the topic is effectively locked unless un-archived).
Stan Jensen Posted January 6, 2022 Author Posted January 6, 2022 OK. so my database is 1.4 gigs. Which seems high for me as things slowdown a lot after Facebook, there seems no way to reduce it? am wondering if it slows down because of the site.
Jim M Posted January 6, 2022 Posted January 6, 2022 6 minutes ago, Stan Jensen said: OK. so my database is 1.4 gigs. Which seems high for me as things slowdown a lot after Facebook, there seems no way to reduce it? am wondering if it slows down because of the site. 1.4 GBs is not that large of a database this day in age. It is worth mentioning that your system log has quite a lot of errors in it as of recently. Today alone there were 115 logs. I would advise setting this log to purge every 30 days as you currently set it to never purge. I am also seeing: The table 'ibf_core_follow_count_cache' is full There are also a lot of errors where gallery images are missing so that should be investigate on your file system with your hosting provider. Miss_B and Stan Jensen 1 1
Randy Calvert Posted January 6, 2022 Posted January 6, 2022 Just as a side datapoint, I don’t have the biggest community, but our SQL database is 12GB. That does not include the search index as we utilize elasticsearch. The database size itself does not matter much. IPB is written in an efficient manner to handle big amounts of data with well engineered indexes and queries to reduce the amount of overhead associated with finding data. Slowness tends to come from other things such as high CPU load from a high number of concurrent users, an unoptimized MySQL configuration that does not properly get to utilize enough RAM, etc. Ive been able to squeeze absorber 30-40% from my prior setup by focusing on server optimization. (Though your specific results might obviously vary.) Stan Jensen 1
Recommended Posts