How to change the lib path ...
Hi guys, I just have a problem since yesterday, RedHat 7.0 make standard a partition of 256 mb for /var and mysql database are to big for this (so it crashes). Can someone tell me how to change the /var/lib/mysql path to /home/lib/mysql. I changed every file to this path (mysqld, mysql_config, ...) but nothing append. Thx for help, Didier
How to change the lib path ...
Hi guys, I just have a problem since yesterday, RedHat 7.0 make standard a partition of 256 mb for /var and mysql database are to big for this (so it crashes). Can someone tell me how to change the /var/lib/mysql path to /home/lib/mysql. I changed every file to this path (mysqld, mysql_config, ...) but nothing append. Thx for help, Didier
Re: How to change the lib path ...
Hi The config file you are looking for is /etc/my.cnf, I believe. The paths for all mysql related files and dirs are there. Seung-woo Nam "Didier Desmet (RSCA)" wrote: Hi guys, I just have a problem since yesterday, RedHat 7.0 make standard a partition of 256 mb for /var and mysql database are to big for this (so it crashes). Can someone tell me how to change the /var/lib/mysql path to /home/lib/mysql. I changed every file to this path (mysqld, mysql_config, ...) but nothing append. Thx for help, Didier - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Support request - ID support 4300
Hi, It's possible to create a database in a differents directories ? And how to make it ? Thanks Carlo Carlini - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to change the lib path ...
No there is /etc/my.conf but this file is empty ? - Original Message - From: Seung-woo Nam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 02, 2001 10:04 AM Subject: Re: How to change the lib path ... Hi The config file you are looking for is /etc/my.cnf, I believe. The paths for all mysql related files and dirs are there. Seung-woo Nam "Didier Desmet (RSCA)" wrote: Hi guys, I just have a problem since yesterday, RedHat 7.0 make standard a partition of 256 mb for /var and mysql database are to big for this (so it crashes). Can someone tell me how to change the /var/lib/mysql path to /home/lib/mysql. I changed every file to this path (mysqld, mysql_config, ...) but nothing append. Thx for help, Didier - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Inserting more that 16MB of data in a LONGBLOB field.
On Thu, Mar 01, 2001 at 11:41:52PM +0100, Christiaan den Besten wrote: Hi all, Hi, the bugs list is the wrong list I suppose, so I replied to the mysql list (and you in case you don't read it). i've been using mysql for some time now and never had any serious problems I could not solve using the online manuals ( my compliments ! ). But now I've got a problem which requires some help. ... I'm trying to insert binary data into the "inhoud" field. For all files smaller that 16MB that's no problem. But with files larger dan 16MB I get the well know "mysql server has gone away." error. For the record, I use PHP to insert the data. PHP is configured to use upto 256MB of available memory. You're probably looking for the max_allowed_packet setting, which limits the packet size for communication with the MySQL daemon. The docs say that the setting is limited to 16M and the default is even lower. http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[hazelsct@mit.edu: Bug#88186: mysql: Fails to build on ARM: char sign issue?]
Hello Any ideas? -christian- Package: mysql Version: 3.23.33-1 Severity: normal Greetings, The build fails on ARM. Here's the end of the build log: g++ -DMYSQL_SERVER-DDEFAULT_MYSQL_HOME="\"/usr\"" -DDATADIR="\"/var/lib/mysql\"" -DSHAREDIR="\"/usr/share/mysql\""-DHAVE_CONFIG_H -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -c mini_client.cc cc1plus: warning: -g with -fomit-frame-pointer may not give sensible debugging mini_client.cc: In function `int mc_sock_connect(int, const sockaddr *, unsigned int, unsigned int)': mini_client.cc:300: passing `size_socket *' as argument 5 of `getsockopt(int, int, int, void *, socklen_t *)' changes signedness mini_client.cc: In function `struct MYSQL * mc_mysql_connect(MYSQL *, const char *, const char *, const char *, const char *, unsigned int, const char *, unsigned int)': mini_client.cc:590: passing `int *' as argument 5 of `gethostbyname_r(const char *, hostent *, char *, unsigned int, hostent **, int *)' make[4]: *** [mini_client.o] Error 1 make[4]: Leaving directory `/redhat/packages/mysql-3.23.33/sql' Looks like it might be a char sign issue. ARM defaults to unsigned char (as does PPC). Does a "signed" or "unsigned" need to go in front of "char" in one of these files? I'd suggest "-funsigned-char", but that can cause other problems (like the Gnucash "missing cents" bug, where signed-char's CHAR_MAX=127 was being compared to precompiled unsigned CHAR_MAX=255 in glibc). Thanks, -Adam P. GPG fingerprint: D54D 1AEE B11C CE9B A02B C5DD 526F 01E8 564E E4B6 Welcome to the best software in the world today cafe! -- System Information Debian Release: testing/unstable Kernel Version: Linux p4-117-1 2.4.1 #1 Fri Feb 9 14:11:44 GMT 2001 armv4l unknown - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Support request - ID support 4300
I think you can do it by running mysql as the following : prompt mysqld --datadir='your_db_path/' Or, you can create link from another directory to your data directory (using cp -l in linux) Progetto 2000 wrote: Hi, It's possible to create a database in a differents directories ? And how to make it ? Thanks Carlo Carlini - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Extracting data from 2 tables.
Hi,
I have two tables in a db called "univ". The tables are "student" and
"result_meaning".
Using the C API I want to run a query that SELECT's from "student" using the
field "studnum" as
the selection criteria.
In the "student" table their is a field called "code".
I want to then look up the equivelant "code" in the "result_meaning" table,
so that I can print the field
"dbox" with the results of the SELECT on "student".
ie. Using the data in the tables below, and a student number of "31165222" I
would want to extract the following
fields:
fname
sname
studnum
subject
result
code
dbox(from "result_meaning").
I have looked around for help, and have put together the code at the end of
this email, which does not work. I get a
"out of sequence" error.
Where am I going wrong? Is there a simple way to SELECT data from 2
different tables using C? Help, I'm pretty
stuffed here!
Tables
--
--
student
---
+---+--+--+-++--+
| fname | sname| studnum | subject | result | code |
+---+--+--+-++--+
| Evan | Domski | 31165222 | ENG301 | 80 | P|
| Evan | James| 31165223 | AHS301 | 75 | P|
| Frank | Hardy| 31155111 | CRM301 | 80 | P|
| Joe | Hardy| 31155112 | FOR301 | 80 | P|
| Joe | Hardy| 31155112 | CRM301 | 80 | P|
| Frank | Hardy| 31155111 | FOR301 | 85 | PD |
+---+--+--+-++--+
result_meaning
--
+--+--+--+
| code | meaning | dbox |
+--+--+--+
| P| Pass | 1000 |
| F| Fail | 1001 |
| PD | Pass with Distinctio | 1002 |
+--+--+--+
selecttest.c
#include stdlib.h
#include stdio.h
#include "mysql.h"
MYSQL my_connection;
MYSQL_RES *res_ptr;
MYSQL_RES *res_ptr_code;
MYSQL_ROW sqlrow;
MYSQL_ROW sqlrow_code;
void display_row();
int main(int argc, char *argv[]) {
int res;
int res_code;
int stud_num;
char query[96]="SELECT * FROM student WHERE studnum=";
char query_code[96]="SELECT * FROM result_meaning WHERE code=";
/* Getting some test data! */
printf("Enter your student number: ");
scanf("%i", stud_num);
/*-*/
mysql_init(my_connection);
/**/
/* "host", "user", "password", "database" */
/**/
if (mysql_real_connect(my_connection, "localhost", "root", "", "univ", 0,
NULL, 0))
{
printf("Connection success\n");
/* -*/
/* Table student access */
sprintf(query[36], "%d", stud_num);
res = mysql_query(my_connection, query);
if (res)
{
printf("SELECT error: %s\n", mysql_error(my_connection));
}
else
{
res_ptr = mysql_use_result(my_connection);
if (res_ptr)
{
while ((sqlrow = mysql_fetch_row(res_ptr)))
{
/*
-*/
/* Table result_meaning access
*/
sprintf(query_code[36], "%d", sqlrow[5]);
res_code = mysql_query(my_connection, query_code);
if (res_code)
{
printf("SELECT error: %s\n", mysql_error(my_connection));
}
else
{
res_ptr_code = mysql_use_result(my_connection);
if (res_ptr_code)
{
while ((sqlrow_code = mysql_fetch_row(res_ptr_code)))
{
printf("Fetched data from
result_meaning...\n");
}
if (mysql_errno(my_connection))
{
printf("Retrive error: %s\n",
mysql_error(my_connection));
}
}
mysql_free_result(res_ptr_code);
}
/* End table result_meaning access
*/
/*
-*/
display_row();
}
if (mysql_errno(my_connection))
{
printf("Retrieve error: %s\n", mysql_error(my_connection));
}
}
mysql_free_result(res_ptr);
}
/* open if else */
}
else
{
printf("Connection failed\n");
if (mysql_errno(my_connection))
UNIQUE multiple-column index
Hi, All! Please, give me an opinion about multiple-column index. May I create the UNIQUE multiple-column index, which the index of each column is not UNIQUE in? If yes than how do it? Best. Nick. - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can I see all the field information in MySQL?
* I have create a field in MySQL like this:
+---+-+--+-+-+--
-+-+
| Field | Type| Null | Key | Default |
Extra | Privileges |
+---+-+--+-+-+--
-+-+
| contact_pref | enum('email','telephone','fax') | | | email |
| select,insert,update,references |
I can only get "enum" from mysql_field_flags(), I would like to get the
information in enum: "email", "telephone" and "fax"; as well as the default
value: "email".
* How can I do this?
RE: Can I see all the field information in MySQL?
I have create a field in MySQL like this:
+---+-+--+-+-+--
-+-+
| Field | Type| Null | Key | Default |
Extra | Privileges |
+---+-+--+-+-+--
-+-+
| contact_pref | enum('email','telephone','fax') | | | email | |
select,insert,update,references |
I can only get "enum" from mysql_field_flags(), I would like to get the
information in enum: "email", "telephone" and "fax"; as well as the default
value: "email".
How can I do this?
Sorry, forget the tell at last message, I am using php4 to programming.
Do index in MySQL is case insensitive?
I have heard from somebody that MySQL index is case insensitive. If this is true, how can I set it to case sensitive?
parentheses () in regular expression
Hello! How do I express parentheses in a mysql regexp? For example the expression select * from Term where Term_name regexp "^[0-9\(\)A-Z\s\-]+$"; NATO (MILITRTEKNISKE SPM) but returns TV2 as well as NORDISK SAMARBEID Thanks Michael - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
libmysqlclient
Description: upgrading my old MySql version to the new one, all my C code doesn't compile returning an ld error in resolving my_compress() and my_uncompress() finctions. I forced compilation coping the old libraries and include files from previus version of MySql. Server version 3.23.33 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 22 hours 50 min 21 sec Threads: 1 Questions: 57864 Slow queries: 0 Opens: 68 Flush tables: 1 Open tables: 59 Queries per second avg: 0.704 Environment: machine, os, target, libraries (multiple lines) System: Linux mediadata.windpress.it 2.2.16-22smp #1 SMP Tue Aug 22 16:39:21 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium ' CXX='gcc' CXXFLAGS='-O6 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 14 Dec 14 11:26 /lib/libc.so.6 - libc-2.1.92.so -rwxr-xr-x1 root root 4776568 Aug 30 2000 /lib/libc-2.1.92.so -rw-r--r--1 root root 22607104 Aug 30 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Aug 30 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thai in MySQL
Do you have to do anything special to start putting Thai text into MySQL? Ta, Dave -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Locked Out
I have been using MySQL for sometime now. However, i had been experimenting with MySQL priviliges and have locked myself out. I cannot access the database to perform any function. I cannot issue any command like mysqladmin ping or mysqlshow. Somehow the command mysqlaccess doesnt execute either. The message i get trying to access mysql is: Access denied to user root@localhost using (password=NO) If i try to connect to the DB using mysql -p and give any password the message is: Access denied to user root@localhost using (password=YES) Unfortunately, i didnt note down the changes i made to the host, DB and user tables. Any help would be really appreciated. Thanks Asaf Maruf PING
Merge table problem.
Hi!
"Peter" == Peter Zaitsev [EMAIL PROTECTED] writes:
Peter Hello monty,
Peter I'm trying to use merge table for logging - to have a possibility to
Peter Rotate log files and to quickly delete old data - for this I'm goint
Peter to setup a number of merge tables where each contains data for one
Peter day, and the inserts are done to the last table using real table
Peter name, therefore the select runs on merged table to cover all data.
Peter Currently I found the followning problem which may lead to the
Peter problems:
mysql create table t1 (val char(10));
Peter Query OK, 0 rows affected (0.00 sec)
mysql create table t2 (val char(10));
Peter Query OK, 0 rows affected (0.00 sec)
mysql create table test (val char(10)) type=merge union=(t1,t2);
Peter Query OK, 0 rows affected (0.00 sec)
mysql insert into t1 values("a");
Peter Query OK, 1 row affected (0.01 sec)
mysql insert into t2 values("b");
Peter Query OK, 1 row affected (0.00 sec)
mysql select * from test;
Peter +--+
Peter | val |
Peter +--+
Peter | a|
Peter | b|
Peter +--+
Peter 2 rows in set (0.00 sec)
Peter as you see the result is correct and merge table reflects all changes:
mysql insert into t2 values("b");
Peter Query OK, 1 row affected (0.00 sec)
mysql select * from test;
Peter +--+
Peter | val |
Peter +--+
Peter | a|
Peter | b|
Peter | b|
Peter +--+
Peter 3 rows in set (0.00 sec)
Peter Dublicates are also wellcome.
Peter Let's add the key:
mysql alter table t2 add key(val);
Peter Query OK, 2 rows affected (0.00 sec)
Peter Records: 2 Duplicates: 0 Warnings: 0
mysql insert into t2 values("b");
Peter Query OK, 1 row affected (0.00 sec)
mysql select * from test;
Peter +--+
Peter | val |
Peter +--+
Peter | a|
Peter | b|
Peter | b|
Peter +--+
Peter 3 rows in set (0.00 sec)
Peter As you see the're starting to get incorrect result. The same thing
Peter will be if I'll insert other different rows.
This is because the MERGE table is still mapped to the original table.
Bascily MERGE tables is not to be used if you are going to DROP or
ALTER a table that is mapped.
Peter The only thing to fix this is to flush table test;
Peter Other thing which also seems to be strange:
mysql delete from t1;
Peter Query OK, 0 rows affected (0.00 sec)
mysql delete from t2;
Peter Query OK, 0 rows affected (0.00 sec)
mysql select count(*) from test;
Peter +--+
Peter | count(*) |
Peter +--+
Peter |2 |
Peter +--+
Peter 1 row in set (0.00 sec)
This may see strange, but it isn't.
The problem is that DELETE FROM table (without a WHERE) is currently
mapped to DROP TABLE / CREATE TABLE, in which case you get exactly the
same problem.
In 4.0, we will change that TRUNCATE TABLE will be mapped to DROP +
CREATE while DELETE FROM table (without a WHERE) will be safe.
cut
Peter The last thing is unrepeatable. But I got this once during the tests.
Peter Other tests show even more strange ting (this seems not to be key
Peter related):
mysql alter table t2 drop key val;
Peter Query OK, 0 rows affected (0.00 sec)
Peter Records: 0 Duplicates: 0 Warnings: 0
cut
Same thing here; ALTER TABLE will produce unexpected results.
I have now updated the documentation to warn about using ALTER TABLE,
DROP TABLE or DELETE without a WHERE on a mapped table.
Regards,
Monty
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
After a crash, a bogus log entry doesn't appear on the slave
Description: I had a system crash today. The master log didn't get written after some point (zeroed-out data). The slave's log stated: 010302 12:59:47 Slave: Failed reading log event, reconnecting to retry, log 'mysql.138449' position 86713 010302 12:59:47 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'mysql.138449' at position 86713 010302 12:59:47 Error reading packet from server: bogus data in log event (read_errno 0,server_errno=65535) Unfortunately, the slave status still showed "running" and no error. How-To-Repeat: See above. Fix: Your task. ;-) Submitter-Id: submitter ID Originator:Matthias Urlichs Organization: MySQL support: licence Synopsis: Bogus log entry doesn't show in the slave state Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.34 (noris network MySQL) Environment: System: Linux play.smurf.noris.de 2.4.0s-noris-t5-2 #58 SMP Wed Jul 19 10:24:19 CEST 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i686-pc-linux-gnu/2.95.3/specs gcc version 2.95.3 19991030 (prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='-DTHREAD_SAFE_CLIENT -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jun 8 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4118299 Sep 20 1999 /lib/libc-2.1.2.so -rwxr-xr-x 1 root root 4123003 Jun 8 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 19203634 Jun 8 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jun 8 2000 /usr/lib/libc.so -rwxr-xr-x 1 root root 2042654 Oct 27 17:09 /usr/lib/libc-client.a Configure command: ./configure --prefix=/usr --with-debug --enable-shared --without-mit-threads --libexecdir=/usr/sbin --localstatedir=/var/mysql --enable-thread-safe-client --sysconfdir=/etc --datadir=/usr/share --enable-large-files --without-readline --with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysql.socket --enable-strcoll '--with-comment=noris network MySQL' --with-docs --with-bench --without-berkeley-db --without-bench - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlgui
Hi, I like the look of the "mysqlgui" but I cannot get it to connect to "mysql". I keep getting the error message: cannot connect to local mysql server through socket (111). Can you help? Thanks, Peter Lindsay - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OLAP and MySQL
Does anyone know if there an open-source OLAP product for MySQL?
Re: Locked Out
The manual tells you how to reset a forgotten password. It also tells you not to mess with these tables, but to use. GRANT and REVOKE. We all have to explore everything, dont't we? Worst case, kill mysqld and reinstall privilege tables with mysql_install_db --user=mysql Asaf Maruf Ali wrote: I have been using MySQL for sometime now. However, i had been experimenting with MySQL priviliges and have locked myself out. I cannot access the database to perform any function. I cannot issue any command like mysqladmin ping or mysqlshow. Somehow the command mysqlaccess doesnt execute either. The message i get trying to access mysql is: Access denied to user root@localhost using (password=NO) If i try to connect to the DB using mysql -p and give any password the message is: Access denied to user root@localhost using (password=YES) Unfortunately, i didnt note down the changes i made to the host, DB and user tables. Any help would be really appreciated. Thanks Asaf Maruf PING - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Antwort: Re: Why Heap Tables doesn´t support auto in =?iso-8859-1?Q?crement_ colums?=
So sprach Entryon Corp., Chief Technical Officer - P. Hasenfratz am Thu, Mar 01, 2001 at 02:37:30PM +0100: What's if you combine a timestamp with the client's IP address? IP addresses can be easily forged, especially if you're writing some kind of web application, so this is also not a good choice. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die guenstige Art an Linux Distributionen zu kommen Uptime: 15 hours 18 minutes - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: yes/no
Hi, I want to have like in Access a column that is yes or no or true or false, something on that line. I looked at www.mysql.com but could not find anything. I don't know what exactly I am looking for. Could someone give me a hand it will be greatly appreciated. The ENUM field type will do exactly what you want here. It isn't strictly boolean, but will work exactly how you want if you just specify "Yes" and "No (or "True and "False", etc.) as the possible values. For more info, see the MySQL manual: http://www.mysql.com/doc/E/N/ENUM.html Regards, Basil Hussain ([EMAIL PROTECTED]) - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Antwort: Re: Why Heap Tables doesn´t support auto increment ?colums
So sprach Gerhard Schmidt am Thu, Mar 01, 2001 at 04:02:54PM +0100: Besides the fakt tha this ID not unique. There ist the Problem that the ID you proposed ist an String ID and strings als Index are the Well, but he could make a two column primary key, where the first is the timestamp, and the second an unsigned int holding the ip, if the ip is first transformed from the usual dotted notation (1.2.3.4) to the "raw" number (which would be 4+3*256+2*256*256+1*256*256*256 in this case - 16909060 ). Thus would give a timestamp + integer key, which is fast to index. The question still is. Why are auto_increment columns are not supported True. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die guenstige Art an Linux Distributionen zu kommen Uptime: 15 hours 19 minutes - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Antwort: boolean type
"Thalis A. Kalfigopoulos" wrote:
Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is
closest to the boolean type
ShortInt: 0 == FALSE, 0 == TRUE
That's how I do it anyway.
Or maybe combine multiple bool fields to one and use binary logic.
Or quoting from http://www.bitbybit.dk/mysqlfaq/faq.html
Q: create a column of type BOOLEAN?
MySQL does not have a boolean type per se. The usual way to create a boolean value,
is to use the ENUM type:
mysql CREATE TABLE truths
- (answer ENUM('true','false') NOT NULL);
(don't forget the NOT NULL clause, or you end up having not two, but three legal
values for the field.)
You can also use the following hack to define a field which can contain only one of
two values, namely the empty string ("") or NULL:
mysql CREATE TABLE truths
- (answer CHAR(0));
The special beauty of the second example is that the data in the field only occupies
one bit
I don't quite understand this. How is it possible to story an 1-bit
value in a file or memory and use exactly only 1 bit for it? As far as I
know compters can access at least 1 byte-8 bits at one time, not less.
Does MySQL use a special algorithm in this case?
Robert
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
delete
When you delete somthing... is there any way to recover the data?? mvh: Pl Wester, programmerer never.no as, stortingsgt 30, 0161 Oslo direkte: 22 01 66 34, 906 900 62 tlf: 22 01 66 34, fax: 22 01 66 21 http://never.no - icq:103476059 ~ innhold for internett ~ - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't find mysqladmin
4.17 Installing many servers on the same machine In some cases you may want to have many different mysqld deamons (servers) running on the same machine. You may for example want to run a new version of MySQL for testing together with an old version that is in production. Another case is when you want to give different users access to different mysqld servers that they manage themself. One way to get a new server running is by starting it with a different socket and port as follows: shell MYSQL_UNIX_PORT=/tmp/mysqld-new.sock shell MYSQL_TCP_PORT=3307 shell export MYSQL_UNIX_PORT MYSQL_TCP_PORT shell scripts/mysql_install_db shell bin/safe_mysqld The environment variables appendix includes a list of other environment variables you can use to affect mysqld. See section A Environment Variables. The above is the quick and dirty way that one commonly use for testing. The nice thing with this is that all connections you do in the above shell will automaticly be directed to the new running server! If you need to do this more permanently, you should create an own option file for each server. See section 4.16.5 Option Files. In your startup script that is executed at boot time (mysql.server?) you should specify for both servers: safe_mysqld --default-file=path-to-option-file At least the following options should be different per server: port=# socket=path pid-file=path Sandeep [EMAIL PROTECTED] - Original Message - From: "K.K" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 01, 2001 12:12 PM Subject: Can't find mysqladmin Hello I have installed the latest rpm on an exiting RH6.2 Linux box. I actually upgraded mysql to the newest version and everything went fine and it verified after the installation was done. The problem that I have is that I cannot log into mysql now. I have tried to located mysqladmin anywhere on the server and it seems to be missing and I cannot log into MYSQL. However when I do a ps -ef I can see that safe_mysqld is running along with the three other processes. Any clues on how to log in would be appreciated (It has just been one of those days) _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.33 fail on SOLARIS 8 x86 and gcc 2.95.2
Hi I'm follwing all instructions to install mysql-3.23.33 on Solaris 8 to X86, and the compilers and programs installed are gcc version 2.95.2 19991024 (release) perl v5.6.0 built for i86pc-solaris tcl tcl8.3 make 3.79 flex version 2.5.4 This is the LOG of configure which one are the Mistake ? ltconfig:603: checking for object suffix ltconfig:604: gcc -cconftest.c 15 ltconfig:629: checking for executable suffix ltconfig:630: gcc -o conftest conftest.c 15 ltconfig:776: checking if gcc PIC flag -fPIC works ltconfig:777: gcc -c -fPIC -DPIC conftest.c 15 ltconfig:829: checking if gcc supports -c -o file.o ltconfig:830: gcc -c -o out/conftest2.o conftest.c 15 ltconfig:862: checking if gcc supports -c -o file.lo ltconfig:863: gcc -c -c -o conftest.lo conftest.c 15 ltconfig:914: checking if gcc supports -fno-rtti -fno-exceptions ltconfig:915: gcc -c -fno-rtti -fno-exceptions -c conftest.c conftest.c 15 ltconfig:958: checking if gcc static flag -static works ltconfig:959: gcc -o conftest -static conftest.c 15 ltconfig:1653: checking if global_symbol_pipe works ltconfig:1654: gcc -cconftest.c 15 ltconfig:1657: eval "/usr/ccs/bin/nm -p conftest.o | sed -n -e 's/^.*[ ]\([BDT]\)[ ][ ]*\(\)\([_A-Za-z][_A-Za-z0-9]*\)$/\1 \2\3 \3/p' conftest.nm" ltconfig:1709: gcc -o conftest -fno-builtin -fno-rtti -fno-exceptions conftest.c conftstm.o 15 configure:2234: checking for a BSD compatible install configure:2292: checking for bison configure:2325: checking for pdftex configure:2353: checking return type of sprintf configure: error: can not run test program while cross compiling Many Thanks Diego Varona [EMAIL PROTECTED] - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: RE: yes/no
Like you, I too consider anything not 0 as true. The cool thing about enum types is you can do it both ways (if you are simulating a boolean). This flexibility it affords the best of both worlds. It gives coders the ability to deal in binary AND/OR something more english like - which in the long run can make for more readable, maintainable code. Jon Haworth [EMAIL PROTECTED] wrote: You certainly could, in fact you should use whatever you're happy with. Intuitive coding for me personally would have "anything that isn't 0" as true and "0" as false, if you prefer Y and N then here's a perfect solution. Cheers Jon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 02 March 2001 14:32 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: yes/no Why not use an enumerated type. It takes up almost no storage and it makes for more intuitive coding since you can assign Y/N to 1/0. Jon Haworth [EMAIL PROTECTED] wrote: I usually use a tinyint with a value of 1 for true, and 0 for false. There doesn't appear to be a boolean datatype in MySQL, but I may have missed it :-) HTH Jon -Original Message- From: Scott Dunn [mailto:[EMAIL PROTECTED]] Sent: 02 March 2001 13:55 To: Mysql Subject: yes/no I want to have like in Access a column that is yes or no or true or false, something on that line. I looked at www.mysql.com but could not find anything. I don't know what exactly I am looking for. Could someone give me a hand it will be greatly appreciated. - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- === "If you put three drops of poison into a 100 percent pure Java, you get - Windows. If you put a few drops of Java into Windows, you still have Windows." -- Sun Microsystems CEO, Scott McNealy __ Get your own FREE, personal Netscape Webmail account today at http://webmail.netscape.com/ -- === "If you put three drops of poison into a 100 percent pure Java, you get - Windows. If you put a few drops of Java into Windows, you still have Windows." -- Sun Microsystems CEO, Scott McNealy __ Get your own FREE, personal Netscape Webmail account today at http://webmail.netscape.com/ - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem installing mysql on FreeBSD
Hi!! I have a system FreeBSD 3.5 - STABLE and I am trying to install the mysql 3.23.33 It is the first time that I install a mysql and let us meet with a problem that I didn't know as solving. During the compilation I send myself the following message: hostname.o: In function `ip_to_hostname(in_addr *, unsigned int *)': hostname.o(.text+0x52b): undefined reference to `my_gethostbyname_r' *** Error code 1 Stop The truth is that I don't have idea for where to begin to try to solve him problem and I would thank them any idea that you can give me Thank you. - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Do index in MySQL is case insensitive?
An index is an index and has nothing to do with case. This all depends on how you define your columns. Look up the section on column types in the manual. - Original Message - From: "Carfield Yim" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 02, 2001 18:42 Subject: Do index in MySQL is case insensitive? I have heard from somebody that MySQL index is case insensitive. If this is true, how can I set it to case sensitive? - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please put me off this list
_ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Confused with GCC
I notice some of you compile with gcc as you C-compiler (CC) and C++-compiler (CXX). Configure generates an error message for me when I try to do this. Can anyone help me with this? Thanks, Terry -- __ Terry Babbey Technical Support Specialist Lambton College, Sarnia, Ontario, Canada __ - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
yes/no
I am trying to insert this into my table but mysql doesn't like my syntax.
alter table categoryminor solvalveyn enum('True','False');
When I press enter it does nothing it just goes to a greater than prompt.
What I want is for 1 to be true and 0 to be false.
What is the syntax that I am needing?
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql dbi modules
On Thu, Mar 01, 2001 at 10:58:03AM -0500, [EMAIL PROTECTED] wrote: HI, I sent this note a couple days ago and no one has commented. I am trying to implement DBI-1.14.tar.gz Data-ShowTable-3.3.tar.gz Msql-Mysql-modules-1.2215.tar.gz . The first two packages completed successfully byt the Mysql-modules failed druing the 'make test' step.I am using mysql version 3.23.32-log. MySql is ruuning but the database is located at 'local/mysql' and the mysql.sock socket is present. This is setup in /etc/my.cnf. _Where_ is the socket? Assuming you've done a 'make install' as root, and you are running 'make test' as a mere mortal, do you have read permissions on the full path to the socket? (Remember that you need read _and_ execute permissions on directories.) You make it sound like you're using a relative path 'local/mysql'; that doesn't sound right. What _do_ you have in my.cnf? (I, for one, _never_ use my.cnf. In fact, I don't use safe_mysqld, either; I run mysql, with a ton of command-line flags, directly under a watchdog script.) I don't know the details of how you set everything up, but it would seem you managed to trick either the test scripts in Msql-Mysql-modules-1.2215.tar.gz (which is possible), or you've built/run MySQL itself in a confusing manner, such that safe_mysqld is really running it with different paramaters than you've intended. If you have read access to the socket, but the '10dsnlist' can't tell it there, then perhaps the test script is making a bad guess. You can tell MySQL clients to look for the socket via an environemnt variable: section A Environment variables: MYSQL_UNIX_PORT The default socket; used for connections to localhost. Maybe that'll help... Any help would be appreciated, TIA Subject: Mysql dbi modules I have almost installed all of the dbi/dbm modules but can't get thru the 'make test'. I get the error msg: 't/10dsnlist.DBI-connect(database=test) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at t/10dsnlist.t line 45' MySql is ruuning but the database is located at 'local/mysql' and the mysql.sock socket is present. This is setup in /etc/my.cnf How can I change the test to reference the current setup? Thanks, Dave - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Confused with GCC
g++ works in the configure stage, but then when I do the gnumake using g++ I get the following error: g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local/mysql \"" -DDATADIR="\"/usr/local/mysql/var\"" - DSHAREDIR="\"/usr/local/mysql/share/mysql\""-DHAVE_CONFIG_H -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -c sql_acl.cc In file included from ../include/global.h:186, from mysql_priv.h:20, from sql_acl.cc:28: /usr/include/alloca.h:71: warning: declaration of `void * alloca(int)' /usr/include/alloca.h:71: warning: conflicts with built-in declaration `void * a lloca(long unsigned int)' sql_acl.cc: In function `int replace_column_table(GRANT_TABLE *, TABLE *, const LEX_USER , ListLEX_COLUMN , const char *, const char *, unsigned int, bool)' : sql_acl.cc:1459: Internal compiler error in `scan_region', at except.c:2566 Please submit a full bug report. See URL:http://www.gnu.org/software/gcc/faq.html#bugreport for instructions. gnumake[3]: *** [sql_acl.o] Error 1 gnumake[3]: Leaving directory `/usr/local/mysql/mysql-3.23.33/sql' gnumake[2]: *** [all-recursive] Error 1 gnumake[2]: Leaving directory `/usr/local/mysql/mysql-3.23.33/sql' gnumake[1]: *** [all-recursive] Error 1 Peter Pentchev wrote: On Fri, Mar 02, 2001 at 11:30:31AM -0500, Terry Babbey wrote: Here is my configure statement and the generated error message ( I am using GCC2.95.2): CC="gcc" CXX="gcc" ./configure --prefix=/usr/local/mysql Have you tried CXX="g++"? The C++ compiler of the GNU Compiler Suite is g++, you know.. G'luck, Peter -- This sentence would be seven words long if it were six words shorter. -- __ Terry Babbey Technical Support Specialist Lambton College, Sarnia, Ontario, Canada __ - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
scsi vs ide performance on fsync's
We're doing some mysql benchmarking. For some reason it seems that ide
drives are currently beating a scsi raid array and it seems to be related
to fsync's. Bonnie stats show the scsi array to blow away ide as
expected, but mysql tests still have the idea beating on plain insert
speeds. Can anyone explain how this is possible, or perhaps explain how
our testing may be flawed?
Here's the bonnie stats:
IDE Drive:
Version 1.00g --Sequential Output-- --Sequential Input- --Random-
-Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
MachineSize K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP
jeremy 300M 9026 94 17524 12 8173 9 7269 83 23678 7 102.9 0
--Sequential Create-- Random Create
-Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP
16 469 98 1476 98 16855 89 459 98 7132 99 688 25
SCSI Array:
Version 1.00g --Sequential Output-- --Sequential Input- --Random-
-Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
MachineSize K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP
orville300M 8433 100 134143 99 127982 99 8016 100 374457 99 1583.4 6
--Sequential Create-- Random Create
-Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP
16 503 13 + +++ 538 13 490 13 + +++ 428 11
So...obviously from bonnie stats, the scsi array blows away the ide...but
using the attached c program, here's what we get for fsync stats using the
little c program I've attached:
IDE Drive:
jeremy:~# time ./xlog file.out fsync
real0m1.850s
user0m0.000s
sys 0m0.220s
SCSI Array:
[root@orville mysql_data]# time /root/xlog file.out fsync
real0m23.586s
user0m0.010s
sys 0m0.110s
I would appreciate any help understand what I'm seeing here and any
suggestions on how to improve the performance.
The SCSI adapter on the raid array is an Adaptec 39160, the raid
controller is a CMD-7040. Kernel 2.4.0 using XFS for the filesystem on
the raid array, kernel 2.2.18 on ext2 on the IDE drive. The filesystem is
not the problem, as I get almost the exact same results running this on
ext2 on the raid array.
Thanks
-jeremy
--
this is my sig.
#include stdio.h
#include string.h
#include stdlib.h
#include unistd.h
#include fcntl.h
struct Entry
{
int count;
char string[50];
};
int main(int argc, char **argv)
{
int fd;
struct Entry *trans;
int x;
if((fd = creat(argv[1], 0666)) == -1)
{
printf("Could not open file %s\n", argv[1]);
return 1;
}
for(x=0; x 2000; ++x)
{
trans = malloc(sizeof(struct Entry));
trans-count = x;
strcpy(trans-string, "Blah Blah Blah Blah Blah Blah Blah");
if(strcmp(argv[2],"fsync")== 0)
{
write(fd, (char *)trans, sizeof(struct Entry));
if(fdatasync(fd) != 0)
{
perror("Error");
}
}
else
{
write(fd, (char *)trans, sizeof(struct Entry));
}
free(trans);
}
close(fd);
}
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Confused with GCC
# find /usr -name gcc /usr/local/bin/gcc # echo $PATH /sbin:/usr/sbin:/usr/bin:/usr/ccs/bin:/usr/bin/X11:/usr/local:/usr/local/bin It seems to find gcc for the CC compiler though, and that part of the configure works. "Matthew P. Marino" wrote: OK. Much better. The configure can't find gcc. If it is installed, find it with "find /usr -name gcc -print". This will tell you where gcc is installed, something like /usr/local/bin or /usr/ccs/bin. If you find "gcc" it is probably not in your search list. Meaning, the path to the directory that contains gcc isn't in the $PATH environment variable. Check it by entering "echo $PATH". So, let's say that it's in /usr/local/bin and your $PATH variable doen't contain that path. type in something like; PATH=$PATH:/usr/local/bin export PATH Now; "echo $PATH" to make sure it worked. That should help. !! I strongly suggest you use gnu "make" and use the "--with-low-memory" option. I have a sun UltraSparcII with dual CPU's and 512MB RAM that still couldn't manage to compile the sql_yacc.cc Good luck!! Terry Babbey wrote: Here is my configure statement and the generated error message ( I am using GCC2.95.2): CC="gcc" CXX="gcc" ./configure --prefix=/usr/local/mysql checking whether the C++ compiler (gcc ) works... no configure: error: installation or configuration problem: C++ compiler cannot cre ate executables. "Matthew P. Marino" wrote: We really need to know what the error message text is. Could be anything from a.) you don't actualy have gcc loaded" to z.) sql_yacc.cc which hardly ever compiles right and has nothing to do with gcc. Terry Babbey wrote: I notice some of you compile with gcc as you C-compiler (CC) and C++-compiler (CXX). Configure generates an error message for me when I try to do this. Can anyone help me with this? Thanks, Terry -- __ Terry Babbey Technical Support Specialist Lambton College, Sarnia, Ontario, Canada __ - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- __ Terry Babbey Technical Support Specialist Lambton College, Sarnia, Ontario, Canada __ -- __ Terry Babbey Technical Support Specialist Lambton College, Sarnia, Ontario, Canada __ - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unable to make install mysql with DB-3.2.9a
--- Boulat Khakimov [EMAIL PROTECTED] wrote: Making install in ./db-3.2.9a/build_unix make[1]: Entering directory `/usr/src/mysql-3.23.33/db-3.2.9a/build_unix' install_include install_lib install_utilities install_docs make[1]: install_include: Command not found make[1]: *** [install] Error 127 make[1]: Leaving directory `/usr/src/mysql-3.23.33/db-3.2.9a/build_unix' make: *** [install-recursive] Error 1 Anyone knows how to solve this problem? Well, I've got this problem too. So I do the next: cd db-3.2.9a/build_unix make distclean ../dist/configure make cd ../.. make install So, to be more clear... I just compile the BDB again, something in the MySQL configure is doing this problem... Best Regards. Fox Mulder __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Why MySQL?
Hi guys, I'm wondering why you prefered mySQL overe Postgres , they are both open source, and accorting to many people Postgres is more powerful and stable than mySQL. I've been using mySQL for awhile myself, but recently, I've been extremely frustrated by mySQLs bugginess ... the BDB transaction support for example is extremely unstable. Regards, Boulat - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why MySQL?
Boulat Khakimov wrote: Hi guys, I'm wondering why you prefered mySQL overe Postgres , they are both open source, and accorting to many people Postgres is more powerful and stable than mySQL. I've been using mySQL for awhile myself, but recently, I've been extremely frustrated by mySQLs bugginess ... the BDB transaction support for example is extremely unstable. Regards, Boulat Then stick with the Myisam or isam tables. The BDB is the current work-in-progress. The MySQL team will tell us when the BDB has been declared stable. I chose MySQL for our products because I could NOT get postgres to run on SCO Openserver, even though it was supposed to be supported. I tried for 2 months to get help on the postgress mailing list. Nobody offered ANY help. I could not afford to base our future on a product that had ZERO support. MySQL has better support than ANY commercial product I have ever used. Now you know. - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: scsi vs ide performance on fsync's
This is just a guess - I have significant experience of Scsi drives but none of Unix internals. To do a good sync, you have to force the data from the CPU to the disk, and from the disk ram onto the disk oxide. IDE disks are not very clever, and I do not think that they cache unwritten data. If, therefore, the data has left the CPU, it will have hit the oxide. Scsi disks, however, play considerable tricks, which may include delayed writeback. If I were writing a Scsi disk drive, I would be strongly tempted to put a Scsi Rezero command into the sync operation. This has the effect of flushing all cached data to disk - amongst other things. It is the "amongst other things" which is the catch. Some disk manufacturers just do a simple reset of the disk's seek logic, which would only take a few milliseconds. Others treat a Rezero command as an instruction to do a full thermal recalibrate, which may take 250 milliseconds. This means that drivers tested on one brand of disk will show essentially no performance hit from doing a sync with Rezero, whilst a different brand would show a collossal hit. Yours appears to fall between the two extremes. Alec Cawley - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why MySQL?
I'm wondering why you prefered mySQL overe Postgres , they are both open source, and accorting to many people Postgres is more powerful and stable than mySQL. Hmm... It's free, robust, damn fast, small footprint, lots of free add on software available, it's free. The other thing is you will never want for tech support. This mailing list alone is some of the best damn tech support around - if I ever had to make a telephone tech support call it would probably be because the end of the world was coming soon... -- === "If you put three drops of poison into a 100 percent pure Java, you get - Windows. If you put a few drops of Java into Windows, you still have Windows." -- Sun Microsystems CEO, Scott McNealy __ Get your own FREE, personal Netscape Webmail account today at http://webmail.netscape.com/ - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: scsi vs ide performance on fsync's
Here's a strace -r on IDE: 0.001488 write(3, "\214\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 0.000516 fdatasync(0x3)= 0 0.001530 write(3, "\215\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 0.000513 fdatasync(0x3)= 0 0.001555 write(3, "\216\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 0.000517 fdatasync(0x3)= 0 0.001494 write(3, "\217\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 0.000515 fdatasync(0x3)= 0 0.001495 write(3, "\220\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 0.000522 fdatasync(0x3)= 0 Here it is on SCSI: 0.049285 write(3, "\3\0\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 0.000689 fdatasync(0x3)= 0 0.049148 write(3, "\4\0\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 0.000516 fdatasync(0x3)= 0 0.049318 write(3, "\5\0\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 0.000516 fdatasync(0x3)= 0 0.049343 write(3, "\6\0\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Looks like a constant 50ms delay on each fdatasync() on SCSI vs .5ms for IDE. Maybe IDE isn't really doing a sync?? I find .5ms to be a little too good. I did this on 4 different machines with different SCSI cards (include RAID5 and non-RAID), disks, and IDE drives with the same behavior. Michael D. Black Principal Engineer [EMAIL PROTECTED] 321-676-2923,x203 http://www.csihq.com Computer Science Innovations http://www.csihq.com/~mike My home page FAX 321-676-2355 - Original Message - From: "Jeremy Hansen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, March 02, 2001 11:27 AM Subject: scsi vs ide performance on fsync's We're doing some mysql benchmarking. For some reason it seems that ide drives are currently beating a scsi raid array and it seems to be related to fsync's. Bonnie stats show the scsi array to blow away ide as expected, but mysql tests still have the idea beating on plain insert speeds. Can anyone explain how this is possible, or perhaps explain how our testing may be flawed? Here's the bonnie stats: IDE Drive: Version 1.00g --Sequential Output-- --Sequential Input- --Random- -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks-- MachineSize K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP jeremy 300M 9026 94 17524 12 8173 9 7269 83 23678 7 102.9 0 --Sequential Create-- Random Create -Create-- --Read--- -Delete-- -Create-- --Read--- -Delet e-- files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP 16 469 98 1476 98 16855 89 459 98 7132 99 688 25 SCSI Array: Version 1.00g --Sequential Output-- --Sequential Input- --Random- -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks-- MachineSize K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP orville300M 8433 100 134143 99 127982 99 8016 100 374457 99 1583.4 6 --Sequential Create-- Random Create -Create-- --Read--- -Delete-- -Create-- --Read--- -Delet e-- files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP 16 503 13 + +++ 538 13 490 13 + +++ 428 11 So...obviously from bonnie stats, the scsi array blows away the ide...but using the attached c program, here's what we get for fsync stats using the little c program I've attached: IDE Drive: jeremy:~# time ./xlog file.out fsync real0m1.850s user0m0.000s sys 0m0.220s SCSI Array: [root@orville mysql_data]# time /root/xlog file.out fsync real0m23.586s user0m0.010s sys 0m0.110s I would appreciate any help understand what I'm seeing here and any suggestions on how to improve the performance. The SCSI adapter on the raid array is an Adaptec 39160, the raid controller is a CMD-7040. Kernel 2.4.0 using XFS for the filesystem on the raid array, kernel 2.2.18 on ext2 on the IDE drive. The filesystem is not the problem, as I get almost the exact same results running this on ext2 on the raid array. Thanks -jeremy -- this is my sig. - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Support request - ID support 4300
Yeah, it's in the manual. On Fri, 2 Mar 2001, Progetto 2000 wrote: Hi, It's possible to create a database in a differents directories ? And how to make it ? Thanks Carlo Carlini - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why MySQL?
Yes MySQL has excellent support :) Thats why I use MySQL and ASTA MySQL Server. Both of these are excellent produtcs. Cheers Mike -Original Message- FROM: [EMAIL PROTECTED] TO: [EMAIL PROTECTED] DATE: Fri 3/2/01 11:08 SUBJECT: Re: Why MySQL? I'm wondering why you prefered mySQL overe Postgres , they are both open source, and accorting to many people Postgres is more powerful and stable than mySQL. Hmm... It's free, robust, damn fast, small footprint, lots of free add on software available, it's free. The other thing is you will never want for tech support. This mailing list alone is some of the best damn tech support around - if I ever had to make a telephone tech support call it would probably be because the end of the world was coming soon... -- === "If you put three drops of poison into a 100 percent pure Java, you get - Windows. If you put a few drops of Java into Windows, you still have Windows." -- Sun Microsystems CEO, Scott McNealy __ Get your own FREE, personal Netscape Webmail account today at http://webmail.netscape.com/ - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: UNIQUE multiple-column index
On Fri, 2 Mar 2001, Nick Kostirya wrote: Hi, All! Please, give me an opinion about multiple-column index. May I create the UNIQUE multiple-column index, which the index of each column is not UNIQUE in? If yes than how do it? Best. Nick. When you create a multi-column unique index, it means that the combination of the participating columns must be "unique" and not that each of the participating columns must be "unique" by itself. How you do it?...the normal way: mysql create unique my_index on my_table (col1,col2..); and you may or may not have indeces (unique or not) on cols 1,2... The above is fully equivalent (as of 3.22) to: mysql alter table my_table add unique my_index (col1,col2...); But be careful because even though Mysql will complain if you try to insert a tuple whose value for the unique index attributes (col1,2...) is the same as an already existing tuple, this doesn't hold if any of the index attributes is NULL. To cut a long story short (as I understand it): NULL!=NULL regards, thalis - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: OLAP and MySQL
Hi, Hmm, MySQL in itself is a wonderful cornerstone for OLAP. I've set up a MIS that's been running for 16 months now, without a glitch. The 25 million rows in the main fact table are not a problem. The trick reads: compressed tables. But the interface is very poor, MS Query. Perhaps it would make sense to develop an intranet appliacation to run manage queries and format the output, but the customer is actually happy with plain SQL. Jan Paul Ulrich wrote: Does anyone know if there an open-source OLAP product for MySQL? - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Locked Out
On Fri, 2 Mar 2001, Gerald L. Clark wrote: The manual tells you how to reset a forgotten password. It also tells you not to mess with these tables, but to use. GRANT and REVOKE. We all have to explore everything, dont't we? Worst case, kill mysqld and reinstall privilege tables with mysql_install_db --user=mysql Or alternatively kill mysqld and restart it with option --skip-grant-tables. Read the manual about it (section 4.16.4 Command-line Options) regards, thalis Asaf Maruf Ali wrote: I have been using MySQL for sometime now. However, i had been experimenting with MySQL priviliges and have locked myself out. I cannot access the database to perform any function. I cannot issue any command like mysqladmin ping or mysqlshow. Somehow the command mysqlaccess doesnt execute either. The message i get trying to access mysql is: Access denied to user root@localhost using (password=NO) If i try to connect to the DB using mysql -p and give any password the message is: Access denied to user root@localhost using (password=YES) Unfortunately, i didnt note down the changes i made to the host, DB and user tables. Any help would be really appreciated. Thanks Asaf Maruf - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hard Drive Space
I have filled my hard drive by inserting data into a table (15 gigs). The table was then corrupted. I have freed 1 gigs to repair the table and there is nothing else to delete. How can I repair my table? __ Dave Loisel DBA Wanted technologies [EMAIL PROTECTED] - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Hard Drive Space
It depends on your table type, check the manual, you will want myisamchk or isamchk if you are using 3.23.x you can do SQL REPAIR TABLE so long as your table is MyISAM. Dave Loisel wrote: I have filled my hard drive by inserting data into a table (15 gigs). The table was then corrupted. I have freed 1 gigs to repair the table and there is nothing else to delete. How can I repair my table? __ Dave Loisel DBA Wanted technologies [EMAIL PROTECTED] - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
String Size question
Hey, Curious about the maximum string size for various field types. Eg. VARCHAR or CHAR. It's not really only 255 is it? Mike Richards Network Administrator Harmony Integrated www.hi.ca
RE: String Size question
Yes, it really is 255. need something bigger? try: TINYBLOB MEDIUMBLOB LONGBLOB etc.. LONGBLOB will hold L+4 bytes, where L 2^32 2^32 is large enough for most things. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.954.9133 -Original Message- From: Mike Richards [mailto:[EMAIL PROTECTED]] Sent: Friday, March 02, 2001 1:46 PM To: [EMAIL PROTECTED] Subject: String Size question Hey, Curious about the maximum string size for various field types. Eg. VARCHAR or CHAR. It's not really only 255 is it? Mike Richards Network Administrator Harmony Integrated www.hi.ca - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Aborted connection error on RedHat 7
Be so kind and read the archives :-). Do you happen to use PHP? If so, get the newest release from http://snaps.php.net. You should be fine then. Maciek -Original Message- From: Daniel Fritzler [mailto:[EMAIL PROTECTED]] Sent: Friday, March 02, 2001 5:07 AM To: [EMAIL PROTECTED] Subject: Aborted connection error on RedHat 7 Hello there. I'm writing these lines because I'm having a weird problem with mySQL 3.23.33 (also with 3.23.32) on servers running RedHat 7.0. Each time that I run my SQL based applications, I start getting the following errors on mySQL: 010302 0:45:59 Aborted connection 10207 to db: 'db201' user: 'visual' host: `sql1' (Got an error reading communication packets) 010302 0:46:04 Aborted connection 10216 to db: 'db201' user: 'visual' host: `sql1' (Got an error reading communication packets) 010302 0:46:10 Aborted connection 10227 to db: 'db201' user: 'visual' host: `sql1' (Got an error reading communication packets) 010302 0:46:10 Aborted connection 10225 to db: 'db200' user: 'visual' host: `sql1' (Got an error reading communication packets) I get the above error messages like four times per minute. I'm having this problem on three different servers all of them running RedHat 7.0. I tried using the precompiled mySQL version, but I got the same error. I also tried downgrading gcc 2.96 to gcc 2.95 and recompiling mySQL, but the problem was still there. Do you have any ideas of what is causing this? Perhaps it is a bug on the RedHat libraries? Any help would be appreciated. Thank you! Regards, Daniel Fritzler - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql configure fails
Hi, I run into following problem while installing mysql-3.23.33 on Solaris 2.6, with gcc 2.95.2. checking return type of sprintf... configure: error: can not run test program while cross compiling Please advise. Sally Guan Aicent Inc. 408-965-5528 (voice) 408-965-5526 (fax) [EMAIL PROTECTED] - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql dbi modules
At 11:05 AM 3/2/01 -0500, you wrote: On Thu, Mar 01, 2001 at 10:58:03AM -0500, [EMAIL PROTECTED] wrote: HI, I sent this note a couple days ago and no one has commented. I am trying to implement DBI-1.14.tar.gz Data-ShowTable-3.3.tar.gz Msql-Mysql-modules-1.2215.tar.gz . The first two packages completed successfully byt the Mysql-modules failed druing the 'make test' step.I am using mysql version 3.23.32-log. MySql is ruuning but the database is located at 'local/mysql' and the mysql.sock socket is present. This is setup in /etc/my.cnf. _Where_ is the socket? Assuming you've done a 'make install' as root, and you are running 'make test' as a mere mortal, do you have read permissions on the full path to the socket? (Remember that you need read _and_ execute permissions on directories.) You make it sound like you're using a relative path 'local/mysql'; that doesn't sound right. What _do_ you have in my.cnf? (I, for one, _never_ use my.cnf. In fact, I don't use safe_mysqld, either; I run mysql, with a ton of command-line flags, directly under a watchdog script.) I don't know the details of how you set everything up, but it would seem you managed to trick either the test scripts in Msql-Mysql-modules-1.2215.tar.gz (which is possible), or you've built/run MySQL itself in a confusing manner, such that safe_mysqld is really running it with different paramaters than you've intended. If you have read access to the socket, but the '10dsnlist' can't tell it there, then perhaps the test script is making a bad guess. You can tell MySQL clients to look for the socket via an environemnt variable: section A Environment variables: MYSQL_UNIX_PORT The default socket; used for connections to localhost. Maybe that'll help... Any help would be appreciated, TIA Subject: Mysql dbi modules I have almost installed all of the dbi/dbm modules but can't get thru the 'make test'. I get the error msg: 't/10dsnlist.DBI-connect(database=test) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at t/10dsnlist.t line 45' MySql is ruuning but the database is located at 'local/mysql' and the mysql.sock socket is present. This is setup in /etc/my.cnf How can I change the test to reference the current setup? Thanks, Dave - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brian 'you Bastard' Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USAIntel architecture: the left-hand path -- Thanks Brian, Setting the environment variable worked. Dbi/dbm is now installed! To clarify my other posts, my data is on '/local/mysql' where '/local' is defined as most of disk available. mysql is running as a user and I was trying to run the install dbi/dbm as root. It would not run as the user either. I did have a little problem in setting the variable. I used the command: export MYSQL_UNIX_PORT='/local/mysql/mysql.sock' Then displayed the environment with export I sure you know this but thought I would explain what I did in case some one else has a similiar problem. Thanks agzin, Dave - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: yes/no
set your column something like: enum('0','1');
Curtis
On Fri, 2 Mar 2001, Scott Dunn wrote:
I want to have like in Access a column that is yes or no or true or false,
something on that line. I looked at www.mysql.com but could not find
anything. I don't know what exactly I am looking for. Could someone give me
a hand it will be greatly appreciated.
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help with SELECT statement.
SELECT request.id, request.date, request.type, request.status, faculty.f_name, faculty.l_name, action.id, faculty.id FROM request INNER JOIN faculty ON request.requested_by=faculty.id LEFT JOIN request ON action.request_id=request.id; Chris Toth [EMAIL PROTECTED] wrote: I'm trying to form a select statement that will match up all relevent data from a database for a trouble-ticket system. The select statement below is the only way I can figure out how to do it. However, the last line " AND action.request_id=request.id" worries me, because what if there are no actions yet? Even if there are no actions, I still want to display everything and just leave the action section blank. Is there a way to do this? Thanks "SELECT request.id, request.date, request.type, request.status, faculty.f_name, faculty.l_name, action.id, faculty.id FROM request, faculty, action WHERE request.requested_by=faculty.id AND action.request_id=request.id"; - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BDB tables crashing mysql 3.23.33
Hi!
"Sasha" == Sasha Pachev [EMAIL PROTECTED] writes:
cut
Sasha I do have a patch for it now. From what I understood in the code, this is
Sasha actually a more correct way to do things, but I would like to get Monty's
Sasha approval to be sure. After the patch, MySQL still passes our test suite,
Sasha which is a good sign. So if you are in dire straits, go ahead and apply it,
Sasha otherwise, wait until 3.23.34 - if there is something wrong with the current
Sasha fix, it will be corrected by then. Here it is:
Sasha --- 1.33/sql/field.cc Wed Feb 7 19:43:54 2001
Sasha +++ 1.34/sql/field.cc Thu Mar 1 11:49:05 2001
Sasha @@ -4075,8 +4075,8 @@
Sasha const char *Field_blob::unpack(char *to, const char *from)
Sasha {
Sashamemcpy(to,from,packlength);
Sasha + ulong length=get_length(from);
Sashafrom+=packlength;
Sasha - ulong length=get_length();
Sashaif (length)
Sasha memcpy_fixed(to+packlength, from, sizeof(from));
Sashaelse
Looks ok. Thanks for fixing this!
Regards,
Monty
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Why MySQL?
On Fri, 2 Mar 2001, Evan James Dembskey wrote: I chose MySQL for our products because I could NOT get postgres to run on SCO Openserver, even though it was supposed to be supported. I tried for 2 months to get help on the postgress mailing list. Nobody offered ANY help. Funny, I had the same experience. The only reason I am no learning to use MySQL is because PostgresQL would not install on either my Linux box or my DEC box. The postgres list was not helpful. My current (personal) view on the debate is that PG is more advanced featurewise and they claim to be as fast. It's also much less user/admin-friendly and lacks (last I could tell) an important feature I've come to love (ALTER TABLE CHANGE column). However, mySQL is very fast. It's got virtually all of the features I need (row-level locking and transactions are what I'm waiting for to become stable). I've seen some stability problems but most were under Solaris. I look forward to it maturing and growing out of the "small to medium" range RDBMs that it's usually tagged as due to the (stable) lack of the two features I mentioned. By the way, found the -1 table handler problem. *sigh* Disk was at 100% usage on that partition. Got so used to scripts keeping track of disk usage I forgot to even consider that a possibility. Perhaps mySQL could so some testing to find the instances where it would get an error writing to the disk or temp file and indicate an error as such? I mean, you're going to get an error code back from your system (f)write call that indicates what the problem is... -- Nathan Clemons [EMAIL PROTECTED] 978-635-5300 ext 123 Linux Systems Administrator IRC: etrnl ICQ: 2810688 AIM: StormeRidr O | S | D | N,50 Nagog Park,Acton,MA01720 http://www.osdn.com/ Open Source Development Network Nextel: 978-423-0165 [EMAIL PROTECTED] - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Cant conect...
I had the same problem. Ensure that /var, /var/lib, and /var/lib/mysql have permissions: drwxr-xr-x This should solve your problem for item 1. rick -Original Message- From: Paulus [mailto:[EMAIL PROTECTED]] Sent: Friday, March 02, 2001 4:09 PM To: [EMAIL PROTECTED] Subject: Cant conect... 1) I've installed mysql from rpm. When i try to connect with database using: mysql database_name -uusername -ppassword from a root account it works. When i log in as other user and i type mysql database_name i got the message : Cant connect to local mysql server using socket. User 'username' exists in user table and has enough privileges in db table. 2) I think that Mysql doesn't work propely with a mod_perl newer than 3.0.3 I have RedHat 7 installed at home and i can't access to database using http - perl script I can only see 'Internal Server Error' and a message in error_log Access denied for user: 'u@localhost' (Using password: YES) Sorry for my english and please help... - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Antwort: ReisserFS
Tim Bunce wrote: Only problem we know is that in our tests on ReiserFS is MySQL was 30% faster on writes :/ How does it compare to FreeBSD with "soft updates" enabled? Sorry, I use only linux and very rarely touch anything else. So this 30% was meant under linux. Sorry for confusion. I really do not know about *BSD. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
look-up fields in MySql
I am creating a couple of tables. Some of the tables call for a column denoting the entry's type or catagories. The ENUM and SET types seems to be ideal for this except for the fact that I wasn't able to add types or categories dynamicly. Is there anyway that the ENUM or SET types could be used to list the set of values of a column in another table? (like lookup field in MS Access) Or if anyone has an alternative for implementing the system i describe I would be happy to hear about it. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
adding WHERE statements?
Hello everyone. I am in a real bind. I am trying to get a list of names from a table where for each name there are several specific entries. For example, the table looks like this: ContactID FactName Value for each ContactID, there may be several entries with different fact/values such as hair=red, eyes=blue, married=yes and so on. So if I want to get a list of all contactid who has 1 child and is married, I would think I should do this: SELECT * FROM contact INNER JOIN fact ON fact.contactid=contact.contactid WHERE (fact.factname='married' AND fact.value='yes') AND (fact.factname='children' AND fact.value='1') This will not work. As soon as I add the AND in the middle, it dies. If I use an OR it works, but that is not what I want. What can I do? Glenn Thimmes Software Engineer TransLux West 1651 N. 1000 W. Logan, UT 84321 435.716.8675 - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with berkeley DB v3.2.9 and mysql v3.2.33 under Solaris 8
Hello everyone, I've figured out what the problem was with getting the configure script to work (I needed to set the LDFLAGS environment variable to pass a -R runpath to the compiler for some of the configure tests to build properly), but now I have a different issue which has cropped up when trying to build mysql from source on my server machine... I have got the build to progress significantly, but it's barfed with some errors when compiling 'ha_berkeley.cc': c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local\"" -DDATADIR="\"/usr/local/var\"" -DSHAREDIR="\"/usr/local/share/mysql\"" -DHAVE_CONFIG_H -I'../'../db-3.2.9/build_unix -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -DHAVE_CURSES_H -I/var/azwan/mysql-3.23.33/include -DHAVE_RWLOCK_T -c ha_berkeley.cc ha_berkeley.cc:105: type specifier omitted for parameter ha_berkeley.cc:105: parse error before `)' ha_berkeley.cc: In function `bool berkeley_init()': ha_berkeley.cc:143: no matching function for call to `__db_env::set_noticecall (DB_ENV *, void ()(...))' ha_berkeley.cc: At top level: ha_berkeley.cc:292: type specifier omitted for parameter ha_berkeley.cc:292: parse error before `)' ha_berkeley.cc: In function `void berkeley_noticecall(...)': ha_berkeley.cc:294: `notice' undeclared (first use this function) ha_berkeley.cc:294: (Each undeclared identifier is reported only once ha_berkeley.cc:294: for each function it appears in.) ha_berkeley.cc:296: `DB_NOTICE_LOGFILE_CHANGED' undeclared (first use this function) ha_berkeley.cc:297: warning: unreachable code at beginning of switch statement *** Error code 1 make: Fatal error: Command failed for target `ha_berkeley.o' Current working directory /var/azwan/mysql-3.23.33/sql *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /var/azwan/mysql-3.23.33/sql *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /var/azwan/mysql-3.23.33 *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' This appears to be a serious problem, but at first glance I'm not sure what it's actually being caused by. The build environment of the server machine is a Sun Sparc 20 running Solaris 8 (aka SunOS 5.8) using gcc-2.95.2 as the compiler. The mysql source version I'm trying to build is v3.23.33, and it's using Berkeley DB v3.2.9. Any advice would be greatly appreciated. I'm planning to use mysql together with php to offer extra services to people using my server for web sites, etc. Regards, Craig. -- Craig Ian Dewick ([EMAIL PROTECTED]). http://lios.apana.org.au/~craig Operator of Jedi (APANA Sydney member-access site) in Waterfall, Australia. Always striving for a secure long-term future in an insecure short-term world Have you exported a crypto system today? Do your bit to undermine the NSA. - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Having a hard time installing MySQL
I have it running on a few servers here already but one has me baffled. O/S is FreeBSD 4.0-RELEASE #0 MySQL is mysql-3.23.33 I'm getting this error: 010302 00:20:57 mysqld started /usr/libexec/ld-elf.so.1: /usr/lib/libstdc++.so.3: Undefined symbol "__ti9exception" 010302 00:20:57 mysqld ended\n Anybody recognize this? -- /"\ / http://www.vrx.net \ / ASCII RIBBON CAMPAIGN / http://killifish.vrx.net X AGAINST HTML MAIL/ [EMAIL PROTECTED] +1 (613) 473-1719 / \ AND POSTINGS/ http://www.mbz.org http://www.dnso.com - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with berkeley DB v3.2.9 and mysql v3.2.33 under Solaris 8
Craig Ian Dewick wrote: The build environment of the server machine is a Sun Sparc 20 running Solaris 8 (aka SunOS 5.8) using gcc-2.95.2 as the compiler. The mysql source version I'm trying to build is v3.23.33, and it's using Berkeley DB v3.2.9. Download BDB v3.2.9a from www.mysql.com AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. | ~ Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Laboratories, Inc. .eFax 248.671.0909 http://www.pcraft.com . 3550 Arapahoe Ave #6 .. . . . . Boulder, CO 80303, USA - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Long deletes
On Wed, Feb 28, 2001 at 02:38:40PM -0500, Michael Villalba wrote: I have a rather large table (~130 million rows) running under MySQL 3.23.30 and have been very pleased with the performance of the database. However, occasionally I have to delete millions of rows from the table, and it appears that MySQL hangs on these jobs. To be specific, I am running a delete job now that will remove about 4 million rows. It has been running for 11 hours on a 4-processor Sun E450 with 4Gb. The OS is Solaris 2.7. For about the last 10 hours the state displayed by 'show processlist' has been 'end'. How big is your key_buffer? record_buffer? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Having a hard time installing MySQL
In the last episode (Mar 02), Richard Sexton said: I have it running on a few servers here already but one has me baffled. O/S is FreeBSD 4.0-RELEASE #0 MySQL is mysql-3.23.33 I'm getting this error: 010302 00:20:57 mysqld started /usr/libexec/ld-elf.so.1: /usr/lib/libstdc++.so.3: Undefined symbol "__ti9exception" 010302 00:20:57 mysqld ended\n Anybody recognize this? This looks like you used the binary package, right? That was built for FreeBSD 4.2, which has a different set of c++ libraries from 4.0. You'll have to either upgrade to 4.2, or build mysql from ports. -- Dan Nelson [EMAIL PROTECTED] - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How can I upgrade from 3.22.32 to 3.23.33 with huge database(5GB)?
Hi, mysql users, I have a problem to upgrade mysql to a newer stable version. The problem is the database size. It's about 5.4GB. I have noticed that the database structure has been changed between 3.22 and 3.23. So, I have to dump the whole database(5.4GB) to upgrade. But, as you know, it is impossible with 'mysqldump', right? Any good suggestions? please, *cc* to me, because I'm not on this list. -- no signature - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can I upgrade from 3.22.32 to 3.23.33 with huge database(5GB)?
In the last episode (Mar 03), ho-sang, yoon said: Hi, mysql users, I have a problem to upgrade mysql to a newer stable version. The problem is the database size. It's about 5.4GB. I have noticed that the database structure has been changed between 3.22 and 3.23. So, I have to dump the whole database(5.4GB) to upgrade. But, as you know, it is impossible with 'mysqldump', right? You don't have to convert the database if you don't want to; 3.23 supports both ISAM and MYISAM table formats just fine. When you're ready, you can convert tables from within mysql: "alter table mytable TYPE=MYISAM". There's a perl script called mysql_convert_table_format that automates the conversion of entire databases. BTW - mysqldump shouldn't have any problem dumping a 5.4GB database; just make sure you use the -q option. -- Dan Nelson [EMAIL PROTECTED] - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
max connections
hey, i'm developing a product that heavily utilizes mysql databases through PHP. The max number of connections that any server can handle is needed as i have to think of scaleability issues. The servers are pretty powerful - it maxes out at 4G's 2x850 P-III. I need max performance out of this box. It will be accessed by multiple web servers. I also wanted to know if I can have 2 mysql servers on the same machine accessing and serving data from the *same* database... also, at what number of connections does mysql go for a toss? Tx. Vinod _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A newbie question
hello All, I am new to mysql database. I downloaded mysql and running on my system. For adminiatrative purpose the command i run as written in manual is "mysql -u root mysql" I am unable to understand why i have to write mysql after "-u root" why not any other database name "test". I tried to run the command like this "mysql -u root test" and when i tried to add a user i ghot Error Table db.user does not exist. I am unable to understand the meaning of above Error. Please help me to understand the problem. Thanks in advance anil - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: max connections
Hi, The maximum number of connections that mysql can accept is restricted by both: the OS and ulimit. In other words, you can set max_connections as high as you want without bypassing the limits specified in ulimit. If you do ulimit -n you should get the number of connections allowed (1024 by default I think) .. Read section 21.3 in the manual for having several servers running on different ports on the same machine. Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "vinod panicker" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 02, 2001 1:09 PM Subject: max connections hey, i'm developing a product that heavily utilizes mysql databases through PHP. The max number of connections that any server can handle is needed as i have to think of scaleability issues. The servers are pretty powerful - it maxes out at 4G's 2x850 P-III. I need max performance out of this box. It will be accessed by multiple web servers. I also wanted to know if I can have 2 mysql servers on the same machine accessing and serving data from the *same* database... also, at what number of connections does mysql go for a toss? Tx. Vinod _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
test suite skips all tests
Hello, I just installed mysql (from source) on three machines, and I have encountered the same problem on all of them. Everything appears to work fine (including the benchmark tests), but when I attempt to run the test suite (the script mysql-test-run under the source directory), I get something that ends like this: update [ skipped ] varbinary [ skipped ] variables [ skipped ] warnings [ skipped ] Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished All 0 tests were successful. Not very helpful. :) I looked at mysqld-slave.err, but it didn't mean much to me (maybe someone here can see the problem). I have included one page of it below. Thanks for your help. The machines consist of basic Red Hat clones. I had not yet installed a root password when I tried to run the tests. /tmp/mysql-3.23.33/sql/mysqld: ready for connections 010303 1:41:46 Slave: connected to master '[EMAIL PROTECTED]:9306', replication started in log 'master-bin.001' at position 73 010303 1:41:46 /tmp/mysql-3.23.33/sql/mysqld: Normal shutdown 010303 1:41:46 Slave thread exiting, replication stopped in log 'master-bin.001' at position 73 010303 1:41:46 /tmp/mysql-3.23.33/sql/mysqld: Shutdown Complete User time 0.01, System time 0.00 Maximum resident set size 0, Integral resident set size 0 Non-physical pagefaults 95, Physical pagefaults 381, Swaps 0 Blocks in 0 out 0, Messages in 0 out 0, Signals 0 Voluntary context switches 0, Involuntary context switches 0 /tmp/mysql-3.23.33/sql/mysqld: ready for connections 010303 1:41:47 Slave: connected to master '[EMAIL PROTECTED]:9306', replication started in log 'master-bin.001' at position 73 010303 1:41:48 Aborted connection 3 to db: 'unconnected' user: 'root' host: `localhost' (Got an error writing communication packets) 010303 1:41:48 /tmp/mysql-3.23.33/sql/mysqld: Normal shutdown 010303 1:41:48 Slave thread exiting, replication stopped in log 'master-bin.001' at position 73 010303 1:41:48 /tmp/mysql-3.23.33/sql/mysqld: Shutdown Complete User time 0.01, System time 0.00 Maximum resident set size 0, Integral resident set size 0 Non-physical pagefaults 97, Physical pagefaults 381, Swaps 0 Blocks in 0 out 0, Messages in 0 out 0, Signals 0 Voluntary context switches 0, Involuntary context switches 0 /tmp/mysql-3.23.33/sql/mysqld: ready for connections 010303 1:41:49 Slave: connected to master '[EMAIL PROTECTED]:9306', replication started in log 'master-bin.001' at position 73 010303 1:41:49 /tmp/mysql-3.23.33/sql/mysqld: Normal shutdown 010303 1:41:49 Slave thread exiting, replication stopped in log 'master-bin.001' at position 73 010303 1:41:49 /tmp/mysql-3.23.33/sql/mysqld: Shutdown Complete User time 0.02, System time 0.00 Maximum resident set size 0, Integral resident set size 0 Non-physical pagefaults 97, Physical pagefaults 381, Swaps 0 Blocks in 0 out 0, Messages in 0 out 0, Signals 0 Voluntary context switches 0, Involuntary context switches 0 /tmp/mysql-3.23.33/sql/mysqld: ready for connections 010303 1:41:51 Aborted connection 2 to db: 'unconnected' user: 'root' host: `localhost' (Got an error writing communication packets) 010303 1:41:51 /tmp/mysql-3.23.33/sql/mysqld: Normal shutdown 010303 1:41:51 /tmp/mysql-3.23.33/sql/mysqld: Shutdown Complete User time 0.01, System time 0.01 Maximum resident set size 0, Integral resident set size 0 Non-physical pagefaults 95, Physical pagefaults 383, Swaps 0 Blocks in 0 out 0, Messages in 0 out 0, Signals 0 Voluntary context switches 0, Involuntary context switches 0 __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
