Hi,
We are using Mysql for the last 4 months. We are happy on following your solutions and
by your valuable support rendered to us.
We now have an issue. Either Mysql or ODBC for Mysql doesn't work. This happens often.
When we reinstall, then it works. ODBC for Mysql was working till
Pete Harlan wrote:
Probably because you need to redirect your output into the file AFTER all
the options. Rewrite your command like this:
In which shell? In SunOS /bin/sh, or in bash, the shell strips out
the redirection, and the program sees what's left. It doesn't matter
where the
Hi all
Not sure if I'm sending my emails to the correct address here, as I havent
had a reply, or even seen my own email ? :o/
Anyway...
I need to store the 'news' which goes onto a web page in a database, I was
going to use the VARCHAR field type but it can only store 255 characters -
which
Look up text and blob fields in the manual.
- Original Message -
From: "Robb Meade" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 03, 2001 15:31
Subject: What field type do I use (NEWBIE)
Hi all
Not sure if I'm sending my emails to the correct address here, as I
Just started using mysql and was wondering if there's a way to specify the
autocommit mode on a per database rather on a per server. I know I can
using the BEGIN/COMMIT to turn off autocommit for a particular call. But
it would be nice to have a coarser granularity.
Thanks,
Albert
Hi,
I know I've allready posted this question but it's rather important for my
final work. I'll add some extra information at the bottom.
I've got a question 'bout the number of number of writes a MySQLserver can
handle in a second. I've written a program which contains the following
code:
Hi,...
Does anyone knows how many databases can handle on MySQL Server?
Does a big number of databases ( perhaps 2.000 or 3.000) can impact on the system
Performance?
Thanks a lot,...
Best Regards!!!
Santiago LLobet (Spain)
Robb,
You'll need a TEXT field, to be sure you pick the right field check
http://www.mysql.com/doc/C/o/Column_types.html
Best regards,
MvG,
Maarten Verheijen
T/EXP kamernummer C558
Telefoonummer 4559
"Robb Meade" [EMAIL PROTECTED] 03-04-01 08:31
Hi all
Not sure if I'm sending my
Un update, the problem was solved thanks to Gerald Clarke and Bob Hall.
They said:
t(6), date date, origine varchar(16));
"The use of a reserved word as a column name probably is the reason
that your table is corrupted as soon as it is created."
I also declared some fields to be
Hi,
As I know, mysqldump --opt command will lock all the tables at once.
I got confused from the above statement. What I have been confused is that
if I have three databases. And I am trying to backup all three databases,
using mysqldump --opt database1 /xxx/datatbase1.sql ...etc... The
Dear Sir,
my name is Martin Weber and I study IT at the University of Dortmund.
For my diploma I need a non comercial database and I decide to use
MySQL. Now I stumbled into a question, and I hope for your help:
I want to insert data into a table with the "LOAD DATA INFILE" function.
The data
Description:
I get this message ,bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MYSQL server thourgh socket '/tmp/mysql.sock(111) Check
that mysqld is running and hat the socket :'/tmp/mysql.sock exists! mysqld is running
fine, but the sock file
Hi,
we currently have a situation with our mysql-3.22.29 under
Solaris-2.7, where the databases itself are put on an NFS-mounted
filesystem. Yesterday we had a crash of the system and isamcheck
tried to recover some databases - but some people have reached or
already exceeded their quotas,
Description:
umcn I get this message ,bin/mysqladmin: connect to server at 'localhost'
failed error: 'Can't connect to local MYSQL server thourgh socket
'/tmp/mysql.sock(111) Check that mysqld is
umcn running and hat the socket :'/tmp/mysql.sock exists! mysqld is running fine, but
the
Hi,
I did the binary installation. Yes, I restarted and checked again, it shows same.
Regds
Ujwol
- Original Message -
From: James Lyon
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, April 03, 2001 3:56 PM
Subject: Re: [couldn't connect to the mysql
U Hi,
U I did the binary installation. Yes, I restarted and checked again,
U it shows same.
The other thing to check is permissions on the directory / sock file
for the user that you're logged-in as. Are you logged-in as the same
user as yesterday?
U Regds
U Ujwol
U - Original Message
Hi,
I have got problems while compiling 3.23.36 under HP-UX11.
gcc exited with an internal error.
I am using gcc version 2.95.2 19991024 (release)
I 'configured' with the following lines:
CXX=gcc
CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti -O6"
CFLAGS="-fomit-frame-pointer -O6
Hi,
I could run it again and connect. Thanks. But can anyone explain, why I had
mysqld.sock instead of mysql.sock in the /tmp folder? Thanks everyone..
Regds
Ujwol
- Original Message -
From: [EMAIL PROTECTED]
To: Ujwol
Cc: MySQL List
Sent: Tuesday, April 03, 2001 4:12 PM
Bonjour,
I have a table created with :
CREATE TABLE intraday_PAR (
symbole char(20) NOT NULL default '',
date datetime NOT NULL default '-00-00 00:00:00',
first double(17,5) NOT NULL default '0.0',
high double(17,5) NOT NULL default '0.0',
low double(17,5) NOT NULL
Bonjour,
I may have copy all the lines from "mysqladmin process-list".
While I'm doing my "DELETE FROM", another program is doing UPDATE on
the query, but this should not be a problem.
[12:32pm]# mysqladmin proc
Bonjour,
I have re-run my query without the other program trying to UPDATE
the table :
mysql delete from intraday_PAR where date'2001-04-03 00:00:00';
Query OK, 364842 rows affected (32.95 sec)
It works.
Why did both threads lock each other.
There is one doing a lot of UPDATE
Leo McCarthy writes:
Hello,
The configure program doesnt recognize my machine type. I am running
SuSe v7.0 on a S/390 mainframe. uname -m returns S390, uname -s returns
Linux and uname -p returns unknown. When I try to configure I get:
Checking host system type... Invalid
skick writes:
I am havving the same problem. I even tried compiling a version. If it
is a window manager problem then how do I fix it. It seems like it
should work wiith both the kde 2.0 window manager and the enlightenment
window manager that is part on gnome.
Hi!
Please try to
Silvio Picano writes:
Might the NFS dependence be a problem?
What does "some other processes access the files" mean? Are you thinking
like automated system backup software, or my own database client
accesses?
Both, as well as copying files, checking file system ...
Scott Ellsworth writes:
Please find ctype.h attached. (I could have just trimmed, but it seemed
likely that you might want info I blatantly trimmed away...)
Also, on another topic, I tried building the berkeleydb option the other
day, and got an error on startup about a lack of
Raf Geusens writes:
Hi,
I know I've allready posted this question but it's rather important for my
final work. I'll add some extra information at the bottom.
I've got a question 'bout the number of number of writes a MySQLserver can
handle in a second. I've written a program which
Tried to post this to mailing.database.mysql, but earthlink's news servers
suck, and it seems the message got dropped. Bleh. Anyway..:
Jeff S Wheeler [EMAIL PROTECTED] wrote in message news:...
Below is a filled-out mysqlbug form. Indexes on HEAP tables are ignored in
numerous queries in
Hi,
May be, you run out of memories. Try to use --large-table command to
startup mysqld.
Hope this help..
- Original Message -
From: "BAUMEISTER Alexandre" [EMAIL PROTECTED]
To: "Heikki Tuuri" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, April 03, 2001 6:49 PM
Subject:
Bonjour,
I have a table created with :
CREATE TABLE intraday_PAR (
symbole char(20) NOT NULL default '',
date datetime NOT NULL default '-00-00 00:00:00',
Don't use reserved words for column names.
first double(17,5) NOT NULL default '0.0',
high double(17,5)
Is there any way to make one field in a table calculate another field.
I'm making a DB that calculates commissions. So in the money_made
field would have the # of sales (sales field) times whatever the
commission would be.
Yes sir, but don't do it. That's the classic example of something
that
Derek Sivers wrote:
Doing a "make" on the newest MySQL stable 3.23.36 source tarball - on a
stock Cobalt RaQ3 (Linux 386) which I've installed MySQL on many times before.
Got this strange error:
gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O6
-DDBUG_OFF -c
Jeff S Wheeler writes:
Tried to post this to mailing.database.mysql, but earthlink's news servers
suck, and it seems the message got dropped. Bleh. Anyway..:
Jeff S Wheeler [EMAIL PROTECTED] wrote in message news:...
Below is a filled-out mysqlbug form. Indexes on HEAP tables are
Andre,
there is probably a bug in inlining of functions in gcc on HP-UX.
You should edit mysql/innobase/include/univ.i and put
#define INSIDE_HA_INNOBASE_CC
on line 11.
You will probably get another compiler error in mysql/innobase/os/os0thread.c
Edit also that file, on line 81, call of
hello mysql;
how can I recreate indices from .frm and .MYD?
laplace:/mnt/bigboy/mysql/newage# /usr/local/mysql/bin/myisamchk -rv
USR_User.MYD
/usr/local/mysql/bin/myisamchk: error: 'USR_User.MYD' doesn't have a
correct index definition. You need to recreate it before you can do a
repair
it
Alex,
a possible temporary workaround you can try: use
LOCK TABLES intraday_PAR WRITE;
in your deleting transaction. It will lock updaters out
of your table while the delete batch is running.
There probably is a bug in hangdling of concurrent deletes
and updates in Innobase. I will try to
Hi,
I am using MySql on Redhat Linux 7.0. Recently I downloaded mySql++.
I installed and confugured it as per the instruction given. But when
I try to run the files in the examples directory I get the error
'Segmentation Fault (core dumped)', pls help.
Sudheer
Hi.
Does mySQL have support for virtual domains ? And if so, how can
i set it up ? (relevant documentation, ...)
Kris
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hiya,
I'm running MySQL 3.23.36 on my Windows 2000 workstation and I noticed
that all table names are converted to lowercase by default??? After some
going through the docs I found the following setting:
lower_case_table_names
So I figured I add:
lower_case_table_names=0
to my
I have a DB that (for the purpose of this email) contains three
tables: projects, comments, and history. Each project will have its set
of comments added, and as the project advances over time, also its set
of history items.
This information gets displayed on a web page roughly in the
Hi
I have a WebObjects Application that I was using with
openbase and when I switched over to MySQL the app. could no
longer save the blob to the db. Is there some way to save a
picture in a blob in binary or should I be doing it another way.
thank
Ian
I've got the following file on RH Linux 7.0:
#include mysql/mysql.h
#include stdio.h
int main()
{
MYSQL mysqlConnection;
mysql_init(mysqlConnection);
mysql_options(mysqlConnection,MYSQL_READ_DEFAULT_GROUP,"Finance Manager");
if
"Kris Van Hulle" [EMAIL PROTECTED] wrote:
Does mySQL have support for virtual domains ? And if so, how can
i set it up ? (relevant documentation, ...)
MySQL has its own security system that doesn't rely on the
security/authentication system of the underlying operating system. In the
manual at
"Ashley M. Kirchner" [EMAIL PROTECTED] wrote:
If I list 15 to 30
projects per page, that's 31 to 61 queries for one page: once to the
projects table to get the projects, then for each project I make two
queries, one to the history table and one to the comments table to get
the accurate
Good morning all, last night I installed MyODBC on my laptop. What i dont
understand is how do i connect threw access now?
I'm a little confuse, can anyone help me understand how MyODBC works.
luis
-
Before posting, please
"Bob Hall" [EMAIL PROTECTED] wrote:
Quorting someone else who's name is no longer present:
Is there any way to make one field in a table calculate another field.
I'm making a DB that calculates commissions. So in the money_made
field would have the # of sales (sales field) times whatever the
On my replicated linux machines with the latest 3.23.36 rpm from mysql.com, I
have been getting the following errors lately:
010403 17:08:35 Slave: received 0 length packet from server, apparent master
shutdown: (0)
010403 17:08:35 Slave: Failed reading log event, reconnecting to retry, log
On Tue, Apr 03, 2001 at 10:46:22AM -0400, Steve Werby wrote:
"Kris Van Hulle" [EMAIL PROTECTED] wrote:
Does mySQL have support for virtual domains ? And if so, how can
i set it up ? (relevant documentation, ...)
MySQL has its own security system that doesn't rely on the
Luis wrote:
Good morning all, last night I installed MyODBC on my laptop. What i dont
understand is how do i connect threw access now?
I'm a little confuse, can anyone help me understand how MyODBC works.
luis
It is an ODBC driver for Mysql.
Create a databsae in mysql
go to the ODBC
Hi ,
You must go to control panel of windows in Data Sources(ODBC) section and add your DSN
of you new MySQL database and then you can explor the database by browsing your ODBC
avilable databases . You can check MyODBC manual for this .
On Tue, Apr 03, 2001 at 06:55:52AM -1000, Luis wrote:
Hello.
On Tue, Apr 03, 2001 at 10:53:06AM +0100, [EMAIL PROTECTED] wrote:
Hi,...
Does anyone knows how many databases can handle on MySQL Server?
AFAIK, it is only limited by your operating system (databases are
stored as directories, so the question is how many directories your OS
is
Hello.
On Tue, Apr 03, 2001 at 11:51:47AM +0200, [EMAIL PROTECTED] wrote:
Hi,
we currently have a situation with our mysql-3.22.29 under
Solaris-2.7, where the databases itself are put on an NFS-mounted
filesystem. Yesterday we had a crash of the system and isamcheck
tried to recover some
I think what Kris needs answered is...
If mysql.a.com and mysql.b.com are two virtual hosts on the same
physical server, can
mysql -h mysql.a.com dbname
and
mysql -h mysql.b.com dbname
be differentiated. I'm fairly sure that mysqld has an option so that the
IP to bind to can be specified
Make sure that the files are not world readable.
On Tue, 3 Apr 2001, Taing Nguon wrote:
Date: Tue, 3 Apr 2001 09:52:30 +0700
From: Taing Nguon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: MySQL Security
Dear sir or madam
MySQL user's account is not related to user's account on
When you set to ignore a table on the slave ( say replicate-ignore-table=foo.bar ),
will the updates
be sent to the slave and then filtered out, or will they not be sent at all to the
slave machine from the server?
Just wanna know, because I got a table with lots of updates and have set the
Then two MySQL installed on a machine can use the same port 3306 or
one of them must changed to another port ?
Unless you have some auto-magical port-proxy thingy you have to have
different ports for each working server on the same machine.
Or does MySQL have native handling of this? (I would
I think that must install them on diffrent ports .
On Tue, Apr 03, 2001 at 05:27:16PM +0100, Aigars Grins wrote:
Then two MySQL installed on a machine can use the same port 3306 or
one of them must changed to another port ?
Unless you have some auto-magical port-proxy thingy you have to
Hello,
I have a table design question relating to best practice and performance.
Monthy is somewhat of a SQL guru and so may be many others on this list,
this may actually help a lot of folks out there:
Example:
I want to get a listing of all applicable rates for a delivery:
a rate can be
hi,
i would like to show 5 random field from a total of 100.
id is my primary key
id name
--
abmarcos
akjohn
how can i show 5 of them randomly?
thanks in advance,
marcos
[EMAIL PROTECTED]
I am using mysql to store content that will contain double-byte (korean,
japanese) language text -- What is it that I need to specify when inserting
that type of text (if anything) and how do I retrieve it? I am writing in
Java using JDBC to a mySQL database.
Thanks,
Kim Albee
Ok i'm still a little bit lost. I have a database in MySQL called "irm"
In the ODBC Data Source 32 bit I went in user dsn and added user data source
called irm the driver is mysql
not this is were i dont understand .
In the field that says Windwos DSN name I put "irm"
MySQL I put the ip
Hi,
I'm running MySQL 3.22.32 on Slackware Linux (not sure about the exact
configuration or kernel - don't have telnet access to the machine at the
moment; apologies). I have three tables:
* domains - a large monolithic table with 1 primary key and 3 other
keys, 43
fields in total, 1344
After installing the server and client RPMs on my RH 7 box and verifying that
everything worked properly as root. Since I want mysql to run as the mysql user, I
searched for every directory where mysql occurred and changed ownership from root:root
to mysql:root. I can start safe_mysqld fine
On Tue, 3 Apr 2001, Marcos wrote:
hi,
i would like to show 5 random field from a total of 100.
id is my primary key
id name
--
abmarcos
akjohn
how can i show 5 of them randomly?
thanks in advance,
marcos
When you say "5
Hello,
I have a site that I'm trying to implement a search engine on existing and
archived news stories on a medium text datatype in a database.
I read the documentation and got it running, but unless I missed something
it's not doing what I want it to do.
For example, if I put in the
In the field were "Windows DSN name" what do I put there.
Also if i just created a database in mysql called customer
would i put the that name in "MySQL database Name"
-
Before posting, please check:
I haven't had any success so far finding any help in the manual or Monty's
book about this particular condition, so any help is appreciated.
I don't know about the RPM's. But if you would install from source there is
a directory called Docs containing a manual.txt I did NOT compare this with
Design Question
Hello,
I have a table design question relating to best practice and performance.
Monthy is somewhat of a SQL guru and so may be many others on this list,
this may actually help a lot of folks out there:
Example:
I want to get a listing of all applicable rates for a delivery:
Hi all,
I have an upcoming project to port a large application, currently
uses Oracle as its database, to a new architecture.
As part of this conversion, we're investigating the possibility of
changing the database component to Mysql.
Having never worked with Oracle, I'm at somewhat of a loss
To do a full word match like you are wanting, you would need to break up the
sql query to do this:
... WHERE field LIKE "%word1%" AND field LIKE "%word2%" ...
That is how you have to do it if you are not using one of the latest 3.23
versions of mysql. If you have a newer version of mysql,
Greetings:
I'm using the datetime format and the data is stored in mySQL as CCYY-MM-DD
HH:MM:SS
I want to use a SELECT statement where the ORDER BY clause is based on the
date portion (CCYY-MM-DD).
How would I write the clause to ignore the time portion?
Thank you.
Can a program connect to an Oracle (or Sybase, Informix or DB2) database using MySQL++?
I have not been able to find any documentation on binding a mysql
process to a specific interface. The application would be for setting
up a high availability, failover environment where a server can take
over an IP and services running on that machine, given that the file
systems can be shared
"Hamid Hashemi Golpayegani" [EMAIL PROTECTED] wrote:
Then two MySQL installed on a machine can use the same port 3306 or one of
them must changed to another port ?
They'll need to be on separate ports and have separate socket files. You'll
just have to append the port to the host as follows
On Tue, 03 Apr 2001 15:00:31 -0400, "Peter M. Perchansky"
[EMAIL PROTECTED] wrote:
Greetings:
I'm using the datetime format and the data is stored in mySQL as CCYY-MM-DD
HH:MM:SS
I want to use a SELECT statement where the ORDER BY clause is based on the
date portion (CCYY-MM-DD).
How would
"Peter M. Perchansky" [EMAIL PROTECTED] wrote:
I'm using the datetime format and the data is stored in mySQL as
CCYY-MM-DD
HH:MM:SS
I want to use a SELECT statement where the ORDER BY clause is based on the
date portion (CCYY-MM-DD).
How would I write the clause to ignore the time portion?
Hi!
Can anyone help me with a probably simple issue?
All I need to be happy forever is to the inverse of the following:
insert into user (host, user, password) values ("localhost", "tvinhas",
password("phl1nao8"));
and
insert into db (host, db, user, Select_priv, Insert_priv, Update_priv,
Hi,
I have one site developed with php+mysql. We have about 10.000 visits per day with
more or less 250/300 users on prime time. When users increase over 200 mysql starts
runing some errors and restarting...
Number of processes running now: 0
010402 21:33:13 mysqld restarted
Hi
Does anyone know why no matter what user I log into my database undr, the
only history file that is being written to is root's :
/root/.mysql_history
Why is a history file not created in the users home directory?
Thank You so much to anyone who has the time to help.
Scott
Have you tried using REVOKE instead?
Are you sure YOU have DELETE privilege on the mysql database?
You should be able to: DELETE FROM mysql.user where User='tvinhas';
And from the other databases that use the User field.
On 4/3/01 12:51 PM, "Thiago Vinhas de Moraes" [EMAIL PROTECTED]
wrote:
My apologies, I didn't clarify that I *was* using a full-text search.
-Original Message-
From: Lindsay Adams [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 11:52 AM
To: [EMAIL PROTECTED]
Subject: Re: Full Text Search Question
To do a full word match like you are wanting, you
"Thiago Vinhas de Moraes" [EMAIL PROTECTED] wrote:
Can anyone help me with a probably simple issue?
All I need to be happy forever is to the inverse of the following:
insert into user (host, user, password) values ("localhost", "tvinhas",
password("phl1nao8"));
and
insert into db (host,
I finally did find a discussion in Monty's book on p. 417 about this.
Thanks,
Brian
- Original Message -
From: "B. van Ouwerkerk" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 03, 2001 11:20 AM
Subject: Re: ownership/permission problems
I haven't had any success so
delete from user where user='tvinhas' and host='localhost';
delete from db where user='tvinhas' and host='localhost';
Cal
http://www.calevans.com
-Original Message-
From: Thiago Vinhas de Moraes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 2:51 PM
To: [EMAIL PROTECTED]
I've posted this problem before, but I didn't get any responses.
Has anyone had problems with errors like this with replication:
010403 3:34:26 Error reading packet from server: bogus data in log event (read_errno
0,server_errno=65535)
This seems to happen when I do a large number of
Howdy,
I am trying to run mysqldump and I am getting a memory error.
=
mysqldump: Out of memory (Needed 65576 bytes)
mysqldump: Got error: 2008: MySQL client run out of memory
=
I have 256 megs of ram on the server and I just added another 256 megs ...
same
it matters what you run the mysql client as
if I'm root
root: # mysql -u foo -p
the program mysql is running as root and hense writes the history file to
root's home dir.
if I'm me
andrew: $ mysql -u foo -p
it'll write it to ~andrew/.mysql_history
regards,
-- Andrew
- Original
Can somebody tell me where i'm wrong ?
insert into table3 select * from table1 where RecNo = 12 --- this
works
insert into table3 select * from table2 where RecNo = 12 --- Nothing
Happens
There are 3 fields in all tables, 2 LongText, and 'RecNo' -
AutoIncrement
Thanks in advance
--
Martin
could i respectfully request help, i am totaly lost
as to how to format this code
as well as only been with mysql perl for 2
weeks.
i am trying to take a real time internet tcp feed
that is a comma deliminated row
and input into fields in a mysql
database
my attempt although possibly
You probably need to boost the memory limits up in your shell (ie with bash
see man ulimit)
Mike
Jeremiah Griffin wrote:
Howdy,
I am trying to run mysqldump and I am getting a memory error.
=
mysqldump: Out of memory (Needed 65576 bytes)
mysqldump: Got error: 2008:
Friends,
I need to manager database MySQL on UNIX Server from Windows NT and I found the
software netadmin.exe, that it is very good, written and maintained by David Axmark.
I didnt find how to create tables on UNIX server from windows NT... If somebody
knows how to do this, please
"Martin Jeremic" [EMAIL PROTECTED] wrote:
Can somebody tell me where i'm wrong ?
insert into table3 select * from table1 where RecNo = 12 --- this
works
insert into table3 select * from table2 where RecNo = 12 --- Nothing
Happens
Post to the list the output of:
DESCRIBE table1
SELECT
Db - table1, table2 and table3
SELECT table1.task, table2.comment, table2.remarks, table3.history
FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid
LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10;
Results (roughly) in:
To access the Unix database from NT, there is a good tool I use called
webmin (http://www.webmin.com/). It is written in perl and uses a http
connection through a different port. I don't know about connecting to NT
from Unix, I only have databases on Linux.
len.
-Original Message-
What is the maximum number of connections MySQL can handle?
I would like to use MySQL as a logging server, for some 500 machines,
but i'm not sure it is able to handle so many simultaneous connections
(the clients will do only INSERT or INSERT DELAYED).
--
Florin Andrei
Depends on your hardware...
500 machines of logging, how many entries per second? I've seen people
report their MySQL installs doing hundreds or thousands of queries per
second, and not even phasing the machine.
- Original Message -
From: "Florin Andrei" [EMAIL PROTECTED]
To: [EMAIL
On 03 Apr 2001 16:49:36 -0700, Eric Fitzgerald wrote:
Depends on your hardware...
500 machines of logging, how many entries per second?
I'm not sure, but i believe most of those machines will not send more
than a couple of events per second. Some of them (but not too many) will
surely send
In that case I refer you to the archives:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:70079:hkagoolipmedibdijphh
That message mentions that in his normal operation he is handling 1631
queries per second without even phasing the machine. He also mentions that
he got the machine digesting over
Using Windows and Statically Compiled MySQLGUI 1.7.4, it appears to refuse to connect
until I go to Options and Apply again every time I wish to connect.
Grant/revoke crashes the application, while appearing to be downloading data through
my modem. I don't get to the grant/revoke screen.
How does one tell if mysql is using BDB? Do I have to somehow specify BDB
when creating a new database? I've installed BerkeleyDB and mysql, yet it
doesn't look like it's using bdb. Unable to rollback any insert's.
Thanks,
Albert
How does one tell if mysql is using BDB?
SHOW TABLE STATUS;
Type = BerkeleyDB
http://www.mysql.com/doc///S/H/SHOW_TABLE_STATUS.html
Do I have to somehow specify BDB
when creating a new database?
CREATE TABLE [...] TYPE = BDB;
http://www.mysql.com/doc///C/R/CREATE_TABLE.html
I've
1 - 100 of 113 matches
Mail list logo