Re: select from table hangs?
Hi. Try to upgrade to the latest release (use official binaries from MySQL). Kristina Clair [EMAIL PROTECTED] wrote: Hello, I am having a problem with a mysql (myisam) table that I've never had before, and I'm completely stumped! I am using mysql version 4.0.13. myisamchk -e table.MYI returns no errors. Yet, when I try to do any kind of select from the mysql prompt, it just hangs and never returns an error code. Does anyone have any thoughts on what might be wrong or other ways to debug this? Thanks! -- 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 and innoDB
Egor Egorov [EMAIL PROTECTED] wrote: Stefan Gnann [EMAIL PROTECTED] wrote: I have a mysql database 4.0.15 on a suse linux 9.x system running. First, upgrade to .20 version officially built by MySQL AB (http://dev.mysql.com/). RPM version is easy to install and run. Oops, of course I meant the latest, .21. -- -- 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 Issue
Randy Johnson [EMAIL PROTECTED] wrote: I have mysql master and mysql slave on same machine running separately. I have master and slave setup. I was able to do the LOAD DATA FROM MASTER; to get the data but the data does not replicate after that. =20 Looking at the info below can you tell why replication is not taking = place. Can I provide you with any other information? Look in the tail of .err file, which may contain some clue info. Are you sure that replication slave is running? See http://dev.mysql.com/doc/mysql/en/Replication.html, most issues are covered there. -- -- 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: Two Instances
Christopher Chamber [EMAIL PROTECTED] wrote: Hi Everyone. My problem is that i want to create 2 instances of a sub-query. For Example: SELECT DISTINCT V4.* FROM (SELECT v2.* FROM cell v1,cell v2 WHERE v1.name = 'reviews' AND v2.sal = v1.sal ) v3 , v4 This query will gives an error as V4 is not allowed, i.e. not more than 1 instance of a sub-query can be created. Is there a way around this problem. I would not like to make this sub-query again to get another instance of it. I need it very much, and if anyone can give me a way to do it, i would be highly grateful. Can you please describe what you mean by an instance of a query? It's not clear to me. -- 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 mysql installations?
Minuk Choi [EMAIL PROTECTED] wrote: I managed to get multiple instances of mysql to install and run(via = mysqld_multi), but only by compiling the source. The system I had was Redhat9 and I used the Mysql RPM, but I couldn't = get that to work, so I opted to download and compile the source. Is this the ONLY way to get multiple instances of mysql to run on one = machine? See that: http://dev.mysql.com/doc/mysql/en/Multiple_servers.html http://dev.mysql.com/doc/mysql/en/mysqld_multi.html Usually following these steps you can safely run many instances of MySQL on a single box. Please however use the MySQL official binary release 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: Result returned by LOAD LOCAL...
Karam Chand [EMAIL PROTECTED] wrote: When I execute a LOAD DATA INFILE statment.. mySQL returns a result with info like: Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 How can I get more information about deletions, warnings etc? See: http://dev.mysql.com/doc/mysql/en/SHOW_WARNINGS.html http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html Hope that helps. -- 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: Commercial Licensing Question
You may direct your question to [EMAIL PROTECTED] -- 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 ALTER TABLE error
John Stile [EMAIL PROTECTED] wrote: I have Mysql Cluster (version 4.1.16-gama) running, and now I need to convert database tables from engine MyISAM to NDBCLUSTER, but ALTER TABLE fails on some tables. Does anyone know what the error means or how to get around it? mysql use database1; mysql alter table attr engine=NDB; ERROR 1005: Can't create table './database1/#sql-4627_3a.frm' (errno: 4009) Seems weird. Can you check permissions in datadir/database1 and/or create a testcase for us? -- 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-administrator
spiv007 [EMAIL PROTECTED] wrote: Has anyone seen this before with mysql-administrator? /usr/local/bin/mysql-administrator: line 9: 19856 Segmentation fault $MYPATH/mysql-administrator-bin I get this everytime i go to schema privileges to assian a user rights. Can you create a simple testcase for this and send it to me? -- 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: Sharing database files between EMBEDDED MYSQL and MySQL Server
Valdir Henrique Dias Leite [EMAIL PROTECTED] wrote: I have an application that uses mysql embedded (performance issues ...). The app itself works fine, but data adminsitration (issuing DDL, DML statements ) is very complicated using C API... So, I created an entry in my.cnf pointing to directory where database used by embedded is, aiming to use mysql interface to perform queries, updates, et cetera. The problem is: Every changes I make using mysql interface, don=B4t reflect inside embedded scope (for example, inserts made by mysql don=B4t exists in queries run by embedded application). My questions are: Is it possible to have a situation like mine ? There is an isolation between two aplications (mysqld and mysqlembedded) ? May I mix scenarios as I wonder ? What is wrong ? Read manual on flush tables and lock tables: http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html http://dev.mysql.com/doc/mysql/en/FLUSH.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: Odd MySQL error
Rich West [EMAIL PROTECTED] wrote: Check limits for the MySQL user account in Fedora. Check that the init script is original from MySQL, not the Fedora one. Tail the dmesg output and look for suspictious messages. I have searched the archives (well, the search never came back...), and I have searched the web, but found very little that could help with the scenario that we are currently experiencing. We have the 4.0.21 RPM's installed direct from MySQL.com on a Fedora Core 2 server. The previous incarnation of this server was a Fedora Core 1 server which ran flawlessly. Since the new server has been put in to production, on a daily basis (random times), we are forced to restart mysql because all processes which attempt to get data out of the databases fail. We access the database through Apache+PHP+MySQL as well as via the Perl DBI interface.. Everything comes back after a restart... In the logs, all we see is: 041018 20:32:50 mysqld started 041018 20:32:51 Warning: Asked for 196608 thread stack, but got 126976 041018 20:32:51 InnoDB: Started /usr/sbin/mysqld: ready for connections. Version: '4.0.21-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 Official MySQL RPM 041020 16:20:35 Error in accept: Too many open files 041020 16:33:23 /usr/sbin/mysqld: Normal shutdown 041020 16:33:24 InnoDB: Starting shutdown... 041020 16:33:27 InnoDB: Shutdown completed 041020 16:33:27 /usr/sbin/mysqld: Shutdown Complete 041020 16:33:27 mysqld ended I did find that the Warning can be safely ignored. However, the problem definitely is at the Error in accept: Too many open files line... the rest of the system is behaving happily, so I am not sure where to go from here.. /proc/sys/fs/file-max comes back with an astronomical 76949, and sysctl shows nominal activity: fs.file-max = 76949 fs.file-nr = 3760 0 76949 fs.inode-state = 17709 26290 0 0 0 0 fs.inode-nr = 17709 2629 A couple of related postings seemed to indicat that it had to do with the mysql process and/or the limits set upon the mysql user account, but that was all speculation. Ideas, Comments, Suggestions are all more than welcome! -Rich -- 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 Starting MySQL 4.0.21
Jason Williard [EMAIL PROTECTED] wrote: I have a new linux server that I just installed the mysql-max-4.0.21-pc-linux-i686 binary on. The installation had no errors. However, it is not starting on startup because of the following error: Can't execute ./bin/mysqld_safe from dir /var/lib I can start MySQL manually running '/usr/local/mysql/bin/mysqld_safe '. Does anyone know why I am getting this error message? Because you have to start it using the full path: /usr/local/mysql/bin/mysqld_safe If you are running rpm-based linux, better take the RPM version. -- 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: Revert a column to its default value
Jonathan Kart [EMAIL PROTECTED] wrote: Hi all, Is it possible in mysql 3.23 to update a row and revert a column back to its default value. Not the default value for the type, but the value defined as the column default. [] UPDATE pictures SET picture_name=DEFAULT; -- don't think this is possible It works in 4.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 server is taking all my hardrive space
Most likely, binary logs are populating the space. Read http://dev.mysql.com/doc/mysql/en/PURGE_MASTER_LOGS.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: Importing Excel Data in MySql
See http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html Hope that helps. -- 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 and innoDB
Stefan Gnann [EMAIL PROTECTED] wrote: I have a mysql database 4.0.15 on a suse linux 9.x system running. First, upgrade to .20 version officially built by MySQL AB (http://dev.mysql.com/). RPM version is easy to install and run. Now we have to use the features of InnoDB tables (rollback, a.s.o.). Second, setup InnoDB: http://dev.mysql.com/doc/mysql/en/InnoDB_configuration.html http://dev.mysql.com/doc/mysql/en/InnoDB_start.html Up to now we use the standard table type MyISAM. Now I want to change the tabel type with the command ALTER TABLE x TYPE = InnoDB. The command doesn´t show any effect !!! Third, check that InnoDB is enabled: SHOW VARIABLES LIKE 'have_innodb' and look for InnoDB to be enabled. -- 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... INTO OUTFILE problem
Jay Blanchard [EMAIL PROTECTED] wrote: [snip] Exception occured in Microsoft OLE DB Provider for ODBC Drivers, [MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]Can't create/write to file 'C:\data_out\day234\data_out.txt' (Errcode: 2) [EMAIL PROTECTED] egor]$ perror 2 System error: 2 = No such file or directory -- 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: Modify type
Jerry Swanson [EMAIL PROTECTED] wrote: I have field date type of datetime. I need to modify to timestamp. If I alter the table and mofiy the field will this crash the data in the field. MySQL server will crash? Please show us the 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: Unable to Start MySQL on FreeBSD4.10 box
Lynette Tillner [EMAIL PROTECTED] wrote: I'm setting up a development box with FreeBSD 4.10 and installed MySQL = 4.0.12 on it. Everything in the install appeared to work smoothly.=20 However, when I go to start MySQL I get an error that says:=20 database list could not be retrieved So, how do I fix this? I've been unable to find any documentation that = sheds any light on what I need to change.=20 Doesn't look like a MySQL error message. Please read http://dev.mysql.com/doc/mysql/en/Unix_post-installation.html and http://dev.mysql.com/doc/mysql/en/FreeBSD.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: create table....select * from table anomaly..
It's rather a different behaviour. We suggest to upgrade to 4.0.21 in this case. -- 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: hotcopy - segfault
James Green [EMAIL PROTECTED] wrote: Trying to run mysqlhotcopy on multiple Debian stable systems, am getting segfaults on some of them. We're using mysql-4.0.20 from the binary release off mysql.com. strace says: [] I'm no expert - can anyone identify the fault? Running as root user. mysqlhotcopy is a perl script. Please check the perl version, the DBI versions and also how is the DBD::MySQL linked with libmysqlclient. I suggest you to install MySQL-devel and MySQL-shared and then recompile and reinstall DBD::MySQL to get sure that it's linked with properly-compiled MySQL libraries. Also, as a clue, take a look at the end of the dmesg output. If there's a kernel panic - then you have something wrong with your hardware or less possibly, with your kernel. -- 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: Transactions dilemma
Stuart Felenstein [EMAIL PROTECTED] wrote: I have a slight dilemma. I am using transactions to insert data into multiple tables. All but one table is Innodb. That one is Myisam and it's left as such because its one text column, so I want the benefits of full text search. Still I need this transaction to somehow include this entry. Two thoughts : 1- I created a temp innodb table and then after transaction move the data over to the myisam. 2-Figure out what the text search options are in innodb and maybe if there is a way to improve on them. Any suggestions ? Consider LOCK TABLES: http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.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: strange user permissions error
Check tables in mysql database with myisamchk. This might me some kind of table corruptions. -- 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 with mysqldump
See http://dev.mysql.com/doc/mysql/en/GRANT.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: Which Filesystem to choose?
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I'm trying to set up a new Opteron-Based MySQL-Server. The only thing I'm unsure about is which filesystem to choose.. ext3? ReiserFS? XFS? What's your experience? ext3 is the safest. For both others I'd suggest you to have UPS for your server. XFS is sensitive to power outages. For InnoDB consider using raw partitions or raw disks as a storage. This will give you more performance/reliability and this will let InnoDB have full control over the storage space, bypassing the filesystem layer. -- 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: Blob question
Steve Grosz [EMAIL PROTECTED] wrote: I'm just getting into the whole MySql (was using access). Is it better to create a Blob type and insert a image into it, or to create a char file type and have a directory structure to the specific file? It's FAQ. One of the most FA Q. Store image in file and store file name in table. How big of files to the different Blob's hold? As much as you want, size limited by the int 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: just testing, sorry.
tibyke [EMAIL PROTECTED] wrote: pls delete it Done, deleted from my computer. :-)) -- 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 TMPDIR.
You can be sure that MySQL won't loose any data in this case. -- 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: Fatal Error on db
John [EMAIL PROTECTED] wrote: Not a MySQL error. it's a bug in the application. I am using php/mysql for a program and everything installed fine but when I try to open it up I get this error: Fatal Error : Couldn't find local config file. File Name : /program/admin/index.php Error Code : err01 Time :18 Oct 2004, 07:19:44 pm PHP Fatal error: Call to undefined function: make_last_processes() in /home/main/public_html/app/program/admin/index.php on line 16 Line 16 is : make_last_processes(false); Help please. :) ___ Do you Yahoo!? Express yourself with Y! Messenger! Free. Download now. http://messenger.yahoo.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: From .txt to MySQL
roime puniran [EMAIL PROTECTED] wrote: My question is, how can I dump all the data from text file into mySQL without specifies the names of the text file..It's mean that, we only specifies the extention of text file (*.txt) then by that way i can dump all into mysql?... You can write a script to import all text files in php or MySQL. See http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html - this may 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: Tables and performance
Yves Arsenault [EMAIL PROTECTED] wrote: Does a very large number of tables in a database affect MySQL's performance? Strictly saying, yes. But the difference won't really matter. So read - no, it won't affect performance. -- 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: Unable top drop table, error 1051
Bug filled: http://bugs.mysql.com/bug.php?id=5784 Thank 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: Install Problem on Fedora Core 2 w/ ver 4.0.21
Jigal van Hemert [EMAIL PROTECTED] wrote: 040925 21:50:34 Warning: Asked for 196608 thread stack, but got 126976 Databases are installed. You can ignore the above warning. Egor, 1) A warning usually indicates an error that has limited impact on the system, but still an error! Well, not always and not in this case. This warning is shown in logs by default since .19 or .20 afair; but it existed in earlier versions, just not being shown. 2) Can you explain this warning and what to do to solve (and not supress) it? This issue shows up very regularly on this list and nobody here seems to have a clue what causes it... Because it's a minor warning with a recomendation to ignore it. :) Your question forwarded to developers. I will publish an answer here. -- 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 1033, still having major problems
Brian J.S. Miller [EMAIL PROTECTED] wrote: Does anyone have any ideas? This is killing me! In this case I may suggest you to buy a support and request a support incident. MySQL developers will recover your files manually if there is anything possible to recover. To buy a support contract, please follow the link in my signature. -- 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 Distributed database version
Look forward in documentation at http://dev.mysql.com/doc/ for Replication and MySQL Cluster sections. Hopefully one or both will be answer for 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: hostname-bin.001 Files
Rob Best [EMAIL PROTECTED] wrote: Okay, replying to my own post is like talking to one's self but... so I finally found the manual page that describes the two files. Any reason I want them (the log files that is)? My databases currently are not replicating (no plans to add it) and have many reads but few writes. If replication is not used and you don't need it, then remove log-bin from your configuration, then delete these log files. -- 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: show the row of last action like UPDATE or INSERT
Vincent Ghilardi [EMAIL PROTECTED] wrote: Is there a way to show the row of last action like UPDATE or INSERT ? Only for INSERT if there was an AUTO_INCREMENT value added. See http://dev.mysql.com/doc/mysql/en/Information_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: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
Jeremy Zawodny [EMAIL PROTECTED] wrote: And we've had good but limited experiences so far with 64 bit FreeBSD 5 on amd64 (also a quad w/32GB). Somewhere in this list I've seen controversial reports about FreeBSD/amd64. Seems like it's not yet stable and may give unpredictable performance behaviour, no? What's your opinion? Agreed. FreeBSD's production release is 4.10. The 5.x tree is still a work in progress, much like MySQL 4.1. We are speaking of AMD64 port, are we? -- 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: Connection Error
Phillip Mangwiro [EMAIL PROTECTED] wrote: I'm getting an Error 1130, (MyDNSName is not allowed to connect to this machine), whenever I try to connect to MySQL server from any client by using its IP or friendly DNS name other than 127.0.0.1 or localhost. This has happened on three machines so far, is there something I forgot to enable/disable? Are you sure that GRANTs are correct? Take a look at http://dev.mysql.com/doc/mysql/en/GRANT.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: Which file to backup
Luciano Barcaro [EMAIL PROTECTED] wrote: I'm trying to backup the 'binary log' and don't know which file is it. these are the files I see in my datadir -rw-rw 1 mysql users175K Sep 14 14:21 hrrgp01-bin.07 -rw-rw 1 mysql users345K Sep 14 15:03 hrrgp01-bin.08 -rw-rw 1 mysql users1.6M Sep 14 15:18 hrrgp01-bin.09 -rw-rw 1 mysql users3.9M Sep 15 09:06 hrrgp01-bin.10 -rw-rw 1 mysql users 29K Sep 15 09:11 hrrgp01-bin.11 -rw-rw 1 mysql users676K Sep 15 15:58 hrrgp01-bin.12 -rw-rw 1 mysql users4.4M Sep 16 11:10 hrrgp01-bin.16 -rw-rw 1 mysql mysql322M Sep 16 11:10 ibdata1 -rw-rw 1 mysql users 40M Sep 16 11:10 ib_logfile0 The thing is I intend to stop the server at a certain time and then make a backup copy of the actual binary log. But which is the name of the file I should use into my script? Backup *-bin.* and ib_logfile* if you use InnoDB. And don?t forget ibdata1 The question was about logs. -- 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: Upgrading MySQL. Caveats or Cautions anyone?
Tim Johnson [EMAIL PROTECTED] wrote: The simpliest way: Download and install MySQL Official Binary RPMs from www.mysql.com. They will install on your server and run fine. You'd also want to install the shared-compat RPM in case you have something compiled with older libmysqlclient. The link to read carefully: http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html Hello: Am currently using Ver 11.18 Distrib 3.23.58 on Linux 2.4.20-20.9. (RH 9.0). I'd like to upgrade to the current version. I would like to know if there are any cautions to observe, or any prepartory steps to take. If I look at the following URL: http://dev.mysql.com/downloads/mysql/4.0.html I see some things that confuse me a bit: I see this label: Linux (x86, glibc-2.2, static, gcc) ## Well, I've got glibc-2.3 And I see this label: Linux (x86, glibc-2.3, dynamic, Intel C++ Compiler) ## Well, glibc-2.3 looks good, *but* I don't have ## the Intel C++ Compiler. Just gcc (GCC) 3.2.2 Comments and pointers to docs would be appreciated. Thanks much tim -- 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: Eventual connection looses
See http://dev.mysql.com/doc/mysql/en/Server_system_variables.html You are interested in interactive_timeout and wait_timeout system variables. -- 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: libmysqlclient.so.10 is needed
Tim Johnson [EMAIL PROTECTED] wrote: Installing MySQL-server-4.0.21-0.i386.rpm on Red Hat 9.0 Getting the following: error: Failed dependencies: libmysqlclient.so.10 is needed by (installed) MySQL-python-0.9.1-6 libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3 libmysqlclient.so.10 is needed by (installed) php-mysql-4.2.2-17.2 I presume that I need other packages. What packages would that be? Install MySQL-shared-compat also. And you may safely add --nodeps to rpm if it will still fail -- 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 query performance test tool
Haitao Jiang [EMAIL PROTECTED] wrote: We want to test our MYSQL (4.1.4g) server's query performance, and I just wondering if there is a tool that enable us sending a list of queries over HTTP or JDBC repeatedly and gather/display the statistics? Honetsly, it's almost always better to write your own for your own application. It's not so complicated. See perl module WWW::Mechanize on cpan (http://search.cpan.org), it's a gift for HTTP test/benchmark development. :) -- 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: Unable top drop table, error 1051
Can you create a test case? I.e. a .sql file which is supposed to drop the table well but instead fails? This will help us determine if it's a bug and fix if it is. Thank 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: Duplicate Entries
Suresh [EMAIL PROTECTED] wrote: I am porting from 4.0.0-alpha-nt to 4.0.1-alpha-nt. In which i have a table with two primary key, my older mysql server insert all the records except the duplicate fields(Primary Key). Whereas in the new mysql server it exits whenever it sees a duplicate entry. How to resolve it ? INSERT IGNORE is a solution. And 4.0.1 is not a way to go - take the latest instead, because 4.0.1 is about three years old...:) -- 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: Clean Reinstall
FayeC SQL [EMAIL PROTECTED] wrote: rpm -qa | grep -i mysql then remove all MySQL packages, which are likely to be MySQL-shared, MySQL-server, MySQL-client and/or similar names if not the official RPMs where installed. To remove a package, do rpm --erase --force --nodeps packagename Then rm -rf /var/lib/mysql /etc/my.cnf /usr/local/mysql Ignore possible errors about the files/directories not existant, I'm just providing you a general idea of what to look for and delete. Then you may want to take a look around and see if there's something left over after MySQL removal: find / -name \*mysql\* Then after you are sure everything is deleted, install MySQL official binary RPMs from the scratch. And voila, clean MySQL is here. I am extremely frustrated with the root passwordproblem. I read the manual and followed the instructions but it just won't work. I tried setting a newpassword but then when I insert the new passoword it says the password it wrong. In any case...I want to uninstall MySQL and try a new clean install. What would be the procedure to do a VERY clean install? Thanks in advance, FayeC -- 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.1.5 FreeBSD 4.10 compile error
Unreal HSHH [EMAIL PROTECTED] wrote: Making all in sql make all-recursive Making all in share ../../extra/comp_err -C./charsets/ danish/errmsg.sys Usage: ../../extra/comp_err [-?] [-I] [-V] fromfile[s] tofile *** Error code 255 what's this error? Something wrong which is unclear what. comp_err syntax is broken. The Right Way(tm) to install MySQL on FreeBSD, is use the port /usr/ports/databases/mysql40-server Don't forget to add -DWITH_LINUXTHREADS=yes -DBUILD_OPTIMIZED=yes -- 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: libmysqlclient.so.10()(64bit) not found
Better download the official binaries from http://dev.mysql.com/downloads/mysql/4.1.html There are RPM builts for AMD64. -- 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: 4.1.3-5. Bugs alive!
Juri Shimon [EMAIL PROTECTED] wrote: Using 'int not null' make next enum (using cp1251) corrupted in mysqldump output on W2000. Is this a known issue? Spasibo, the bug is posted as http://bugs.mysql.com/bug.php?id=5728 I'm not sure if this is a known issue, but I let the developers investigate it out. -- 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: Two versions on same server?
Jim McAtee [EMAIL PROTECTED] wrote: The link to manual was already suggested, but I may also suggest you to try run the application on 4.0 anyway. It should work seamlessly. Can I run two different versions of MySQL on the same server? I've got a commercial application for which the vendor will only support MySQL 3.x and makes no guarantees if running MySQL 4. But I'd like to migrate a number of our own web applications to MySQL 4. My choices are take my chances with the other app, run MySQL on a second machine (not an option at the current time) or else run two instances of MySQL, different versions, both on the same machine. -- 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: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
Thank you for valuable feedback! -- 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 limit log space usage?
See http://dev.mysql.com/doc/mysql/en/PURGE_MASTER_LOGS.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: 4.1 client protocol?
Todd Gruben [EMAIL PROTECTED] wrote: I have an interesting problem. I have developed a custom mysql replication client that we use for monitoring our mysql database. Kinda like a poor man's trigger, but the power of an asynchronus trigger is very beneficial. Any way, I developed this client based on the 4.0 version of mysql. It appears that the network protocol has changed in 4.1. Is there any documentation of the 4.1 protocol, I figured the 4.0 protocol out from the code, but that was a very time consuming experience for me and i was hoping for a slightly higher level bit of documentation than c code. Does such a beast exist? Why not use libmysqlclient? -- 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: Which file to backup
Mauricio Pellegrini [EMAIL PROTECTED] wrote: I'm trying to backup the 'binary log' and don't know which file is it. these are the files I see in my datadir -rw-rw 1 mysql users175K Sep 14 14:21 hrrgp01-bin.07 -rw-rw 1 mysql users345K Sep 14 15:03 hrrgp01-bin.08 -rw-rw 1 mysql users1.6M Sep 14 15:18 hrrgp01-bin.09 -rw-rw 1 mysql users3.9M Sep 15 09:06 hrrgp01-bin.10 -rw-rw 1 mysql users 29K Sep 15 09:11 hrrgp01-bin.11 -rw-rw 1 mysql users676K Sep 15 15:58 hrrgp01-bin.12 -rw-rw 1 mysql users4.4M Sep 16 11:10 hrrgp01-bin.16 -rw-rw 1 mysql mysql322M Sep 16 11:10 ibdata1 -rw-rw 1 mysql users 40M Sep 16 11:10 ib_logfile0 The thing is I intend to stop the server at a certain time and then make a backup copy of the actual binary log. But which is the name of the file I should use into my script? Backup *-bin.* and ib_logfile* if you use InnoDB. -- 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 Mysql Security
Mike Bao [EMAIL PROTECTED] wrote: Last week, the all tables in one database had been deleted, which is second times since I upgrade my operation system from NT 4.0 to Server 2003. Before that, they had been deleted many times. I just copied all table files to one database(one directory). They will work normally. I don't know my operation is correct or not. And I want to get more suggestions about mysql security, more details better. Look forward to hearing from you, thanks lot. To ask a correct question you should know half of the answer. :) For your case, do FLUSH TABLES and LOCK TABLES before taking the files snapshot. Or, even better, use mysqlhotcopy. -- 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: Changing datatype of a large table's column
Wouter van Vliet [EMAIL PROTECTED] wrote: Would I be able to support the datatype change on this? And more generally; can somebody advice me on (maybe some other) strategy for changing the datatype? Actually it's easy, you just need to have free space to be able to convert from blob to longblob. And what I would advice: don't store images in MySQL. Store them in files, because filesystem is a DBMS specially designed to store files. :) Store the file names in 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: Query execution time?
joe mcguckin [EMAIL PROTECTED] wrote: Does the mysql server return to the client (DBI in this case) the query execution time? If so, how do I retrieve it? my $_startTime = time; $dbh-do(INSERT INTO dinner VALUES ('chicken','grille')); print Execution time: .(time - $_startTime).\n; Like 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: Installing DBIx::DWIW on CPAN
Sanjeev Sagar [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] DBIx-DWIW-0.41]# make test PERL_DL_NONLAZY=3D1 /usr/bin/perl -Iblib/lib -Iblib/arch test.pl 1..1 # Running under perl version 5.008 for linux # Current time local: Wed Sep 15 13:42:27 2004 # Current time GMT: Wed Sep 15 20:42:27 2004 # Using Test.pm version 1.23 Can't locate Time/HiRes.pm in @INC (@INC contains: blib/lib blib/arch = Any help will be highly appreciable. It's clear: install Time::HiRes. -- 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: root-password important?
Marten Lehmann [EMAIL PROTECTED] wrote: security problem? Is there any way to trick the mysql-server, so that a remote-client can claim to be a localhost-client and thus can connect as mysql-user root? 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: different max_connections based on users/host
Alberto Mucignat [EMAIL PROTECTED] wrote: I mean, suppose we have max_connections=500, is it possible to say that from all external clients there could be at max 490 connections, while a single host or user can have at max 10 connections? Obviously, if host who has reserved 10 connections uses a single connection each time, should always find a free connection to the server, even if all other servers have reserverd 490 connections. Of course, I did take a look at resources per hour features, but they don't fit my need, since I need a instant control, not a per hour control. Any hint? A dirty hint: write a script which will run SHOW PROCESSLIST each second and hmm.. enforce restrictions. Somehow, but not killing threads. -- 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 goes down when executing query
Mauricio Pellegrini [EMAIL PROTECTED] wrote: Hi, Sorry to disturb but Mysql 4.1.4 gamma goes down when executing this query. Please create a testcase and send it to me by email at [EMAIL PROTECTED] I will investigate and get back to you. Somehow looks like you've found a bug. -- 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: Force slave to connect from specified IP
Irek Slonina [EMAIL PROTECTED] wrote: I have two interfaces on my slave: ppp0 80.80.80.8 ( - Internet ) eth0 10.10.10.1 ( - LAN ) and remote master host 192.168.168.168 available by 80.80.80.8. How can I force mysql to start slave processes using 10.10.10.1 and not 80.80.80.8, which is he choosing by defualt. I need similiar behaviour like: ping -I 10.10.10.1 192.168.168.168 I have tried to bind mysqld only to 10.10.10.1:3336 by bind-address option but that does not make the thing. Correcting routes doesn't help? I can't surely understand what you need. To specify the source IP? -- 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 bringing up mysql on RHEL
Peter Flynn [EMAIL PROTECTED] wrote: manual, mysql_install_db gets run automatically when you do this, but I don't know what to look for as evidence that this has happened. Wrong way. Remove it and install MySQL official binary RPMs downloaded from www.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: Checking for live connections
Ruben Safir Secretary NYLXS [EMAIL PROTECTED] wrote: Is there a way of checking for live connections prior to using mysql_connect in the C API (asside from mysql_ping) Try to open a TCP connection to port 3306 of target server. If successful - then connections are live. Close that test connection correctly and then do mysql_connect. Just a first idea. -- 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: ft_min_word_len=2... YAY or NAY?
[EMAIL PROTECTED] wrote: I'm wondering whether or not I should implement fulltext searching for 2 letter words within a product database (HP, TV, G5, LG, etc)... My searchable text is currently about 600Mb and a 3-letter fulltext index is consuming about 420Mb. Is the trade-off for user convience vs. performance worth it? In general, how much will performance decrease? Or should I look for alternatives such as a 2-letter keyword table that I build on my own? Or do most of you just let 2-letter words slide? Building a keywords table is a more proper way I believe. But - try enabling 2-letters index first, it may not be a slowdown for 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: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
Dathan Vance Pattishall [EMAIL PROTECTED] wrote: I get permission from my bosses to release the benchmarks I will send it = to the list. Please! This definitely will be a valuable information for the community. -- 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: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
Jeremy Zawodny [EMAIL PROTECTED] wrote: I can verify that a quad opteron 2.2 runs about a million times better than a quad xeon 3.06. The opteron can handle more than 3 gigs of memory which is a 32 bit limitation. Right now in my quad opteron we have 32 gigs of memory and MySQL is using 16.8 gigs of the memory. We run fedora core 2, with the rpm built by MySQL. We don't run anything else any longer. And we've had good but limited experiences so far with 64 bit FreeBSD 5 on amd64 (also a quad w/32GB). Somewhere in this list I've seen controversial reports about FreeBSD/amd64. Seems like it's not yet stable and may give unpredictable performance behaviour, no? What's your opinion? -- 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: Which MySQL product should I choose for a comparison?
[EMAIL PROTECTED] wrote: I am doing a technical comparison between two products of which one is MySQL. But I don't exactly know which product that MySQL offers that I should pick. I am thinking of MaxDB, because it's supposed to be the most feature rice, but it does not seem to be MySQL but another product owned by other people. I am a bit confused. MaxDB is SapDB in the past. :) -- 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: delay_key_write usage
Paul DuBois [EMAIL PROTECTED] wrote: According to the documentation, when delay_key_write is active the index keys aren=92t written to disk until the table(s) are closed. When is a = table closed? Is it only when a connection is closed? When connection is closed, when FLUSH TABLES requested and probablt on COMMIT. I suspect COMMIT makes no difference, because delay_key_write applies only to MyISAM tables, which are non-transactional. Yes, you're right, mea culpa! :) -- 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: Lost connection to MySQL server during query bind-address
Marten Lehmann [EMAIL PROTECTED] wrote: Redhat Enterprise Linux 3, self-build mysql 4.0.20 (server and client). OKay, here's the problem - a self-built MySQL. Unfortunately, due to some glibc bugs it's not really possible to build a stable MySQL under linux using stock glibc... And the problems are like the one you are experiencing. I'd suggest you to download and install MySQL binary RPMs from www.mysql.com. I'm sure, the problem will disappear. -- 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 installing without the server
Juan Fernandez [EMAIL PROTECTED] wrote: I am trying to install mysql without the server on fedora: Don't install Fedora packages. Install binary packages downloaded from www.mysql.com in RPM format. You will probably need MySQL-shared and MySQL-client if you don't want the 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: Anyone else having trouble contacting MySQL AB?
Patrick Connolly [EMAIL PROTECTED] wrote: I've been trying to contact MySQL AB using the contact us link. I got a auto-response to the effect that I'd get a real reply in 2 days, but that was a week ago. My question was about a login that seems to also go into a black hole. Has anyone else experienced similar? Uncommon situation. Please try again. Which address you are writting 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: Lost connection to MySQL server during query bind-address
Marten Lehmann [EMAIL PROTECTED] wrote: I'm experiencing a strange thing: When bind is running without bind-address everything works fine. But when I'm doing a bind-address = ... the clients get Lost connection to MySQL server during query. I don't understand this, because ot worked once before and the ip-address the clients are connection to is the same as the one mentioned at bind-address= Do you have any ideas for that? Tell us the OS, the MySQL server and client version and the build information (custom or binary downloaded from MySQL.com). This *might* be a problem of resolver in glibc. -- 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: Implementing xml/xpath UDF with libxml2
Joel McConaughy [EMAIL PROTECTED] wrote: I'm trying to implement a UDF that supports xpath evaluation on a column using the gnome libxml2 library. The library is thread-safe EXCEPT for the initialization and deinitialization routines which need to be called on a pre-process basis. My question: I advise you to ask this questions in [EMAIL PROTECTED] Developers read the list and you will get the needed 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: Optimize index building
Haitao Jiang [EMAIL PROTECTED] wrote: We are using following steps to re-load and re-build a table every day: truncate the table disable index load data enable index What are the important parameters I should be watching out to make the ebale index step faster? Out table is over 10million rows and has two fulltext indexes. No need to move data back and forth. You can just run optimize table. See http://dev.mysql.com/doc/mysql/en/OPTIMIZE_TABLE.html Also see the myisam_max_sort_file_size and myisam_sort_buffer_size variables at http://dev.mysql.com/doc/mysql/en/Server_system_variables.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: delay_key_write usage
Dan Cumpian [EMAIL PROTECTED] wrote: According to the documentation, when delay_key_write is active the index keys aren=92t written to disk until the table(s) are closed. When is a = table closed? Is it only when a connection is closed? When connection is closed, when FLUSH TABLES requested and probablt on COMMIT. -- 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: License question
I have forwareded your question to [EMAIL PROTECTED] They will contact you soon. -- 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: Huge InnoDB data files (again)
Mayuran Yogarajah [EMAIL PROTECTED] wrote: Is there some way to trim the 50gb+ file down ? Yes, dump the databases using mysqldump, then recreate the autoextend InnoDB tablespace and then run the .sql script. -- 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: Perl with MySQL
Just go to http://dbi.perl.org/ You will need to download DBI and DBD::Mysql. Then you could install it manually, even no need to run the CPAN shell. -- 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 Compiling
Andrew Wheeler [EMAIL PROTECTED] wrote: I am not sure that this is the correct list. I did not see any list that seemed more appropriate. Private email answered here. Well if it compiling is not a configure, make, make install job perhaps you could point me in the direction to learn the intricacies of the job? First, see http://dev.mysql.com/doc/mysql/en/Installing_source.html And don't forget about glibc patch. -- 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.1.4 RPM Distribution startup problem
Egor Egorov [EMAIL PROTECTED] wrote: Then temporary give a+rw on /root/tmp (don't forget to +x /root) and see what's mysqld_safe gonna write there. Maybe it's a bug in the script. Also please check the environment for TMPDIR. After this mysql started successfully but it didn't write anything in /root/tmp. [] Does MySQL need rights to /root/tmp to work well? No. It's a weird behavior. I will investigate and get back to you. Igor, First, does the mysql user exists? Second, here is what Marko Makela told me about your situation: It's probably from innobase_mysql_tmpfile(), which is called two or three times at startup. That function relies on create_temp_file(). Has the MySQL configuration parameter tmpdir or the environment variable TMPDIR been set incorrectly, or is the default value somehow incorrect? Could it be that the directory /var/mysqltmp does not exist, and the fall-back value is incorrect? Maybe $HOME is pointing to /root, but mysqld is being run as a non-privileged 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 4.1.4 RPM Distribution startup problem
Igor Zinkovsky [EMAIL PROTECTED] wrote: Then temporary give a+rw on /root/tmp (don't forget to +x /root) and see what's mysqld_safe gonna write there. Maybe it's a bug in the script. Also please check the environment for TMPDIR. After this mysql started successfully but it didn't write anything in /root/tmp. [] Does MySQL need rights to /root/tmp to work well? No. It's a weird behavior. I will investigate and get back to 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: please explain why this query isn't optimized
David T-G [EMAIL PROTECTED] wrote: % Well, actually, there are 2.878 Meg rows, or 2878k. FYI, you're both right. Americans write numbers as x,xxx,xxx.xx while Europeans typically write them as x.xxx.xxx,xx (dot as thousands separator and comma as decimal separator). But programmers do write numbers as 0xEFD6A2F4 :))) -- 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: per user database size quota
Balazs Miklos [EMAIL PROTECTED] wrote: I would like to limit database sizes on my server on a per user basis. I haven't really found any information about this in the manual, neither in the list archive or on the web. Is there a way to do this? 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: Linking Mysql tables across databases
Rob Keeling [EMAIL PROTECTED] wrote: Is there a way to create a linked mysql table? I have one master database, which has a table of data I would like to use with three other projects, I want to try to avoid copying the data between three databases, or putting everything in one database, (which could have data protection problems). Is replication the solution for you? http://dev.mysql.com/doc/mysql/en/Replication.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 4.1.4 gamma - Install error
Mauricio Pellegrini [EMAIL PROTECTED] wrote: 040902 21:47:53 mysqld started 040902 21:47:53 [ERROR] Warning: Asked for 196608 thread stack, but got 126976 Despite that message, everything seems to be working just fine. Is that error something I should take care of? what is the cause ? Ignore 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: slow linux to windows connect
David Obwaller [EMAIL PROTECTED] wrote: I have a linux webserver (running apache2 with php4 module), which connects to a windows db server (mysql-4.1) for certain pages. There's also a db on the linux server. If a php script connects to the local mysql server everything runs fine and at normal speed. However, if php connects to the windows mysql server the connect takes very long. When the connection is established the queries run at normal speed again. Hey, that's Windows! :) Speaking seriously, first thing to check is DNS on Windows. Is it working? Can you backresolve IPs 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: Mysql openBSD Copying to tmp table
Mevershosting.nl [EMAIL PROTECTED] wrote: Anyone here have any qlue ? We had a couple of dissatisfactions trying to run MySQL on OpenBSD. See http://bulk.fefe.de/scalability/ -- 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: please explain why this query isn't optimized
Oops, haven't noticed that these are InnoDB tables. The behavior of optimization and even explain are much different for 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: tuning suggestion for large query
Sun, Jennifer [EMAIL PROTECTED] wrote: l consuming all my RAM and swap and being killed with error=20 'VM: kill= ing process mysql __alloc_pages: 0-order allocation failed (gfp=3D0x1d2/= 0)' I would like to find a startup parameter either for client or serv= er to limit per thread memory usage. =20 First, ensure that key_buffer is reasonable and takes, say, 50% of ram. Then for each new thread MySQL will try to allocate bulk_insert_buffer_size, read_rnd_buffer_size and sort_buffer_size. See also http://dev.mysql.com/doc/mysql/en/Server_system_variables.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: bad too many connections error (os x)
Michael Winston [EMAIL PROTECTED] wrote: Okay, so the first thing to try is obviously enlarge the max_connections. Have you tried this? Yes. It's set to 400 (a number we will never reach unless there's some sort of logjam). max_connect_errors is set to 200. Is it a webserver backend database? Yes. PHP-generated pages. pconnect? Apache limits? -- 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: Backing up directly to tape.
Tucker, Gabriel [EMAIL PROTECTED] wrote: I have been searching the archives and was unable to find an answer. I need the ability to backup MySQL instances directly to a tape device. Currently, I run a mysqldump to disk and have legato pick up the file. = As I get to some larger databases, hundred's of gigs, and higher = transaction rates, I will need an online solution that goes directly to = a tape device. Currently we are using MySQL table types, though this = may change. tar? mysqlhotcopy? -- 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 compiled with OpenSSL support in XP(not works)
Osmin Castillo [EMAIL PROTECTED] wrote: I'm having some problems connecting to the server under Winx XP with the openssl certificates. Checking the have_openssl variable says YES. When i try to connect with a user with the REQUIRE SSL grant I can't loggin and receive this error: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' Does your mysql client support SSL connections? -- 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: Installing MySQL 4.1 from RPM on Fedora2
Danesh Daroui [EMAIL PROTECTED] wrote: I have installed Server, Client, Benhcmark, Share, Embeded and = Compact-Share RPMs version 4.1 on a Fedora2 system. The have been = installed successfully but when I type: Shell mysql -u root it says that it can not open socket and I think it is because mysqld is = not alive. When I type: Shell mysqld it returns a fatal error and refers me to Security notes about = installation. Also, I thought that an user account which name is mysql = should be created automatically when RPMs are installed, but there is no = user account with name mysql !!! Please help me to fix the problem and = install mysql on my linux system. Maybe, you haven't removed the older mysql that comes with fedora? Let's clean your system. Save your data in a safe place, we will later remove the MySQL data directory. Issue rpm -qa | grep -i mysql And see what are the packages with mysql in it. Remove everything that has relation to MySQL itself (but of course, not packages like postfix-sasl-mysql or mod_php_mysql, etc). Ignore dependencies. After that, clean your system: remove /var/lib/mysql and delete the mysql user: userdel mysql Again, don't forget to save your data! Then do a fresh install of MySQL.com's downloaded packages. Install it like that: rpm --install -v -h MySQL*4.1.4*rpm That should 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: grant tables update backward compatibility
[EMAIL PROTECTED] wrote: I have been using mysql 3.23.58, and I want to upgrade to 4.0.20. My question is this: after I run the script to upgrade the grant tables to support the new privilgeges, can I then revert back to 3.23.58 seamlessly or will I need to readjust the grant tables. Thanks in advance. You can revert back to 3.23. MySQL will just ignore the new columns. -- 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: Is it possible to have Undeletable Records?
zzapper [EMAIL PROTECTED] wrote: Is it possible to have undeletable/unmodifiable records in a table of otherwise modifiable deleteable createable records? At present I do it at the Update/Delete level where I have clauses which prevent certain records being changed. I suppose I could also have an extra boolean field Record Read only, but is there anyway to specify at the data level? No, no such feature. -- 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 space - Different Question
Stuart Felenstein [EMAIL PROTECTED] wrote: InnoDB free: 10240 kB Does this mean the actual space provided for the records it can hold ? Approximately. -- 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 Compiling
Andrew Wheeler [EMAIL PROTECTED] wrote: I am not sure that this is the correct list. I did not see any list that seemed more appropriate. I have RedHat 8: gcc-3.2-7 You'd better take the binary distribution from www.mysql.com Compiling MySQL is absolutely not a configure; make; make install job. -- 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.1.4 RPM Distribution startup problem
Igor Zinkovsky [EMAIL PROTECTED] wrote: error log: 040902 21:47:53 mysqld started 040902 21:47:53 [ERROR] Warning: Asked for 196608 thread stack, but got 126976 /usr/sbin/mysqld: Can't create/write to file '/root/tmp/ibezxsoi' (Errcode: 13) mysql does not have permission to write to /root/tmp Why do you have the temp directory set here? I've wrote that I have following lines in my.cnf: [mysqld] tmpdir=/var/mysqltmp Then temporary give a+rw on /root/tmp (don't forget to +x /root) and see what's mysqld_safe gonna write there. Maybe it's a bug in the script. Also please check the environment for TMPDIR. -- 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]