Tagged Questions
0
votes
2answers
77 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
...
0
votes
1answer
57 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
214 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 ...
2
votes
2answers
140 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 ...
