Re: ARGH - Mysql won't stop eating RAM and finally it SEGV's
Richard Clarke [EMAIL PROTECTED] wrote: It is the proper binary from mysql.com. mysql-standard-4.1.3-beta-pc-linux-i686.tar.gz I have also filed a bug report for this problem. #4673 There is some extra information in the bug report describing what my application does. Okay, thank you. We'll take care. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Splitting data across tables
Andrew Hill [EMAIL PROTECTED] wrote: Perhaps it would be better to insert the timestamp, rather than letting MySQL set it. Sure. This gives consistency in your situation. Or, is there perhaps a way to let MySQL select which table to perform the insert into, based on the time? No. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: after upgrade unicode characters changed to question marks
Stefan Klopp [EMAIL PROTECTED] wrote: We recently upgraded our mysql server from 3.23 to 4.0.18 and have found that all of our Unicode characters are now being displayed as question marks (?). Anyway this only happens when viewing over the web as when we view via the shell mysql we can see the characters fine. Not a MySQL issue: both versions 3 4 don't manage unicode characters. Only 4.1 does. MySQL 3 4 just store the binary data. Try to debug your web software and first recompile it with .so.12 client libraries (the ones that comes with MySQL 4.0). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Tuning MySQL for Large Database
Michael Sleman [EMAIL PROTECTED] wrote: key_buffer = 384M Try to enlarge this up to, say, 1G and check it out how that helps. sort_buffer_size = 2M You may want to enlarge this as well. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Update on installing mysql on linux
Levi Campbell [EMAIL PROTECTED] wrote: Okay, I got the RPM package installed but when I use rpm -I = mysql-server-4.0.20-0.i386.rpm, I am told that I need several files, = most of which I can't find in the Debian package library. I need the = following files: /usr/bin/perl, sh-utils and sh, where can I get these? Install it like this: rpm --install -v -h --nodeps MySQL-server-4.0.20-0.i386.rpm ... and other rpms Debian RPM database may be missing some dependencies but the chances are that MySQL will work installed without dependency check. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cygwin Mysql No Response
| 0 | | Handler_read_first | 1 | | Handler_read_key | 0 | | Handler_read_next| 0 | | Handler_read_prev| 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_next| 9 | | Handler_update | 0 | | Handler_write| 0 | | Key_blocks_used | 0 | | Key_read_requests| 0 | | Key_reads| 0 | | Key_write_requests | 0 | | Key_writes | 0 | | Max_used_connections | 0 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 0 | | Open_files | 0 | | Open_streams | 0 | | Opened_tables| 6 | | Questions| 4 | | Select_full_join | 0 | | Select_full_range_join | 0 | | Select_range | 0 | | Select_range_check | 0 | | Select_scan | 0 | | Slave_running| OFF | | Slave_open_temp_tables | 0 | | Slow_launch_threads | 0 | | Slow_queries | 0 | | Sort_merge_passes| 0 | | Sort_range | 0 | | Sort_rows| 0 | | Sort_scan| 0 | | Table_locks_immediate| 5 | | Table_locks_waited | 0 | | Threads_cached | 0 | | Threads_created | 3 | | Threads_connected| 1 | | Threads_running | 1 | | Uptime | 1912 | +--+---+ 112 rows in set (0.01 sec) [-- text/plain, encoding 7bit, charset: US-ASCII, 21 lines, name: mysql_my_ini.txt --] #This File was made using the WinMySQLAdmin 1.4 Tool #7/21/2004 4:09:20 PM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/mysql #bind-address=192.168.1.222 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-nt.exe user= password= [-- text/plain, encoding 7bit, charset: us-ascii, 4 lines --] -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump question
Jim McAtee [EMAIL PROTECTED] wrote: Can I easily restore individual databases and/or individual tables from a backup made with mysqldump? Yes if you will individually dump the tables. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Multiple inserts in one statement
Scott Haneda [EMAIL PROTECTED] wrote: I was just reading a forum post on mysql, someone said it was possible in mysql 4 to insert data into more than one table at once. Is this possible, if so, where in the docs can I see a example of this? Not possible. What is possible is inserting several rows at once. See http://dev.mysql.com/doc/mysql/en/INSERT.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: extracting substring from text blob during query
Redmond Militante [EMAIL PROTECTED] wrote: i have a large text blog that i want to extract strings out of.=20 the large text blob See http://dev.mysql.com/doc/mysql/en/String_functions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld being killed by VM
Michael Gale [EMAIL PROTECTED] wrote: Please install MySQL official binary downloaded from http://www.mysql.com/ and check if the problem is gone. It very much looks like some build issues. Also please check that MySQL has enough memory to run - i.e. the key_buffer variable is reasonably high and also check other software on the server. I have a mysql server that VM is killing about once every two weeks. Now my sar utility shows that the memory on the box continues to grow at a small rate from start to stop. But I am not sure how accurate that is. Now I am running slackware 9.1 with kernel 2.4.23 with mysql 3.23 build 50 with InnoDB support. I checked the my.cnf file and found the following: The box is a dual xeon 2.4Ghz with 2GB of RAM __alloc_pages: 0-order allocation failed (gfp=0x1d2/0) VM: killing process mysqld-max Where do I start to find out if the problem is with mysql ? or our application ? It appears that the mysqld-max process will try and use all the memory in the box and so the kernel will kill the process. Also if I used mysqld_safe would it restart after this ? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump issue
Ginger Cheng [EMAIL PROTECTED] wrote: If a table has a column defined as 'float not null' and the corresponding txt file used to load it have sth like 'nan' for the column, although giving warnings, the record will be loaded and the column looks like 'nan' by using mysqlimport. But if you do mysqldump, it puts a 'null' in the column for the insert statement, which fails the later mysql mysqldump (cuz the table definition does not allow it). Can you prepare a testcase for that? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problems transferring database
james patrick [EMAIL PROTECTED] wrote: I previously had a server runnning RH 7.3, cPanel 9.41 and MySQL 4.0.20. I'm moving to a different server running Fedora 1, DirectAdmin and MySQL 4.0.17. I have a large database (200mb) and I'm trying to move it over. 200mb is not a large database. 200gb may be considered as such. :) I made a dump using mysqldump -u USER -pPASSWORD DATABASE filename.sql, transferred it between servers via SCP, and tried importing it using mysql -u USER -pPASSWORD DATABASE filename.sql. Make a dump like that: mysqldump -u user -ppassword --opt -Q database filename.sql -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: About backup/restore solution
Matsunobu, Yoshinori [EMAIL PROTECTED] wrote: I'd like to ask about backup/restore(roll forward recovery) solutions using mysqldump and binary logs. ^[$B!^[(JVersion : 4.0.20 ^[$B!^[(JUsing 1 database.(ex. sample1db) ^[$B!^[(JAll tables are InnoDB. I'm considering the following solution. - backup: mysqldump --flush-logs --single-transaction sampledb1 dump1.dmp (ex. binary logs are generated hostname.001(binary log before mysqldump) hostname.002(binary log after mysqldump) ) roll forward: mysqlbinlog hostname.002 dump1.dmp mysql sampledb1 dump1.dmp - Use --master-data option of mysqldump. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ARGH - Mysql won't stop eating RAM and finally it SEGV's
Richard Clarke [EMAIL PROTECTED] wrote: I have switched to the mysql standard binary and it helped in no way at all. If anything it made the situation worse. It seems that mysql grows even worse than before. Mysql uses an extra 1MB roughly every 5-10 seconds. mysql standard binary - is it a binary version downloaded from http://www.mysql.com/ or the one that comes in gentoo (gentoo ports?) ? Richard -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication Overhead and Benchmarks
Nathan [EMAIL PROTECTED] wrote: Does anyone know of any written stats on how much overhead for CPU/ Disk IO replication has for a single master and a single slave? I am looking for any detailed stats on the proformance issues associated with replication. In a very rough oversimplification, the replication itself is just: On master: write SQL statements into log. On slave: retrieve SQL statements from the log on master. As you may guess this overhead is so small so it probably even can't be measured. But understand that slave will run all the data-modifying SQL statements that are found in log on master. Hope that's a answer to your question. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: cannot install mysql on linux using RPM's
Levi Campbell [EMAIL PROTECTED] wrote: Hi, I'm trying to install MySQL on Debian Linux on an old computer whe = had lying around. (Pentium 2 or three) and I'm trying to install the RPM = files so I can install the software. my problem is with the Perl debian = packages, I can't get them configured, can anyone help? So you can't install MySQL packages or perl packages? If the problem is in MySQL RPMs, use mysql binary distribution downloaded from http://www.mysql.com/ The one in .tar.gz, not in RPM. If you are trying to install Perl DBI modules from RPM and you cannot, download them and install manually from http://dbi.perl.org/ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fw: Confirm 2 question in replication.
MaFai [EMAIL PROTECTED] wrote: I'd like to confirm 2 queries on the replication as follows: 1. Could we not using root on mysql for setting up the replication? ( I think no) No. 2. Could the password for replication be changed? ( I think Yes) mysqladmin -uusername -ppassword password newpassword This could be done remotely of course. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: data design question
Justin French [EMAIL PROTECTED] wrote: Should I worry at 40,000? 100,000? Or will the indexing of the siteID keep everything extensible? Indexing is designed to keep SELECT speed small with no matter how much data it is. You should ensure that the siteID index is properly used (use EXPLAIN SELECT). Say, if half of the records belongs to a particular siteID - the index won't help, the full table scan will be done to find out the needed article. You may consider creating a complex index as well - say, (siteID, articleID). Then to fetch the list of all articles of a site the (siteID) index will be used, and to fetch particular article the compound index will be used. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Erro:Got error 28 from table handler!
[EMAIL PROTECTED] wrote: qual o significado da seguinte menssagem de erro do MySQL: Got error 28 from table handler? [EMAIL PROTECTED] egor]$ perror 28 Error code 28: No space left on device -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimize problem on BIG table
Aman Raheja [EMAIL PROTECTED] wrote: $ perror 28 Error code 28: No space left on device I agree that there is not much disk space. THE ISSUE: I want to reclaim the disk space that should be freed because of the millions of records I deleted. I need disk space to reclaim disk space? Atleast that's what it seems to be. When you delete records from MyISAM data file you only delete records. You don't physically empty the disk space they use. The OPTIMIZE TABLE operation works by making a temporary table. Of course it can be as big as the original table is (including index). So you can't OPTIMIZE TABLE if you don't have spare about 78+16G. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how the redhat 9.0 adds the mysql user:
j.rabbit [EMAIL PROTECTED] wrote: This is how the redhat 9.0 mysql.spec file adds the mysql user: ' useradd -M -o -r -d /var/lib/mysql -s /bin/bash -c MySQL Server -u = 27 mysql ' Anybody know why the shell is '/bin/bash' instead of '/sbin/nologin' = like other daemon users? Is this simply an oversite? I can't speak about Red Hat 9, but for MySQL itself there is no need to have a valid shell for the 'mysql' user. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: query locking up the system
Aman Raheja [EMAIL PROTECTED] wrote: Has anyone experienced this kind of load. The hardware is not an issue - it is a dual processor, 1GB RAM etc. Suggections? Tell us your MySQL server version, OS version, describe the structure of the table and if possible show EXPLAIN SELECT on the statements provided. Then we could help. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: RAM-usage and hardware upgrade 10gb RAM
Jan Kirchhoff [EMAIL PROTECTED] wrote: Money is not really an issue but of course we don't want to waste it for scsi-hardware if we can reach almost the same speed with hardware sata-raids. 'Almost' is a key word. Some SCSI disk are working at 15k RPM, which will give you a HUGE MySQL performance growth compared to 10k disks. AFAIR, there are no 15k RPM SATA disks yet. Money is not really an issue but of course we don't want to waste it for We'd like to stay with x86 because all our hardware is intel/amd and all our servers are running debian-linux. Can we expect better performance or problems using kernel 2.6.x? You can expect better performance on kernel 2.6.x of course, especially on multiple requests. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ARGH - Mysql won't stop eating RAM and finally it SEGV's
Richard Clarke [EMAIL PROTECTED] wrote: I think that is possibly related to some known glibc/gcc issues. Please download official MySQL binaries from http://www.mysql.com/ install them and try the same on it. Should work smoothly. Mysql won't stop eating RAM!! :( Machine is a quad xeon 2.4 with 4 gigs of RAM. Linux db2 2.6.7-rc3 #1 SMP Thu Jun 17 12:51:21 UTC 2004 i686 Intel(R) Xeon(TM) CPU 2.40GHz GenuineIntel GNU/Linux Mysql is 4.1.3-beta Compile options are, ./configure --enable-thread-safe-client --enable-assembler --with-unix-socket-path=/tmp/mysql-4.1.3.sock --prefix=/usr/local/mysql-4.1.3 --without-extra-tools --without-docs --without-bench --with-innodb --without-berkley-db My startup variables are not especially high for a 4 gig box (see end of e-mail). I have 3 UDF functions which I wrote to do some simple things; extracting domain portion of a web url, and access to some libgeoip routines. I have run these 3 functions through benchmark(100,function()) to see if rate of RAM consumption increases, but I don't really see any change or at least if I do i think it's probably the placebo effect. I really can't think where to look to figure this problem out. I would like mysql to run with 3.5/4 gigs of RAM and stay that way. Not start off there and end up leaving the system with 1meg of RAM. I also add the problem that within about 72 hours of the server being started it dies with signal 11. 040720 6:04:15 Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL ROWS
[EMAIL PROTECTED] wrote: I have 7000 rows in mysql table, it crashes often, is number of rows reason, or can their be any other reason, I want to increase number of rows and prevent further crashes how do I do the same, Inform ,please Please tell your MySQL version, your OS version, describe the hardware and describe the table. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ARGH - Mysql won't stop eating RAM and finally it SEGV's
Richard Clarke [EMAIL PROTECTED] wrote: But my UDF's are very important for the process of my statistics. I need 3 functions webdomain(val) = convert http://www.google.com/blah into google.com geoip_lookup(123.123.123.123.) = country code geoip_lookup_isp(123.123.123.123) = isp I will try the mysql binaries and disable statistical operations depending on the above functions temporarily. Check on official binaries. If everything is ok on them - then you will need either to prepare a correct build farm with gcc 2.95 and patched glibc 2.2.5 (or hire someone to do it for you - us, for example) or buy primary, enhanced or premium support from MySQL AB and ask them for a custom build. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (Using password: YES)
Laurent [EMAIL PROTECTED] wrote: User mysqladmin has not the rights to access mysql? How can that be? Have you created the mysqladmin user? By default there is no such user and it's not supposed to be there. There is no special meaning for it - mysqladmin usually logs in as root user. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL blocking ACPI suspend
Loic Minier [EMAIL PROTECTED] wrote: Did other MySQL users experience this? Yep. I could not find MySQL's bugtracker, should it be reported there as well? You can post the report at http://bugs.mysql.com/ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: iterative load data crashes. - table limit??
Michaell Taylor [EMAIL PROTECTED] wrote: Lost connection to MySQL server during query details: myssql 4.0.20 linux: fedora core 2 file system : ext3 There should be a clue of what's happening with MySQL at the end of .err file in the datadir. Take a look into it. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: stress test
Brad Waddell [EMAIL PROTECTED] wrote: does anyone have a stress test for mysql? i want to give my box a workout before deploying on the web. Maybe a PHP page which runs forever, creating, finding and deleting thousands of records? Maybe I can run it in several browsers at the same time? thanks! First, try mysql test suite which is available in sources in tests/ directory. Second, super-smack tool http://jeremy.zawodny.com/mysql/super-smack/ is a stress-testing software. Third, see crash-me http://dev.mysql.com/tech-resources/crash-me.php -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Get Updated Rows
Daniel Cummings [EMAIL PROTECTED] wrote: Is there a way of getting the number of updated rows without using the API calls? No. But if you connect to MySQL from your software then you are already using the API. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Consistency among multiple connections
Sergio Ilarri [EMAIL PROTECTED] wrote: P.S. I also get sometimes an error: General error, message from server: Can't lock file (errno: 116). ...which is: [EMAIL PROTECTED] egor]$ perror 116 Error code 116: Stale NFS file handle See the end of .err files in datadir of your servers, there might be a clue what's happening with MySQL on networking filesystems if you happen to run over it. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: #sql-... files
Sergei Skarupo [EMAIL PROTECTED] wrote: I see some files in the data dir with names like #sql-85d_4.MYI. Some of = these are pretty old. Are these the temp tables that didn't get deleted = properly? Is it OK to shut down the server and delete them? The answer is yes to both questions. :) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: slow response time
Jeremy Zawodny [EMAIL PROTECTED] wrote: So I haven't really done much to optimize things, as this seems like a fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux Threads). Reliability and performance is not what you should expect to find in FreeBSD 4.x. MySQL doesn't perform well on it because of threads problems in OS itself. We're happily running MySQL on FreeBSD 4.x w/LinuxThreads at Yahoo. So I'm not sure how you back that claim. http://jeremy.zawodny.com/blog/archives/000203.html and so on. :-) Assuming one follows the *bold* UPDATE link at the top, I still don't see it... What about SMP machines? In general the experience may vary but I have been unable to manage it to work fine. :( Like, updating the key_buffer variable on the fly to enlarge it causes the computer to hang at a certain point. I had LOTS of os-dependent things like that. But to be honest this was FreeBSD 5 the most recent. I hope, KSE is our solution in a near future. Jeremy -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin shutdown command hangs
[EMAIL PROTECTED] wrote: We have installed a mysql database on our our server. The data and log files are stored on an external SCSI disk array which is connected to our server using FC cable connected to SCSI port. The mysql process is running on the local machine but the data and logs are stored on the disk array. =20 When there is an accidental communication breakdown between disk array and server on which mysql process is running (e.g, pulling out FC cable), this is being detected by our scripts and then we are trying to shutdown the mysql process by using mysqladmin shutdown option. However this command hangs and does not complete. =20 What is the kind of the communication breakdown: a temporary one or the array goes offline forever? In the later case MySQL will hang until disk is available to flush data. You can killall -9 mysqld then but it's brute force. In the first case there is no need to restart MySQL (and theoreticly it should flush and shutdown with no problems). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: slow response time
Jeremy Zawodny [EMAIL PROTECTED] wrote: So I haven't really done much to optimize things, as this seems like a fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux Threads). Reliability and performance is not what you should expect to find in FreeBSD 4.x. MySQL doesn't perform well on it because of threads problems in OS itself. We're happily running MySQL on FreeBSD 4.x w/LinuxThreads at Yahoo. So I'm not sure how you back that claim. http://jeremy.zawodny.com/blog/archives/000203.html and so on. :-) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: slow response time
Charles Sprickman [EMAIL PROTECTED] wrote: The hardware is a dual Athlon MP-1600 smp box with 1GB of RAM. BTW, user-level threads don't scale on more than one CPU. I.e. different threads cannot run on different CPUs on FreeBSD 4. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: sock file
michael johnson [EMAIL PROTECTED] wrote: When trying to start mysql on a lx50 I get the following message: Error 2002 Cannot connect to local MySQL server through socket /var/lib/mysql/mysql.sock (111). What can I do to resolve this problem pls? Start MySQL or change the correct path to socket file. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql 4.0.20, InnoDB my.cnf problems
C.F. Scheidecker Antunes [EMAIL PROTECTED] wrote: Can anyone point me out what is going on wrong in this scenario? The .err file in the datadir can give you a clue. Take a look at the end of it. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Increasing number of sockets
Robert Canary [EMAIL PROTECTED] wrote: I am getting an error on my radius server asking me to increase the number of sockets on mysql. Probably you mean connections. Enlarge the value of max_connections variable. You can write it in the /etc/my.cnf in [mysqld] section: [mysqld] max_connections=300 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: authentication error
Chip Bell [EMAIL PROTECTED] wrote: The email users authenticate against a MySQL table... Then it's not about MySQL, it's about the imap/pop3 server. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: select query that uses a temporary table
Lorderon [EMAIL PROTECTED] wrote: Mabye, is there a way to tell MySQL to limit the temporary table up to 500 rows? so, when a row is matching into the top 500 rows, the last row will be dropped out (in case the table is on limit), and the new matched row will be inserted into the right place in the temporary table... To find out top 500 of 10,000 rows ordered by some criteria you anyway need to sort these 10,000 rows. :) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: bugzilla not working now after MySQL re-installed
Nguyen, Long P (Mission Systems) [EMAIL PROTECTED] wrote: Your thoughts on this would be appreciated. MySQL was re-installed and now Bugzilla is not working now I am getting this error when I bring up - http://localhost/bugzilla/ http://localhost/bugzilla/ The scripts were looking for MySQL socket located in /tmp. Now as you installed the RPM version, the socket is no longer available there. You can tweak my.cnf to tell client libraries where to find the socket. Add socket = /var/lib/mysql/mysql.sock to /etc/my.cnf to [client] section. For more info, see http://dev.mysql.com/doc/mysql/en/Option_files.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB table data
Sagara Wijetunga [EMAIL PROTECTED] wrote: I can see his MyISAM *.frm, *.MYD and *.MYI are kept under his database directory. But I can see only table.frm are in his database directory for InnoDB tables. It looks like InnoDB table data belongs to his database are not kept under his database directory. Am I right? Right. InnoDB uses big single (or multiple) tablespace for all data. But you can also use different tablespaces for different tables. See http://dev.mysql.com/doc/mysql/en/Multiple_tablespaces.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: slow response time
Charles Sprickman [EMAIL PROTECTED] wrote: So I haven't really done much to optimize things, as this seems like a fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux Threads). Reliability and performance is not what you should expect to find in FreeBSD 4.x. MySQL doesn't perform well on it because of threads problems in OS itself. Either upgrade to FreeBSD 5 or switch to Linux or Solaris. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 64 Bit Support
David Griffiths [EMAIL PROTECTED] wrote: Sorry - didn't read your email closely enough. The Windows version is not native - runs under Cygwin. Is there a version of Cygwin for the Itanium 2? Wrong. It is a native application. :) No, there are no Itanium binaries for Windows. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Concurrency Question
Javier Diaz [EMAIL PROTECTED] wrote: 3- Replication of these tables to another server ?? This is classical solution to the problem and probably the easiest to provide. Just do SELECTs on the slave server. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Strange server crashes with large table and myisamchk
Hanno Fietz [EMAIL PROTECTED] wrote: Jul 2 03:10:28 t56 kernel: hda: dma_intr: status=0x51 { DriveReadySeekComplete Error } Jul 2 03:10:28 t56 kernel: hda: dma_intr: error=0x40 { UncorrectableError }, LBAsect=429367, sector=316864 Jul 2 03:10:28 t56 kernel: end_request: I/O error, dev 03:02 (hda), sector 316864 Definitely, a hardware problem. Either your harddrive is dead (dying) or the DMA. The first is more likely. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INTEL vs. SPARC
mac [EMAIL PROTECTED] wrote: does the speed of mysql depends more on things like the processor than other resources? Disk speed memory size are much more important then the CPU. Processor is used to calculate while MySQL is a database. And databases move data back and forth. if so: what kind of general suggestions can be made about using select-statements on huge tables to be fast over different platforms? Allocate as much memory as you can for key_buffer. Generally, 70% of RAM is a good starting point. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: GUI for mysql
gowthaman ramasamy [EMAIL PROTECTED] wrote: i use MySQL 4.0.20 on RH7.3 on a sun fire workstation. Can some one of you suggest a good GUI for mysql. I also use Mysql 4.0.13-pc-linux-i686 on P4. MySQL Administrator and MySQL Control Center are a good choice. See at http://www.mysql.com/products/ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INTEL vs. SPARC
mac [EMAIL PROTECTED] wrote: Are you running Linux or Solaris on these servers? sparc: solaris 9 intel: debian-linux (2.4.21-kernel) To achieve best performance, you better get the Official MySQL binaries from http://www.mysql.com rather then compiling by yourself. This is due to glibc patches applied to glibc for official binaries. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL IPv6 enabled ready !!!
Rafael Martinez Torres [EMAIL PROTECTED] wrote: you will find a patch to make the last stable version on MySQL, (4.0.8) You are more than a year past the schedule: the last stable version of MySQL is 4.0.20. :-)) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Server Startup
David Scott [EMAIL PROTECTED] wrote: Then get a copy of mySQL CC http://dev.mysql.com/downloads/mysqlcc.html Also take a look at MySQL Administrator http://dev.mysql.com/downloads/administrator/index.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql client connectivity and orphaned connections
Jim [EMAIL PROTECTED] wrote: I'm just wondering if anyone can tell me exactly what happens when one is using the mysql client on a remote server and the connection to that server (in this case over ssh) gets dropped. if your ssh session suddenly closes, the only thing that happens is that MySQL command line client will exit. This will not stop server from processing OPTIMIZE TABLE as this is an atomic operation. In this case, I was in the midst of a long OPTIMIZE TABLE. Stepped out to get some coffee and the ssh connection timed out. When I log back in again, and log in to mySQL using the client, I can see that the first mysql session is still in effect, and show processlist shows that the state of the orphaned user is Repair with keycache. But, this is taking too long (over 45 minutes) I think. In some cases this may take DAYS, not minutes. :) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: time on tenth of secounds
Matthias Eireiner [EMAIL PROTECTED] wrote: problem is, that I want to save the time with the fraction of seconds. as far as I know MySQL is fine with something like D HH:MM:SS.fraction, but doesn't store the fraction. Is there anything that could fix that problem? I thought about an extra integer column only for the fraction, but I would love to use the MySQL built in sub and add functions. There is no support for fractions in DATETIME type. Feel free to add the fraction manually into another column. Do you really need database's internal functions to support high-resolution time? MySQL is in no case a real-time DBMS. Even inserting a NOW() value into a high-resolution DATETIME column will give you an unpredictable result as you never know how much time for server it will take to process the query. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: defaults for net_read_timeout and net_write_timeout?
Marten Lehmann [EMAIL PROTECTED] wrote: what are the defaults for the following options? net_read_timeout 30 seconds. net_write_timeout 60 seconds. See http://dev.mysql.com/doc/mysql/en/Server_system_variables.html for details. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: C API -- huge result sets slowin me down
Matt Eaton [EMAIL PROTECTED] wrote: Try to profile application from that point ... if (mysql_real_query(dbase,sqlBuff,strlen(sqlBuff))) { printf(Pool Attributes Select Failed... dumbass\n); fprintf(stderr, Error: %s\n, mysql_error(dbase)); exit(1); } result = mysql_store_result(dbase); numRows=mysql_num_rows(result); ... to that point and then from here to .. for (i=0;inumRows;i++) { row = mysql_fetch_row(result); tempq=atoi(row[1]); tempP=atoi(row[0]); genAttrib[tempP][tempq]=atoi(row[2]); } ..here. I suppose the cycle could be a slowdown/ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Security
Sheraz [EMAIL PROTECTED] wrote: How can i achieve Security acpect in mysql? How secure can we make transactions over internet for 3306 ? Use SSL. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: php-mysql RPM
[EMAIL PROTECTED] wrote: I'm installing the php-mysql-4.3.6-1.3.i386.rpm and it's complaining about a dependency libmysqlclient.so.10. My mysql server version is 4.0.20. Can anyone tell me where I can get libmysqlclient.so.10. Download MySQL RPMs from http://dev.mysql.com/ The package containing libmysqlclient is MySQL-shared. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: authentication error
Chip Bell [EMAIL PROTECTED] wrote: Hello, I run a toaster email server which is having trouble authenticating at times. Both methods of authentication, imap AND web for some reason just hang. I'm pretty new to MySql but I figure if both methods are trying to authenticate against the same table, the problem is there. I activated binary logging, what else can I do to find the issue? Are you talking about MySQL user auth OR about some kind of email user authentication against data stored in MySQL database? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql growing pains, 4 days to create index on one table!
Are you running this under Microsoft Windows? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Index problem
Oropeza Querejeta, Alejandro [EMAIL PROTECTED] wrote: Hi, i'm trying to create an index on a table with 199 million records. The problem is that is taking too long (8 hours and is not yet finnished). does anyone have any idea? Wait until it finishes.:) We have tables where index creation takes tens of hours or even sometimes _days_, not even hours. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb and backup
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: i have read multiple websites and posts.. and this mail list archive but i have not found the answer to the question: how is it possible to do a backup of a innodb table? i have read: try to use mysqldump.. but this does not work right i have read: try to use mysqldump --single-transaction ... but i dont see any difference.. and doesnt work right too i have read: use this: http://www.innodb.com/order.php .. but it isnt free :/ the problem is not how to do the backup.. but recovering from it.. because it complains about the foreign keys. How to restore tables that have foreign key relationships is described at: http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html You should set FOREIGN_KEY_CHECKS to 0 before restoring tables. and then i think: how is it possible that i cant do backup, and recover it, of my innodb tables? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: can't read innodb tables after 3.23 - 4.0.18 upgrade
Rusty Weaver [EMAIL PROTECTED] wrote: After upgrading from to 4.0.18 I can no longer access my innodb tables created under 3.23. I get these errors: % mysql -uroot db0 ... Didn't find any fields in table 'Employees' ... My database files and .frm files are all present and readable. No errors in the hostname.err file either. I tried all the tips in the installation instructions, confirmed proper file permissions, etc. Has anyone encountered this problem? I did not see this issue discussed, and my only solution was using mysqldump to export my tables prior to the upgrade, then import after. In the install docs I read that mysqldump *may* be required when jumping to a new release series. Is that definitely the case for 3.23 - 4.0.18? I have a large data set and I want to avoid the downtime for mysqldump. Check where your ibdata file is located and specify innodb_data_file_path variable. If innodb_data_file_path isn't specified by default innodb data file is created in the MySQL data dir. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: question on auto increment field
Scott Haneda [EMAIL PROTECTED] wrote: on 06/23/2004 12:14 AM, Joe Wong at [EMAIL PROTECTED] wrote: If it possible to limit the max value of an auto increment field to say, , and how to do it? I am using MySQL 4.0.18. No. The maximum value for the auto_increment column can be limited by the maximum value of the column type(tinyint, int, mediumint etc.). I am not sure, as a 'hack' you could simply insert a blank record with the value set to ,, once you reach that limit and try to insert a record, a error would be generated, no new records would be able to be inserted until this was resolved. It will not work, because if you insert dummy row and set auto_increment value to , the next generated auto_increment value will be 1. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql action history
web tur [EMAIL PROTECTED] wrote: I have mysql database on the web server. Is there any way to see mysql actions from any log? I want to see what my visitors did on the sql databases. You can turn on general query log: http://dev.mysql.com/doc/mysql/en/Query_log.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL InnoDB tables dump [CASCADE]
Milan Svrlo [EMAIL PROTECTED] wrote: Hi, I'd ask you : Can I use in MySQL 4.x on InnoDB tables something like : create dump from this InnoDB tables with cascade INSERT sql statements based foreign keys ? And if yes, how ? No. Probably you need mysqldump and SET FOREIGN_KEY_CHECKS = 0 command: http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html http://dev.mysql.com/doc/mysql/en/mysqldump.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to randomnly select just 1 record from the table?
Binay [EMAIL PROTECTED] wrote: well i have only 4 records in the table. When i use below mentioned query it always return the same record irrespective of time delay. Now wht can i do? What version of MySQL do you use? Thanks Binay Binay [EMAIL PROTECTED] wrote on 21/06/2004 15:03:34: I need to select randomnly just one record from the table. how can i do? please help me out. SELECT * FROM tbl_name ORDER BY RAND() LIMIT 1 ; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld not starting
Matt Brei [EMAIL PROTECTED] wrote: Last night I upgraded from 3.23 to 4.0.20 and when I try to start mysqld it fails. The only entries I have in my error log are: 040620 23:44:19 mysqld started 040620 23:44:19 mysqld ended I know this isnt' enough info to troubleshoot the problem. How can I set the log level to give me more detail so I can figure out why the service keeps dying? Any help would be greatly appreciated. Check error log file for error message. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: disconnecting from server
[EMAIL PROTECTED] wrote: I am using the command ./mysqld_safe --user=3Dmysql to connect to the= server but how does one disconnect? With the above command you start the MySQL server, not connect. To stop MySQL server use command: shell mysqladmin shutdown http://dev.mysql.com/doc/mysql/en/mysqladmin.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'foo@host' (Using password: YES)
Marc Tardif [EMAIL PROTECTED] wrote: I'm using mysql-3.23.58-1.9 installed from RPM on Red Hat Linux release 9 (Shrike). First, I create a database and user to connect to this database using the following commands: mysql CREATE DATABASE foo; mysql GRANT ALL PRIVILEGES ON foo.* TO foo@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; mysql GRANT ALL PRIVILEGES ON foo.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' WITH GRANT OPTION; mysql FLUSH PRIVILEGES; Then, I try to connect to the database using the host parameter but I get the following error message: # mysql --user=foo --password=password -h host foo ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I've only managed to find a single thread about this issue which was a bug in the installation of mysql on RedHat 7. Many months have gone by since then so I wonder if this is still the same issue. Delete from the table User entry for user ''@'localhost' and then FLUSH PRIVILEGES. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ` around object names?
Karam Chand [EMAIL PROTECTED] wrote: Can somebody tell me the exact version from when ` around object names were allowed? It was introduced in version 3.23.6. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB Newbie Simple Question
Carlos Sunden [EMAIL PROTECTED] wrote: InnoDB is included in binary distributions by default as of MySQL 4.0. Hello Is InnoDb always used when installing MySQL whether RPM or binary is used? Yes. If you don't need InnoDB, start MySQL server with --skip-innodb option. I am not completely sure what this is although I've read about it. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to Fix Broken Replication
Henry Chang [EMAIL PROTECTED] wrote: I have MySQL replication setup between Master A and Slave B. Everything was working fine, until one day replication was broken. Status on the slave shows the following error message: Last_error: Error 'Can't drop database X. Database doesn't exist' on query 'DROP DATABASE X. I suspect another admin probably deleted or moved the database from the linux command line. At this point, how can I tell Slave B to jump over this drop command and resume replication at the next command?? Or is re-installing replication the only option on Slave B?? Any help would be greatly appreciated. Master A Slave B MySQL version 4.0.18 Red Hat 9 SET GLOBAL SQL_SLAVE_SKIP_COUNTER command will help you: http://dev.mysql.com/doc/mysql/en/SET_GLOBAL_SQL_SLAVE_SKIP_COUNTER.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
You better download the binary release from mysql.com and install it. It's statically linked so it should work fine on all Linuxes. Correctly installed MySQL binary release works fine and generally needs no tweaking to start and run. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Last Modified
Martijn Tonies [EMAIL PROTECTED] wrote: If your table contains a timestamp field, it will update each time the row is altered. Otherwise I don't think it's possible. That's on a per ROW basis, not TABLE basis. But if it is on every row, you can MAX() it to get the latest row update, which is the latest table update. How fast would this be on a largish table? Build an index on this column and force it: SELECT MAX(timestamp) FROM table FORCE INDEX(timestamp_index) In this case you'll be sure that it's fast enough. And, of course, as Ian Gibbons correcly mentioned, you can use MySQL-only way to check the latest update time of a table: SHOW TABLE STATUS LIKE 'tablename'; and look for the Update_time field. Martijn Tonies -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help with apostrophe and FTS
Andrea Gangini [EMAIL PROTECTED] wrote: Well yes, it's an option. I really need this functionality. But on mysql site, under source downloads, there's this warning: For maximum stability and performance, we recommend that you use the binaries we provide. Is it really true? Absolutely. There are too many ways to build MySQL so that it will not work well... buggy compilers, thread stack size, etc. Especially this applies to Linux, because MySQL build is statically linked with a bit patched glibc version. And glibc compilation by itself is tricky. So if you need rock stability on Linux and still need to have a custom built binary you can subscribe to Primary support or Login installation packages. Both include custom binaries build. Click on the link below to learn more. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how mysql sends its data to clients.
Craig Harding [EMAIL PROTECTED] wrote: MySQL protocol is a binary protocol. Still it's not encrypted and data could be sniffed. Use MySQL-Max and SSL connections to encrypt data in protocol. I'm wondering how mysql actually sends its data to a mysql client? Is it binary data or plain text or encrypted with some general function? When I use ethereal to capture the packets all I can see is anything but plain text. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Corrupted .MYI file
There are too many reasons for that. Yes, users who press reset button, power outage, buggy hardward or OS, even corrupted MySQL builds may cause this to happen. Example: we often have this kind of troubles on FreeBSD 5.x on high load with big databases (tens of gigs). This happens because of damaged threads in FreeBSD, not because of MySQL. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding replica server in a mixed MyISAM/InnoDB multi-master env?
Tabor J. Wells [EMAIL PROTECTED] wrote: Is it safe to just shutdown ServerB, copy all of the mysql data dir (including the ibdata files) to ServerC, restart ServerB, and then change the my.cnf of ServerC to set a new server-id, master-host, replicate-do-db entries and start ServerC? You better dump data using mysqldump. Don't forget the --opt option. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Server optimization issue
Misao [EMAIL PROTECTED] wrote: Take a deep look at http://dev.mysql.com/doc/mysql/en/Server_system_variables.html But ensure that this is MySQL who takes so much memory. Watch other variables like key_buffer. MySQL probably should not take that much memory if these are the only variables specified: Here are my InnoDB settings in my.cnf: innodb_log_files_in_group=2 innodb_log_file_size=512M innodb_buffer_pool_size = 1512M innodb_additional_mem_pool_size = 20M What are the OS and MySQL build? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Column's DataType -- TEXT vs BLOB...
Scott Fletcher [EMAIL PROTECTED] wrote: I also have another table that use 4 columns of 800 characters along with 5 columns that use 250 characters. I'm thinking of using TEXT for 9 of those columns. If you don't plan to store pure binary data in these fields, choose the TEXT type. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Bug in 4.0.20
Wendell Dingus [EMAIL PROTECTED] wrote: RedHat Enterprise 3WS, fully up2date. MySQL binary RPMs for AMD64 won't even start for me, what were they built on?. I installed the .src.rpm and built one myself (-bb --target amd64). Installed that and all seems well. This seems strange. Can you provide me with the details (mailto:[EMAIL PROTECTED], please)? We will investigate and possibly fix the AMD build. And, of course, to eliminate bugs, it's better to run MySQL prebuilt binaries on Linux. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Maximum number of simulatneous connections
venkata ramana [EMAIL PROTECTED] wrote: What is the maximum number of simulataneous connections that can exist for MySQL. Can we change this limit? If yes please tell me how to do this. I am using MySQL4.1 in Linux. You can tweak max_connections variable, but on Linux the limit is around 1000 connection due to some system limitations. To achieve more connections it should be rebuilt. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How do you display last modified date
Daniel Venturini [EMAIL PROTECTED] wrote: Hello I am using PHP, mysql. How would I query mysql to display the last time a table was last modified/changed/or updated. For example I have a user that updates a stats page via the web, and I would like it to say (Current up to The last date the stats table was modified). Thanks for your help, Take a look at the TIMESTAMP column type. Add one to table and then you'l be able to use SELECT MAX(timestamp_column) on your table. See: http://dev.mysql.com/doc/mysql/en/DATETIME.html I've been looking online as well but thought this may be quicker. Take care. Thanks again. Daniel -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Converting table types
Greg Macek [EMAIL PROTECTED] wrote: I was wondering what happens when you change table types. Does MySQL automatically get rid of the old table files? Yes, MyISAM files are deleted. As for converting InnoDB - MyISAM, then of course, InnoDB tablespace is not deleted, but freed. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FreeBSD 5.x
Peter [EMAIL PROTECTED] wrote: Does anybody have experience with FreeBSD 5.x Mysql ? FreeBSD 4.x and mysql seems to be awful combination due to threading , = but I have no tried FreeBSD 5.x with mysql under heavy load MySQL under FreeBSD 5.x works way much better than under FreeBSD 4.x but still not at production level. In my experience it works fine on a single CPU box and with relatively small tables. If the tables grow really big (tens of Gigs) and/or in SMP mode (including HT), then FreeBSD's behaviour is unacceptable. It randomly crashes in random places. Tested on 5.0, 5.1, 5.2, etc. Only linuxthreads tested, no KSE. Peter Zyumbilev -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Causes of MySQL slowness... how to test to fix this?
Dan Brown [EMAIL PROTECTED] wrote: Will the number of databases being handled by MySQL affect it's speed regardless of the actual load being put on MySQL or should I look farther into OS issues which could be causing system hangups and slowdowns? Yes, investigate the OS. The age of the OSes in the high end servers is a bit of a sore point but cannot be addressed at this point in time and are currently as secure as possible in all relevant software interacting with the outside world. Also please ensure that you are running prebuilt RPM binaries downloaded from mysql.com. Sometimes improperly built binaries may cause such weirdness. Is there some useful error messages in the .err files when data is being inserted? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: key_buffer or key_buffer_size
Chambon [EMAIL PROTECTED] wrote: Can somebody tell me if 'key_buffer' and 'key_buffer_size' are the same variables ? Yes. _size is deprecated. Perhaps it is just a question of syntax, I mean, in the my.cnf you write key_buffer=100M or you write set-variable = key_buffer_size=100M It's the same. set-variable is deprecated, so use the first syntax instead. Same question for sort_buffer and sort_buffer_size, thread_cache and thread_cache_size, innodb_buffer_pool and innodb_buffer_pool_size etc. All the same :-) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with Merge Table,ERROR 1016: Can't open file: '#sql-407f_f.MRG'. (errno: 144)
Michael Arndt [EMAIL PROTECTED] wrote: a) what could be reason /solution for the following Problem: ERROR 1016: Can't open file: '#sql-407f_f.MRG'. (errno: 144) [EMAIL PROTECTED] egor]$ perror 144 Error code 144: Unknown error 144 144 = Table is crashed and last repair failed So, running myisamchk is a solution for this. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: General log file in v3.23.52
Don Dachner [EMAIL PROTECTED] wrote: How do I turn on the General log file in version 3.23.52? Can I put an entry in the my.cnf file and reboot? Yes, put the log entry in my.cnf and restart MySQL. If you are running Red Hat Linux, restart MySQL by running service mysql restart In other case, run mysqladmin -uroot shutdown Then as root: mysqld_safe -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on NetWare and Backups
Mark Goldfarb [EMAIL PROTECTED] wrote: Hi. Hope someone can help me. I am running MySQL on a NetWare 6.x server. I am using Veritas BackupExec. I currently manually copy the files before a backup or manually unload the MySQL server. I would like to automate the backup. What is the best way to do a backup on a NetWare server. Take a look at mysqlhotcopy script, that may help you. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on NetWare and Backups
Mark Goldfarb [EMAIL PROTECTED] wrote: I saw the script. I am actually fine running a shutdown on the server prior to each backup. Veritas BackupExec supports running commands prior and after each backup. The problem I am having is if I run the mysqladmin --shutdown command, it generates a message saying NLM has been shutdown, press any key to continue. Until someone presses a key on the server, the MySQL server is in a frozen state (I cannot restart it). Does anyone know anyway to avoid getting that message when running the mysqladmin NLM? What is NLM? Thanks Egor Egorov [EMAIL PROTECTED] 6/10/04 12:58:59 PM Mark Goldfarb [EMAIL PROTECTED] wrote: Hi. Hope someone can help me. I am running MySQL on a NetWare 6.x server. I am using Veritas BackupExec. I currently manually copy the files before a backup or manually unload the MySQL server. I would like to automate the backup. What is the best way to do a backup on a NetWare server. Take a look at mysqlhotcopy script, that may help you. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [mysql-php] mysqlimport error
[EMAIL PROTECTED] wrote: is that a problem? I want to avoid ftp db.txt files and then mysqlimport them You should run mysqlimport on the Windows box and specify MySQL server host with -h option. - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 4:38 PM Subject: Re: [mysql-php] mysqlimport error nikos [EMAIL PROTECTED] wrote: I'm trying mysqlimport --local -d --fields-enclosed-by=| --fields-terminated-by=; - -lines-terminted-by=\n -unikos -p mydb c://temp//programs.txt but i get an Error: File 'c:/temp/programs.txt' not found (Errcode: 2), when using table: programs What I'm doing wrong? RH-9 - APACHE v2 - mysql 3.23.54 Looks like you run mysqlimport on the server host but file is located on Windows box. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innoDB
[EMAIL PROTECTED] wrote: Anybody know how do I know if innoDB is enabled? SHOW VARIABLES LIKE have_innodb; If InnoDB is enabled, you will see 'YES' in the output. I have MySQL 3.23 installed. The MySQL document says the simplest way to install MySQL-Max is to replace the executable mysqld server with the corresponding executable from the MySQL-Max distribution. Where can I get the mysqld of MySQL-Max? How did you install MySQL? Is MySQL-MAX the MaxDB on the download page? No. Mysql-max packages you can find at: http://dev.mysql.com/downloads/mysql/3.23.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL daemon fails after setting root password
Jesse [EMAIL PROTECTED] wrote: anyone know why the mysql daemon fails to start after I set the root password according to this: http://dev.mysql.com/doc/mysql/en/Default_privileges.html I use the command: SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd'); SET PASSWORD FOR 'root'@'host_name' = PASSWORD('newpwd'); This is on SuSE 9.0 with mysql version 4.0.15 What error did you receive? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Subscription
Tom Murdock [EMAIL PROTECTED] wrote: Good evening, I would like to subscribe to MySQL mailing list. Thank you. If you want to subscribe to MySQL mailing list, visit http://lists.mysql.com/ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replicator thread dying
Balazs Rauznitz [EMAIL PROTECTED] wrote: It's happened to me four times the past few weeks that in a very lightly used QA environment replication is dying. The symptoms are that Exec_master_log_pos gets stuck somewhere, while Read_Master_Log_Pos gets incremented as the master has new updates. There is always a max-mysqld process that would not die on a restart, only kill -9 makes it go away, after which replication is hosed. The funny thing is that the production environment with 100 times the load is working OK. MySQL 4.0.16 on linux 2.4.x What is the value of Slave_SQL_Running in the SHOW SLAVE STATUS output? Is there anything in the error log? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Exporting/Importing Databases
David Blomstrom [EMAIL PROTECTED] wrote: --- Robert A. Rosenberg [EMAIL PROTECTED] wrote: At 20:36 -0700 on 06/02/2004, David Blomstrom wrote about Exporting/Importing Databases: Third, my practice database includes half a dozen tables, but only one made it online, followed by this error message: Database USERNAME running on localhost Error SQL-query : CREATE TABLE `counties` ( `SCode` varchar( 6 ) NOT NULL default '', `NameC` varchar( 255 ) default NULL , `TypeC` varchar( 255 ) default NULL , `Seat` varchar( 255 ) default NULL , `Area_MI` decimal( 10, 1 ) default NULL , `Area_KM` decimal( 10, 1 ) default NULL , `Pop_2000` int( 10 ) default NULL , `Pop_1990` int( 10 ) default NULL , `Pop_MI` decimal( 10, 1 ) default NULL , `Pop_KM` decimal( 10, 1 ) default NULL , `Race1` int( 10 ) default NULL , `Race2` int( 10 ) default NULL , `Amerindian` int( 10 ) default NULL , `White` int( 10 ) default NULL , `Black` int( 10 ) default NULL , `Asian` int( 10 ) default NULL , `Pacific_Island` int( 6 ) default NULL , `Some_Other_Race` int( 10 ) default NULL , `Hispanic` int( 10 ) default NULL , `id` int( 6 ) NOT NULL AUTO_INCREMENT , PRIMARY KEY ( `id` ) , KEY `SCode` ( `SCode` ) , CONSTRAINT `0_132` FOREIGN KEY ( `SCode` ) REFERENCES `statesarticles` ( `SCode` ) ON UPDATE CASCADE ) TYPE = InnoDB AUTO_INCREMENT =3143 MySQL said: #1005 - Can't create table './[USERNAME]/counties.frm' (errno: 150) Do you know what this means? You just got caught with the old Referential Integrity Gotcha. It will not allow you to create countries since statesarticles does not (yet) exist. The fix is to temporally turn off RI during the load. Put this command at the start of your file: SET FOREIGN_KEY_CHECKS = 0; and this one at the end: SET FOREIGN_KEY_CHECKS = 1; and it will work. OK, is this something I can do in phpMyAdmin or another software program, or do I have to open the MySQL file itself? I've scarcely touched MySQL files, but I found the file counties.frm, which I assume I would open with Notepad, right? And then I can make SET FOREIGN_KEY_CHECKS = 0; the very first line and SET FOREIGN_KEY_CHECKS = 1; the very last line, after which I would EXPORT my database, then import it, right? And since I like to plan ahead, is it OK to insert these two lines in ALL my MySQL documents, just to be prepared for this error? If I inadvertently stick these lines in a file that doesn't have a foreign key, will it cause a problem? Finally, after I've imported my database online, do I have to go back and remove these two lines, or can I just leave them there indefinitely as a safeguard? You should put these lines to the dump file that contains CREATE TABLE statements, not to the *.frm files. Then load tables. If you use command-line client you can do: mysql SET FOREIGN_KEY_CHECKS = 0; mysql SOURCE file_name; mysql SET FOREIGN_KEY_CHECKS = 1; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Exporting/Importing Databases
David Blomstrom [EMAIL PROTECTED] wrote: --- Egor Egorov [EMAIL PROTECTED] wrote: David Blomstrom [EMAIL PROTECTED] wrote: --- Robert A. Rosenberg [EMAIL PROTECTED] wrote: You just got caught with the old Referential Integrity Gotcha. It will not allow you to create countries since statesarticles does not (yet) exist. The fix is to temporally turn off RI during the load. Put this command at the start of your file: SET FOREIGN_KEY_CHECKS = 0; and this one at the end: SET FOREIGN_KEY_CHECKS = 1; and it will work. You should put these lines to the dump file that contains CREATE TABLE statements, not to the *.frm files. Then load tables. If you use command-line client you can do: mysql SET FOREIGN_KEY_CHECKS = 0; mysql SOURCE file_name; mysql SET FOREIGN_KEY_CHECKS = 1; Does anyone on this list know... 1. Can I also open the file with Notepad and insert the statements? Yes. 2. Where's the location of this dump file? Where did you save it? 3. After I import my SQL file online, do I have to then change the file back, deleting the two statements I added? Up to you. If you plan to reuse this dump file, you can keep SET FOREIGN_KEY_CHECKS statements too. I'm leery of using the command-client, because it's unfamiliar to me, and I'm worried about making a major mistake. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]