Delete unused MySQL indexes Programming Databases by Dani How can I identify and delete unused MySQL indexes? I have a large table that has somehow accumulated way too many indexes over the years, and I'd now like to identify and delete indexes that are no longer used by the application. Re: Delete unused MySQL indexes Programming Databases by Reverend Jim I thought it would be as simple as DROP INDEX index_name ON table_name; As for removing only unused indexes, I don't know how MySql would be able to determine if an index is used, or not. You'd have to decide. Since indexes are used to find things quickly I would imagine that if you delete an index and then take a performance hit it's … Re: how to build a software without a website Programming Web Development by jonathannweyer … or mobile app, you can distribute it through app stores, direct downloads, or even platforms like GitHub. A website helps with… Re: Fujitsu Windows Server 2019 Servers Rebooting at 11pm every day Hardware and Software Microsoft Windows by rproffitt Try a focused area like on Reddit such as https://www.reddit.com/r/homelab/comments/740ap2/the_unofficial_fujitsu_server_guide/ If these were mine I'd move to Linux or BSD. Re: Time for some humour before Jan 20 Community Center Geeks' Lounge by Dani OMG, I can't with the dad jokes. Re: Are Cross-Platform Apps Slower Than Native? Or Is That Just a Myth in 2025? Hardware and Software Cloud-based Apps by asadalig In 2025, cross-platform apps aren't inherently slower than native ones—it really depends on how they're built. Modern frameworks like Flutter, React Native, and Kotlin Multiplatform have closed the performance gap significantly. If developers optimize properly, most users won’t notice a difference. However, for extremely high-performance needs like… Re: Delete unused MySQL indexes Programming Databases by Dani OK, so I found [this blog post](https://www.percona.com/blog/basic-housekeeping-for-mysql-indexes/) by the one and only Percona, that says that I can simply do `select * from sys.schema_unused_indexes;` which does give me a list of indexes. However, it says it's based on having: update performance_schema.setup_consumers set enabled = 'yes' … Re: Delete unused MySQL indexes Programming Databases by Dani As some general background, that's the syntax to delete an index, of course, but MySQL knows if an index is used because, well, it's the one that uses it, and it tracks that stuff internally. Now on to my question ... ;) Re: Delete unused MySQL indexes Programming Databases by Reverend Jim See [performance-schema-consumer-filtering](https://dev.mysql.com/doc/refman/8.4/en/performance-schema-consumer-filtering.html) Re: Delete unused MySQL indexes Programming Databases by Dani I already read that article, as well as related ones such as [this](https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-tables.html) and [this](https://dev.mysql.com/doc/refman/8.4/en/performance-schema-event-tables.html) but it all went above my head and didn’t seem to directly answer my question. For example, when I currently run … Re: Delete unused MySQL indexes Programming Databases by Reverend Jim >Is that list incomplete or straight-up wrong? I have no way of knowing. If I add a bunch of numbers and get an answer, is it right or wrong? Again, as a guess, if you have enabled the correct flags and let the system run through typical processing, the returned list should be, according to the docs, a list of unused indexes. Worst case … Re: Delete unused MySQL indexes Programming Databases by Dani Creating and removing database indexes is very complex and is not a matter of let's throw spaghetti at the wall and see what sticks. When working with big data, loads and loads of thought goes into each and every index. Nearly all indexes can work, but not as well as others might, and having too many indexes on a table can slow down inserts and … Re: Delete unused MySQL indexes Programming Databases by Reverend Jim I faced a similar problem when I created and maintained the corporate side databases to mirror the EMS (AGC/SCADA) real time data. One month of data was roughly 300 meg and it was critical that this be available 24x7. Sometimes databases break and it is important to recover them as quickly as possible. Knowing that around 90% of the queries were on… Re: Delete unused MySQL indexes Programming Databases by Dani I can see your rationale, but I don't necessarily agree with a separate table in the database for every month. There are much more elegant ways of handling that use case these days, especially in MySQL. You didn't specify how long ago this was. Either way, still hoping a MySQL expert can come along and answer my question here. Re: Delete unused MySQL indexes Programming Databases by Reverend Jim >You didn't specify how long ago this was. 1998-1999 Are Cross-Platform Apps Slower Than Native? Or Is That Just a Myth in 2025? Hardware and Software Cloud-based Apps by Himadri_3 …-platform development. Unless you're building something like a heavy 3D game or complex AR experience, you probably won't even… Re: 💻 What’s the First App You Install on a Fresh Windows Machine? Hardware and Software Microsoft Windows by Reverend Jim >I'm quite sure that you can, if I remember correctly? Before OneDrive it was easily done. Not anymore. Microsoft is slightly brain dead. Locations for shell folders are stored in the registry. You'd think they'd all be under "Shell Folders", but not all of them are. And you'd think they would have consistent names. But here are … Re: 💻 What’s the First App You Install on a Fresh Windows Machine? Hardware and Software Microsoft Windows by Reverend Jim First app is Macrium Reflect so I can take an image of the fresh install. Then I repartition to C/D, move my user folders (documents, pictures, etc.) to D. Then I take another image. After that I begin installing my base apps before imaging one more time. Re: 💻 What’s the First App You Install on a Fresh Windows Machine? Hardware and Software Microsoft Windows by Reverend Jim Further note: Because Microsoft insists on crammine OneDrive down our throats, moving the My Documents is damn near impossible. I've found the easiuest way is to initially set up my computer using a Microsoft Account (something they have also made it almost impossibole to avoid), then create a local admin account and always log on with that. That … Re: Cannot run exe from asp.net Programming Web Development by Salem https://xyproblem.info/ * User wants to do X. Sometime later... > My boss just asked me to create a prototype as proof of concept. There is no specific language/tool I must use * User asks for help with Y. Initially asked... > Have a webpage with a button, when pressed, it will launch a webpage that runs a server side exe (eg, … Re: 💻 What’s the First App You Install on a Fresh Windows Machine? Hardware and Software Microsoft Windows by Dani Jim, I have not used Windows in a very, very long time, but can you not configure Windows to store My Documents on D? I'm quite sure that you can, if I remember correctly? https://superuser.com/questions/1725456/wha-cant-i-move-my-documents-folder Re: Time for some humour before Jan 20 Community Center Geeks' Lounge by Reverend Jim I bought my friend an elephant for his room. He said, "thank you." I said, "Don't mention it." Re: Time for some humour before Jan 20 Community Center Geeks' Lounge by Pebble94464 Two elephants jump off a cliff. Boom boom! Re: Time for some humour before Jan 20 Community Center Geeks' Lounge by Reverend Jim A guy from New York is driving through the southern bible belt when he sees two men putting up a sign that says "**Turn Yourself Around. The End Is Near**". He ignores it and drives on. A few moments laret the men hear a squeal of brakes followed by a loud splash. One man turns to the other and says, "Maybe it should just read **… ArkTS - McCharts Programming Software Development by 杨_659 … to reach out via GitHub’s group QR code or direct message—I’ll respond promptly. Let’s grow together… Escape in-app browser? Programming Web Development by alexxx1 Hello everyone. I have built a website which I've attached to my bio on Instagram. What I'd like to achieve is to make it open on my phone's (default) browser, safari or whatever that may be. By default, all bio links open in the app's browser. But I saw it from a few influencers that use getallmylinks.com in their bio and this page doesn't open in… Re: Linking Sitemap to all the Webpages Digital Media Digital Marketing Search Engine Strategies by adilhassan You don’t need to link your sitemap to every webpage. It’s enough to submit your sitemap to Google Search Console and place a link to it in your robots.txt file. This helps search engines discover and crawl your pages efficiently without needing direct links on your website. Re: How to contact a specific member Community Center Say Hello! by Ja sa bong I had to check but sadly I couldn't find anywhere to specifically contact a member personally. There is no option for you to send direct message or even see the person's contact information on their profile. You have to just tag the person on a post and hope that the person comes back to see it. Re: What is the Best Marketing Platform For E-commerce Website? Digital Media Digital Marketing by Himanshu011 … partnerships. 9. SMS Marketing (Attentive, Postscript) – High conversion rates with direct customer outreach. 10. YouTube & Video Marketing – Effective for product… Re: Upgrade to Fiber internet Hardware and Software Networking by Salem And you need 5Gbps because...? > AT&T just became in our neighborhood available and I'd love to go back to it. Yeah, I'd be letting the neighbours be the guinea pigs. I have little doubt that the "it's available" came from AT&T marketing department as soon as someone in provisioning said "um, maybe". Even if …