At 9:55 PM +0530 9/9/01, Nilesh Parmar wrote:
Hi
I just came across these words in the mailing lists.
Can anyone tell me what are BDB tables and InnoDB tables .
I am new to mysql and would like to know what are they .
thanx in advance
Nilesh
(1) Go to http://www.mysql.com/doc/
hi,
1. can i get a list of locks created with get_lock()?
2. if i create locks with get_lock() and my program stops
with script error before releasing these locks,
how can i release these _dead_ locks?
(i use persistent mysql connections)
thanx,
ati
Hi,
Does mysql support Chinese language?
Thank you,
Regards,
Michael
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Adams, Bill TQO wrote:
The other thing about all of this is that MySQL is feature rich so most people
might not have a use for stored procedures. Unlike, say, Informix which has
not build in MIN or MAX function.
Depending on the way you define things, MIN and MAX are essentially
stored
I use japanese language,
At least, Insert MB data and use MB string to search the DB is OK.
I think Chinese is the same.
best regards
Hxia
-Original Message-
From: Soong, Michael Sau Wah (Michael) [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 4:40 PM
To: '[EMAIL
Hi,
I'm running MySQL on a NT box and do a nightly backup of the complete file
system to tape.
I know I should use mysqldump and probably stop MySQL but will a file system
copy do as well? The system is inactive at the time.
Met vriendelijke groet / With kind regards,
ICL Nederland B.V.
Grega writes:
now, this query executes for about 10 minutes on an AMD 900/256MB and then i
get an execution time exceeded from PHP
Your script is spending too much CPU time on something.
Are you sure that your query doesn't complete? I'd be
very very surprised if it doesn't, since it'd
On Fri, 7 Sep 2001, Robert Alexander wrote:
| Hi Claudio,
|
| I think having the functionality of stored procedures would be a
| wonderful addition to MySQL. Let me be the first to say a hearty
| 'Thank you!' for your very generous offer to devote your vacation time
| to this task.
I definately
YES
Soong, Michael Sau Wah (Michael) wrote:
Hi,
Does mysql support Chinese language?
Thank you,
Regards,
Michael
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi folks,
I've the main developer of nss-mysql. I've found out a very strange
problem.
On a Debian potato, mysql 3.23.38 and glibc 2.1.3
This bit of code segfault on the last line. The string useris correct
(printed correctly in log).
/* we escape the user string */
Howdy,
I tend to do both a dump to disk and then stop the DB and do a tape backup.
I don't believe there is an Online backup capability as user transactions
would need to be stored and played back against the DB after the backup as
in most production ready DB's.
Sid Young
QML Pathology
Hello,
This is the last time I will post this thread. Apparently nobody knows any
solution to this :
The Fulltext search only matches those rows who match
teh exact word, so if I search for bank, the query wont find banking.
(this would work with like '%bank%', but that is much slower). So is
Lorang Jacques wrote:
Hello,
This is the last time I will post this thread. Apparently nobody knows any
solution to this :
The Fulltext search only matches those rows who match
teh exact word, so if I search for bank, the query wont find banking.
(this would work with like '%bank%', but that is
How does mysql manage locks on mergetables?
St. Pinkert
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
Sorry, I should have given you more information about the problem.
We have a Java program, with a J2EE backend which is connected to a MySQL
database.
The database is running on a windows 2000 machine, and we want to output the
contents of the tables in text format(CSV). I can get the
hai ,
We are tryin to get the MySql running on a Intel based Linux box, with microkernel
2.2.16. when i try to install using the MySql using the RPM, it threw a message
stating tht the installation is finished and the mysqladmin is not copied. when we
try to uninstall the same, i get a
The Fulltext search only matches those rows who match
teh exact word, so if I search for bank, the query wont find banking.
(this would work with like '%bank%', but that is much slower). So is
there
anything you can to make it also match those ??
MySQL V3 cannot do what you want. MSQL V4
Nuno,
I noticed a similar unexplained restriction
on our Linux 2.4. We have 512 MB physical memory,
no swap partition, and for some reason I cannot
malloc more than 256 MB. The Unix errno just says
'Cannot allocate memory'.
On our other machine with 900 MB RAM and 512 MB swap
I can malloc 900
Hi everybody,
I'm trying to connect to a mySQL database on the
localhost through a jdbc (mm.mysql.jdbc-1.2b I
downloaded it from mySQL home page) driver, but I
cannot establish the connection for users that need a
password. The java code I use is approximately the
following:
private String
On Mon, Sep 10, 2001 at 02:28:05PM +0300, Heikki Tuuri wrote:
Nuno,
I noticed a similar unexplained restriction
on our Linux 2.4. We have 512 MB physical memory,
no swap partition, and for some reason I cannot
malloc more than 256 MB. The Unix errno just says
'Cannot allocate memory'.
I am trying to use the EXTRA column that exist
in mySQL ( DEFAULT
EXTRA
FIELD
KEY
NULL
PRIVILEGES
TYPE), but I do not understand how to put a
value into it, I can get the value with SHOW COLUMNS,
On 09 Sep 2001 21:24:51 +, Mourad de Riche wrote:
Is he drunk or something? Report to a federal law?
No, he is from United States. According to Sklyarov case they think
that world consists only from them and everyone should follow their
rules, even when not being U.S citizen nor
(This is third attempt to post. always failed in some reason)
I would like to make your attention on bug which was introduced tonight
and can affect some people who are using (var)char field to store
timestamp data.
It is not worst security bug. It affects only people who already had bug
in
Okej I have a site rank script.
When users add the site I want the id number from mysql
to bee shown in the next window. How do I call the id number?
Should it be something like this?:
$id
PLEASE HELP ME.. iiiIIii
Best regeards / Johan Way
Hiya everybody,
I need the advise of a person who knows java servlet programming,
All I need to do is call servlet a's doGet method from servlet b.
Any ideas/code suggestions most welcome.
Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the
list.
Thanks in
Hiya everybody,
I need the advise of a person who knows java servlet programming,
All I need to do is call servlet a's doGet method from servlet b.
Any ideas/code suggestions most welcome.
Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the
list.
Thanks in
Hiya everybody,
I need the advise of a person who knows java servlet programming,
All I need to do is call servlet a's doGet method from servlet b.
Any ideas/code suggestions most welcome.
Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the
list.
Thanks in
Hiya everybody,
I need the advise of a person who knows java servlet programming,
All I need to do is call servlet a's doGet method from servlet b.
Any ideas/code suggestions most welcome.
Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the
list.
Thanks in
;-)
and can't read either ;)
c'mon guys... lets keep the ethnic humour down...
i'm sure it does not do any good to business,
although it sure, well, tingles sometimes...
we all have our natures, cultures, surroundings,
and, understanding and respecting, clears boundaries
and
Hi Folks - simple Q from a newbie,
I'd like to return only the column names using something like show columns.
I'm using PHP to display db tables in html, with the headers of the html
table url'ed to sort the result by field.
It's easy when you hard-code the column names into the page, but I'm
I've got a tour on the web, searching for info and ideas,
regarding the subject to implement some sort of stored procedure in mysql
(remember Lets approach stored procedure thread ?)
This was what I discovered
- The Perl stored procedures (myperl project) in not a good idea
at all, but, even
Hi - I've got an annoying problem here, I've checked books, web,
archives, etc, but can't find anything suitable so far.
I have 2 data tables (ignoring the other columns, not important) :
++
| user |
++
| userid |
++
++
| list |
++
| listid |
SELECT DISTINCT u.userid, IF( ul.listid, true, false)
FROM user u LEFT OUTER JOIN userlist ul ON u.userid = ul.userid
AND ul.listid = listid;
-Original Message-
From: David Otton [mailto:[EMAIL PROTECTED]]
Bonjour,
I have a table created with :
CREATE TABLE mybuffer_NAS_D (
id int(10) unsigned NOT NULL auto_increment,
service varchar(10) NOT NULL default '',
date datetime NOT NULL default '-00-00 00:00:00',
data text,
PRIMARY KEY (id),
KEY id_date (date)
) TYPE=InnoDB;
[EMAIL PROTECTED] writes: [snipped fscking ML bullshit]
database,sql,query,table
David Otton writes:
Users that belong to some lists, but not the one I'm interested in :
this is the one that I'm stuck on. Any thoughts? Suggestions?
SELECT DISTINCT userid FROM userlist WHERE
My Mysqld stopped accepting connections with
Error log:
010910 15:34:19 Error in accept: Too many open files
010910 15:49:02 /usr/local/mysql/libexec/mysqld: Normal shutdown
when trying to connect I got:
ERROR 2013: Lost connection to MySQL server during query
changed max_connections and
I am getting a segmentation fault on a solaris i86pc when executing either
with:
./bin/safe_mysqld
./bin/mysql -h active_mysql_host
On this solaris i86pc, I got the following binary install:
mysql-3.23.39-pc-solaris2.8-i386.tar.gz
Then untarred it with GNU tar
Hi.
On Mon, Sep 10, 2001 at 12:46:01PM +0200, [EMAIL PROTECTED] wrote:
How does mysql manage locks on mergetables?
As far as I can see, it locks all underlying tables. This may not be
the best, but a reasonable approach, because it doesn't know
beforehand which tables will be involved.
Bye,
Hi :
First of all I've test for a short period MYSQL, I
think is great ,,, recently I was navigating MYSQL.COM
and I found and read about the dispute with MYSQL.ORG
I enter the site to see what it was ...
I notice they promote a type of table name GEMINI ...
that support the ACID properties ...
Alex,
slowness of count(*) is a well-known problem.
I will fix it some time this fall. Not very easy,
because of multiversioning and recovery.
The other problem you have is that a delete operation
ends up in a deadlock (I think it should not be called
a 'crash').
I will write in October a
I just got this problem...
bin/mysql -h localhost -u root
logs me into MySQL at the command line
However, the CGI script for Apache webserver gave me an error connecting to
the database
$source = DBI:mysql:red:localhost;
$username = root;
$password = ;
Did any of you ever face this problem
I am trying to compile MySQLGUI for solaris 8. I can't use the precompiled
version as I do not have the same version shared library for libstdc++.
Recompiling that at this point is not an option. The precompiled version is
also several revisions old and not compiled for solaris 8 (this last
Silver Fox wrote:
I just got this problem...
bin/mysql -h localhost -u root
logs me into MySQL at the command line
However, the CGI script for Apache webserver gave me an error connecting to
the database
$source = DBI:mysql:red:localhost;
$username = root;
$password = ;
Did any of
I have a perl-DBI-MySQL database app. that handles everything from my
order entry to my accounts payable. I am in the process of cleaning up
a lot of the code I've written to make it easier to maintain. I
probably use the following DBI staement handle about fifty different
places on
Hello.
On Mon, Sep 10, 2001 at 09:20:55AM -0600, [EMAIL PROTECTED] wrote:
[...]
What I understand is that MYSQL.COM MYSQL.ORG, but
does MYSQL.COM has a table type same as GEMINI ( GEMINI does not complies
with GPL according
to what I read)
that support the ACID PROPERTIES ( TRANSACTIONS )
At 9:20 AM -0600 9/10/01, ROGGER ALEXIS VASQUEZ MARTINEZ wrote:
Hi :
First of all I've test for a short period MYSQL, I
think is great ,,, recently I was navigating MYSQL.COM
and I found and read about the dispute with MYSQL.ORG
I enter the site to see what it was ...
I notice they promote a type
At 2:04 PM +0200 9/10/01, Ralof wrote:
I am trying to use the EXTRA column that exist
in mySQL ( DEFAULT
EXTRA
FIELD
KEY
NULL
PRIVILEGES
TYPE), but I do not understand how to put a
value into it, I can
Hi.
On Mon, Sep 10, 2001 at 02:38:56PM -0700, [EMAIL PROTECTED] wrote:
[...]
I need to find, for each user, whether they are a member of list n :
++--+
| userid | memberoflist |
++--+
| 1 | true |
| 2 |false |
| 3 |
When doing a select that is ordered by a column that is indexed and has a
limit, does mysql not use the index if the order by is descending?
Here's an example:
select parent,number,lastpost from posts where topic=1 and board='abc' and
approved='yes' order by lastpost desc limit 9,12
My app is a
How about
SELECT @last:=MAX(Date + 0) from stat;
Eyal Rif wrote:
Hi,
I have a table with the format of :
char(20),int(7),char(32)
the Date char(20) contents in actually a number(seconds since 1970) -
I want to use a select query that will give the max value according to
number
I have a perl-DBI-MySQL database app. that handles everything from my
order entry to my accounts payable. I am in the process of cleaning up
a lot of the code I've written to make it easier to maintain. I
probably use the following DBI staement handle about fifty different
places on
Did you try deleting the mysql.sock before starting the server?
fsck seems to have changed its file type.
Katrina Maffey wrote:
Description:
After a brief power failure, I rebooted the mysql server machine,
and got this error on startup:
Starting mysqld daemon with databases from
On Mon, Sep 10, 2001 at 09:13:06AM -0700, PR wrote:
And are there future plans for indexing on desc order?
This is already fixed in MySQL 4.0.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL
Hello All,
I've got a question that is likely an easy one, I just want confirmation from
my peers.
I have tables with a timestamp column and perform many selects and counts from
these tables based on the date that the record was written.
Can/should I index a timestamp column? I do my best to
Hi,
so I've tried the binary distribution for linux and I have these errors
in logfile (I've seen them already under 3.23.41, under which I compressed
the tables):
010910 18:12:20 mysqld started
/usr/local/mysql/bin/mysqld: ready for connections
010910 18:13:52 read_const: Got error 127 when
From: [EMAIL PROTECTED]
Can/should I index a timestamp column?
Can: Yes.
Should: Why not?
Should I treat it as a char and
limit it to just index on the portion of the data that distinguishes the date
Hmm, I wouldn't. Offhand, I'd guess that MySQL handles time/date things as integers.
Hi Monty,
Michael Widenius wrote:
Hi!
I have a small comment to this.
Note that you will get crashes in the DBUG package if you call any
MySQL function inside a thread that hasn't called mysql_init() or
mysql_connect().
If you want to use MySQL functions in threads that doesn't
I do:
grant SELECT,alter,index,insert,update on SK_10.* to admin-ab-44
identified by ab-44;
And :
revoke all on SK_10.users_profiles from admin-ab-44;
But the user cant always make a SELECT * from SK_10.users_profiles ;
I want no acces to the table SK_10.users_profiles what can i do?
On Thu, Sep 06, 2001 at 05:26:53PM +0200, Henning Schroeder wrote:
Find all the queries that interact with this table. EXPLAIN them. Time them.
*all* of them? there are lots.
Well, perhaps not initially but you may want to have EXPLAINed a majority
of the queries that are issued against
Depending on the way you define things, MIN and MAX are essentially
stored procedures that were programmed into MySQL. Why not let us make
our own?
This is already possible with Aggregate UDF 's. Check the manual here:
http://www.mysql.com/doc/A/d/Adding_functions.html
dpk
- The Perl stored procedures (myperl project) in not a good idea
at all, but, even if called poor man's stored procedure, I
think that this project don't add, actually, stored procedure in
the precise meamning of term. It add only a binding with Perl via UDF.
It's a nice (and
Tonu Samuel wrote:
On 09 Sep 2001 21:24:51 +, Mourad de Riche wrote:
Is he drunk or something? Report to a federal law?
No, he is from United States. According to Sklyarov case they think
that world consists only from them and everyone should follow their
rules, even when not
hello all,
i am running mysql on a red hat linux v7.0 box. when i
am trying to connect to the mysql database to read a
table that is present in the mysql database i am
facing a strange problem. i am able to get into the
database(named 'newone') to read the table (named
'namelist') from the
Hello,
I'm still having problems with MySQL 3.23 being accent sensitive
during searches. However, I'm now tested to ensure I'm getting the
correct accented search term to MySQL.
Here's my test page, which includes a small database of names with 2
entries per name, one including an accented
Hi.
I'm trying to run a mysqldump. I enter mysqldump
-databases in order to backup all the databases. For
some reason all I'm getting back is a help on the
mysqldump. What am I doing wrong?
thanks
=
__
Do You Yahoo!?
Get email alerts NEW
Hi,
very simple question.
I would like to save and print the contents of myDESCRIBE table_1;
How would I do this?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Good words, Mauricio.
/Rob
Toronto, Ontario, Canada
Ob. MySQL: database, sql, query, table
;-)
and can't read either ;)
c'mon guys... lets keep the ethnic humour down...
i'm sure it does not do any good to business,
although it sure, well, tingles sometimes...
we all have our
Jeremy Morano wrote:
Hi,
very simple question.
I would like to save and print the contents of myDESCRIBE table_1;
How would I do this?
Jeremy:
mysql -e 'DESCRIBE table_1;' | lp
Regards,
Van
--
=
Linux rocks!!!
yes..the /etc/hosts file reads like the following:
127.0.0.1 localhost.localdomain localhost
138.xx.xx.xx mydomain.edu mymachine
thanks
--- Lance Rochelle [EMAIL PROTECTED] wrote:
is localhost setup correctly in /etc/hosts file?
i.e. 127.0.0.1 localhost,
if not put that in
I need to do this seemingly simple thing in mySQL:
SELECT SUM(wucount), SUM(genecount) FROM genomestats WHERE curDate IN
('09-09-2001 9:30:00', '09-09-2001 12:30:00');
However, the SUM() returns the SUM of both dates. However, I could do
SELECT SUM(wucount), SUM(genecount) from genomestats
I'm developing an application and I have to choose a good database
server.
I'm considering MS SQL Server and MySQL.
I haven't heard very much about MySQL, but from I've read on the web I
think MySQL is Unix/Linux orientated and works well with PHP.
I'm going to use a NT platform,
Ok let me explain my problem:
I do:
grant SELECT,alter,index,insert,update on SK_10.* to admin-ab-44
identified by ab-44;
-- So the use get all right...
And :
revoke all on SK_10.users_profiles from admin-ab-44;
-- So now they have all right except in SK_10.users_profiles ...
But the user
YES!!!
I use ASP and MySQL... Works Great
(Win2K, IIS5.0)
John
(www.smalltownworld.com)
- Original Message -
From: L_U_I_Z [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 2:08 PM
Subject: ASP MySQL
I'm developing an application and I have to choose a
I usually use MySQL with MyODBC, then it is just like any other database,
but faster :)
Stefan
-Original Message-
From: L_U_I_Z [mailto:[EMAIL PROTECTED]]
Sent: den 10 september 2001 22:08
To: [EMAIL PROTECTED]
Subject: ASP MySQL
I'm developing an application and I have to
I use ASP and mySQL. I love it!
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.net
717.464.2970
-Original Message-
From: L_U_I_Z [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 4:08 PM
To: [EMAIL PROTECTED]
Subject: ASP MySQL
I'm
At 12:11 PM -0700 9/10/01, Gene Gurevich wrote:
Hi.
I'm trying to run a mysqldump. I enter mysqldump
-databases in order to backup all the databases. For
some reason all I'm getting back is a help on the
mysqldump. What am I doing wrong?
If you're really entering the option as -databases, try
-Original Message-
From: L_U_I_Z [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 9:08 PM
To: [EMAIL PROTECTED]
I'm developing an application and I have to choose a good database
server.
I guess that's not the only choice...
I'm considering MS SQL Server
At 3:18 PM -0400 9/10/01, Jeremy Morano wrote:
Hi,
very simple question.
I would like to save and print the contents of myDESCRIBE table_1;
How would I do this?
Use the --tee option to mysql to create a tee file that serves as a log of
your session, and issue the statement interactively.
Joshua,
I'm not really asking for a new feature. I'm just trying to get the
accent insensitive search to work. If you look at the 3.23 Change Log
http://www.mysql.com/doc/N/e/News-3.23.0.html
the ninth bullet says:
Changed LIKE character comparison to behave as =; This means that
'e' LIKE
I had the same problem with suse 7.2. I see that the path to mysql.sock
is /var/lib/mysql/mysql.sock. this location of mysql.sock was a leftover
from the mysql that i installed from the distribution. the downloaded
version though stores the mysql.sock in /tmp/mysql.sock - i had to tell
a few of
I checked my boot log and found the follwing errors
/etc/init.d/rc.d/S61mysql: @HOSTNAME@: command not found
/etc/init.d/rc.d/S61mysql: my_print_defaults: command not found
I have checked the manual but could not figure out if this is a problem
or not
mysql seems t run fine for now. What are
hi
i'm a newbie with mysql, just knowing well
access
mysql seems to have a lot more of fieldtypes
and i'm wondering, which field type i should
chooce in which case ??
is there a list and description with examples?
i root the manual and was not very satisfied.
thank you for any help
mike
I ran into this and was hoping someone on this list can explain this
behavior to me.
Lets say I have the table table which has id and name, and five rows of
data.
I am using the query
select table.*,if(@count,@count:=@count+1,@count:=1) as count, from table;
What I get is id, name, and five
HI all.
Can I export/import the whole database in MySQL.
I have exported the database into a text file.
Now when I try mysql 'database' filename; it errors
out because column_privs table exists. I thought
mysqlimport would help, but judging by what the manual
says it only imports the single
Hello, I'm a newbie, so pardon my lack of wherewithal with MySQL, and thanks
for the help in advance.
I have two table and I want to copy info from one table to another. I can
pull the correct information out with a select statement that looks
something like this
Select x1 from tbl1, tbl2
I think what you are looking for is the Insert...Select statement
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
- Original Message -
From: Eric Spletzer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Basic (maybe?) question on some optimal variables for MySQLd's my.cnf
configuration ..
Right now, I have three MySQL servers, each with 2 GB ram, dual-CPU P3 1ghz.
They average around 500 connections/second at any given time, two have a
master/slave setup.
MySQL is prettty much the only thing
At 4:35 PM -0500 9/10/01, Sheridan Saint-Michel wrote:
I ran into this and was hoping someone on this list can explain this
behavior to me.
Lets say I have the table table which has id and name, and five rows of
data.
I am using the query
select table.*,if(@count,@count:=@count+1,@count:=1) as
Will this actually work? Because I can't select from the table into which
I'm inserting.
Also I don't want to insert. I want to update a bunch of records that
already exist.
Here is exactly what I want to do.
I have two tables set up that I'm dealing with right now. One is the main
I'm running mysql 3.23.41 on a PIII 800 Mhz machine with 512MB RAM,
linux kernel 2.4.7, dedicated machine (ie, not running anything other
than MySQL). I've been running mysql in a production environment for
nearly 2 years, moderately hit (500,000 - 800,000 database connects per
day) with no
I am having trouble with mysql... i keep getting
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
I uninstalled and reinstalled MySQL rpm (RH 7.1). I originally I was
able to connect to MySQL server via command line client, but could not
connect
On Monday 10 September 2001 09:43, Rodrigo Zerlotti wrote:
here it is...
-
Regards,
Rodgrigo:
Thanks for a bug report. We will try to get this fixed in 3.23.43. Next time,
please write to [EMAIL PROTECTED] when you find a bug and have a test case
for it. This address ([EMAIL
Those are the startup scripts to startup MySQL when the server is rebooted.
view the file /etc/init.d/rc.d/S61mysql and search for @HOSTNAME@ and
my_print_defaults and see how these commands are invoked and if they
exists on your system.
Hope this helps,
-Teresa
-Original Message-
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 6:47 PM
Subject: mysql Digest 10 Sep 2001 21:47:08 - Issue 1490
-
Before posting, please check:
On Mon, Sep 10, 2001 at 04:54:57PM -0500, Weslee Bilodeau wrote:
Basic (maybe?) question on some optimal variables for MySQLd's my.cnf
configuration ..
Right now, I have three MySQL servers, each with 2 GB ram, dual-CPU
P3 1ghz.
Nice. :-)
They average around 500 connections/second at
hi all
this is my first question:
when i try connect since a client windows9x to mysql (in a server linux rh 7.0), say
me the next error:
General Sql Error: [TCX][MyODBC]Access deneied for user [EMAIL PROTECTED] (using
password YES) alias Test
i make the user and system dsn, anyone have a
At 01:46 11.09.01, you wrote:
I'm having a lot of trouble tracing the origin of the problem --
sometimes it seems that accessing a particular large table is causing
it, sometimes it seems that a combination of factors is causing it.
Regardless, what I observe is that within 1 minute my load
This weekend I wanted to better characterize how different key
configurations affect the way rows are inserted. I ran into some behavior I
can't understand:
I created a prototype table to allow me to track the number of events that
occur on a particular day. Events are described with three
Hi all,
I am looking for a freeware-shareware pgm for data entry, on win32 for a
mysql database on Linux(not that it matters I guess), that would allow me to
feed data with drop down or list box field. Any suggestions???
Thanks in advance...
su nobody
ls -l /var/lib/mysql/mysql.sock
Whatever user is trying to get it [such as nobody for a web server usually
or the user]- make sure the user can access the file. Make sure you don't
have maybe /var/lib/mysql to be 750 or something like that. Permissions is
a big one.
--
Mike
-
1 - 100 of 108 matches
Mail list logo