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
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 20
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 j
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.
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
Yep,
That's exactly what you are supposed to do. It's just like the old days, we
have to do it manually.
BTW, technically speaking, MySQL does support the concept of FKs. It simply
does not enforce them. The up-side is you will never have a deadlocked
stored procedure in MySQL! :)
But serio
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.
I
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
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 use
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 replicated
How do I move a MySQL database to a new computer?
>Description:
It appears that if a column generated by a select is
a sum of variables generated in other columns of the
select (see example below!), the column will have a
bogus result if the select is 'DISTINCT'. If the
DISTINCT keyword is dropped, the column is generated
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
Fi
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 corrupt
In message <[EMAIL PROTECTED]>,
"MikeBlezien" <[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). Th
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 i
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 fail
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
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.
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
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
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 back
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
-
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, 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 = "jdbc:mysql://10.6.5.117
I agree.
Charles
- Original Message -
From: "Cal Evans" <[EMAIL PROTECTED]>
To: "Dave Brown" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, March 10, 2001 11:20 AM
Subject: RE: no libmysqlclient.so in binary distribution
> Dave,
>
> Just guessing here but I would say yes,
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 have
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 us
hi,
i have the following database structure:
- -
| pilote| | flight| | airplane |
|---| |---| |--|
| id| 1 n | id| n 1 | id |
| name |
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
auto-i
$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 T
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 cal
$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:
$
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 pos
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, mysqlgu
Vasel, Renee writes:
> Please provide guidance!
>
> I've been looking over the documentation, but haven't come across any
> instructions for creating your own binary distribution. The MySQL source
> distribution is installed and running on our development system. Now I want
> to make it i
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, s
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
e
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 absence
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
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 sha
41 matches
Mail list logo
