Re: how to make MyISAM as default engine for MySQL 5.6.4?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 ? 2011?12?25? 01:04, Suresh Kuna ??: Hi, Try the 3 options available in the below URL option, i.e ignore built in innodb and set the default storage engine to another storage engine. http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#option_mysqld_ignore-builtin-innodb Thanks Suresh Kuna MySQL DBA 2011/12/24 Sharl.Jimh.Tsin amoiz.sh...@gmail.com hello,all: today,i download the latest source tarball of MySQL 5.6.x branch,and build it from source for myself. first,i configure it with WITH_INNOBASE_STORAGE_ENGINE:BOOL=OFF flag,after that,i start mysqld failed,it returns [ERROR] Unknown/unsupported storage engine: InnoDB error message. and i rebuild it with INNODB engine enabled,it works.but when i add |ignore-builtin-innodb| option to my.cnf file,and also make myisam as the default engine with default-storage-engine=MyISAM in my.cnf.the server start failed again,error is [ERROR] Unknown/unsupported storage engine: InnoDB. so,i just want to know that how to disable INNODB fully in 5.6.4,and make myisam default? any reply is wanted!! thanks~ -- Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) Using Gmail? Please read this important notice: http://www.fsf.org/campaigns/jstrap/gmail?10073. yes,as the doc said: As of MySQL 5.6.3, this option sets the storage engine for permanent tables only. To set the storage engine for TEMPORARY tables, set the default_tmp_storage_engine system variable. i also need to set default engine for TEMP tables by default_tmp_storage_engine option,then it works,thanks a lot. - -- Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) Using Gmail? Please read this important notice: http://www.fsf.org/campaigns/jstrap/gmail?10073. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJO9gkWAAoJEEYmNy4jisTjOVcH/jOwnMlQ/Q7TYMVMyZn0yzzG 8UPrBbWXnwr5Rm3NfP6hEyLpkDHzyf0WxxHPjwkQMcN3xq/KBSdiZ54vy4jVrnml gJ2yJ0Uf76u2Xwhqzcno1mKjON7ByGBoIteeAW0hh7ikEfnwGUhPbh63YZzIsAnp FGXvmUTWmdDNI6SChp56HiiH+EavUJ7El/4dvyu/AwqInsSf4hYmsQQRAM9Zr5aw w4QHLLXPyLphEhMb71DYwt63Meo4xXvaUGMVYQsE8JKfsAZgMn4PDVyWmUCaA/CO teUILOrDgmfM0m/n2uywu+uQW8DYVDoEwNdxduEpiyFoHRbebha74LV7XUWdW1M= =aOuj -END PGP SIGNATURE-
Re: DBA MySQL Job Spain
在 2011-10-31一的 09:40 +,Garcia, Monica写道: Hello people, We are looking for a MySQL DBA, based in Malaga (Spain). If you have 5+ years experience administering MySQL and you are interested in join an international company, please send your CV in english to: monica.gar...@hays.es. Salary from 40k and different employee benefits. English fluent is required and Spanish is a plus. This job is in-situ, not remote, you will working at the company in Málaga. * Disclaimer This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it. If you have received this email in error, please delete the email and any attachments immediately and notify the Hays plc group of companies (“Hays”) helpdesk at hsrsupp...@hays.com. Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is your responsibility as recipient to ensure that the opening or other use of this message and any attachments will not adversely affect your systems. Hays accepts no responsibility for damage caused by viruses and you should, therefore, carry out such virus and other checks as you consider appropriate. Hays plc is registered in England and Wales with company number 2150950. Hays plc’s registered office is at 250 Euston Road, London NW1 2AF. Opt Out (where applicable) Should you wish to opt out of receiving further information about our services, please email customerserv...@hays.com to unsubscribe or alternatively write to our Customer Helpline Team at the following address: Hays Specialist Recruitment Limited, 1st Floor Atlas House 173 Victoria Street London SW1E 5NA. To update your contact details or relevant information, please contact the sender. * you send it again? -- Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) Using Gmail? Please read this important notice: http://www.fsf.org/campaigns/jstrap/gmail?10073. signature.asc Description: This is a digitally signed message part
Re: problem with table
在 2011-10-31一的 16:18 +0530,nataraj 0102写道: Hello, I am using MYSQL database with Linux server. I have a problem with one table, when I tried to get the data from that table, I am getting error : “mysql error 4600: mysql server gone away. No connection, trying to re-connect” …. This error message getting and cursor getting stuck in next line…..mysql prompt does not appear. When “*check table tablename; “ * same problem getting….. And also When I tried to describe the table : “*desc tablename*;” its working properly on the same table…. Plz ……….. any one can help…. see here,http://dev.mysql.com/doc/refman/5.1/en/gone-away.html may it -- Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) Using Gmail? Please read this important notice: http://www.fsf.org/campaigns/jstrap/gmail?10073. signature.asc Description: This is a digitally signed message part
Re: How to dynamically create database and tables on mysql?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 2011年10月21日 16:05, 王科选 wrote: Hi, Is there any way to dynamically create database and tables on mysql? For example, if I want to create 100 databases(dbname is unknown until run time), with 100 predefined tables in it, how to achieve that? Thanks in advance! do it in programme language or SQL procedure. - -- Best regards, Sharl.Jimh.Tsin (From China *Obviously Taiwan INCLUDED*) Using Gmail? Please read this important notice: http://www.fsf.org/campaigns/jstrap/gmail?10073. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJOo82/AAoJEEYmNy4jisTjjIoH/R/BPe/skwMVoMmcAelJBQgD 8U1zDtcQu9O5JgQduci4OTodAUnYLYHbqzfqyQw1bom7gWK4Y+EigA9yzh2UENvi L/A5Gg5+bg+GD1LLpjUB0X6U44UzrFHKtOJsArGOou6bJ2n542ttN69RsbEQ7hVB HJenu7P32d6GNc41OjNNSwshoADmzdESG0/DzzrAbmSXRdQZBbrp5JxeiWNqytmX yqADFGbNxVKWn1ubBjNmIRpuMASf30qcxhChrl6Zj0LBt8w+173lKsK8OdqeyXFH O0Uzq4T3d4a2PtMyAiPyAxSJIoUN/djBruUKq/PLj/Sdtt60OBD5XdhMiMeeOHU= =pcDY -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL-devel.tar.gz Availability
在 2011-10-13四的 11:25 -0400,Nick Khamis写道: Hello Everyone, I was wondering if the MySQL devel files tar was available for download? I was only able to find rpm on the mysql site. Thanks in Advance, Nick. download the RPM package,unpack it,then you own it. BTW,MySQL only provide full-source package in tarball format(tar.bz2| gz). -- Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) Using Gmail? Please read this important notice: http://www.fsf.org/campaigns/jstrap/gmail?10073. signature.asc Description: This is a digitally signed message part
Re: MySQL 5.6
在 2011-09-29四的 21:29 +0100,Tompkins Neil写道: Hi Does anyone know when the production release of MySQL 5.6 will be out ? Thanks Neil no idea,maybe you could find some useful info from http://forge.mysql.com/wiki/Development_Cycle. -- Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) Using Gmail? Please read this important notice: http://www.fsf.org/campaigns/jstrap/gmail?10073. signature.asc Description: This is a digitally signed message part
Re: build mysql 5.5.15 err
在 2011-08-16二的 16:18 +0800,linshengke写道: hi all, hear is basic information [root@localhost mysql-5.5.15]# uname -a Linux localhost.localdomain 2.6.18-128.el5 #1 SMP Wed Jan 21 10:44:23 EST 2009 i686 i686 i386 GNU/Linux [root@localhost mysql-5.5.15]# rpm -qa | grep gcc libgcc-4.1.2-50.el5 gcc-c++-4.1.2-50.el5 gcc-4.1.2-50.el5 [root@localhost mysql-5.5.15]# rpm -qa | grep bison bison-2.3-2.1 cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DWITH_EXTRA_CHARSETS:STRING=utf8,gbk \ -DWITH_MYISAM_STORAGE_ENGINE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_MEMORY_STORAGE_ENGINE=1 \ -DWITH_READLINE=1 \ -DENABLED_LOCAL_INFILE=1 \ -DMYSQL_DATADIR=/var/mysql/data \ -DMYSQL_USER=mysql \ -DWITH_DEBUG=1 then i run make get folling errors cc1: warnings being treated as errors /tmp/mysql_soft/mysql-5.5.15/strings/ctype-ucs2.c:50: 警告:‘lfactor’ 定义后未使用 make[2]: *** [strings/CMakeFiles/strings.dir/ctype-ucs2.c.o] 错误 1 make[1]: *** [strings/CMakeFilDBbA87V someone please give me some instruction? thanks 2011-08-16 andy see:cc1: warnings being treated as errors,so compile stopped. -- Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) Using Gmail? Please read this important notice: http://www.fsf.org/campaigns/jstrap/gmail?10073. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: PHP Generator for MySQL 11.4 released
really? that's too bad :-( Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2011/4/29 Jan Steinman j...@bytesmiths.com: One thing they don't bother to tell you until you complete a useless download and discover that you can't open the file: this tool is Windows-only. On 28 Apr 11, at 18:02, mysql-digest-h...@lists.mysql.com wrote: From: Sharl.Jimh.Tsin amoiz.sh...@gmail.com Date: 26 April 2011 18:33:04 PDT To: SQL Maestro Team sql.maes...@gmail.com Cc: mysql@lists.mysql.com Subject: Re: PHP Generator for MySQL 11.4 released very useful tool,is it free? Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) Almost all absurdity of conduct arises from the imitation of those whom we cannot resemble. -- Samuel Johnson Jan Steinman, EcoReality Co-op -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=amoiz.sh...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Запрос
no need to translate it on a separate page,if you use the googlemail and enabled the instant-translate function in labs,you can easy to do it with one click. Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2011/4/28 Fish Kungfu fish.kun...@gmail.com: It's an Earth language. But I know what you mean. :-) The Google translator works great btw. http://translate.google.com/ Cheers! ~~Fish~~ 2011/4/28 Pintér Tibor tib...@tibyke.hu On 04/28/2011 12:40 PM, Johan De Meersman wrote: Я предлагаю более отчетливо английски применения :-p could you guys stop talking alien language on the list, please? t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=fish.kun...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: PHP Generator for MySQL 11.4 released
very useful tool,is it free? Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2011/4/26 SQL Maestro Team sql.maes...@gmail.com: Hi! SQL Maestro Group announces the release of PHP Generator for MySQL 11.4, a powerful GUI frontend that allows you to generate feature-rich CRUD web applications for your MySQL database. http://www.sqlmaestro.com/products/mysql/phpgenerator/ Online demo: http://demo.sqlmaestro.com/ PHP Generator for MySQL comes in both Freeware and Professional editions. The feature matrix can be found at http://www.sqlmaestro.com/products/mysql/phpgenerator/feature_matrix/ Please note that before the end of April 2011 you can purchase Professional Edition of PHP Generator for MySQL as well as all other our products and bundles with a 20% discount. Top 10 new features: 1. Multi-level auto-complete editors based on cascading drop-down lists. 2. Editing and inserting data in modal dialogs. 3. Pre-defined client-side validators including Range, Email, and more. 4. Fixed header for data grid and line numbers for grid records. 5. Time edit control. 6. Masked edit control to restrict data input. 7. Grid footers to display summaries (Sum, Average, Count, etc). 8. Excluding certain files from the output. 9. Template-based lookup editors. 10.Generating image thumbnails on the fly. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/php_generators_updated_to_11_4/ Background information: --- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=amoiz.sh...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Install Error - How to Fix
in windows command,run sc delete SERVICENAME. Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2011/1/15 AndrewMcHorney andrewmchor...@cox.net: Hello At one time I had (or at least partially) installed mysql on my laptop. I went to install a new version and I am getting the following error: A windows service with the name MySql already exists. Please uninstall this service correctly or choose a different name for the new service. How do I uninstall this service? Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=amoiz.sh...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: my.cnf file
rpm -qpi mysql*.rpm | grep my.cnf Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2010/12/30 Lydia Rowe ly...@lydiarowe.com: find / -name my.cnf -- Lydia On Thu, 2010-12-30 at 11:09 -0200, Wagner Bianchi wrote: I am seeing you're using an operate system based on Red Hat distro. Well, after install MySQL via yum or via rpm packages, the location of MySQL samples configuration file usually is /usr/share/mysql. After to check the existence of sample configuration files (my-huge.cnf, my-large.cnf, my-medium.cnf ...), use linux command line cp to copy it to /etc or /etc/mysql and restart mysqld. Could you check it? Best regards. -- Wagner Bianchi 2010/12/30 andrew.2.mo...@nokia.com Adam, you should look upon this as an opportunity to write a my.cnf that suits your application and hardware. Understanding the options in this configuration can be paramount to a well tuned server. a few resources to kick it all off... http://dev.mysql.com/doc/refman/5.1/en/mysqld-option-tables.html http://dev.mysql.com/tech-resources/articles/mysql_intro.html#SECTION000150 http://ronaldbradford.com/blog/tag/my-cnf/ Andy From: ext Adarsh Sharma [adarsh.sha...@orkash.com] Sent: 30 December 2010 06:37 To: mysql@lists.mysql.com Subject: my.cnf file Dear all, I am able to install Mysql-5.1.4 o a Linux Machine without any error. All is working fine. But I am searching a file my.cnf which is most important and is used in mysql but cannot able to find it. I install mysql by yum install mysql-server and yum install mysql-client commands. I find only a folder in /var/lib/ i.e mysql folder that contains ibdata and database folder plus .sock and .err file. After some research i find default path of my.cnf is /etc/my.cnf, /etc/mysql/my.cnf, /var/lib/mysql/my.cnf. But couldn,t locate it as it is needed for changing data dirs. Please help. Thanks Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=andrew.2.mo...@nokia.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=wagnerbianch...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=amoiz.sh...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Another replication question
really really a little noisy. 这下犯众怒了吧,招人烦了~ 囧 Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2010/12/29 杨涛涛 david.y...@actionsky.com: Ok, I'll not post any more! Just reading! David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com 在 2010年12月23日 下午8:14,Johan De Meersman vegiv...@tuxera.be写道: Glad to hear I'm not the only one annoyed :-) I've plonked him in the meantime. 2010/12/23 Jorg W Young jorgwyoung...@gmail.comjorgwyoung%2...@gmail.com jorgwyoung%2...@gmail.com jorgwyoung%252...@gmail.com This guy has been saying nothing meaningful on this list, but advertise his blog everywhere. Just be shame. He should be kicked out from the list. Jorg. 2010/12/23 杨涛涛 david.y...@actionsky.com: This way is very well, but it has to do lots of human work. David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Error while running Mysql
check the error log,and you know the 5.5.8 enable the innodb by default,make sure that you have enough RAM. Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2010/12/23 Krishna Chandra Prajapati prajapat...@gmail.com: HI Adarsh, Try memtester command #memtester 5 1 It' a linux tool to check ram for errors. http://krishna-mysql.blogspot.com/2010/12/faulty-physical-ram.html Krishna On Thu, Dec 23, 2010 at 6:08 PM, Adarsh Sharma adarsh.sha...@orkash.comwrote: Dear all, I am able o successfully build Mysql 5.5.8 from its source code on CentOS but when I issued the following command , it doesn't shows the mysql prompt, there is no error in log file. [r...@ws-test mysql-5.5.8]# bin/mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.5.8 Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Segmentation fault [r...@ws-test mysql-5.5.8]# Don't know what to do.Please help. Thanks Regards Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL 5.5.8 GA's library files have not version information by default?
hi,everyone today, i installed the MySQL 5.5.8 from source tarball,everything looks like OK. and when i try to start PHP-FPM process,the error printed below: [r...@powerpc mysql-5.5.8]# php-fpm php-fpm: /usr/local/mysql/lib/libmysqlclient.so.16: no version information available (required by php-fpm) i do not know how to solve it, does anyone hit it?want help ,thanks Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysql 5.5.x -- when is it going to go GA?
not sure,maybe help to you: http://forge.mysql.com/wiki/Development_Cycle#GA_releases Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2010/12/15 Hank hes...@gmail.com: Mysql 5.5 -- when is it going to go GA? And when it does, which version will it be? 5.5.8 or 5.5.6rc? Thanks, -Hank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Out of memory error
upgrade to the lastest MySQL 5.1.x branch GA and try again. Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2010/11/4 김수영 old...@posbank.co.kr: Dear MySQL users, I got an Out of memory error message on server yesterday. I restarted mysqld, and everything was go back to normal and now is fine. It happened already twice in this weekend even. But I don't know what's wrong. Server has QuadCore Xeon CPU, 4G ECC RAM, 2G x 49(ea) ibdata files, mostly based on using InnoDB typed tables. Below is server condition details. [r...@svr40 mysql]# ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 77824 max locked memory (kbytes, -l) 32 max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 10240 cpu time (seconds, -t) unlimited max user processes (-u) 77824 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited [r...@svr40 mysql]# uname -a Linux svr40.hsl.co.kr 2.6.18-164.11.1.el5PAE #1 SMP Wed Jan 20 08:16:13 EST 2010 i686 i686 i386 GNU/Linux [r...@svr40 mysql]# cat /etc/redhat-release CentOS release 5.4 (Final) [r...@svr40 mysql]# rpm -qa | grep MySQL MySQL-devel-community-5.1.42-0.rhel5 MySQL-client-community-5.1.42-0.rhel5 MySQL-server-community-5.1.42-0.rhel5 [r...@svr40 mysql]# tail -50 svr40..err 101103 15:12:25 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 bytes) 101103 15:12:25 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 bytes) 101103 15:12:25 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 bytes) 101103 15:12:25 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 bytes) 101103 15:12:28 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095116 bytes) 101103 15:12:38 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 bytes) 101103 15:12:38 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 bytes) 101103 15:12:42 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095236 bytes) 101103 15:12:43 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095584 bytes) 101103 15:12:45 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 bytes) 101103 15:12:45 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 bytes) 101103 15:12:47 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095200 bytes) 101103 15:12:51 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095116 bytes) 101103 15:13:12 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095120 bytes) 101103 15:13:16 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 bytes) 101103 15:13:16 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 bytes) 101103 15:13:19 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095120 bytes) 101103 15:13:22 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095548 bytes) 101103 15:13:23 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 bytes) 101103 15:13:23 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 bytes) 101103 15:13:28 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095548 bytes) 101103 15:13:32 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 bytes) 101103 15:13:34 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095500 bytes) 101103 15:13:38 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095548 bytes) 101103 15:13:38 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095392 bytes) 101103 15:13:40 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095120 bytes) 101103 15:13:40 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095120 bytes) 101103 15:13:41 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 bytes) 101103 15:13:41 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 bytes) 101103 15:13:45 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095548 bytes) 101103 15:13:49 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095200 bytes) 101103 15:13:51 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095128 bytes) 101103 15:13:51 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095284 bytes) 101103 15:13:52 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095548 bytes) 101103 15:13:57 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095128 bytes) 101103 15:13:57 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095284 bytes) 101103 15:14:02 [Note] /usr/sbin/mysqld: Normal shutdown 101103 15:14:02 [Note] Event Scheduler: Purging the queue. 0 events 101103 15:14:04 InnoDB: Starting shutdown... 101103 15:14:08 InnoDB: Shutdown completed; log sequence number 10 437654676 101103 15:14:08 [Note] /usr/sbin/mysqld: Shutdown complete 101103 15:14:08 mysqld_safe mysqld from pid file /var/lib/mysql/svr40.xxx.pid ended
Re: How to Install mysql from source
you should read the INSTALL file more patient,and know the difference between prefix exec-prefix. Best regards, Sharl.Jimh.Tsin (From China) 2010/10/18 ml ml mliebher...@googlemail.com: Hello List, i am trying to install mysql on debian lenny from source. Here is what i did (yes, i did read the INSTALL-SOURCE): ./configure --prefix=/usr/local/mysql/ make -j 4 make install cp support-files/my-medium.cnf /etc/my.cnf cd /usr/local/mysql chown -R mysql . chgrp -R mysql . bin/mysql_install_db --user=mysql FATAL ERROR: Could not find mysqld The following directories were searched: /usr/libexec /usr/sbin /usr/bin If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. == Okay, this my make some sense. Whats the _correct_ way to solve this? Which mysql_install_db options do i need here? bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ Installing MySQL system tables... 101018 11:50:13 [ERROR] /usr/local/mysql//libexec/mysqld: unknown option '--skip-bdb' 101018 11:50:13 [ERROR] Aborting 101018 11:50:13 [Note] /usr/local/mysql//libexec/mysqld: Shutdown complete Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. == Why does it also log to /var/lib/mysql ? find /var/lib/mysql/ /var/lib/mysql/ /var/lib/mysql/mysql /var/lib/mysql/test /var/lib/mysql/mysql-bin.index Cheers, Mario -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=amoiz.sh...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Access denied with mysqladmin
On 2010年09月24日 16:11, Ma Xiaoming wrote: Dear all, I have installed the MySQL version 5.1.50 with complete installation. After the installation process is finished and the configuration is done, when I run 'mysqladmin' with option 'version' in prompt, I got the following error message: -- C:\Program Files\MySQL\MySQL Server 5.1\binmysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)' -- Why do I get this result? Thanks. Best Regards Xiaoming As the console print,do you enter the password for user ODBC correctly? ODBC用户密码不对,说的很明显. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Error on compile MySQL with version 5.5.6 rc
On 2010年09月24日 16:27, Joerg Bruehe wrote: Hi Sharl! Sharl.Jimh.Tsin wrote: hi,everyone i try to compile and install mysql from source tarball,but i failed again again. this is my config string: [r...@powerpc mysql-5.5.6-rc]# ./configure --prefix=/usr/local/mysql --exec-prefix=/usr/local --sysconfdir=/etc/sysconfig/mysql --localstatedir=/var --enable-profiling --disable-largefile --disable-ipv6 --with-unix-socket-path=/tmp/mysql.socket --with-mysqld-user=mysql --with-zlib-dir=bundled --without-docs --without-man --with-low-memory --with-system-type --with-machine-type config-l.log the configure returns some warnings which i think can be simple ignored. /usr/bin/nm: old_atexit.o: no symbols /usr/bin/nm: udiv_qrnnd.o: no symbols /usr/bin/nm: mp_clz_tab.o: no symbols /usr/bin/nm: getopt_init.o: no symbols /usr/bin/nm: get_child_max.o: no symbols /usr/bin/nm: init-posix.o: no symbols /usr/bin/nm: lseek64.o: no symbols /usr/bin/nm: oldgetrlimit64.o: no symbols /usr/bin/nm: libc_multiple_threads.o: no symbols /usr/bin/nm: getutmpx.o: no symbols I don't think you can ignore them. To me, it looks like you have a severe inconsistency on your system: .o files should always contain symbols in a format which nm understands. I have never seen such a symptom before, so my speculations are that either your .o files or your nm do not really match your platform. Have you searched the internet for similar reports? /bin/rm: cannot remove 'libtoolT': No such file or directory I have seen this one, AFAIK it is an indication that your autotools installation is not really working. See these bug reports: http://bugs.mysql.com/bug.php?id=47411 http://bugs.mysql.com/bug.php?id=50067 then, make mysql with make command. and the ERROR appeared. mi_static.c:40: error: conflicting types for 'myisam_max_temp_length' ../../include/myisam.h:254: error: previous declaration of 'myisam_max_temp_length' was here make[2]: *** [mi_static.o] Error 1 make[2]: Leaving directory '/root/mysql-5.5.6-rc/storage/myisam' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory '/root/mysql-5.5.6-rc/storage' make: *** [all-recursive] Error 1 i really do not know what is wrong,want your help!!! Have you searched our bugs database? Your error message is identical to one I commented on Wednesday, see here: http://bugs.mysql.com/bug.php?id=56928 HTH, J�rg No match my platform? my vps is centos 5 x86 system,maybe it is the most common system. [r...@powerpc mysql-5.5.6-rc]# uname -a Linux PowerPC 2.6.18-194.8.1.el5.028stab070.5 #1 SMP Fri Sep 17 19:10:36 MSD 2010 i686 i686 i386 GNU/Linux Have you searched the internet for similar reports? Yes,of course. for example:http://forums.mysql.com/read.php?117,267696,267696 but the way how to fix it was no found. your autotoolsinstallation is not really working thanks.i will check it later. Have you searched our bugs database. yes,and goto the bug #56928.any useful tip no found there. thanks again,and how to resolve it? -- Best regards, Sharl.Jimh.Tsin(From China)
Error on compile MySQL with version 5.5.6 rc
hi,everyone i try to compile and install mysql from source tarball,but i failed again again. this is my config string: [r...@powerpc mysql-5.5.6-rc]# ./configure --prefix=/usr/local/mysql --exec-prefix=/usr/local --sysconfdir=/etc/sysconfig/mysql --localstatedir=/var --enable-profiling --disable-largefile --disable-ipv6 --with-unix-socket-path=/tmp/mysql.socket --with-mysqld-user=mysql --with-zlib-dir=bundled --without-docs --without-man --with-low-memory --with-system-type --with-machine-type config-l.log the configure returns some warnings which i think can be simple ignored. /usr/bin/nm: old_atexit.o: no symbols /usr/bin/nm: udiv_qrnnd.o: no symbols /usr/bin/nm: mp_clz_tab.o: no symbols /usr/bin/nm: getopt_init.o: no symbols /usr/bin/nm: get_child_max.o: no symbols /usr/bin/nm: init-posix.o: no symbols /usr/bin/nm: lseek64.o: no symbols /usr/bin/nm: oldgetrlimit64.o: no symbols /usr/bin/nm: libc_multiple_threads.o: no symbols /usr/bin/nm: getutmpx.o: no symbols /bin/rm: cannot remove `libtoolT': No such file or directory then, make mysql with make command. and the ERROR appeared. mi_static.c:40: error: conflicting types for ‘myisam_max_temp_length’ ../../include/myisam.h:254: error: previous declaration of ‘myisam_max_temp_length’ was here make[2]: *** [mi_static.o] Error 1 make[2]: Leaving directory `/root/mysql-5.5.6-rc/storage/myisam' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/root/mysql-5.5.6-rc/storage' make: *** [all-recursive] Error 1 i really do not know what is wrong,want your help!!! Many Thanks, Sharl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org