Re: Mysql error causing database to not accept threads

Note that some of the memory settings are per connection, if you have 63 connections, you may have up to 63 copies of the buffers, and you have pretty huge buffers even with 30GB of memory. Join buffers close to 1 G, tmp_table_size of 2 G, 63 connections could mean upto 63 copies of these,

Re: 2 servers 1 common data base

anderen Kommunikationsweg zu benennen. Für viele der Dateien, die Sie von uns erhalten, benötigen Sie zum Betrachten den Acrobat Reader, den Sie hier erhalten können. http://www.adobe.de/products/acrobat/readstep2.html GF: Benedikt Schackenberg und Christian Peiter AG Sitz: Mainz am Rhein

Re: Render row without duplicates

Am 02.01.2010 13:43, schrieb bharani kumar: No Duplicate records, select hospital1code from *yourtable* grop by hospital1 -- 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 server is not starting

/products/acrobat/readstep2.html GF: Benedikt Schackenberg und Christian Peiter AG Sitz: Mainz am RheinHandelsregister: HR-B 8608 Umsatzsteuer ID: DE126633578 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: mysql server is not starting

Benedikt Schackenberg schackenb...@termindoc.de mailto:schackenb...@termindoc.de Check that your my.ini or my.cnf has the correct entry for the Basedir option. F.A.I.Z.A.L schrieb: hi iam trying to start mysql services but it showing error. while i start

Re: mysql server is not starting

. it ask me to run mysql_upgrade. why it is asking .. any idea Best Regards Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com 2009/11/11 Benedikt Schackenberg schackenb...@termindoc.de mailto:schackenb...@termindoc.de Check that your my.ini or my.cnf has

Re: mysql server is not starting

://oradbapro.blogspot.com 2009/11/11 Benedikt Schackenberg schackenb...@termindoc.de hi, exists this folder on your System? /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit F.A.I.Z.A.L schrieb: hi thanks for your reply,, i can see

AW: why different users get different count(*) from same table?

Check your rights ;) -Ursprüngliche Nachricht- Von: jinava [mailto:jin...@gmail.com] Gesendet: Mittwoch, 1. Juli 2009 14:52 An: mysql@lists.mysql.com Betreff: Re: why different users get different count(*) from same table? Hi experts, Something strange here, use root and mysql (root

AW: creating databases in different folders

You can configure it in the my.cnf file: there you can set the data directory. -Ursprüngliche Nachricht- Von: Foo JH [mailto:jhfoo...@extracktor.com] Gesendet: Dienstag, 2. Juni 2009 05:00 An: mysql@lists.mysql.com Betreff: creating databases in different folders Hi all, I'm using

AW: AW: creating databases in different folders

: Re: AW: creating databases in different folders Benedikt Schackenberg wrote: You can configure it in the my.cnf file: there you can set the data directory. Thanks for the quick reply. My concern is that setting the data directory puts ALL databases in that folder. What I plan to do is to put

AW: AW: creating databases in different folders

Thx john !! i can use this :) -Ursprüngliche Nachricht- Von: John Daisley [mailto:john.dais...@mypostoffice.co.uk] Gesendet: Dienstag, 2. Juni 2009 17:10 An: Jerry Schwartz Cc: john.dais...@butterflysystems.co.uk; 'Foo JH'; schackenb...@termindoc.de; mysql@lists.mysql.com Betreff: RE:

AW: Recover data without logs

O think not, did you make dumps of your database? If not you have to use bin-log -Ursprüngliche Nachricht- Von: Weitao Liu [mailto:liuwt...@gmail.com] Gesendet: Sonntag, 31. Mai 2009 10:13 An: mysql@lists.mysql.com Betreff: Recover data without logs I had deleted some important data