Roger,
On Sat, Mar 10, 2001 at 12:52:54AM +0100, Roger Westin wrote:
Thanks Setve,
but right now I cant change the filesystem, so I need to go for the
with-raid option,
I read the manual and recompiled my MySQL, but I still cant get bigger
files than 2GB. Accordning to the manual it shall
Hy!
I have a problem I couldn't solve by my one. Here is a sample of mysql
client output:
mysql use lumina;
Database changed
mysql select * from absences;
ERROR 1030: Got error 127 from table handler
The table absences exists. I tried to delete it and create it again and I
get the same error.
Try REPAIR TABLE absences; This should do the trick:-)
Hy!
I have a problem I couldn't solve by my one. Here is a sample of mysql
client output:
mysql use lumina;
Database changed
mysql select * from absences;
ERROR 1030: Got error 127 from table handler
The table absences exists. I
Hello
I get a lot of these in my hostname.err file. When the load is high i
get around 10 every minute.
010310 13:01:51 Aborted connection 215 to db: 'XXX' user: 'XXX' host:
`XXX' (Got an error reading communication packets)
What does it mean? Everything seems to work ok, except this strange
Aaron Weiss writes:
Hi,
I wanted to create a UDF for MySQL that can use the ASpell engine to
generate a string of spelling suggestions, given a single word
parameter. Thus, select aspell('wrd') should return Aspell's suggested
spellings.
I don't know C very well at all, so I
Herve Gaudillat writes:
Hello,
Thank you very much for your quick answer .
(I had forgotten to give my OS : solaris 2.7 on Sparc)
This has solved the connection problem. So, now I can launched mysqlgui because
I'm able to connect to mysqld .
Unfortunately, mysqlgui
Here is a query:
$query="Select RECEIVER from TRANS_TBL order by TRANS_ID DESC LIMIT 10" ;
How do I change this query to skip rows if it already selected a row with
that particular receiver in it?
Thanks
randy
-
Before
$query="Select DISTINCT RECEIVER from TRANS_TBL order by TRANS_ID DESC LIMIT
10" ;
HTH,
Cal
http://www.calevans.com
-Original Message-
From: Randy Johnson [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 10, 2001 9:42 AM
To: [EMAIL PROTECTED]
Subject: GETTING ROWS
Here is a query:
I have a busy website that uses mysql. It crashed this morning. I don't
know where to begin to fix it. I did notice in my httpd-error.log that I've
been getting a bunch of errors:
DBI::db=HASH(0x8101d68)-disconnect invalidates 1 active statement handle
(either destroy statement handles or
$query="Select DISTINCT RECEIVER from TRANS_TBL order by TRANS_ID DESC LIMIT
10" ;
- Original Message -
From: "Randy Johnson" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, March 10, 2001 10:41 AM
Subject: GETTING ROWS
Here is a query:
$query="Select RECEIVER from
I'm porting some code from perl to php, and have experienced a tremedous
slowdown in one particular query, and I'm perplexed as to why. The query
is simply "Select * From my_table order by ID desc LIMIT 0,20", to get the
last 20 records that were entered. ID is the Primary Key, and it is
hi,
i have the following database structure:
- -
| pilote| | flight| | airplane |
|---| |---| |--|
| id| 1 n | id| n 1 | id |
| name |
I have a working 3.22 setup with perl DBI and php4 (using the php supplied
mysql libraries).
If I install the binary 3.23 distribution then perl DBI no longer works
because it is looking for libmysqlclient.so.6 which is not in the binary
distribution (Solaris 7).
Does this mean that I have to
Dave,
Just guessing here but I would say yes, rebuild form the source.
Cal
http://www.calevans.com
-Original Message-
From: Dave Brown [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 10, 2001 9:55 AM
To: [EMAIL PROTECTED]
Subject: no libmysqlclient.so in binary distribution
I
I am a computer science student who has a project to in a few weeks.
I have been trying to get my Java program make connections to mysql server running on
my windows PC. I got the right drivers but I keep getting bad handshake error..
This is what I used
String address =
Hello All,
We have a table where keywords will be entered into a column (searchwords), up
to 3 unique keywords. Then this column will be used in a keywords search tied to
a Category(a Category has to be selected). The table will have a category
column: category. Basically when a search is done,
Hello,
I have been trying to install MySQLGUI but I have not been so
lucky. I am running on SUN Solaris 7 Sparc... but after I downloaded
your static binary of MySQLGUI1.6... I
could not install it... any suggestion and help will be greatly
welcome...
shen yingshuo
MySQL 3.23 has full-text search built-in, and it's made for exactly this
situation. You'll need to create a index of type FULLTEXT:
http://www.mysql.com/doc/M/y/MySQL_full-text_search.html
Of course, the other way to do this is to create another table with the
keysword in it, and a pointer
On Sat, 10 Mar 2001 14:24:18 -0500, "Tac/Smokescreen Action Network"
[EMAIL PROTECTED] wrote:
Would you happen to have an example?? I did look at the FULL TEXT search, but
I'm not sure this would work in our situation,... but we maybe able to adapt to
it.
TIA,
Of course, the other way to do
I have been getting the same error message, but using perl and DBI. One
thing it MAY be but I haven't been able to pinpoint it is when for some
reason my program dies because of a bad query or the mysql server getting
sig11. Dunno.
Anyone else have this problem? Anyone know what causes it or if
i'm trying to execute a sql script in batch mode. the command i'm typing is:
mysql createdb.sql;
does the createdb.sql script need to be in a specific directory for mysql to
recognize it? i've tried putting it in mysql\bin and mysql and specifying
relative and absolute paths to the file.
Hello all,
I'm trying to write what should be a simple query but is turning out to
be a particularly difficult one and was wondering if I could ask your
advice.
The problem is to do with some harbour management software I'm writing for
a university software course. I have a table which gives the
Hi,
I have a mysql server running, and I can access it directly by typing
'mysql' and I can use the test database, as any user. The database *is*
running.
I installed DBI-1.14 and Data-ShowTable-3.3. Then with
Msql-Mysql-modules-1.2215, I ran
perl Makefile.PL
make
make test
The test
Well ... actually, I recommend you stay out of \mysql\bin and run scripts
from some other directory.
Your message doesn't say it, but I assume you are running on a Win32
platform. You should put c:\mysql\bin (or wherever it is installed) into
your computer's path. That way, you can put scripts
In message [EMAIL PROTECTED],
"MikemickaloBlezien" [EMAIL PROTECTED] writes
Hello All,
We have a table where keywords will be entered into a column (searchwords), up
to 3 unique keywords. Then this column will be used in a keywords
search tied to
a Category(a Category has to be selected). The
Today I was having more index corruption problems.. the fact
that it typically happens on the *biggest* and *busiest* tables
leads me to believe that the request rate on my database
might be right off the scale compared to other users, who are
not reporting corruptions nearly as often.
My
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Can't compile MySQL 3.23.33 on Solaris 7 (x86)
Description:
Configure fails, says there may not be any static libraries. I can find
libm.a in /lib
however. I have installed G++ 2.95.2
How-To-Repeat:
./configure --prefix=/usr/local/mysql
How do I move a MySQL database to a new computer?
Maybe I'm not understanding how replication is supposed to work, but I've found a
situation where it definitely does not log changes. I'd just like to know if this is
normal or not.
Say you have two databases (call them data1 and data2) on your master server. Only
data1 is being
On Sat, Mar 10, 2001 at 06:41:20PM -0500, Justin wrote:
Today I was having more index corruption problems.. the fact that it
typically happens on the *biggest* and *busiest* tables leads me to
believe that the request rate on my database might be right off the
scale compared to other users,
Hello Fernando,
Tuesday, March 06, 2001, 7:13:50 PM, you wrote:
FRS Where can I find the ODBC API Documentation to create a new ODBC
FRS driver? and the JDBC API?
msdn.microsoft.com
see in platform SDK-DB and msgng services-MDAC SDK-ODBC
--
Best regards,
Alexey
hello .
I am new to mySQL
I am really surprised on mySQL not supporting 'FOREIGN KEYS'.
Like oracle , foreign keys are used to perform on delete cascade to child tables,
which eventually performs
a delete operation on child table , if any primary key row is deleted from the Parent
table.
Well thats good to know.. although this is sustained 24x7x365
linux 2.2.14-5.0smp, uptime 170 days but e2fsk ok's the
the database partition, which is a mirror.
in an attempt to get stability, I've been running on the official
3.22.32 mysql binary for a month now .. it hasn't helped.
Typically
Hi,
I would like to use AUTO_INCTRMENT on a column but
I would like it start from zero.
Example:-
ID | Colour
0 | black
1 | white
2 | red etc...
From my understanding of the manual,
if insert a NULL into an AUTO_INCREMENT column,
the next number in the sequence is inserted.
On Sun, Mar 11, 2001 at 01:16:20AM -0500, Justin wrote:
Well thats good to know.. although this is sustained 24x7x365
My average rate over the last 67 days is about 52/second. In reality
we have some periods of much higher load (several hundred per second)
and some of much lower load. It is
I have a server that averages 256 queries/sec.
It maxes out at 1187 queries/sec.
It averages about 100 threads and maxes out at about 300.
I've never experienced the problems below with corrupted tables, but I
have been experiencing an interesting problem lately.
Normally the server uses about
What is your key buffer size? In my case, key buffer size is set
to 384mb .. and mysqld starts out small, perhaps 18mb and grows
within a day to 100mb, and within a few days to pretty much 300+mb
..so it is doing what one would expect it to.
The other mem parameters combine in ways explained in
37 matches
Mail list logo
