Re: BDB Tables, InnoDB tables ??
At 9:55 PM +0530 9/9/01, Nilesh Parmar wrote: Hi I just came across these words in the mailing lists. Can anyone tell me what are BDB tables and InnoDB tables . I am new to mysql and would like to know what are they . thanx in advance Nilesh (1) Go to http://www.mysql.com/doc/ (2) Type innodb or bdb into the search box OR (1) Go to http://www.mysql.com/doc/ (2) Use your browser's search function to search the page for innodb or bdb -steve -- + Open source questions? + | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +--- http://pgfsun.ucdavis.edu/open-source-tools.html ---+ - 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 get a list of locks
hi, 1. can i get a list of locks created with get_lock()? 2. if i create locks with get_lock() and my program stops with script error before releasing these locks, how can i release these _dead_ locks? (i use persistent mysql connections) thanx, ati - 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 on non-English support
Hi, Does mysql support Chinese language? Thank you, Regards, Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Let's approach stored procedures
Adams, Bill TQO wrote: The other thing about all of this is that MySQL is feature rich so most people might not have a use for stored procedures. Unlike, say, Informix which has not build in MIN or MAX function. Depending on the way you define things, MIN and MAX are essentially stored procedures that were programmed into MySQL. Why not let us make our own? Frank. - 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 on non-English support
I use japanese language, At least, Insert MB data and use MB string to search the DB is OK. I think Chinese is the same. best regards Hxia -Original Message- From: Soong, Michael Sau Wah (Michael) [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 4:40 PM To: '[EMAIL PROTECTED]' Subject: Question on non-English support Hi, Does mysql support Chinese language? Thank you, Regards, Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this 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
Backup question
Hi, I'm running MySQL on a NT box and do a nightly backup of the complete file system to tape. I know I should use mysqldump and probably stop MySQL but will a file system copy do as well? The system is inactive at the time. Met vriendelijke groet / With kind regards, ICL Nederland B.V. Simon de Kraa e-Applications / Logistic Systems Systems Architect Het Kwadrant 1 Tel. +31 346 598865 Postbus 4000Fax +31 346 562703 3600 KA MAARSSEN The Netherlands mailto:[EMAIL PROTECTED] --- Progress 9.1b, Roundtable 9.1c, NuSphere Pro Advantage 2.2 @ MS Windows 2000 5.00.2195 SP 2 Progress 9.1b @ SCO UnixWare 7.1.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: SQL query
Grega writes: now, this query executes for about 10 minutes on an AMD 900/256MB and then i get an execution time exceeded from PHP Your script is spending too much CPU time on something. Are you sure that your query doesn't complete? I'd be very very surprised if it doesn't, since it'd probably mean that you've found a bug in mysql_query(). My guess would be that your script gets stuck in a loop somewhere. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: Let's approach stored procedures
On Fri, 7 Sep 2001, Robert Alexander wrote: | Hi Claudio, | | I think having the functionality of stored procedures would be a | wonderful addition to MySQL. Let me be the first to say a hearty | 'Thank you!' for your very generous offer to devote your vacation time | to this task. I definately agree, and I'm reading all those other emails wondering whether people are crazy?! This guy is saying that he wants to devote considerable time in making stored procedures, and people start to argue against him with sarcasm and everyhting. | | I like Oracle's PL/SQL. I've used it a fair amount, and it get's the | job done. PL/SQL = Procedural SQL -- SQL plus procedural logic. This | has the advantage of being a language that uses the SQL that we all | already know and love, plus enough procedural things -- loops, | conditionals, etc. -- to implement logic. It's more a programming | language than just a query language. This is a good thing. One LARGE point in PL is that, yes, it's Oracle's, and they have a large industy momentum and are kind of the defacto industry standard. MySQL could steal a lot of momentum from Oracle if you could port your application to MySQL by just swapping the backend of your application. And this is definately not negative for a Open Source project. (I'd like to see MySQL be a _real_ alternative to the big-dudes. Let the OS community dominate the whole serverside market totally!) Oracle's PL/SQL would be a _huge_ benefit for MySQL, I believe. Transactions, subqueries and stored procudures NOW! | | That being said, I don't think re-implementing PL/SQL is necessarily | the way to go for MySQL. There may indeed be proprietary issues | (though I'm not sure) and I think it'd be possible to take a more | 'open source' approach. The proprietary issues might of course be a huge problem. Anyone knows anything about this? | | Let's remember what we want to accomplish with stored procs; that is, | the ability to store server-side logic where we can implement such | things as business rules, and ensure consistency in the way | 'front-ends' of whatever flavour (and probably written by different | programmers) perform transactions with the dataset. Also, remember that _speed_ is a _big_ thing here. If your application needs to grep through a large amount of data and compare lots of rows from different tables in an elaborate way, then you'd have to transfer immense amounts of data through the TCP stack (and maybe even though a couple of ethernet cards and a cable!) or anyways between different tiers and data representations in your system (think e.g. Java?). This is done _much_ more effeciently with a couple of stored procedures. -- Mvh, Endre - 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 on non-English support
YES Soong, Michael Sau Wah (Michael) wrote: Hi, Does mysql support Chinese language? Thank you, Regards, Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) 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
segfault in mysql_real_escape_string
Hi folks, I've the main developer of nss-mysql. I've found out a very strange problem. On a Debian potato, mysql 3.23.38 and glibc 2.1.3 This bit of code segfault on the last line. The string useris correct (printed correctly in log). /* we escape the user string */ secure_user = malloc(strlen(user) * 2 + 1); if ( secure_user == NULL ) { _nss_mysql_log(LOG_ERR,initgroups: not enough memory to escape the user string); *errnop = EAGAIN; return NSS_STATUS_TRYAGAIN; } mysql_real_escape_string(mysql_auth,secure_user,user,strlen(user)); This part is taken from the initgroups function and segfaults everytime when called from Apache. I've noticed that upgrading libc to 2.2.4 fixes the problem. I guess this is a problem in the client lib. Any hints will be welcome. -- Guillaume Morin [EMAIL PROTECTED] Justice is lost, Justice is raped, Justice is done. (Metallica) - 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: Backup question
Howdy, I tend to do both a dump to disk and then stop the DB and do a tape backup. I don't believe there is an Online backup capability as user transactions would need to be stored and played back against the DB after the backup as in most production ready DB's. Sid Young QML Pathology Database Administrator -Original Message- From: Kraa de Simon [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 5:47 PM To: '[EMAIL PROTECTED]' Subject: Backup question Hi, I'm running MySQL on a NT box and do a nightly backup of the complete file system to tape. I know I should use mysqldump and probably stop MySQL but will a file system copy do as well? The system is inactive at the time. Met vriendelijke groet / With kind regards, ICL Nederland B.V. Simon de Kraa e-Applications / Logistic Systems Systems Architect Het Kwadrant 1 Tel. +31 346 598865 Postbus 4000Fax +31 346 562703 3600 KA MAARSSEN The Netherlands mailto:[EMAIL PROTECTED] --- Progress 9.1b, Roundtable 9.1c, NuSphere Pro Advantage 2.2 @ MS Windows 2000 5.00.2195 SP 2 Progress 9.1b @ SCO UnixWare 7.1.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
Fulltext search
Hello, This is the last time I will post this thread. Apparently nobody knows any solution to this : The Fulltext search only matches those rows who match teh exact word, so if I search for bank, the query wont find banking. (this would work with like '%bank%', but that is much slower). So is there anything you can to make it also match those ?? Thankx Lorang Jacques sql is mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fulltext search
Lorang Jacques wrote: Hello, This is the last time I will post this thread. Apparently nobody knows any solution to this : The Fulltext search only matches those rows who match teh exact word, so if I search for bank, the query wont find banking. (this would work with like '%bank%', but that is much slower). So is there anything you can to make it also match those ?? I don't think you can make FULLTEXT do substring matches. If LIKE is too slow, maybe try |INSTR|(str, substr) instead and see if it's any faster. Thankx Lorang Jacques sql is mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
Mergetable locking
How does mysql manage locks on mergetables? St. Pinkert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help needed getting table headings into an outfile
Sorry, I should have given you more information about the problem. We have a Java program, with a J2EE backend which is connected to a MySQL database. The database is running on a windows 2000 machine, and we want to output the contents of the tables in text format(CSV). I can get the formatting ok, but it just needs the table headings. Ideally we want to use one or more queries to do this, rather than using mysqldump. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 10 September 2001 11:38 am To: Andrew Murphy Subject: Re: Help needed getting table headings into an outfile I do this in perl to get the headers. Perhaps you can adjust to fit into your output script. my $statement = SELECT * FROM $table; my $sth = $dbh-prepare( $statement ) ; $sth-execute(); my $fields = $sth-{NUM_OF_FIELDS}; for ( my $i = 0 ; $i $fields ; $i++ ) { $name = $sth-{NAME}-[$i] ; if ($i == 0) { $fldnames = $name ; } else { $fldnames = $fldnames . | . $name ; } } # end of for loop $sth-finish(); Dirk Van Wie Andrew Murphy [EMAIL PROTECTED] on 09/10/2001 12:33:50 PM To: 'mysql Mailing List' [EMAIL PROTECTED] cc: Subject: Help needed getting table headings into an outfile Hi, I keep sending this to the list, but im not sure if anyone else is getting it. I hope you can help me with this. I am using the INTO OUTFILE 'filename' function, to create .CSV output files from my queries. Whenever I do this, the table headings are removed from the output. Is there a way to get the table headings displayed in the output file? Thanks in advance Andrew database, sql, query, table database, sql, query, table database, sql, query, table - 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 the Installation of MySql 3.23 on Linux 7.1
hai , We are tryin to get the MySql running on a Intel based Linux box, with microkernel 2.2.16. when i try to install using the MySql using the RPM, it threw a message stating tht the installation is finished and the mysqladmin is not copied. when we try to uninstall the same, i get a message that the package is not installed. at this point i tried to reinstall the MySql and i got a message that Mysql 3.23 is already installed. it would be helpful if anyone could throw some light on this.. regards Support - 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: Fulltext search
The Fulltext search only matches those rows who match teh exact word, so if I search for bank, the query wont find banking. (this would work with like '%bank%', but that is much slower). So is there anything you can to make it also match those ?? MySQL V3 cannot do what you want. MSQL V4 will have more features along the lines you want - see http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Fulltext_Features_to_Appear_in_MySQL_4.0 V4.0 alpha version mis expected to be released within the next month or so. I cannot say whether these features will be implemented at that time - perhaps the developers can comment (I would love to see them). Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB problems
Nuno, I noticed a similar unexplained restriction on our Linux 2.4. We have 512 MB physical memory, no swap partition, and for some reason I cannot malloc more than 256 MB. The Unix errno just says 'Cannot allocate memory'. On our other machine with 900 MB RAM and 512 MB swap I can malloc 900 MB. What is your my.cnf like? Is it possible that you have allocated so much memory to PostgreSQL, MyISAM, and other programs that the 2 GB or 3 GB you have is almost totally used? Regards, Heikki At 10:55 AM 9/10/01 +0100, you wrote: On Fri, Sep 07, 2001 at 08:47:16PM +0300, Heikki Tuuri wrote: Nuno, what does ulimit -a say (assuming you are running on Unix)? ulimit tells the limits set for the user. I think there are also hard limits decided at kernel compile time. core file size (blocks) 0 data seg size (kbytes) unlimited file size (blocks) unlimited max memory size (kbytes) unlimited stack size (kbytes) 8192 cpu time (seconds) unlimited max user processes 256 pipe size (512 bytes)8 open files 1024 virtual memory (kbytes) 2105343 I'm running Linux. What does free say? total used free sharedbuffers cached Mem: 20967202094180 2540 01073620 786400 -/+ buffers/cache: 2341601862560 Swap: 1052248 32921048956 But I'm running two SQL servers (MySQL and PostGres) and I'm running some scripts. Apart from that, the machine is totally dedicated to SQL stuff. When installing InnoDB I should have most of the memory available. Regards, Heikki http://www.innodb.com Nuno Dias wrote: I installed mysql with innodb support on a machine with 2G of RAM. The manual recommends that one should set innodb_buffer_pool_size in my.cnf to up to 80% of the physical memory available. However, if I set a value above 50M!!! I get this error: Innobase: Fatal error: cannot allocate memory! Innobase: Cannot continue operation! Innobase: Check if you can increase the swap file of your Innobase: operating system. 010906 15:31:27 mysqld ended Anyone as any clue about this? -- Nuno Dias [EMAIL PROTECTED] Novis - Dir. Rede - ISP http://www.novis.pt/ Ed. Atrium Saldanha - Pça. Dq. de Saldanha, 1, 7o / 1050 - 094 Lisboa tel: +351 21 0104437 - fax: +351 21 0104301 I may not be able to walk, but I drive from a sitting position. - 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 Dias [EMAIL PROTECTED] Novis - Dir. Rede - ISP http://www.novis.pt/ Ed. Atrium Saldanha - Pça. Dq. de Saldanha, 1, 7o / 1050 - 094 Lisboa tel: +351 21 0104437 - fax: +351 21 0104301 Brandy Davis, an outfielder and teammate of mine with the Pittsburgh Pirates, is my choice for team captain. Cincinnatti was beating us 3-1, and I led off the bottom of the eighth with a walk. The next hitter banged a hard single to right field. Feeling the wind at my back, I rounded second and kept going, sliding safely into third base. With runners at first and third, and home-run hitter Ralph Kiner at bat, our manager put in the fast Brandy Davis to run for the player at first. Even with Kiner hitting and a change to win the game with a home run, Brandy took off for second and made it. Now we had runners at second and third. I'm standing at third, knowing I'm not going anywhere, and see Brandy start to take a lead. All of a sudden, here he comes. He makes a great slide into third, and I scream, Brandy, where are you going? He looks up, and shouts, Back to second if I can make it. -- Joe Garagiola, It's Anybody's Ball Game - 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
Login with password fails with jdbc
Hi everybody, I'm trying to connect to a mySQL database on the localhost through a jdbc (mm.mysql.jdbc-1.2b I downloaded it from mySQL home page) driver, but I cannot establish the connection for users that need a password. The java code I use is approximately the following: private String url = jdbc:mysql://localhost/test; public static void main(String[] args) { ProvaJDBC thisclass = new ProvaJDBC(); try { Class.forName(org.gjt.mm.mysql.Driver).newInstance(); Driver dr = DriverManager.getDriver(thisclass.url); System.out.println(Connessione: +dr.acceptsURL(thisclass.url)+ +dr.getMinorVersion()); Connection con = DriverManager.getConnection(thisclass.url, user, password .. } } catch(SQLException e) { System.out.println(SQLException: + e.getMessage()); System.out.println(SQLState: + e.getSQLState()); System.out.println(VendorError: + e.getErrorCode()); e.printStackTrace(); } This code works perfectly for users that don't need to specify a password (that is, I specify a null or void string password), while it gets an error when a password is needed. The error is: SQLState: 08S01 VendorError: 1043 java.sql.SQLException: Communication link failure: Bad handshake at java.lang.Throwable.init(Throwable.java:96) at java.lang.Exception.init(Exception.java:44) at java.sql.SQLException.init(SQLException.java:45) at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:278) at org.gjt.mm.mysql.Connection.init(Connection.java:230) at org.gjt.mm.mysql.Driver.connect(Driver.java:126) at java.sql.DriverManager.getConnection(DriverManager.java:523) at java.sql.DriverManager.getConnection(DriverManager.java:183) at ProvaJDBC.main(ProvaJDBC.java:12) Is there anyone who can help me? thanx, Attilio Mattiocco - 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: InnoDB problems
On Mon, Sep 10, 2001 at 02:28:05PM +0300, Heikki Tuuri wrote: Nuno, I noticed a similar unexplained restriction on our Linux 2.4. We have 512 MB physical memory, no swap partition, and for some reason I cannot malloc more than 256 MB. The Unix errno just says 'Cannot allocate memory'. On our other machine with 900 MB RAM and 512 MB swap I can malloc 900 MB. What is your my.cnf like? Is it possible that you have allocated so much memory to PostgreSQL, MyISAM, and other programs that the 2 GB or 3 GB you have is almost totally used? Here's my.cnf: [mysqld] innodb_data_file_path = data/data1:2000M;data/data2:2000M innodb_data_home_dir = /servers/mysql/ set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = /servers/mysql/data/logs/ set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=50M set-variable = innodb_log_buffer_size=20M innodb_flush_log_at_trx_commit=0 innodb_log_arch_dir = /servers/mysql/data/logs/ innodb_log_archive=0 set-variable = innodb_buffer_pool_size=50M set-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 innodb_flush_method=O_DSYNC This problem arose before the installation of PostGres. Even then I could not reserve more than 50M for innodb_buffer_pool_size. The only thing that is also running on the machine is a HTTP server that uses at most 60M of mem. At 10:55 AM 9/10/01 +0100, you wrote: On Fri, Sep 07, 2001 at 08:47:16PM +0300, Heikki Tuuri wrote: Nuno, what does ulimit -a say (assuming you are running on Unix)? ulimit tells the limits set for the user. I think there are also hard limits decided at kernel compile time. core file size (blocks) 0 data seg size (kbytes) unlimited file size (blocks) unlimited max memory size (kbytes) unlimited stack size (kbytes) 8192 cpu time (seconds) unlimited max user processes 256 pipe size (512 bytes)8 open files 1024 virtual memory (kbytes) 2105343 I'm running Linux. What does free say? total used free sharedbuffers cached Mem: 20967202094180 2540 01073620 786400 -/+ buffers/cache: 2341601862560 Swap: 1052248 32921048956 But I'm running two SQL servers (MySQL and PostGres) and I'm running some scripts. Apart from that, the machine is totally dedicated to SQL stuff. When installing InnoDB I should have most of the memory available. Regards, Heikki http://www.innodb.com Nuno Dias wrote: I installed mysql with innodb support on a machine with 2G of RAM. The manual recommends that one should set innodb_buffer_pool_size in my.cnf to up to 80% of the physical memory available. However, if I set a value above 50M!!! I get this error: Innobase: Fatal error: cannot allocate memory! Innobase: Cannot continue operation! Innobase: Check if you can increase the swap file of your Innobase: operating system. 010906 15:31:27 mysqld ended Anyone as any clue about this? -- Nuno Dias [EMAIL PROTECTED] Novis - Dir. Rede - ISP http://www.novis.pt/ Ed. Atrium Saldanha - Pça. Dq. de Saldanha, 1, 7o / 1050 - 094 Lisboa tel: +351 21 0104437 - fax: +351 21 0104301 I may not be able to walk, but I drive from a sitting position. - 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 Dias [EMAIL PROTECTED] Novis - Dir. Rede - ISP http://www.novis.pt/ Ed. Atrium Saldanha - Pça. Dq. de Saldanha, 1, 7o / 1050 - 094 Lisboa tel: +351 21 0104437 - fax: +351 21 0104301 Brandy Davis, an outfielder and teammate of mine with the Pittsburgh Pirates, is my choice for team captain. Cincinnatti was beating us 3-1, and I led off the bottom of the eighth with a walk. The next hitter banged a hard single to right field. Feeling the wind at my back, I rounded second and kept going, sliding safely into third base. With runners at first and third, and home-run hitter Ralph Kiner at bat, our manager put in the fast Brandy Davis to run for the player at first. Even with Kiner hitting and a change to win the game with a home run, Brandy took off for second and made it. Now we had runners at second and third. I'm standing at third, knowing I'm not going anywhere, and see Brandy start to take a lead. All of a sudden, here he comes. He makes a great slide into third, and I scream, Brandy, where are you going? He looks up, and shouts, Back to second if I can make it.
Column definition: The EXTRA column
I am trying to use the EXTRA column that exist in mySQL ( DEFAULT EXTRA FIELD KEY NULL PRIVILEGES TYPE), but I do not understand how to put a value into it, I can get the value with SHOW COLUMNS, but I can not set it, andd it seem to be totally ignored in the manual. Does anyone know anything about this? Thankful for any help Stefan - 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: REMOVE NOW THIS IS THE SECOND TIME
On 09 Sep 2001 21:24:51 +, Mourad de Riche wrote: Is he drunk or something? Report to a federal law? No, he is from United States. According to Sklyarov case they think that world consists only from them and everyone should follow their rules, even when not being U.S citizen nor located on U.S soil. Tõnu BTW, sql - 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
Notice about seconds overroll - S7K bug
(This is third attempt to post. always failed in some reason) I would like to make your attention on bug which was introduced tonight and can affect some people who are using (var)char field to store timestamp data. It is not worst security bug. It affects only people who already had bug in their code. Just now this bug become visible/exploitable. This is not MySQL bug. This is how people use their database. Also similar situation can be found in other software. I would like to inform people in public list as maybe some people have to search similar problems. The problem: Computers store time and date usually as integer value representing amount of seconds from 1 January 1970. Tonight it overrolled from 9 to 10. Possible bug and exploit relies on fact that some people have used character type of field to store this seconds information (we have already such case) example: mysql create table session (expire varchar(100) not null); Query OK, 0 rows affected (0.31 sec) mysql insert into session values (7), (8), (9), (10), (11); Query OK, 5 rows affected (0.00 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql mysql select * from session; ++ | expire | ++ | 7 | | 8 | | 9 | | 10 | | 11 | ++ 5 rows in set (0.00 sec) mysql Let's assume that this table contains values we use somewhere to authenticate users. After user logs in, we write down session expiry time and later we check it like this: mysql select count(*) from session where expire = '132535'; +--+ | count(*) | +--+ |3 | +--+ 1 row in set (0.00 sec) mysql WOW, what happened? Shouldn't be 13253 bigger than any value in table? It worked yesterday! In MySQL we suggested people to use quotation marks around integer values. This can avoid many web-based attacks targeted to modify SQL commands (more information on http://www.mysql.com/doc/G/e/General_security.html). This is the reason why people put quotation marks around integer expressions and this is correct. Also automatic type casting will fix the source problem is column data is integer or some time/date vale. But when both column is character type and expression, they get compared as strings. And as we know, strings get sorted in order: 1,11,2,22 but integers: 1.2.11.22 So, this is why 13253 10 It is possible that some web applicatons have endless expiry times now and not only in MySQL contexts. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.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
I´m totally lost on this.......
Okej I have a site rank script. When users add the site I want the id number from mysql to bee shown in the next window. How do I call the id number? Should it be something like this?: $id PLEASE HELP ME.. iiiIIii Best regeards / Johan Way - 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 Java Problem and msg to MySql Admin
Hiya everybody, I need the advise of a person who knows java servlet programming, All I need to do is call servlet a's doGet method from servlet b. Any ideas/code suggestions most welcome. Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the list. Thanks in advance, -Ryan NOTE TO MySql admins: Dear Sir/Madam, After trying to subscribe to the list I get a email asking me to confirm and when I confirm by sending a blank email with the necessary string in the subject line I get an email saying that there was an error and that you have given up on that error as its a perminant error. Kindly help, thanking you, -Ryan - 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 Java Problem and msg to MySql Admin
Hiya everybody, I need the advise of a person who knows java servlet programming, All I need to do is call servlet a's doGet method from servlet b. Any ideas/code suggestions most welcome. Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the list. Thanks in advance, -Ryan NOTE TO MySql admins: Dear Sir/Madam, After trying to subscribe to the list I get a email asking me to confirm and when I confirm by sending a blank email with the necessary string in the subject line I get an email saying that there was an error and that you have given up on that error as its a perminant error. Kindly help, thanking you, -Ryan - 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 Java Problem and msg to MySql Admin
Hiya everybody, I need the advise of a person who knows java servlet programming, All I need to do is call servlet a's doGet method from servlet b. Any ideas/code suggestions most welcome. Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the list. Thanks in advance, -Ryan NOTE TO MySql admins: Dear Sir/Madam, After trying to subscribe to the list I get a email asking me to confirm and when I confirm by sending a blank email with the necessary string in the subject line I get an email saying that there was an error and that you have given up on that error as its a perminant error. Kindly help, thanking you, -Ryan - 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 Java Problem and msg to MySql Admin
Hiya everybody, I need the advise of a person who knows java servlet programming, All I need to do is call servlet a's doGet method from servlet b. Any ideas/code suggestions most welcome. Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the list. Thanks in advance, -Ryan NOTE TO MySql admins: Dear Sir/Madam, After trying to subscribe to the list I get a email asking me to confirm and when I confirm by sending a blank email with the necessary string in the subject line I get an email saying that there was an error and that you have given up on that error as its a perminant error. Kindly help, thanking you, -Ryan - 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: REMOVE NOW THIS IS THE SECOND TIME
;-) and can't read either ;) c'mon guys... lets keep the ethnic humour down... i'm sure it does not do any good to business, although it sure, well, tingles sometimes... we all have our natures, cultures, surroundings, and, understanding and respecting, clears boundaries and improve overall communicability. my warmest regards to all mauricio portasio [EMAIL PROTECTED] sao paulo - brazil - Original Message - From: Tonu Samuel [EMAIL PROTECTED] To: Mourad de Riche [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 9:11 AM Subject: Re: REMOVE NOW THIS IS THE SECOND TIME On 09 Sep 2001 21:24:51 +, Mourad de Riche wrote: Is he drunk or something? Report to a federal law? No, he is from United States. According to Sklyarov case they think that world consists only from them and everyone should follow their rules, even when not being U.S citizen nor located on U.S soil. Tõnu BTW, sql - 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
show columns
Hi Folks - simple Q from a newbie, I'd like to return only the column names using something like show columns. I'm using PHP to display db tables in html, with the headers of the html table url'ed to sort the result by field. It's easy when you hard-code the column names into the page, but I'm going by the table name only, and need to work with an array of the column names to print out the html table header. Help appreciated; thx in advance. Steve. - 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
Stored procedures (2)
I've got a tour on the web, searching for info and ideas, regarding the subject to implement some sort of stored procedure in mysql (remember Lets approach stored procedure thread ?) This was what I discovered - The Perl stored procedures (myperl project) in not a good idea at all, but, even if called poor man's stored procedure, I think that this project don't add, actually, stored procedure in the precise meamning of term. It add only a binding with Perl via UDF. It's a nice (and quite simple) hack. Dana Power, I've not take a look to _your_ hack, but I think this is the same approach. - I had searched everywhere the ANSI SQL3 directive... not luck. I only found a 1994 document where this directives were proposed It is quite incomprensile, though (like all standard doc I have read :) - I'm evalueting the IBM DB2 approach. Since the ol' COBOL days (rattles...) I remember the EXEC SQL ... END-EXEC commands embedded inside the COBOL as the host language. At compile time there was a cross-compile step the produced some code to get recompiled and finally linked and binded. This is also the (old?) informix approach, where SQL EXECs were embedded inside the C source, and then a cross-compile (or precompiler) make the dirty work, creating another C source that could finally be compiled and linked. But I don't know to have some (low skilled) SQL coders to be well skilled in some other language to write down a stored procedure. So here came my idea: use a SIMPLE language to write the logic of the stored procedure (no complex structures, definition and use of local variables, some test statement, error trapping, and of source free SQL coding), than use a precompiler to convert that source into the source of an UDF. At last, we had stored procedure written in a simple language, but compiled and used as UDFs. MySQL itself could then be used to store the packaging approach (as Oracle does), or other information regarding validation of the sp, last modification time, user... etc Just some thoughts Claudio Cicali mysql, database, tables - 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 where A is not a member of B
Hi - I've got an annoying problem here, I've checked books, web, archives, etc, but can't find anything suitable so far. I have 2 data tables (ignoring the other columns, not important) : ++ | user | ++ | userid | ++ ++ | list | ++ | listid | ++ and a joining table : +--+ | userlist | +--+ | listid | | userid | +--+ As you can see, users can belong to many lists, lists can contain many users. I need to find, for each user, whether they are a member of list n : ++--+ | userid | memberoflist | ++--+ | 1 | true | | 2 |false | | 3 | true | | 4 |false | ++--+ It seems simple, but I've been banging my head against this all weekend. When I break it down, I need to find 3 things : Users that are members : SELECT user.userid FROM user, userlist WHERE listid=1 AND user.userid=userlist.userid Users that belong to NO lists : SELECT user.userid FROM user LEFT JOIN userlist ON user.userid=userlist.userid WHERE listid IS NULL Users that belong to some lists, but not the one I'm interested in : this is the one that I'm stuck on. Any thoughts? Suggestions? djo - 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 where A is not a member of B
SELECT DISTINCT u.userid, IF( ul.listid, true, false) FROM user u LEFT OUTER JOIN userlist ul ON u.userid = ul.userid AND ul.listid = listid; -Original Message- From: David Otton [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 5:39 PM To: [EMAIL PROTECTED] Subject:Select where A is not a member of B Hi - I've got an annoying problem here, I've checked books, web, archives, etc, but can't find anything suitable so far. I have 2 data tables (ignoring the other columns, not important) : ++ | user | ++ | userid | ++ ++ | list | ++ | listid | ++ and a joining table : +--+ | userlist | +--+ | listid | | userid | +--+ As you can see, users can belong to many lists, lists can contain many users. I need to find, for each user, whether they are a member of list n : ++--+ | userid | memberoflist | ++--+ | 1 | true | | 2 |false | | 3 | true | | 4 |false | ++--+ It seems simple, but I've been banging my head against this all weekend. When I break it down, I need to find 3 things : Users that are members : SELECT user.userid FROM user, userlist WHERE listid=1 AND user.userid=userlist.userid Users that belong to NO lists : SELECT user.userid FROM user LEFT JOIN userlist ON user.userid=userlist.userid WHERE listid IS NULL Users that belong to some lists, but not the one I'm interested in : this is the one that I'm stuck on. Any thoughts? Suggestions? djo - 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
InnoDB tables : difficulties with COUNT(*), DELETE etc ...
Bonjour, I have a table created with : CREATE TABLE mybuffer_NAS_D ( id int(10) unsigned NOT NULL auto_increment, service varchar(10) NOT NULL default '', date datetime NOT NULL default '-00-00 00:00:00', data text, PRIMARY KEY (id), KEY id_date (date) ) TYPE=InnoDB; There are many rows in it. And InnoDB take a VERY long time to do count(*) :( mysql select count(*) from mybuffer_NAS_D; +--+ | count(*) | +--+ | 4611891 | +--+ 1 row in set (1 min 34.71 sec) If I select 100 first rows ordered by 'date asc', I see that there are less than 100 lines with date'2001-08-16 00:00:00'. mysql select * from mybuffer_NAS_D order by date asc limit 100; +--+-+-+--+ | id | service | date| data | | +--+-+-+--+ | 51155706 | live| 2001-07-02 17:58:08 | |TPEEIX?019.95?10?20?30?40?612001/7/2?7117:58:08?J0?K0.0 | | 51196330 | live| 2001-07-02 17:58:08 | |TPEEIX?019.95?10?20?30?40?612001/7/2?7117:58:08?J0?K0.0 | ... cut ... | 51192850 | live| 2001-08-15 14:30:18 | |TISMT?015.19?10?20?30?40?612001/8/15?71?J5.19?K-5| | 51192851 | live| 2001-08-15 14:30:18 | |TISMTW?010.74?10?20?30?40?612001/8/15?71?J0.74?K-5 | | 51194111 | live| 2001-08-15 14:30:20 | |TMAII?013.2?10?20?30?40?612001/8/15?71?J3.2?K-5 | | 51201163 | live| 2001-08-15 14:30:33 | |TUSOLW?010.1?10?20?30?40?612001/8/15?71?J0.1?K0.0| | 51201418 | live| 2001-08-15 14:30:33 | |TVFND?010.11?10?20?30?40?612001/8/15?71?J0.11?K-5| | 51203036 | live| 2001-08-15 14:30:37 | |TZSEV?015.52?10?20?30?40?612001/8/15?71?J5.52?K0.0 | | 51145454 | live| 2001-08-16 02:00:22 | |TCNBA?0117.75?10?20?30?40?612001/8/16?71?J17.75?K0.0 | | 51152124 | live| 2001-08-16 02:00:32 | |TMBLAP?0115.75?10?20?30?40?612001/8/16?71?J15.75?K0.0| | 51154024 | live| 2001-08-16 02:00:35 | |TNESC?011.35?10?20?30?40?612001/8/16?71?J1.35?K0.0 | | 51162377 | live| 2001-08-16 02:00:48 | |TZYSCD?0120?10?20?30?40?612001/8/16?71?J20?K0.0 | | 51186600 | live| 2001-08-16 14:30:08 | |TCNBA?0117.75?10?20?30?40?612001/8/16?71?J17.75?K0.0 | | 51194263 | live| 2001-08-16 14:30:24 | |TMBLAP?0115.75?10?20?30?40?612001/8/16?71?J15.75?K0.0| | 51203050 | live| 2001-08-16 14:30:37 | |TZYSCD?0120?10?20?30?40?612001/8/16?71?J20?K0.0 | | 51143821 | live| 2001-08-20 02:00:18 | |TADSTW?010.12?10?20?30?40?612001/8/20?71?J0.12?K0.0 | | 51157301 | live| 2001-08-20 02:00:40 | |TRLCOW?010.16?10?20?30?40?612001/8/20?71?J0.16?K0.0 | | 51159119 | live| 2001-08-20 02:00:42 | |TSSLI?013.2?10?20?30?40?612001/8/20?71?J3.2?K0.0 | +--+-+-+--+ 100 rows in set (0.42 sec) But if I ask Mysql to delete these rows, it crashes after a few minutes : mysql delete from mybuffer_NAS_D where date'2001-08-16 00:00:00'; ERROR 1030: Got error 100 from table handler I think I already read a lot about these limitations. But this is really a problem for me now :( Any improvement expected ? 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: Select where A is not a member of B
[EMAIL PROTECTED] writes: [snipped fscking ML bullshit] database,sql,query,table David Otton writes: Users that belong to some lists, but not the one I'm interested in : this is the one that I'm stuck on. Any thoughts? Suggestions? SELECT DISTINCT userid FROM userlist WHERE listid != thislistid might be what you want. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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
Too many open files
My Mysqld stopped accepting connections with Error log: 010910 15:34:19 Error in accept: Too many open files 010910 15:49:02 /usr/local/mysql/libexec/mysqld: Normal shutdown when trying to connect I got: ERROR 2013: Lost connection to MySQL server during query changed max_connections and restarted server got error.log : 010910 15:49:04 /usr/local/mysql/libexec/mysqld: Shutdown Complete 010910 15:49:04 mysqld ended 010910 15:49:15 mysqld started 010910 15:49:15 Warning: setrlimit couldn't increase number of open files to more than 1024 010910 15:49:15 Warning: Changed limits: max_connections: 300 table_cache: 357 /usr/local/mysql/libexec/mysqld: ready for connections Documentation states: open_files_limit If this is not 0, then mysqld will use this value to reserve file descriptors to use with setrlimit(). If this value is 0 then mysqld will reserve max_connections*5 or max_connections + table_cache*2 (whichever is larger) number of files. You should try increasing this if mysqld gives you the error 'Too many open files'. Can I increase setrlimits limit to more then 1024, or is that the ceiling on my OS/ hardware? (I thought about dropping the value of wait_timeout from 8 hours to 4 (or 2) hours, as this would disconnect idle clients. I have numerous apache clients, all with many children hanging onto a connection. Any thoughts about this before I do it?) Thanks, Robin Running Redhat Linux 7.1 on intel Mysql version 3.23.37-log Some Variables: | open_files_limit| 0 | max_connections | 300 | max_user_connections | 0 | max_tmp_tables | 32 - 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
segmentation fault post mysql server binary install for solaris-i386
I am getting a segmentation fault on a solaris i86pc when executing either with: ./bin/safe_mysqld ./bin/mysql -h active_mysql_host On this solaris i86pc, I got the following binary install: mysql-3.23.39-pc-solaris2.8-i386.tar.gz Then untarred it with GNU tar (gtar-i386). The uname -X output for my target machine is: System=SunOS Release=5.8 Kernel=Generic_108529-06 Machine=i86pc NumCPU=2 I have done a binary install before of MySQL onto a solaris-sparc. Did I get the wrong binary? Thanks Jeff Tanner Seattle, WA - 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: Mergetable locking
Hi. On Mon, Sep 10, 2001 at 12:46:01PM +0200, [EMAIL PROTECTED] wrote: How does mysql manage locks on mergetables? As far as I can see, it locks all underlying tables. This may not be the best, but a reasonable approach, because it doesn't know beforehand which tables will be involved. Bye, Benjamin. - 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
GEMINI Table Type
Hi : First of all I've test for a short period MYSQL, I think is great ,,, recently I was navigating MYSQL.COM and I found and read about the dispute with MYSQL.ORG I enter the site to see what it was ... I notice they promote a type of table name GEMINI ... that support the ACID properties ... What I understand is that MYSQL.COM MYSQL.ORG, but does MYSQL.COM has a table type same as GEMINI ( GEMINI does not complies with GPL according to what I read) that support the ACID PROPERTIES ( TRANSACTIONS ) (MyIsam, Inodb ?) ... Sorry if someone already post this Question, and sounds like a echo to all of you, but I am really interest in using MYSQL to develop a project and I am evaluating it ... Thanks a lot - 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: InnoDB tables : difficulties with COUNT(*), DELETE etc ...
Alex, slowness of count(*) is a well-known problem. I will fix it some time this fall. Not very easy, because of multiversioning and recovery. The other problem you have is that a delete operation ends up in a deadlock (I think it should not be called a 'crash'). I will write in October a selective deadlock resolution algorithm to InnoDB where a big transaction is not chosen as the victim in a deadlock situation. Unfortunately EXPLAIN does not work on a DELETE, and you cannot ask how MySQL does the delete. You should download the version 3.23.42 and do mysqlcreate table innodb_lock_monitor (a int) type = innodb; so that we would see what locks and lock waits happen during the delete. That could give us a clue how to fix the delete inefficiency. Regards, Heikki http://www.innodb.com At 04:17 PM 9/10/01 +0200, you wrote: Bonjour, I have a table created with : CREATE TABLE mybuffer_NAS_D ( id int(10) unsigned NOT NULL auto_increment, service varchar(10) NOT NULL default '', date datetime NOT NULL default '-00-00 00:00:00', data text, PRIMARY KEY (id), KEY id_date (date) ) TYPE=InnoDB; There are many rows in it. And InnoDB take a VERY long time to do count(*) :( mysql select count(*) from mybuffer_NAS_D; +--+ | count(*) | +--+ | 4611891 | +--+ 1 row in set (1 min 34.71 sec) If I select 100 first rows ordered by 'date asc', I see that there are less than 100 lines with date'2001-08-16 00:00:00'. mysql select * from mybuffer_NAS_D order by date asc limit 100; +--+-+-+--- ---+ | id | service | date| data | +--+-+-+--- ---+ | 51155706 | live| 2001-07-02 17:58:08 | TPEEIX?019.95?10?20?30?40?612001/7/2?7117:58:08?J0?K0.0 | | 51196330 | live| 2001-07-02 17:58:08 | TPEEIX?019.95?10?20?30?40?612001/7/2?7117:58:08?J0?K0.0 | ... cut ... | 51192850 | live| 2001-08-15 14:30:18 | TISMT?015.19?10?20?30?40?612001/8/15?71?J5.19?K-5| | 51192851 | live| 2001-08-15 14:30:18 | TISMTW?010.74?10?20?30?40?612001/8/15?71?J0.74?K-5 | | 51194111 | live| 2001-08-15 14:30:20 | TMAII?013.2?10?20?30?40?612001/8/15?71?J3.2?K-5 | | 51201163 | live| 2001-08-15 14:30:33 | TUSOLW?010.1?10?20?30?40?612001/8/15?71?J0.1?K0.0| | 51201418 | live| 2001-08-15 14:30:33 | TVFND?010.11?10?20?30?40?612001/8/15?71?J0.11?K-5| | 51203036 | live| 2001-08-15 14:30:37 | TZSEV?015.52?10?20?30?40?612001/8/15?71?J5.52?K0.0 | | 51145454 | live| 2001-08-16 02:00:22 | TCNBA?0117.75?10?20?30?40?612001/8/16?71?J17.75?K0.0 | | 51152124 | live| 2001-08-16 02:00:32 | TMBLAP?0115.75?10?20?30?40?612001/8/16?71?J15.75?K0.0| | 51154024 | live| 2001-08-16 02:00:35 | TNESC?011.35?10?20?30?40?612001/8/16?71?J1.35?K0.0 | | 51162377 | live| 2001-08-16 02:00:48 | TZYSCD?0120?10?20?30?40?612001/8/16?71?J20?K0.0 | | 51186600 | live| 2001-08-16 14:30:08 | TCNBA?0117.75?10?20?30?40?612001/8/16?71?J17.75?K0.0 | | 51194263 | live| 2001-08-16 14:30:24 | TMBLAP?0115.75?10?20?30?40?612001/8/16?71?J15.75?K0.0| | 51203050 | live| 2001-08-16 14:30:37 | TZYSCD?0120?10?20?30?40?612001/8/16?71?J20?K0.0 | | 51143821 | live| 2001-08-20 02:00:18 | TADSTW?010.12?10?20?30?40?612001/8/20?71?J0.12?K0.0 | | 51157301 | live| 2001-08-20 02:00:40 | TRLCOW?010.16?10?20?30?40?612001/8/20?71?J0.16?K0.0 | | 51159119 | live| 2001-08-20 02:00:42 | TSSLI?013.2?10?20?30?40?612001/8/20?71?J3.2?K0.0 | +--+-+-+--- ---+ 100 rows in set (0.42 sec) But if I ask Mysql to delete these rows, it crashes after a few minutes : mysql delete from mybuffer_NAS_D where date'2001-08-16 00:00:00'; ERROR 1030: Got error 100 from table handler I think I already read a lot about these limitations. But this is really a problem for me now :( Any improvement expected ? 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
Weird problem
I just got this problem... bin/mysql -h localhost -u root logs me into MySQL at the command line However, the CGI script for Apache webserver gave me an error connecting to the database $source = DBI:mysql:red:localhost; $username = root; $password = ; Did any of you ever face this problem before?? BTW, I'm running Mandrake Linux... Very puzzled Tony _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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
compiling MySQLGUI
I am trying to compile MySQLGUI for solaris 8. I can't use the precompiled version as I do not have the same version shared library for libstdc++. Recompiling that at this point is not an option. The precompiled version is also several revisions old and not compiled for solaris 8 (this last argument does not stand on its own, but if I am going for the latest version, I might as well get it compiled for the same version).. The first issue I have it that MySQLGUI expects the fl_editor package to compile static libraries librcl and librcledit. However, the version distributed from the mysql.com site as well as newer versions on the maintainers site do not build these libraries. I had to get an older version (0.3) to get these files built. Using those static libraries I almost finished, but got a bunch of undefined symbol errors errors when trying to build the final binary. Thanks for your time. Steve - 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: Weird problem
Silver Fox wrote: I just got this problem... bin/mysql -h localhost -u root logs me into MySQL at the command line However, the CGI script for Apache webserver gave me an error connecting to the database $source = DBI:mysql:red:localhost; $username = root; $password = ; Did any of you ever face this problem before?? BTW, I'm running Mandrake Linux... It is probably a problem with the permissions of the /path/to/mysql.sock. The web server usually runs as user nobody so make sure that the path to the mysql.sock has world read and execute. --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
Perl MySQL OO design question
I have a perl-DBI-MySQL database app. that handles everything from my order entry to my accounts payable. I am in the process of cleaning up a lot of the code I've written to make it easier to maintain. I probably use the following DBI staement handle about fifty different places on different tables: use DBI; my $dbh = DBI-connect(DBI:mysql:database=operations;192.128.0.1,abuser,whisky); my $q = INSERT into table (column, column, column, column) VALUES (?, ?, ?, ?); my $sth = $dbh-prepare($q); $sth-execute($val1, $val2, $val3, $val4); Would it be best to create a class called INSERT that all scripts call when they need to insert create a new record in a table? Richard - 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: GEMINI Table Type
Hello. On Mon, Sep 10, 2001 at 09:20:55AM -0600, [EMAIL PROTECTED] wrote: [...] What I understand is that MYSQL.COM MYSQL.ORG, but does MYSQL.COM has a table type same as GEMINI ( GEMINI does not complies with GPL according to what I read) that support the ACID PROPERTIES ( TRANSACTIONS ) (MyIsam, Inodb ?) ... MyISAM does not (fully), InnoDB and BDB do support ACID properties. Have a look at the documentation in the manual to learn more about these table types. Bye, Benjamin. PS: Why did you try mail this to the announce-list? It certainly doesn't belong there. - 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: GEMINI Table Type
At 9:20 AM -0600 9/10/01, ROGGER ALEXIS VASQUEZ MARTINEZ wrote: Hi : First of all I've test for a short period MYSQL, I think is great ,,, recently I was navigating MYSQL.COM and I found and read about the dispute with MYSQL.ORG I enter the site to see what it was ... I notice they promote a type of table name GEMINI ... that support the ACID properties ... What I understand is that MYSQL.COM MYSQL.ORG, but Correct. does MYSQL.COM has a table type same as GEMINI ( GEMINI does not complies with GPL according to what I read) I think you may be referring to material that predates Gemini's release under GPL. that support the ACID PROPERTIES ( TRANSACTIONS ) (MyIsam, Inodb ?) ... The distributions available at mysql.com do not include code for the Gemini table type. The MySQL+Gemini distributions at mysql.org do. The distributions from both sites also support ISAM, MyISAM, BDB, and InnoDB table types. You may have to compile from source with the appropriate configure flags to enable support for the table types you want to evaluate. Sorry if someone already post this Question, and sounds like a echo to all of you, but I am really interest in using MYSQL to develop a project and I am evaluating it ... Thanks a lot -- Paul DuBois, [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: Column definition: The EXTRA column
At 2:04 PM +0200 9/10/01, Ralof wrote: I am trying to use the EXTRA column that exist in mySQL ( DEFAULT EXTRA FIELD KEY NULL PRIVILEGES TYPE), but I do not understand how to put a value into it, I can get the value with SHOW COLUMNS, but I can not set it, andd it seem to be totally ignored in the manual. Does anyone know anything about this? There is no EXTRA coluumn. You're misinterpreting the output from SHOW COLUMNS. That statement provides information about the columns in a table, but the column names of the SHOW COLUMNS output do not all corrspond to attributes that you can set directly when you create the table. Those you can specify directly: FIELD (column name) TYPE (the column type; INT, CHAR, etc.) NULL (by specifying NULL or NOT NULL) DEFAULT KEY (by specifying indexes for the the table) Those you cannot specify directly: EXTRA (currently used in SHOW COLUMNS only to indicate whether or not the column has the AUTO_INCREMENT attribute) PRIVILEGES (you must set these with a GRANT statement) Thankful for any help Stefan -- Paul DuBois, [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: Select where A is not a member of B
Hi. On Mon, Sep 10, 2001 at 02:38:56PM -0700, [EMAIL PROTECTED] wrote: [...] I need to find, for each user, whether they are a member of list n : ++--+ | userid | memberoflist | ++--+ | 1 | true | | 2 |false | | 3 | true | | 4 |false | ++--+ The following should give something like the above (verified): SELECT u.userid, IF( COUNT(ul.listid) 0, 'true', 'false' ) FROM user u LEFT JOIN userlist ul ON u.userid = ul.userid AND ul.listid = 1 GROUP BY u.userid It seems simple, but I've been banging my head against this all weekend. When I break it down, I need to find 3 things : Users that are members : SELECT user.userid FROM user, userlist WHERE listid=1 AND user.userid=userlist.userid Users that belong to NO lists : SELECT user.userid FROM user LEFT JOIN userlist ON user.userid=userlist.userid WHERE listid IS NULL Users that belong to some lists, but not the one I'm interested in : this is the one that I'm stuck on. Any thoughts? Suggestions? This would be (not verified): SELECT DISTINCT u.userid FROM user u, userlist ul LEFT JOIN userlist nl ON nl.userid = ul.userid AND nl.listid = 1 WHERE ul.userid = u.userid AND nl.listid IS NULL That is: First build a list of all users that are members in any group, then look up which users are in list 1 and exclude them, then remove all duplicates (DISTINCT). Bye, Benjamin. PS: Feeding the filter: database - 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
indexes and desc
When doing a select that is ordered by a column that is indexed and has a limit, does mysql not use the index if the order by is descending? Here's an example: select parent,number,lastpost from posts where topic=1 and board='abc' and approved='yes' order by lastpost desc limit 9,12 My app is a message board and I'm using date descending as the order. One thought I had is to create a new column like desctime and set the value of each post to something like the time value for say 1/1/2025 minus the lastpost time - that should set it far enough out I wouldn't have to every worry about it. Another thought I guess would be to just store the value as a negative value. If it doesn't use the index in descending order, does anyone have any suggestions on my thoughts here or other ideas on how to work around this most efficiently? And are there future plans for indexing on desc order? - 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: Simple select problem.
How about SELECT @last:=MAX(Date + 0) from stat; Eyal Rif wrote: Hi, I have a table with the format of : char(20),int(7),char(32) the Date char(20) contents in actually a number(seconds since 1970) - I want to use a select query that will give the max value according to number value of that column. select @last:=MAX(Date) from stat1; What I need to know is how to convert a string to a number on a select statement. Any help/reference will be appreciated 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 -- Gerald L. Clark [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: [Chicago.pm]: Perl MySQL OO design question
I have a perl-DBI-MySQL database app. that handles everything from my order entry to my accounts payable. I am in the process of cleaning up a lot of the code I've written to make it easier to maintain. I probably use the following DBI staement handle about fifty different places on different tables: If you've got the same SQL getting executed over 'n' over, you can just keep the same $sth and re-execute each time. For instance. DBI-connect(DBI:mysql:database=operations;192.128.0.1,abuser,whisky); my $q = INSERT into table (column, column, column, column) VALUES (?, ?, ?, ?); my $sth = $dbh-prepare($q); $sth-execute($val1, $val2, $val3, $val4); And then: $sth-execute(@another_set_of_vals); $sth-execute(still,more,values,here); etc etc with appropriate error checking, natch. xoxo, Andy -- %_=split/;/,.;;n;u;e;ot;t;her;c; . # Andy Lester 'Perl ;@; a;a;j;m;er;y;t;p;n;d;s;o;'. # http://petdance.com hack;print map delete$_{$_},split//,q [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: sqld core dump after power failure
Did you try deleting the mysql.sock before starting the server? fsck seems to have changed its file type. Katrina Maffey wrote: Description: After a brief power failure, I rebooted the mysql server machine, and got this error on startup: Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/safe_mysqld: line 254: 1844 Segmentation fault (core dumped) $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 010910 13:32:48 mysqld ended I tried running myisamchk -re on every *.MYI file under /var/lib/mysql, and they seemed to repair successfully, however the crash still occurs. From the strace output, I don't think mysqld even gets as far as opening these files. What else can I try to get mysqld running again? Extra info: -- Gerald L. Clark [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: indexes and desc
On Mon, Sep 10, 2001 at 09:13:06AM -0700, PR wrote: And are there future plans for indexing on desc order? This is already fixed in MySQL 4.0. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 4 days, processed 99,159,321 queries (254/sec. avg) - 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
Index Question
Hello All, I've got a question that is likely an easy one, I just want confirmation from my peers. I have tables with a timestamp column and perform many selects and counts from these tables based on the date that the record was written. Can/should I index a timestamp column? I do my best to index columns that I specify in my WHERE clauses, however I haven't yet tried to index a timestamp column. Is it even possible? Is it advisable? Should I treat it as a char and limit it to just index on the portion of the data that distinguishes the date (I don't care about the time, just the date). Thanks! Tyrone Mills = Internet service provided by telus.net http://www.telus.net/ - 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.42 and some errors in logfile
Hi, so I've tried the binary distribution for linux and I have these errors in logfile (I've seen them already under 3.23.41, under which I compressed the tables): 010910 18:12:20 mysqld started /usr/local/mysql/bin/mysqld: ready for connections 010910 18:13:52 read_const: Got error 127 when reading table ./Ncrassa/contig_data Running myisamchk without options does not show any errors. Here are some details: $ myisamchk -dvvv /data/mysql/Ncrassa/contig_data.MYI MyISAM file: /data/mysql/Ncrassa/contig_data.MYI Record format: Compressed Character set: latin1 (8) File-version:1 Creation time: 2001-08-29 5:45:44 Recover time:2001-08-30 0:08:31 Status: checked,analyzed,optimized keys,sorted index pages Checksum: 2185832194 Data records: 247 Deleted blocks: 0 Datafile parts:247 Deleted data: 0 Datafile pointer (bytes):4 Keyfile pointer (bytes):2 Datafile length: 4562802 Keyfile length: 15360 Max datafile length:4294967294 Max keyfile length: 67107839 Recordlength:55929 table description: Key Start Len Index Type Rec/key Root Blocksize 1 2 3 unique uint24 1 1024 1024 2 108 100 multip. char packed stripped 1 4096 1024 3 208 255 multip. char packed stripped 247 7168 2048 4 8 100 multip. char packed stripped 1 9216 1024 5 5 3 multip. uint24 prefix 112288 1024 Field Start Length Nullpos Nullbit Type Huff tree Bits 1 1 1 constant 1 0 2 2 3 zerofill(2) 2 9 3 5 3 zerofill(2) 2 9 4 8 100no endspace 2 9 5 108 100no endspace 2 9 6 208 255constant 3 0 7 463 12 1 1 blob 4 3 CHECK TABLE CONTIG_DATA says that the table is also OK. My question is: because I compressed the table under broken 3.23.41, shouldn't I uncpress the table and compress again? Or at least recreate the index. The problem is, that I don't know how to repeat this problem. I can work with table (i.e. SELECTs work). However, the message in logfile is weird. It happens (and happened even before this upgrade) with other tables: 010910 16:08:04 read_const: Got error 127 when reading table ./Athaliana_II/contig_data 010910 16:12:28 read_const: Got error 127 when reading table ./Campylobacter_jejuni_NCTC_11168/blast_data You may want to check pub/mysql/secret/compressed.tgz or delete it as junk. ;) Thanks! -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics http://mips.gsf.de GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, 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
Re: Index Question
From: [EMAIL PROTECTED] Can/should I index a timestamp column? Can: Yes. Should: Why not? Should I treat it as a char and limit it to just index on the portion of the data that distinguishes the date Hmm, I wouldn't. Offhand, I'd guess that MySQL handles time/date things as integers. I'm pretty sure that he also handles indexes as some sort of integer based serialization. Meaning that conversion to a string would be an extra step and thereby a loss. I'd say to try it a few different ways (if you have the time on this job) and find out what works best for you. --- Rodney Broom Programmer: Desert.Net Spam filter: sql - 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: MyODBC, DBUG and multi-threaded clients
Hi Monty, Michael Widenius wrote: Hi! I have a small comment to this. Note that you will get crashes in the DBUG package if you call any MySQL function inside a thread that hasn't called mysql_init() or mysql_connect(). If you want to use MySQL functions in threads that doesn't call the above functions, you need to call my_thread_init() at the start of the thread and my_thread_end() before the thread ends. If you think that the DBUG functions are the ones that is causing problems, you can always recompile MySQL without --with-debug, in which the DBUG macros will not generate any code. Regards, Monty Thanks very much for this: I will check the application for these calls. Regards, Peter - 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
revoke privilege
I do: grant SELECT,alter,index,insert,update on SK_10.* to admin-ab-44 identified by ab-44; And : revoke all on SK_10.users_profiles from admin-ab-44; But the user cant always make a SELECT * from SK_10.users_profiles ; I want no acces to the table SK_10.users_profiles what can i do? --=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-- François Boucher [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Performance Problem
On Thu, Sep 06, 2001 at 05:26:53PM +0200, Henning Schroeder wrote: Find all the queries that interact with this table. EXPLAIN them. Time them. *all* of them? there are lots. Well, perhaps not initially but you may want to have EXPLAINed a majority of the queries that are issued against your database and probably all the ones that occur often. as said before, it is the main user table. a user account is updated every time somebody request a page. and i need to join to that table very often to find out, when the corresponding user logged in last and what his name is. bad design? bad idea? what do you think? It does seem to be a point of contention. i could split these queries below into multiple queries, first getting the userid and then firing off another query to get the name (without a join). but i thought letting the database handle this should be faster. I guess only benchmarking will show if it's faster. Generally though I've found that many very quick queries is preferable to MySQL than one large, slow query, even if the many queries take longer (all added together) than the one large query. This assumes a web-backend type of application. select * from cookies left join users on cookies.uid=users.uid left join sessions on users.uid=sessions.uid where cookies.cookie=e3bd03382561eb3619b66fbea2af217d; select * from cookies left join users on cookies.uid=users.uid left join extended on users.uid=extended.uid where cookies.cookie=5226220e3b62cef71a13524ec7a413ac; (above queries have to be performed at the beginning of every webpage to find the current user. i don´t really think they are slow; they just lock because of something else.) i just tried the above query ten times. result: 7x 0.00sec, 1x0.01, 1x0.02, 1x0.04. does that spell slow? Yes. I wouldn't let queries with times like these near a busy production server I was responsible for unless I was positive they wouldn't and couldn't happen more than a handful of times a day. :-) Post the output of EXPLAIN for these queries. Along with the create defns for these other tables. Explanations snipped doesn´t look too bad for me. except that timing information at the end :-(. but that´s because the database is almost completely locked up again (processlist full of queries with Locked status). the table definition is quite long, i´ll append it to the end of the mail. Yes, I see what you mean. :-) Since uid is the primary key for cookies, users, sessions and extended, I wonder if the database could be made happier overall by breaking the queries down... select uid from cookies where cookie = 5226220e3b62cef71a13524ec7a413ac select * from users where uid=$uid select * from sessions where uid=$uid select * from extended where uid=$uid These might ease the bottlenecks. An update to sessions (for example) will only delay for the (relatively quick) third query instead of on the first bigger query. Conversely, only the third query will delay updates to sessions. I assume (and I'm guessing here) that the bottlenecks are being caused by regular updates to sessions and, to a lesser extent, extended. Perhaps some normalisation of sessions might help? Chances are I'm missing an important subtlety in your use of left join though, so feel free to flame (offlist)... :-) well, yes. i noticed that :-(. thank you for your good explanation though. but i think it´s probably not very fruitful to look for queries in the processlist that have locked status, because they are probably not the slow ones that caused the block. am i correct? Pretty much. While queries that spend too much time in a locked state aren't directly to blame (I blame the queries that lock the tables :-), blame isn't really at issue: either make the tables not locked so much or make the queries less dependent on the locked tables. :-) i also tried logging the queries that appear often with copying to temp table status and now have a nice set of them, though i don´t quite understand *why* the are copying. below are two: (the rows count is *way* to high, probably because the timestamps are ancient by the time i ran explain select) select count(*) from adviews where click=f and uid=7618 and cid=11 and datestamp=999782664 mysql explain select count(*) from adviews where click=f and uid=7618 and cid=11 and datestamp=999782664 ; +-+--+-+--+-+---+--++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+-+--+-+---+--++ | adviews | ref | uid,click,cid,datestamp | uid | 4 | const | 2365 | where used | +-+--+-+--+-+---+--++ 1 row in set (0.00 sec) index on all fields, optimized nightly.
Re: Let's approach stored procedures
Depending on the way you define things, MIN and MAX are essentially stored procedures that were programmed into MySQL. Why not let us make our own? This is already possible with Aggregate UDF 's. Check the manual here: http://www.mysql.com/doc/A/d/Adding_functions.html dpk - 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: Stored procedures (2)
- The Perl stored procedures (myperl project) in not a good idea at all, but, even if called poor man's stored procedure, I think that this project don't add, actually, stored procedure in the precise meamning of term. It add only a binding with Perl via UDF. It's a nice (and quite simple) hack. Dana Power, I've not take a look to _your_ hack, but I think this is the same approach. Actually, its not. Its more along the lines of apache's CGI vs. mod_perl. And its not just perl, its an architecture for pluggable languages ( python, javascript, lisp, or your new pl/sql clone ), which is exactly what you're looking for, if im not mistaken. The problem you're going to have is that MySQL does not support callbacks into the engine - i.e. youre in the middle of an sql call when your function gets called ( whether its udf or something else doesnt matter ), halting everything - effectively pushing it onto 'the stack' - and making separate sql calls, is not supported. You'll find that the hardest part is overcoming the current 'atomic' architecture, which has been used to optimize pretty much every part of the engine ( atomic meaning that 1 sql call is 1 simple actions. ). Of course CREATE ... SELECT and INSERT ... SELECT are simple exceptions, but the same reason that Sub-Selects are non-trivial, is the same reason that stored procedures are non-trivial. dpk - 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: REMOVE NOW THIS IS THE SECOND TIME
Tonu Samuel wrote: On 09 Sep 2001 21:24:51 +, Mourad de Riche wrote: Is he drunk or something? Report to a federal law? No, he is from United States. According to Sklyarov case they think that world consists only from them and everyone should follow their rules, even when not being U.S citizen nor located on U.S soil. Tõnu BTW, sql Tõnu: Without regard to his/her mental state the original message was a response to a very valid (probably somewhat useful) technical discussion responded to by Jeremy Z. I.e. (doesn't always stand for Internet Exploder): it was a flame. It's unfortunate those M$ mailers still don't let people view the unsubscribe instructions and that particular company is beyond the jurisdiction of the U.S. DOJ. Clearly the reach of that company's software extends beyond U.S. borders or this thread would never have started. mysqladmin create db SSSCA mysql use mysql; mysql delete citizen from db; mysql quit; mysqladmin -u Bush reload 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
'localhost' problem
hello all, i am running mysql on a red hat linux v7.0 box. when i am trying to connect to the mysql database to read a table that is present in the mysql database i am facing a strange problem. i am able to get into the database(named 'newone') to read the table (named 'namelist') from the command line on the machine that is running mysql in any of the following ways: # mysql -u myname -p mypassword # mysql -u myname -p mypassword -h localhost # mysql -u myname -p mypassword -h mydomain.edu All these 3 commands are successful, without returning an error. So i have created a php file named 'namelist.php' to read this 'namelist' table, which reads like the following: html head titleName List/title /head body ?php mysql_connect ('localhost','myname','mypassword') or die ('bUnable to connect to the database/b'); mysql_select_db ('newone') or die ('bUnable to connect to the database/b'); $result = mysql_query (select * from namelist); printf (First Name: %sbr\n, mysql_result($result, 0, firstname)); printf (Last Name: %sbr\n, mysql_result($result, 0, lastname)); ? /body /html when i run this php script from the browser, it is producing the following error: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/namelist.php on line 7 Unable to connect to the database But if change the 'localhost' to 'mydomain.edu' in line 7 it shows the contents of the table on the browser without any glitch. My question is eventhough if it doesn't complain any thing from the command line when i specify '-h localhost', why it returns the above error when i run the script in a browser? i am able to reach the index.html page from the browser by typing any of the following, on the same machine: 127.0.01 localhost mydomain.edu 138.xx.xx.xx --my ip address Can any one please help me with this. TIA __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.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
Still Searching for Accent solution - MySQL 3.23
Hello, I'm still having problems with MySQL 3.23 being accent sensitive during searches. However, I'm now tested to ensure I'm getting the correct accented search term to MySQL. Here's my test page, which includes a small database of names with 2 entries per name, one including an accented vowel. http://www.sedl.org/accents.html If you search for Jose (no accent on the e) you get Jose (no accent) If you search for José (with accent on the é) you get José (with accent) At first, I thought it might be a problem with MySQL not recieveing the accented value in the search term correctly, but that still doesn't answer why searching for Jose (no accent) doesn't act like a wildcard to pull up the record with the accented value as well as the unaccented value. Brian -- Brian Litke Web Administrator Southwest Educational Development Laboratory (SEDL) (800 or 512) 476-6861 x-260 http://www.sedl.org/ - 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
mysqldump question (very basic)
Hi. I'm trying to run a mysqldump. I enter mysqldump -databases in order to backup all the databases. For some reason all I'm getting back is a help on the mysqldump. What am I doing wrong? thanks = __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.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
Hi, very simple question. I would like to save and print the contents of myDESCRIBE table_1; How would I do this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) 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: REMOVE NOW THIS IS THE SECOND TIME
Good words, Mauricio. /Rob Toronto, Ontario, Canada Ob. MySQL: database, sql, query, table ;-) and can't read either ;) c'mon guys... lets keep the ethnic humour down... i'm sure it does not do any good to business, although it sure, well, tingles sometimes... we all have our natures, cultures, surroundings, and, understanding and respecting, clears boundaries and improve overall communicability. my warmest regards to all mauricio portasio [EMAIL PROTECTED] sao paulo - brazil ~ Robert Alexander~~ Programmer/Analyst/DBA/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: print
Jeremy Morano wrote: Hi, very simple question. I would like to save and print the contents of myDESCRIBE table_1; How would I do this? Jeremy: mysql -e 'DESCRIBE table_1;' | lp Regards, Van -- = Linux rocks!!! 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: 'localhost' problem
yes..the /etc/hosts file reads like the following: 127.0.0.1 localhost.localdomain localhost 138.xx.xx.xx mydomain.edu mymachine thanks --- Lance Rochelle [EMAIL PROTECTED] wrote: is localhost setup correctly in /etc/hosts file? i.e. 127.0.0.1 localhost, if not put that in there and then try again lance - Original Message - From: Crazy Linux [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 2:53 PM Subject: 'localhost' problem hello all, i am running mysql on a red hat linux v7.0 box. when i am trying to connect to the mysql database to read a table that is present in the mysql database i am facing a strange problem. i am able to get into the database(named 'newone') to read the table (named 'namelist') from the command line on the machine that is running mysql in any of the following ways: # mysql -u myname -p mypassword # mysql -u myname -p mypassword -h localhost # mysql -u myname -p mypassword -h mydomain.edu All these 3 commands are successful, without returning an error. So i have created a php file named 'namelist.php' to read this 'namelist' table, which reads like the following: html head titleName List/title /head body ?php mysql_connect ('localhost','myname','mypassword') or die ('bUnable to connect to the database/b'); mysql_select_db ('newone') or die ('bUnable to connect to the database/b'); $result = mysql_query (select * from namelist); printf (First Name: %sbr\n, mysql_result($result, 0, firstname)); printf (Last Name: %sbr\n, mysql_result($result, 0, lastname)); ? /body /html when i run this php script from the browser, it is producing the following error: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/namelist.php on line 7 Unable to connect to the database But if change the 'localhost' to 'mydomain.edu' in line 7 it shows the contents of the table on the browser without any glitch. My question is eventhough if it doesn't complain any thing from the command line when i specify '-h localhost', why it returns the above error when i run the script in a browser? i am able to reach the index.html page from the browser by typing any of the following, on the same machine: 127.0.01 localhost mydomain.edu 138.xx.xx.xx --my ip address Can any one please help me with this. TIA __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.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 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.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: UNION workaround?
I need to do this seemingly simple thing in mySQL: SELECT SUM(wucount), SUM(genecount) FROM genomestats WHERE curDate IN ('09-09-2001 9:30:00', '09-09-2001 12:30:00'); However, the SUM() returns the SUM of both dates. However, I could do SELECT SUM(wucount), SUM(genecount) from genomestats WHERE curDate = '09-09-2001 9:30:00' UNION SELECT SUM(wucount), SUM(genecount) FROM genomestats where curDate = '09-09-2001 12:30:00'; Does anyone know a good way around this??? - Glendon Solsberry Internet Programmer Tricon Global Restaurants tel. (502) 874-6736 fax (502) 874-8818 - 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
ASP MySQL
I'm developing an application and I have to choose a good database server. I'm considering MS SQL Server and MySQL. I haven't heard very much about MySQL, but from I've read on the web I think MySQL is Unix/Linux orientated and works well with PHP. I'm going to use a NT platform, with the IIS as web server, and I wanted to use ASP. Does MySQL fit good with IIS and ASP? Thaks. ___ Consigue tu e-mail gratuito TERRA.ES Haz clic en http://www.terra.es/correo/ - 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
revoke privileges
Ok let me explain my problem: I do: grant SELECT,alter,index,insert,update on SK_10.* to admin-ab-44 identified by ab-44; -- So the use get all right... And : revoke all on SK_10.users_profiles from admin-ab-44; -- So now they have all right except in SK_10.users_profiles ... But the user cant always make a SELECT * from SK_10.users_profiles ; I want admin-ab-44 get access everywhere except to the table SK_10.users_profiles what can i do? --=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-- François Boucher [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: ASP MySQL
YES!!! I use ASP and MySQL... Works Great (Win2K, IIS5.0) John (www.smalltownworld.com) - Original Message - From: L_U_I_Z [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 2:08 PM Subject: ASP MySQL I'm developing an application and I have to choose a good database server. I'm considering MS SQL Server and MySQL. I haven't heard very much about MySQL, but from I've read on the web I think MySQL is Unix/Linux orientated and works well with PHP. I'm going to use a NT platform, with the IIS as web server, and I wanted to use ASP. Does MySQL fit good with IIS and ASP? Thaks. ___ Consigue tu e-mail gratuito TERRA.ES Haz clic en http://www.terra.es/correo/ - 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: ASP MySQL
I usually use MySQL with MyODBC, then it is just like any other database, but faster :) Stefan -Original Message- From: L_U_I_Z [mailto:[EMAIL PROTECTED]] Sent: den 10 september 2001 22:08 To: [EMAIL PROTECTED] Subject: ASP MySQL I'm developing an application and I have to choose a good database server. I'm considering MS SQL Server and MySQL. I haven't heard very much about MySQL, but from I've read on the web I think MySQL is Unix/Linux orientated and works well with PHP. I'm going to use a NT platform, with the IIS as web server, and I wanted to use ASP. Does MySQL fit good with IIS and ASP? Thaks. ___ Consigue tu e-mail gratuito TERRA.ES Haz clic en http://www.terra.es/correo/ - 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: ASP MySQL
I use ASP and mySQL. I love it! Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.net 717.464.2970 -Original Message- From: L_U_I_Z [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 4:08 PM To: [EMAIL PROTECTED] Subject: ASP MySQL I'm developing an application and I have to choose a good database server. I'm considering MS SQL Server and MySQL. I haven't heard very much about MySQL, but from I've read on the web I think MySQL is Unix/Linux orientated and works well with PHP. I'm going to use a NT platform, with the IIS as web server, and I wanted to use ASP. Does MySQL fit good with IIS and ASP? Thaks. ___ Consigue tu e-mail gratuito TERRA.ES Haz clic en http://www.terra.es/correo/ - 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: mysqldump question (very basic)
At 12:11 PM -0700 9/10/01, Gene Gurevich wrote: Hi. I'm trying to run a mysqldump. I enter mysqldump -databases in order to backup all the databases. For some reason all I'm getting back is a help on the mysqldump. What am I doing wrong? If you're really entering the option as -databases, try --databases. Otherwise, check whether your version of MySQL is older than 3.23.12, which is when this option was added. -- Paul DuBois, [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: ASP MySQL
-Original Message- From: L_U_I_Z [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 9:08 PM To: [EMAIL PROTECTED] I'm developing an application and I have to choose a good database server. I guess that's not the only choice... I'm considering MS SQL Server and MySQL. I haven't heard very much about MySQL, but from I've read on the web I think MySQL is Unix/Linux orientated and works well with PHP. True, but MySQL has an exellent ODBC module as well. It's called MyODBC. I'm going to use a NT platform, with the IIS as web server, and I wanted to use ASP. Does MySQL fit good with IIS and ASP? Now, with this env, you want to check out how big your application might become and shed light on aspects like scalability, ease of backup and restore, etc. Especially Microsoft made some very good progress in this area with MS SQL 2000... OTOH, MySQL is very simple to backup / restore. MySQL is also quite scalable when it comes to seperation of readers and writers (replication). Now, back to your question. As far as my experience is concerned, the Microsoft products work very well if left in a Microsoft-Products-Only-Environment. The big problem that remains is that you need to understand how to install the products in order to guarantee long life time. I don't know about performance of IIS/MySQL vs IIS/SQLServer2000, but I guess MS has the top hand here as well. OTOH, if your choice was somewhat free, I'ld rather use Apache/PHP/MySQL combination: 1st: Cheap Solution (OS + Web Server + DB all for free...) 2nd: Proven Record of Quality (PHP is the most widely used language in Server Side Scripting...; Apache has a proven record of being the most used web server...) 3rd: Yahoo uses MySQL for certain (if not all) areas, and they seem quite happy. 4th: (From my own experience) MySQL virtually never crashes... last but not least: Monty and Team, and this list are very actively participating in helping people out with their problems. Just my 0.02$, Guus - 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: print
At 3:18 PM -0400 9/10/01, Jeremy Morano wrote: Hi, very simple question. I would like to save and print the contents of myDESCRIBE table_1; How would I do this? Use the --tee option to mysql to create a tee file that serves as a log of your session, and issue the statement interactively. Then quit mysql and print the file. Or do this: mysql -t -e DESCRIBE table_1 database_name | lpr (assuming you use lpr to print) -- Paul DuBois, [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: Still Searching for Accent solution - MySQL 3.23
Joshua, I'm not really asking for a new feature. I'm just trying to get the accent insensitive search to work. If you look at the 3.23 Change Log http://www.mysql.com/doc/N/e/News-3.23.0.html the ninth bullet says: Changed LIKE character comparison to behave as =; This means that 'e' LIKE ''e' (if the line doesn't display correctly, the latter 'e' means a French 'e' with a dot above) is now true. So, I'm still thinking my configuration is messed up or something. Brian While I am not saying that a search feature should not be made for this, I will say that 'é' and 'e' have different values, and thus wouldn't match... Perhaps you could substitue a regular expression style search w/more intelligence in your code, for each case where you may want to see an accented character? On Monday 10 September 2001 01:00 pm, you wrote: Hello, I'm still having problems with MySQL 3.23 being accent sensitive during searches. However, I'm now tested to ensure I'm getting the correct accented search term to MySQL. Here's my test page, which includes a small database of names with 2 entries per name, one including an accented vowel. http://www.sedl.org/accents.html If you search for Jose (no accent on the e) you get Jose (no accent) If you search for José (with accent on the é) you get José (with accent) At first, I thought it might be a problem with MySQL not recieveing the accented value in the search term correctly, but that still doesn't answer why searching for Jose (no accent) doesn't act like a wildcard to pull up the record with the accented value as well as the unaccented value. Brian -- Brian Litke Web Administrator Southwest Educational Development Laboratory (SEDL) (800 or 512) 476-6861 x-260 http://www.sedl.org/ - 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: 'localhost' problem
I had the same problem with suse 7.2. I see that the path to mysql.sock is /var/lib/mysql/mysql.sock. this location of mysql.sock was a leftover from the mysql that i installed from the distribution. the downloaded version though stores the mysql.sock in /tmp/mysql.sock - i had to tell a few of my programs to look for it there. may you need to add a line in your php program to look for it there good luck harry a. Crazy Linux wrote: yes..the /etc/hosts file reads like the following: 127.0.0.1 localhost.localdomain localhost 138.xx.xx.xx mydomain.edu mymachine thanks --- Lance Rochelle [EMAIL PROTECTED] wrote: is localhost setup correctly in /etc/hosts file? i.e. 127.0.0.1 localhost, if not put that in there and then try again lance - Original Message - From: Crazy Linux [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 2:53 PM Subject: 'localhost' problem hello all, i am running mysql on a red hat linux v7.0 box. when i am trying to connect to the mysql database to read a table that is present in the mysql database i am facing a strange problem. i am able to get into the database(named 'newone') to read the table (named 'namelist') from the command line on the machine that is running mysql in any of the following ways: # mysql -u myname -p mypassword # mysql -u myname -p mypassword -h localhost # mysql -u myname -p mypassword -h mydomain.edu All these 3 commands are successful, without returning an error. So i have created a php file named 'namelist.php' to read this 'namelist' table, which reads like the following: html head titleName List/title /head body ?php mysql_connect ('localhost','myname','mypassword') or die ('bUnable to connect to the database/b'); mysql_select_db ('newone') or die ('bUnable to connect to the database/b'); $result = mysql_query (select * from namelist); printf (First Name: %sbr\n, mysql_result($result, 0, firstname)); printf (Last Name: %sbr\n, mysql_result($result, 0, lastname)); ? /body /html when i run this php script from the browser, it is producing the following error: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/namelist.php on line 7 Unable to connect to the database But if change the 'localhost' to 'mydomain.edu' in line 7 it shows the contents of the table on the browser without any glitch. My question is eventhough if it doesn't complain any thing from the command line when i specify '-h localhost', why it returns the above error when i run the script in a browser? i am able to reach the index.html page from the browser by typing any of the following, on the same machine: 127.0.01 localhost mydomain.edu 138.xx.xx.xx --my ip address Can any one please help me with this. TIA __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.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 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: @HOSTNAME@error
I checked my boot log and found the follwing errors /etc/init.d/rc.d/S61mysql: @HOSTNAME@: command not found /etc/init.d/rc.d/S61mysql: my_print_defaults: command not found I have checked the manual but could not figure out if this is a problem or not mysql seems t run fine for now. What are these commands use for? any insight would greatly be appreciated Harry Amarantidis - 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
fieltypes
hi i'm a newbie with mysql, just knowing well access mysql seems to have a lot more of fieldtypes and i'm wondering, which field type i should chooce in which case ?? is there a list and description with examples? i root the manual and was not very satisfied. thank you for any help mike - 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
Seemingly Strange Variable Behavior
I ran into this and was hoping someone on this list can explain this behavior to me. Lets say I have the table table which has id and name, and five rows of data. I am using the query select table.*,if(@count,@count:=@count+1,@count:=1) as count, from table; What I get is id, name, and five rows of 1's under count. Now If I do set @count=NULL; select table.*,if(@count,@count:=@count+1,@count:=1) as count, from table; the count column has 1,2,3,4,5 When I do select @count immediately upon opening MySQL it returns NULL. So why do I get the expected result when I do set @count=NULL; but an entire column of 1's when I don't... even though @count returns NULL? Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.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
how do I export/import the whole database
HI all. Can I export/import the whole database in MySQL. I have exported the database into a text file. Now when I try mysql 'database' filename; it errors out because column_privs table exists. I thought mysqlimport would help, but judging by what the manual says it only imports the single tables. What I'd like to do is to export the database so that i can import it back if a table is lost or corrupted. Can I do that? = __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.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
Copying data from one table to another.
Hello, I'm a newbie, so pardon my lack of wherewithal with MySQL, and thanks for the help in advance. I have two table and I want to copy info from one table to another. I can pull the correct information out with a select statement that looks something like this Select x1 from tbl1, tbl2 where y1 = y2 (numbers correspond to different tables) This returns a table of the info I want to use. Logically, what I would like to do is: Update tbl1 set x1 = x2 where y1 = y2; But this won't work because x1 and x2 are from different tables, as are y1 and y2. However, I've tried including tbl2 in the update parts, and that doesn't work either. I'm at a loss. Thanks for any help. -eric spletzer - 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: Copying data from one table to another.
I think what you are looking for is the Insert...Select statement http://www.mysql.com/doc/I/N/INSERT_SELECT.html Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Eric Spletzer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 4:38 PM Subject: Copying data from one table to another. Hello, I'm a newbie, so pardon my lack of wherewithal with MySQL, and thanks for the help in advance. I have two table and I want to copy info from one table to another. I can pull the correct information out with a select statement that looks something like this Select x1 from tbl1, tbl2 where y1 = y2 (numbers correspond to different tables) This returns a table of the info I want to use. Logically, what I would like to do is: Update tbl1 set x1 = x2 where y1 = y2; But this won't work because x1 and x2 are from different tables, as are y1 and y2. However, I've tried including tbl2 in the update parts, and that doesn't work either. I'm at a loss. Thanks for any help. -eric spletzer - 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
my.cnf optimization question ..
Basic (maybe?) question on some optimal variables for MySQLd's my.cnf configuration .. Right now, I have three MySQL servers, each with 2 GB ram, dual-CPU P3 1ghz. They average around 500 connections/second at any given time, two have a master/slave setup. MySQL is prettty much the only thing running, nice'd at -20 on a Patched Linux 2.4.9 along w/patched glibc 2.2.4 (LinuxThreads patches). Its run smoothly when I tested it w/~4000 connections and didn't skip a beat. The question basically goes with, I'm expecting to get around 1-2,000 connections/second on average on the systems, using a modified 'my-huge.cnf' from the distribution. No InnoDB, BDB, or overly huge blobs being used. On average each query joins w/about 4 tables on primary/unique indexes where possible. Any changes for this many connections/ram that would be suggested? Thanks, Weslee - 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: Seemingly Strange Variable Behavior
At 4:35 PM -0500 9/10/01, Sheridan Saint-Michel wrote: I ran into this and was hoping someone on this list can explain this behavior to me. Lets say I have the table table which has id and name, and five rows of data. I am using the query select table.*,if(@count,@count:=@count+1,@count:=1) as count, from table; What I get is id, name, and five rows of 1's under count. Now If I do set @count=NULL; select table.*,if(@count,@count:=@count+1,@count:=1) as count, from table; the count column has 1,2,3,4,5 When I do select @count immediately upon opening MySQL it returns NULL. So why do I get the expected result when I do set @count=NULL; but an entire column of 1's when I don't... even though @count returns NULL? This _is_ odd. Dunno. But there's a simpler way to do this: set @count=0; select table.*, @count:=@count+1 AS count from table; Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com -- Paul DuBois, [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: Copying data from one table to another.
Will this actually work? Because I can't select from the table into which I'm inserting. Also I don't want to insert. I want to update a bunch of records that already exist. Here is exactly what I want to do. I have two tables set up that I'm dealing with right now. One is the main information table, and one is a table that I set up from a filemaker export. These are tables with information about a bunch of centers our company has, and the information I'm dealing with will be the sponsors field and the zip code. Basically I want to find a record in the export table, and then take the sponsors info from that row and insert it into the sponsors slot in the other row in the other table that correspond to the same zip code. The code I would use is logically like this. But it seems I can't get the SQL right. I do this, and it tells me it can't find my table. Update tblOrganizations set OrgSponsors = tblCenters.CenterSponsors where OrgZip like tblCenters. CenterZip; Any help would really be great. Thanks. -eric On 9/10/2001 2:51 PM, Sheridan Saint-Michel [EMAIL PROTECTED] wrote: I think what you are looking for is the Insert...Select statement http://www.mysql.com/doc/I/N/INSERT_SELECT.html Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Eric Spletzer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 4:38 PM Subject: Copying data from one table to another. Hello, I'm a newbie, so pardon my lack of wherewithal with MySQL, and thanks for the help in advance. I have two table and I want to copy info from one table to another. I can pull the correct information out with a select statement that looks something like this Select x1 from tbl1, tbl2 where y1 = y2 (numbers correspond to different tables) This returns a table of the info I want to use. Logically, what I would like to do is: Update tbl1 set x1 = x2 where y1 = y2; But this won't work because x1 and x2 are from different tables, as are y1 and y2. However, I've tried including tbl2 in the update parts, and that doesn't work either. I'm at a loss. Thanks for any help. -eric spletzer - 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
load level on linux mysql server out of control
I'm running mysql 3.23.41 on a PIII 800 Mhz machine with 512MB RAM, linux kernel 2.4.7, dedicated machine (ie, not running anything other than MySQL). I've been running mysql in a production environment for nearly 2 years, moderately hit (500,000 - 800,000 database connects per day) with no problems until very recently, and I'm trying to figure out what's going on. I just installed the 3.23.41 from source about 2 weeks ago, and fairly shortly thereafter I started seeing my load levels increase dramatically. This was on a faster machine with 1GB RAM...last week the hard drive developed bad sectors on a part of the disk where one of my larger and more frequently written tables lived, and that machine died a horrible death. So I chalked the load level increase up to bad hard drive, put the above-described machine in its place, and the load levels went thru the roof again. Ran isamchk and myisamchk -r on all problem tables. Verified the disk integrity...but yesterday the *new* disk failed at a block containing another big and heavily hit table started with the bad blocks...caught this one in time and moved the table someplace else. Two disks in one week makes me think of power fluctuations, and I'm wondering if this could be causing me to think the problem is MySQL and really it's a power spike during a table write?? And I wouldn't be seeing the same thing on the web server because it's not written to very often, unlike the mysql server... I'm having a lot of trouble tracing the origin of the problem -- sometimes it seems that accessing a particular large table is causing it, sometimes it seems that a combination of factors is causing it. Regardless, what I observe is that within 1 minute my load level climbs from between 2 and 4 to over 100, which I have never seen on any *nix system before. The RAM utilization is high, but not over 85%, and the CPU utilization fluctuates of course but stays below 40% user until whatever is causing my problems happens, and then it jumps to 100% and doesn't come down until I kill mysqld and let everything close. The database is being accessed almost entirely by PHP calls from php4.0.6 running with apache 1.3.20, using PHP's built in mysql functions. The web server lives on a different machine.Does anyone know of any problems with PHP and the newer versions of MySQL? What about large table handling on linux? I realise that if the tables aren't constructed properly they could cause problems, but these tables aren't *that* big...the data files are no more than 200Mb. And they seem to be using indexes correctly, and they've been running fine for nearly 2 years. These are mostly ISAM tables, if that makes a difference. This has been going on for the better part of a week now and I'm about out of guesses. We have combed our code for places where database connections aren't closed properly, we've split large tables off and checked indexing, we've even moved a high-volume read-only database onto the webserver itself to help lessen the load, and I don't know what else to do. If anyone can help, it will be greatly appreciated. TIA jenn - 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
help with mysql.sock error
I am having trouble with mysql... i keep getting ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I uninstalled and reinstalled MySQL rpm (RH 7.1). I originally I was able to connect to MySQL server via command line client, but could not connect via web page with the error mysql.sock (111). - 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: URGENTE - Replication...... - mySql
On Monday 10 September 2001 09:43, Rodrigo Zerlotti wrote: here it is... - Regards, Rodgrigo: Thanks for a bug report. We will try to get this fixed in 3.23.43. Next time, please write to [EMAIL PROTECTED] when you find a bug and have a test case for it. This address ([EMAIL PROTECTED]) is reserved for paying customers. Joshua and other users: Please do not advise others to use [EMAIL PROTECTED] to users without a support contract as a way to get personal help from MySQL AB when other methods do not work. We usually reply to such messages with a template, and in some near future will have a filter that will check for valid support contract info and reply with a template if it is not present. We have also had a problem with users asking a support question on [EMAIL PROTECTED] after they got no answer on [EMAIL PROTECTED] This is also against the rules. [EMAIL PROTECTED] is reserved for discussion of internal ( not client application) MySQL development, and should not be used as a way to get free support from developers from MySQL AB and experienced users that subscribe to the list. If you have sent a question to the general list ( [EMAIL PROTECTED]) and nobody answers it, you should do one or more of the following: * consider purchasing a support contract at https://order.mysql.com/ * re-state the question providing more relevant information, or in other words, make it easier to answer it * spend some time studying the manual, the source code, and doing some troubleshooting to try to understand how things work * if you think you have found a bug, follow instructions at http://www.mysql.com/doc/B/u/Bug_reports.html to create a repeatable bug report. Once you have a test case, you can write it to [EMAIL PROTECTED] - if you have a test case, we will work with you on the bug until it is fixed regardless of whether you have a support contract or not. The only difference is that without a support contract, we ask you to do the homework and give us a full test case. In short, we provide free code, but we cannot afford to give free support to go along. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / 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: @HOSTNAME@error
Those are the startup scripts to startup MySQL when the server is rebooted. view the file /etc/init.d/rc.d/S61mysql and search for @HOSTNAME@ and my_print_defaults and see how these commands are invoked and if they exists on your system. Hope this helps, -Teresa -Original Message- From: harry amarantidis [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 5:02 PM Cc: [EMAIL PROTECTED] Subject: Re: @HOSTNAME@error I checked my boot log and found the follwing errors /etc/init.d/rc.d/S61mysql: @HOSTNAME@: command not found /etc/init.d/rc.d/S61mysql: my_print_defaults: command not found I have checked the manual but could not figure out if this is a problem or not mysql seems t run fine for now. What are these commands use for? any insight would greatly be appreciated Harry Amarantidis - 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 Digest 10 Sep 2001 21:47:08 -0000 Issue 1490
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 6:47 PM Subject: mysql Digest 10 Sep 2001 21:47:08 - Issue 1490 - Before posting, please check: 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: my.cnf optimization question ..
On Mon, Sep 10, 2001 at 04:54:57PM -0500, Weslee Bilodeau wrote: Basic (maybe?) question on some optimal variables for MySQLd's my.cnf configuration .. Right now, I have three MySQL servers, each with 2 GB ram, dual-CPU P3 1ghz. Nice. :-) They average around 500 connections/second at any given time, two have a master/slave setup. Connections/sec or Queries/sec? That's a lot of connections per second? Can you use persistent connections? It would save a lot of overhead. MySQL is prettty much the only thing running, nice'd at -20 on a Patched Linux 2.4.9 along w/patched glibc 2.2.4 (LinuxThreads patches). Its run smoothly when I tested it w/~4000 connections and didn't skip a beat. The question basically goes with, I'm expecting to get around 1-2,000 connections/second on average on the systems, using a modified 'my-huge.cnf' from the distribution. Care to share the config file? With that much RAM, there are probably some things you can tweak to make optimal use of the 2GB RAM. But if you've done a lot of that, I won't bother pointing them out (obviously). On average each query joins w/about 4 tables on primary/unique indexes where possible. Any changes for this many connections/ram that would be suggested? How are things looking in SHOW STATUS? Any red flags that you've noticed? Any slow queries? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 4 days, processed 103,895,494 queries (249/sec. avg) - 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
when i try connect since a client windows9x to mysql ...
hi all this is my first question: when i try connect since a client windows9x to mysql (in a server linux rh 7.0), say me the next error: General Sql Error: [TCX][MyODBC]Access deneied for user [EMAIL PROTECTED] (using password YES) alias Test i make the user and system dsn, anyone have a good idea of fix my problem? thanks - otro correo: [EMAIL PROTECTED] --- Runbox Mail Manager - www.runbox.com Free online email application - 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: load level on linux mysql server out of control
At 01:46 11.09.01, you wrote: I'm having a lot of trouble tracing the origin of the problem -- sometimes it seems that accessing a particular large table is causing it, sometimes it seems that a combination of factors is causing it. Regardless, what I observe is that within 1 minute my load level climbs from between 2 and 4 to over 100, which I have never seen on any *nix system before. The RAM utilization is high, but not over 85%, and the CPU utilization fluctuates of course but stays below 40% user until whatever is causing my problems happens, and then it jumps to 100% and doesn't come down until I kill mysqld and let everything close. hi, same problem here. mysql 3.23.41, apache 1.3.20, php 4.0.6, kernel 2.2.19, debian system. 1GHz PIII 512MB. load 200. my fix for now till i have a better idea is to restrict the number of apache children to 60 which keeps the load 20. which is horrible nevertheless. and extremely slow for the users at times. the load normalizes (to something 4-ish, which is still pretty high for ~50q/s) again after ~15min. if you find out anything about that problem, PLEASE tell me. i´m searching for ~3 weeks and i´m not smarter in the least. and it sucks :-( at least i didn´t have that harddisk failures. yet. but then, it´s a colo machine so power should be fine. yes, dear mailing list, i know you told me my queries are, well, suboptimal. but i´m not quite sure about that. more tomorrow:-) greetings henning - 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
Strange insert behavior with larger tables
This weekend I wanted to better characterize how different key configurations affect the way rows are inserted. I ran into some behavior I can't understand: I created a prototype table to allow me to track the number of events that occur on a particular day. Events are described with three integer fields and a type field which can be 0-3. The table then is: date date not null, type tinyint not null, val1 int not null, val2 int not null, val3 int not null, occurrences int not null. I then added a primary key (date, type, val1, val2, val3) because I want to ensure that I have only one row for each combination of these items. I ran these benchmarks on my Win2K box (real environment Linux, just testing here). I wrote a program which inserts a number of rows for each day (with unique type, val1, val2, val3 values). type can have the values 0-3, and val1-3 can be between 0 and 24,000. I found that I could insert about 10,000 rows in about 4-5 seconds (512 M RAM, IDE drives UDMA). It consistently took between 4-7 seconds to insert 10,000 rows until I got up to about 2 million rows. Around that time it started to slow down significantly taking about 10 seconds to insert 10,000 rows. By the time I got up to about 15 million rows, it was taking over 30-40 seconds to insert 10,000 rows. The strange thing, however is that as soon as I changed to a new day (the first element in my primary key) rows began inserting very quickly again. I was right back where I started-getting 10,000 rows in only 4-5 seconds. I guessed that the key was the limiting factor here somehow, so I tried my test again, but first dropped the primary key. Without the key I no longer have a guarantee of uniqueness, but I'm able to insert 10,000 rows every 3-4 seconds consistently well over 5 million for a single day. Therefore, it appears to be the key which is so dramatically slowing inserts as I get more rows. Curious, I ran perfmon on my machine and repeated the experiment. I observed the following: - Time to insert quadruples (from 4-5 sec/10,000 rows to 20-25 sec/10,000 rows) - Processor usage drops 2/3s (100% usage to 37% usage) - Amount written to disk/sec drop 4 fold (~400 bytes/sec to ~200 bytes/sec) - Number of writes/sec almost double (232 to 385) - Avg. amount of data with each write drops 4 fold (19000 bytes to 5000 bytes) - Avg. time to do each write stays constant (.004 sec) - The machine is NOT swapping page files on and off the disk. To summarize, at first when doing these inserts the machine is CPU bound. It is using 100% of CPU resources. However, as the number of rows for the day we are inserting increases, the machine becomes severely IO bound. This seems to be due to the fact that although the number of writes to the disk almost double, the average amount of data drops 4 fold as does the amount of data being written with each byte. Basically we switch from doing fewer larger writes and being CPU bound, to doing many many more tiny writes that the disk can't keep up with. At first (before seeing the perfmon data) I though this might have something to do with the key being held in a buffer until it grew too large. Then is when we'd start to see the performance slow down. However, I have not been able to find a value of the key buffer which really changes performance. I've tried values between 3M and 70M, with very similar results. I do get slightly poorer performance with the 3M than 70M (starts slowing down around 1.3 million instead of 2 million) but nothing that I think accounts for this problem. Why do inserts slow down once I get around two million, and I don't seem to be able to affect this by tweaking buffer sizes? Why do inserts then speed up again when switching to a new value for date, but slow down again once I get close to 2 million for the new value? I've included below a dump of variables. Thanks in advance for your insight, Brett Error back_log: 50 basedir: C:\mysql\ binlog_cache_size: 32768 character_set: latin1 character_sets: latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 concurrent_insert: ON connect_timeout: 5 datadir: g:\mysql data\ delay_key_write: ON delayed_insert_limit: 100 delayed_insert_timeout: 300 delayed_queue_size: 1000 flush: OFF flush_time: 1800 have_bdb: NO have_gemini: NO have_innodb: NO have_isam: YES have_raid: NO have_ssl: NO init_file: interactive_timeout: 28800 join_buffer_size: 131072 key_buffer_size: 52424704 language: C:\mysql\share\english\ large_files_support: ON log: OFF log_update: OFF log_bin: OFF log_slave_updates: OFF log_long_queries: OFF long_query_time: 10 low_priority_updates: OFF lower_case_table_names: 1 max_allowed_packet: 1048576 max_binlog_cache_size: 4294967295 max_binlog_size: 1073741824 max_connections: 100 max_connect_errors: 10 max_delayed_threads: 20
Looking for a Data entry program for mysql...
Hi all, I am looking for a freeware-shareware pgm for data entry, on win32 for a mysql database on Linux(not that it matters I guess), that would allow me to feed data with drop down or list box field. Any suggestions??? Thanks in advance... ### # Francois Meehan, vive l'Open source et Linux # # committed to open source and 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help with mysql.sock error
su nobody ls -l /var/lib/mysql/mysql.sock Whatever user is trying to get it [such as nobody for a web server usually or the user]- make sure the user can access the file. Make sure you don't have maybe /var/lib/mysql to be 750 or something like that. Permissions is a big one. -- Mike - Original Message - From: adam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 8:39 PM Subject: help with mysql.sock error I am having trouble with mysql... i keep getting ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I uninstalled and reinstalled MySQL rpm (RH 7.1). I originally I was able to connect to MySQL server via command line client, but could not connect via web page with the error mysql.sock (111). - 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