xPol wrote:
Hi,
i am very new to databases. I would like to know if new entries can be
added to my database from the character terminal.
Hints for achieving such result by a shell script welcome.
http://www.catb.org/~esr/faqs/smart-questions.html
--
MySQL General Mailing List
For list archives
Daevid Vincent wrote:
I'm wondering if we had the foresight to create the tables, and then tack
on extra "dormant" columns of various common types, such as:
Nothing beats empirical evidence. Why don't you try it and find
out (and report back)!
--
MySQL General Mailing List
For list archives:
John G. Heim wrote:
About 5 years ago,...
then the selection committee asked me to add something ...
Then the next year, the graduate school changed their ...
Then they started taking letters of recommendation ...
One might think of this as scope-creep, but really, given the
length of time ove
> Using version 5.0.6x on RH. The question I have is about the updating of
> indexes.
>
> Say I have a table with a primary key and one or more indexes. I run an
> INSERT statement by way of a call to mysql_real_query() in the C api. If
> that function call returns zero, i.e., indicating success, d
Using version 5.0.6x on RH. The question I have is about the updating of
indexes.
Say I have a table with a primary key and one or more indexes. I run an
INSERT statement by way of a call to mysql_real_query() in the C api. If
that function call returns zero, i.e., indicating success, does that me
I think my question is whether the data in MYSQL_RES and MYSQL_ROW data
structures are sufficiently independent from that of other instances of
those data structures in a multi-threaded situation when a pool of
connections are share. The application my have multiple connections
structures defined
> On Sat, Mar 7, 2009 at 12:10 PM, wrote:
> Another way to find out whether this is the problem (yes, I know, you
> already answered this question ;-) is to set concurrent_insert=2 (see
> http://dev.mysql.com/doc/refman/5.0/en/concurrent-inserts.html ).
>
No go. Setting concurrent_insert=2 appea
> On Sat, Mar 7, 2009 at 12:10 PM, wrote:
Is there a way I can restore the concurrent select feature to a
working
state without having to shut down the server and rebuild the entire
data
base?
>>>
>>> Usually when concurrent insert is not permitted, it's because there
>>>
>> Is there a way I can restore the concurrent select feature to a working
>> state without having to shut down the server and rebuild the entire data
>> base?
>
> Usually when concurrent insert is not permitted, it's because there
> are holes in the table that cause inserts to go somewhere other t
> At 07:38 PM 2/25/2009, you wrote:
>
>> >
>> > not sure, though, feel free to report test results
>>
>>Results not good so far. I created a big load file by creating a list of
>>all the files on my server (using "find / -printf ...). and appending
>> that
>
> This bug was reported back in 2006 and
> At 07:38 PM 2/25/2009, you wrote:
>
>> >
>> > not sure, though, feel free to report test results
>>
>>Results not good so far. I created a big load file
>>Then I did a LOAD DATA CONCURRENT INFILE 'my_big_file'...
>>
>>While that was running, I ran a SELECT COUNT(*) query in another session.
>>The
>
> not sure, though, feel free to report test results
Results not good so far. I created a big load file by creating a list of
all the files on my server (using "find / -printf ...). and appending that
file four of five times over for several hundred thousand rows.
Then I did a LOAD DATA CONCUR
I'm working on a system that uses merged tables with insert method LAST,
and occasionally the application runs a LOAD DATA INFILE with a pretty big
input data set. During the load data, other users running selects are
blocked.
As it stands at this time, some of the constituent merged tables in the
13 matches
Mail list logo
