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 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: Is the Vision Pro worth it? Hardware and Software macOS by rproffitt One of my sons spent a lot setting up some other VR gear. And then broke his TV playing a game (punched the TV). 3 years later it sits in a box because it's out of date and new models that are worth buying are not worth buying (not going to rewrite that.) For me, not worth it. 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 … Are Cross-Platform Apps Slower Than Native? Or Is That Just a Myth in 2025? Hardware and Software Cloud-based Apps by Himadri_3 It’s a question we still hear a lot—and honestly, the answer depends on what kind of app you're building. A few years back, native apps definitely had the upper hand when it came to speed and smooth performance. They were built specifically for iOS or Android, so naturally they could tap into every feature and run super efficiently. But now? … 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: Problem with MS Office shortcut bar Hardware and Software Microsoft Windows by themadrastiffin The shortcut bar in MS Office may not appear, may not open or may run slowly if you restart, repair or reinstall the program. Re: Problem with MS Office shortcut bar Hardware and Software Microsoft Windows by asadalikhan Nick, this issue sounds like a file association problem. Your URL shortcuts on the shortcut bar are likely opening with the wrong program (like a printer handler). Here’s a quick fix: 1. Go to Control Panel > Folder Options > File Types 2. Find and select .URL 3. Click Advanced and ensure it’s set to open with Internet Explorer (… Re: Problem with MS Office shortcut bar Hardware and Software Microsoft Windows by asadalikhan Nick, it’s likely a file association issue. Reassign `.url` files to open with Internet Explorer in Folder Options > File Types. That should fix the shortcut bar behavior. 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 **… 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: Upgrade to Fiber internet Hardware and Software Networking by rproffitt My ATT story. Moved from MA to CA and needed to get the apartment setup. The apartment complex was an ATT only zone. Fine. Call ATT and their phone system kept routing me to their Massachusetts offices. No one at ATT could override that or forward me to the right office. OK, find the local ATT store and go in. Much confusion at their counter … 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 …