Re: 💻 What’s the First App You Install on a Fresh Windows Machine? Hardware and Software Microsoft Windows by Yrth … D: (or anywhere else), then go to C:\users\[username], delete the Documents folder (admin permissions required, probably), then open a… Re: Error LNK1104 when debugging Programming Software Development by toneewa … icon. I ruled it the auto-generated files everytime you delete something to cause the issue. Does that sound familiar? However… 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 … to find things quickly I would imagine that if you delete an index and then take a performance hit it's… 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 …, a list of unused indexes. Worst case scenario, if you delete an index and your processes slow down then you probably… 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 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 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: 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: 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. Remove Qemu/kvm snashots Hardware and Software Linux and Unix by Gabriel9999 How can i list snashot information and delete snapshot from command line or bash in elegant way? Thanks. Re: Are we being played by AI? Let's Discuss! Community Center Meta DaniWeb by Dani …, and I always want to exercise extreme caution and not delete or infract a post unless I'm 100% confident. I… Re: Remove Qemu/kvm snashots Hardware and Software Linux and Unix by Salem https://docs.redhat.com/en/documentation/red_hat_enterprise_linux/7/html/virtualization_deployment_and_administration_guide/sect-using_qemu_img-listing_creating_applying_and_deleting_a_snapshot#sect-Using_qemu_img-Listing_creating_applying_and_deleting_a_snapshot 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 Delete install.php file for security reason please! Programming Web Development by kidcameo Delete install.php file for security reason please! How can I delete this and how to find it..I keep seeing this message when I go to a site I usually visit. only saw it first time today Delete checked item from listview Programming Software Development by abu taher Delete checked item (one or more) from listview I write this … -1 If LVEmp.ListItems(x).Checked Then con.Execute "DELETE FROM stock WHERE [SrNo] = '" & LVEmp.ListItems(x).SubItems… Delete Row on Buuton Click in C# through coding Programming Software Development by abhi10kumar Delete selected record on Button click. I am using MS Access as a Database in C#. How it can be done ?? Delete the highlighted row Programming Software Development by Shodow delete the highlighted row ADODC DATAGRID MYSQL Re: Delete keyword question? Programming Software Development by Ancient Dragon … data you stored at that location is still there, but delete invalidated the pointer you had. Its always a good rule…-of-thumb to reset pointers to NULL after calling delete or delete[] so that the program doesn't mistakenly attempt to…;<" "<<t[1]<<endl; delete[] t; [color=red]t = NULL;[/color] cout<<t… Re: Delete Record But Have an err0r Programming Web Development by smantscheff DELETE the record before you SELECT it, otherwise it will appear in the result list of the select (line 4) before your delete in line 42 kills it. Re: Delete row using ms access Programming Web Development by JorgeM > DELETE FROM Employees WHERE Employee ID If your SQL field has a space between two words, you need to wrap the name within brackets. For example, `DELETE FROM Employees WHERE [Employee ID] = " & TextBox1.Text & " ` Re: Delete an Item from listview Programming Software Development by Dili1234 Delete command is only not working.............. Re: delete data, then shift its number.... Programming Databases by cfAllie --- delete selected question delete from Questions where SurveyID = 140 and QuestionNum = 3 --- decrease subsequent numbers update Questions set QuestionNum = QuestionNum -1 where SurveyID = 140 and QuestionNum > 3 Re: Delete duplicate rows in MySQL Programming Databases by stazeclop04 Delete Duplicate Record Using Delete Join. We can use the DELETE JOIN statement in MySQL that allows us to remove duplicate records quickly. ... Delete Duplicate Record Using the ROW_NUMBER() Function. ... DELETE Duplicate Rows Using Intermediate Table. Re: delete record not working Programming Web Development by pritaeas > delete record not working What is not working exactly?