You could write a streaming expression as well…. Or, if you are really nervous, just write a script yourself and make sure that you issue each delete sequentially or some other rate limiting step?
> On Nov 14, 2023, at 10:59 AM, Vince McMahon <[email protected]> > wrote: > > Ishan, within that UI, I have the choice to set "Commit Within". Is there > a way to via the UI to pause all indexing operations? And how to resume, > afterward? > > On Tue, Nov 14, 2023 at 9:54 AM Ishan Chattopadhyaya < > [email protected]> wrote: > >> It should be fine. The DBQs are locking operations on all shards, so >> concurrent indexing might get slowed down. To be safer, pause all indexing >> operations at the time. >> >> On Tue, 14 Nov, 2023, 5:25 pm Vince McMahon, < >> [email protected]> >> wrote: >> >>> I know it will be around 10 million docs. >>> >>> My question is more about will setting 10 sec commit making the solr >>> unstable and crashes? >>> >>> Is there a safer way doing it via the UI? I have only one filtering >>> criteria for delete , that is keycolumn:blue. It will delete 10 million >>> docs. >>> >>> >>> >>> >>> >>> >>> >>> >>> On Tue, Nov 14, 2023, 3:00 AM Vincenzo D'Amore <[email protected]> >> wrote: >>> >>>> Hi, this will delete all the documents matching the query >>>> *keycolumn:blue * >>>> If you are unsure about how many they are, just try the query using the >>> UI >>>> and see the num found value. >>>> >>>> On Tue, Nov 14, 2023 at 4:51 AM Vince McMahon < >>>> [email protected]> >>>> wrote: >>>> >>>>> Hi, >>>>> >>>>> I have a core with 200 million records. >>>>> >>>>> I want to use the UI to delete a large number of docs, liked 10 >> million >>>>> docs. >>>>> >>>>> So, I plan to click on the dropdown for the 200MMcore, >>>>> click on Documents, >>>>> the Document Type is "XML", >>>>> the Document(s) >>>>> is <delete><query>(keycolumn:blue)</query></delete> >>>>> Commit Within >>>>> 10000 >>>>> Overwrite >>>>> true. >>>>> >>>>> Will it bring down the server deleting 10 million liked this? >>>>> >>>> >>>> >>>> -- >>>> Vincenzo D'Amore >>>> >>> >> _______________________ Eric Pugh | Founder & CEO | OpenSource Connections, LLC | 434.466.1467 | http://www.opensourceconnections.com <http://www.opensourceconnections.com/> | My Free/Busy <http://tinyurl.com/eric-cal> Co-Author: Apache Solr Enterprise Search Server, 3rd Ed <https://www.packtpub.com/big-data-and-business-intelligence/apache-solr-enterprise-search-server-third-edition-raw> This e-mail and all contents, including attachments, is considered to be Company Confidential unless explicitly stated otherwise, regardless of whether attachments are marked as such.
