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: 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: 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: 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 **… 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… 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: 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! 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 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 … Re: Show me AI Hidden Features in Samsung Galaxy S25 Ultra ? Hardware and Software Hardware Mobile and Wearables by rproffitt I'd rather have a phone that can make calls, texts and take UNALTERED BY AI photos. As to updates, is there a way to disconnect this from fascist run companies like X (twitter)? Re: Contact form does not working Programming Web Development by Salem Firstly, I'd suggest you edit your post to remove your real email address from the code. https://www.php.net/manual/en/function.mail.php Some things to try. 1. Headers is an optional parameter, can you send without the headers parameter? Many examples I've seen suggest there should be a space after the :, as in `'From: '` 2. Sanitise … Re: Contact form does not working Programming Web Development by Dani > Firstly, I'd suggest you edit your post to remove your real email address from the code. I have replaced their email address with a dummy email. > Sanitise your subject and/or message. You can't in general feed whatever was typed into your dialog directly into mail. Salem is referring to passing each of those variables in … Re: Show me AI Hidden Features in Samsung Galaxy S25 Ultra ? Hardware and Software Hardware Mobile and Wearables by Salem > I'd rather have a phone that can make calls, texts and take UNALTERED BY AI photos. How long before AI eff's up some key witness photo, resulting in the guilty going free or the innocent jailed? Re: Ja sa bong Here! Community Center Say Hello! by Reverend Jim My son had the same problem so typically I'd plug in to the matrix and he would observe on my laptop using Air Receiver. Quick plug: I bought Air Receiver through the Microsoft Store for around four dollars. Running this you can cast directly from the Oculus without having to go through the Meta servers. Naturally, casting point to point means … Re: Hi everyone, I'm varunkumarriat Community Center Say Hello! by Dani Hi and welcome!! I, as well, have a lot of web design and development experience. I wrote DaniWeb, after all ;) I'd love to help with any questions you may have. Feel free to post, and hope to see you come back. I know it's been a few weeks since your post. Re: Upgrade to Fiber internet Hardware and Software Networking by Dani In NY, I had Spectrum cable at home, and Verizon FiOS fiber at my office. In CA, I started with Xfinity cable. Just before COVID, we moved into a townhouse that had a spotty connection that became unbearably inconsistent. Apple ended up paying for us to have AT&T fiber because my husband is an engineering manager there, and they needed their… Re: Odd but True Facts Community Center Geeks' Lounge by Salem > But because the car was made in the US I had to enter the price per US gallon whereas our gas is sold by the litre. I'd wager the software wasn't, and the software is the same regardless of locale. <disclaimer> Do the same youtube "tutorials" also tell you how to do a factory reset? A lot of tech (phones, computers etc)… Re: Can we recover the deleted data of our computer? Hardware and Software Microsoft Windows by Reverend Jim I'd suggest you start by typing that question into Google. Re: How secure is Github? Programming Software Development by pritaeas No sensitive info in any CVS. If I had a codebase such as DW, I'd store it in a local git store, synced to another machine of mine. No cloud. Re: Which country is the best in mobile app development? Programming Mobile Development by rproffitt For now I'd not visit the worst of the 195 countries in the world. The USA has changed teams so it's far too dangerous for visitors today. Also: > The **best in this** kind are but shadows, and the worst are no worse if imagination amend them. Play: A Midsummer Night's Dream Re: What is the Best Marketing Platform For E-commerce Website? Digital Media Digital Marketing by ashleydent4u For e-commerce in the US, Google Ads and Meta (Facebook + Instagram) are definitely top performers—especially for apparel and towel products where visuals matter. I'd also explore Pinterest Ads for the towels site, as home products do well there. For SEO, make sure you're building backlinks from relevant blogs, industry directories, and influencer …