/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Need mySql help/ suggestions

10/15/2013 1511 views

I have a mysql DB that has just over 10k records across two tables with some fields being encrypted.  The server is virtual, 4GB of RAM and 1 CPU.  I need to export the records so they can be imported into another system.   I have a query I want to execute and sort by when the record was created.  When I tried to do this the CPU spiked to 100% utilization for several minutes and I eventually killed the query; I did have the query limited to just return 20 results.  

 

 

Is there a better way to get the data out; e.g. should I export the database?  Will that be just a CPU intensive?

1 Comment   [ + ] Show comment

Comments

  • If the target is another system, rather than a report, why bother sorting? Did you try without sorting?

Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ