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, and

Re: 2 servers 1 common data base

ns einen 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: Ma

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

amssys 512 Nov 11 12:28 tools > > > Best Regards > Faizal S > GSM : 9840118673 > Blog: http://oradbapro.blogspot.com > > > 2009/11/11 Benedikt Schackenberg > >> hi, >> exists this folder on your System? >> >> >> /var/LRM-I

Re: mysql server is not starting

s is not in /usr/local/mysql.. > > if u see my error log. 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

Re: mysql server is not starting

> GSM : 9840118673 > Blog: http://oradbapro.blogspot.com > > > 2009/11/11 Benedikt Schackenberg <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

Re: mysql server is not starting

le 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 RheinHandelsregister: HR-B 8608

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 and

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

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

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 My

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 from