Eric,
I'm looking for a way to eliminate the construction, transmission, and
parsing of the long multi-row INSERT queries that we are issuing from our
client app. Since we are inserting 200k rows a shot, we're looking for
every boost that we can find.
* Connecting: (3) [want to use a connect
Shawn,
Very Interesting idea. I definitely want to look into this a bit more.
I fear though that the bin-logs might be written first to disk before they
are copied over to the replicas.
Another member of my team mentioned there might be a way to issue direct
MyISAM table INSERTS. She suggested
Hi!
I'm looking for a better way to insert large numbers of rows from a client
application that is sampling physical data in real-time. In our case, we
are using a C "double hipvalues[100]" cyclical array to buffer our
sampled values.
We're currently creating large query strings similar to
That could be. If so, it's a MySQL 3.23 limitation that was fixed in
MySQL 4.0.
So, what we are agreeing on is that MySQL 4.x does in fact support both
DESC and ASC indexes?
If this is the case and we're doing something wrong here, cool!
I definitely think the docs should reflect this functiona
>I don't see any relationship between your two sentences?
Thanks for the responses.
I guess I was not clear enough in my last post.
You can define an index to sort values in a particular order... ASC is the
default.
DESC is an option, but it is not implemented yet. I want to know when it
will b
Does anyone know when INDEX DESC will be implemented?
I'm storing time values and want to access the data from the most recent
time value without sorting the result set.
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Hi!
My MyISAM database works perfectly for 98% of the cases that we encounter.
However, there are a few cases during our experiment that we know will
cause spikes in dataflow. We know both the why and when, so we are trying
to plan appropriately for it.
Is there a way that I can mix in memory i
Hi!
My Config:
Running Redhat 9.0 Linux 2.4.20-8bigmem SMP
8GB mem
250GB raid array
My server:
MySQL 4.1.2-alpha-standard
We are running into strange memory related errors with our system.
1) Warning: Asked for 262144 thread stack, but got 126876
On start up, we get the above warning.
How can I hel
