Re: đź’» What’s the First App You Install on a Fresh Windows Machine? Hardware and Software Microsoft Windows by Yrth > 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 You can't, directly, but you can cheat, of course. Put your documents directory … Re: Best Approach for Starting a Linux-Based Home Automation Pro Hardware and Software Linux and Unix by trcooke Hello, I'd probably start with an open source off the shelf solution such as https://www.home-assistant.io/ There are tutorials on their site that cover installation onto a raspberry pi so you should be able to get to and running fairly quickly. It sounds like a fun project so please do let us know how you get on. Re: Best Approach for Starting a Linux-Based Home Automation Pro Hardware and Software Linux and Unix by trcooke Indeed not. He's 7 now. Yes you can get those free standing mounts, but I don't have any. My thermostats are wired into the wall. It'd be cool if you could just pop them off the wall and stick them on a stand anywhere you like, but alas you cannot. 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: Designers, Where Do You Get Your Visuals? Digital Media UI / UX Design by jkon We make a vertical distinction between visuals for UI (which are under the R&D department) and visuals for content management / site promotion (which are under the S&D department). In the first case, which covers every visual within the scaffolding of an app / site, we normally create them ourselves. These are typically SVG files, and … 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: My php is showing wrong results of time difference Programming Web Development by Dani I am confused when you say the HTML time picker input box can be set to 20:00 for time in and 5:00 for time out, because `<input type="time" ...>` only allows the end-user to specify a time, not a time and date combination. Should it always be assumed that if the time out is earlier than the time in, that it is the next day? … Re: My php is showing wrong results of time difference Programming Web Development by Dani In other words, if you just need days or hours you can do something like `$diff->d` or `$diff->h` (All properties available [here](https://www.php.net/manual/en/class.dateinterval.php), but if you want to calculate a runner's start time and end time and then do something like "You ran the race in 08:33:56!" then you could use the `… 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. Re: Time for some humour before Jan 20 Community Center Geeks' Lounge by Pebble94464 I was going to sail around the globe in the world's smallest ship, but then I bottled it. Re: Time for some humour before Jan 20 Community Center Geeks' Lounge by trcooke A QA tester walks into a bar, orders -4 beers, "2" whiskeys, and Integer.MAX_VALUE + 1 packets of crisps. Re: How much anonymity does a VPN really provide? Hardware and Software Information Security by TurisVPN A VPN helps hide your IP and encrypt your internet, so others (like your ISP) can’t see what you do online. But it doesn’t make you totally anonymous. The VPN company can still see your traffic (if they keep logs). Websites can track you with cookies, and if you log in with your real info, they know who you are. So, a VPN is good for privacy … Re: How much anonymity does a VPN really provide? Hardware and Software Information Security by Liam91 A VPN is a tool that keeps your internet connection safe and private. It stops others from seeing what you do online. But a VPN doesn’t make you completely anonymous. To pick a good VPN, check: -How you pay (Bitcoin is more private than a credit card) -If they keep records of your activity (best if they don’t) -If they share IP addresses … 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 …