Re: Java Coin Flip Program Programming Software Development by Dani Better late than never! Thanks for your post. It looks like it's really helped a few people already. Re: Java Coin Flip Program Programming Software Development by Salem > It looks like it's really helped a few people already. Yeah, 4 new members with consecutive user ID's, smelling like sock-puppet accounts. Re: Java Coin Flip Program Programming Software Development by Dani > Yeah, 4 new members with consecutive user ID's, smelling like sock-puppet accounts. I realized that after I posted. I’m on my phone on the sofa so it wasn’t as easy to tell. Although I still can’t see the motivation. Edit: Nevermind. Perhaps they were trying to improve their member reputation/quality score?? (Won’t work because you need… 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: 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 Re: Java Coin Flip Program Programming Software Development by jassonadder Hey! You're on the right track with your idea—it’s a great beginner project to practice loops, input, and class methods in Python. Here’s a sample program that does exactly what you're asking. It defines a class with a flipCoin() method, reads in how many times the user wants to flip a coin, prints each result, and then shows the totals at the … 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 **… Null Pointer Exception in Java Application – Need Fixing Programming Software Development by YashSmith My Java application crashes with a NullPointerException when trying to access an … Re: Page Speed Issue Digital Media Digital Marketing by Olu_610 Java-based websites are known to be difficult for speed optimization because they contain certain technical stacks. But with caching and image compression, java website can generate page speeds which are equivalent to those of WordPress websites. Re: Page Speed Issue Digital Media Digital Marketing by Dani The OP was confused. He meant JavaScript, not Java.