Hello, I'm Tim Cooke Community Center Say Hello! by trcooke Like Ron McLeod, [who we met yesterday](https://www.daniweb.com/community-center/say-hello/threads/543368/hi-everyone-i-m-ron-mcleod), I'm a moderator and administrator over at the CodeRanch.com forums. I'm a Software Engineer, currently working as a Software Architect for a medical technology company in Belfast, Northern Ireland. We use Java, … Re: Remove Qemu/kvm snashots Hardware and Software Linux and Unix by Dani Salem linked to it (thank you!), but it seems succinct enough that I'm going to include it here in case the link were to disappear in the future. # qemu-img snapshot [ -l | -a snapshot | -c snapshot | -d snapshot ] filename -l: lists all snapshots -a: reverts the image to the snapshot -c: creates a snapshot -d: deletes the snapshot Re: sharepoint policy management software Programming Web Development by Reverend Jim Manitoba Hydro implemented Sharepoint a year or two before I retired. Horrible system if you are expected to manage it without training (as was typical where I worked). I eventually got tired of being told "You're doing it wrong" by the people who DID get the training, while not being told how to do it the right way. I eventually told my … 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 Re: Time for some humour before Jan 20 Community Center Geeks' Lounge by Reverend Jim Example of Dad joke: How do you think the unthinkable? With an ithberg. Re: Delete unused MySQL indexes Programming Databases by toneewa Your data wouldn't be accurate and incomplete, if either one of the performance schemas were off. event_waits_current was off, so MySQL didn't store the data (e.g., collect wait event data in detail), which can create incomplete or missing information about index usage like table I/O waits, index access details, event metadata, or timing and … Re: Time for some humour before Jan 20 Community Center Geeks' Lounge by Dani > Example of Dad joke: > > How do you think the unthinkable? > > With an ithberg. Boooo. Re: Hello, I'm Tim Cooke Community Center Say Hello! by Reverend Jim Hello and welcome to Daniweb. Re: Hello, I'm Tim Cooke Community Center Say Hello! by John_165 Welcome aboard! I’m also a member of CodeRanch. Re: Time for some humour before Jan 20 Community Center Geeks' Lounge by Reverend Jim In the same vein... What do you get when you cross the Atlantic with the Titanic? About half-way. Re: Delete unused MySQL indexes Programming Databases by Dani > Your data wouldn't be accurate and incomplete, if either one of the performance schemas were off. Do you mean `!(accurate && incomplete)` or do you mean `!accurate && incomplete`? But I gotcha. Thank you for the explanation. Re: Hello, I'm Tim Cooke Community Center Say Hello! by Dani Hi Tim! Welcome to DaniWeb. Thank you so much for taking the time to join us over here. 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… 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: 💻 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: 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 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 later 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.