The load tag has no wiki summary.
0
votes
2answers
100 views
High Mysql Load , over 700% CPU
I had high mysql load on server linux 64 bit , 24 G.B ram , Intel(R) Core(TM) i7 CPU 950 @ 3.07GHz ,
Alot of quiers in sending data mode
Here is mysql status
...
1
vote
0answers
34 views
DB2 Load Failure due to timestampformat
I'm trying to load a file into DB2 database table using DB2 Load. I'm able to load the file, using the following statement from the unix prompt.
db2 +p -x load from BOM_Sales_20130326.txt of DEL ...
0
votes
1answer
74 views
Integer comparison in MySQL. does it cause lots of overhead?
I have an 8 digit number in my db. I want to do a select on the table in MySql (Innodb) and get the list of all numbers that are equal or smaller than my number. Then I sort them from larger to ...
2
votes
1answer
745 views
DB2 LOAD data into table - Interpreting the error messages
I encountered some constraint issues when loading data from file into table
**
SQL3109N The utility is beginning to load data from file
"xag".
SQL3500W The utility is beginning the "LOAD" phase at ...
2
votes
1answer
232 views
Do database servers need load balancing?
I am trying to build a 1TB database on MySQL which will need strong read performance. I intend to replicate my database to prevent downtime.
Do my database servers need load balancing to improve ...
3
votes
1answer
156 views
Named pipes connection closed when subjected to load
We're hosting a service where we have a messaging service. When a message arrives, it checks which subscribers it should be sent to by connecting to the database, and querying the subscriptions ...
1
vote
1answer
126 views
Is SET INTEGRITY of any use after IMPORT statements, or just after LOAD statements?
I'm getting the feeling, both from documentation and empirically, that you can only put SET INTEGRITY to good use after a LOAD, not after an IMPORT. LOAD is mentioned for SET INTEGRITY, but not ...
2
votes
2answers
145 views
How do I import a specific line from a text file into MySQL
I'm building an app to import data from a text file to a database.
I want to import only specific lines from the text file. With Navicat I found that we could limit number of line when importing ...
