Hi, Eric. The del criteria I've is <delete><query>(keycolumn:blue)</query></delete>
Do you know where I can find working examples to delete in larger chucks, not docByDoc, and not 10 mm doc in one? Much appreciated. On Tue, Nov 14, 2023, 11:41 AM Eric Pugh <[email protected]> wrote: > 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. > >
