Date: Wed, 4 Mar 2015 14:04:55 +0100
From: vegiv...@tuxera.be
To: lu...@lambrate.inaf.it
CC: mysql@lists.mysql.com
Subject: Re: Users and Groups
That reminds me, this may be of interest:
http://www.percona.com/blog/2015/03/02/emulating-roles-percona-pam-plugin-proxy-users/
MGtrès
)
{ // start while
$row = mysqli_fetch_array($res); //get the NEXT
record from the resultset $res
$rowcount = $rowcount + 1;
}
} //end res!=null
} //end $con!=null
Martin Gainty
Check_time: NULL
Collation: latin1_swedish_ci
Checksum: NULL
Create_options: partitioned
Comment:
1 row in set (0.24 sec)
Thanks and Regards,
Ajay
On Sat, Sep 6, 2014 at 8:06 PM, Martin Gainty mgai...@hotmail.com wrote:
Date: Sat, 6 Sep 2014 14:26:22 +0530
Subject
Date: Sat, 6 Sep 2014 14:26:22 +0530
Subject: Query on some MySQL-internals
From: ajaygargn...@gmail.com
To: mysql@lists.mysql.com
Hi all.
We are facing a very strange scenario.
We have two mysql-instances running on the same machine, and they had
been running functionally fine
From: m.ton...@upscene.com
To: j...@ecoreality.org; mysql@lists.mysql.com
Subject: Re: database developer tool Database Workbench 5 now available
Date: Fri, 5 Sep 2014 07:57:37 +0200
Hello Jan, list,
From: Martijn Tonies (Upscene Productions) m.ton...@upscene.com
Database
Jim/Jaime
What engine are you implementing?/
Qual mecanismo de MySQL que você está implementando?
Saludos desde Sud America
Martín
Date: Wed, 20 Aug 2014 13:54:46 -0300
Subject: Re: inconsistent optimization
From: edua...@gerencianet.com.br
To: j...@lowcarbfriends.com
CC:
CC: vegiv...@tuxera.be; mysql@lists.mysql.com
From: wagnerbianch...@gmail.com
Subject: Re: Proxy / connected failover question
Date: Wed, 9 Jul 2014 08:31:05 -0300
To: walterh...@olindata.com
I like HAProxy as well as it simplifies many of the things you seem to be
looking for.
--
Start Here to analyze your tables
Martin Gainty
I would recommend start Here to analyze your tables:
http://dev.mysql.com/doc/refman/5.1/en/analyze-table.html
Once you have evidence of FTS or unbalanced index entries then optimise
http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html
Martin Gainty
To add to Admiral Nelsons observations
As your database grows your options are to either scale up (boost Memory and
Disks) or scale out (add more MySQL nodes)
If you want to add MySQL additional nodes (without incurring resultant)
downtime you may wish to consider MySQL Clustering
We are unable to solve your problem unless you can display
1)all Foreign Key relationships indicating how one Table-column can access
Primary key of another table2)It is impossible to aggregate PriceOfBook
information thru SUM or any other aggregator function(s) since PriceOfBook
column is
indian spammer
please take me off your list
*Warm Regards*
__
Verzicht und Vertraulichkeitanmerkung
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte
in a mySQL statement the values are displayed BEFORE assignments are made
Ciao,
No MAS
__
Per
Possibly run your constructed query thru a regex expression e.g.
String mydata = SELECT * from table WHERE ab;;
Pattern pattern = Pattern.compile('WHERE');
Matcher matcher = pattern.matcher(mydata);
if (matcher.find())
{
//WHERE clause found proceed normally
}
else throw new Exception(WHERE
CONTACT the server admin and request access to the MySQL Instance located there
Martin
__
Verzicht und Vertraulichkeitanmerkung
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine
system specifics so that DB design
can be tailored to that ... of course, knowing that things will change as the
concept evolves.
Thanks,
Justin
-Original Message-
From: Garot Conklin [mailto:garotconk...@yahoo.com]
Sent: 23 August 2012 20:14
To: Martin Gainty; ag4ve...@gmail.com
prototype..
Let me know how i can help out,
Martin Gainty
__
..place long-winded disclaimer here..
From: ag4ve...@gmail.com
Date: Thu, 23 Aug 2012 10:42:55 -0400
Subject: Re: Machine Learning
To: garotconk...@yahoo.com
CC: webmas...@lisol.co.uk
If memory serves predicates convert strings to column-data-type (in your case
DATE) this *should* help
WHERE dateexam = STR_TO_DATE('2012-08-13','%Y-%m-%d')
does this help?
Martin
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de
assign realistic alias names
OuterJoin should be called OuterJoin
InnerJoin should be called InnerJoin
If you want only the most restricitive criteria that match resultsets from both
select statements use INNER JOIN
if you want all results from both resultsets (cartesian JOIN) use OUTER JOIN
Subject: Re: Machine Learning
I think it was the HAL-9000 in the movie 2001: A Space Odyssey
On 08/20/2012 06:25 PM, Martin Gainty wrote:
When I hear 'AI' I always imagine theres a HAL 9001 behind the scenes that
is running the show constantly admonishing its creator to take another
To: webmas...@lisol.co.uk; 'Martin Gainty'; mysql@lists.mysql.com
Subject: Re: Machine Learning
1)Refer to it for ‘knowledge’ (for instance, of what the latest
version of a command is)
It would most likely end up being central in this sense:
A distributed collection
:14
To: webmas...@lisol.co.uk; 'Martin Gainty'; mysql@lists.mysql.com
Subject: Re: Machine Learning
1)Refer to it for ‘knowledge’ (for instance, of what the latest
version of a command is)
It would most likely end up being central in this sense:
A distributed collection
To: webmas...@lisol.co.uk; 'Martin Gainty'; mysql@lists.mysql.com
Subject: Re: Machine Learning
1)Refer to it for ‘knowledge’ (for instance, of what the latest
version of a command is)
It would most likely end up being central in this sense:
A distributed collection
;
To:
'Garot Conklin' garotconk...@yahoo.com; 'Martin
Gainty' mgai...@hotmail.com; mysql@lists.mysql.com
When I hear 'AI' I always imagine theres a HAL 9001 behind the scenes that is
running the show constantly admonishing its creator to take another stress
pill
Sounds like a fun project
Keep us apprised,
Martin Gainty
__
Verzicht und
Garot
Can ypou provide any specific goal(s) on what you would like to achieve?
Martin
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein,
assuming you worked out the access to network by your code permissions
that means memory heap or stack is being overrun...you would be well advised to
download the connect() and sendto() code from the OS vendor and toss in plenty
of codeguard and
debug statements and recompile and rebuild.
responsabilité
pour le contenu fourni.
From: p...@computer.org
Subject: RE: UDF writing to unix socket - segfaults?
Date: Wed, 8 Aug 2012 15:39:09 +0200
To: mysql@lists.mysql.com
Martin Gainty wrote:
assuming you worked out the access to network by your code permissions
When I open the unix
I know I had the same problem with PHP when mysql.dll was off my PATH..put the
2 mysql libraries on the first directory from your PATH
05/30/2008 08:17 PM 2,125,824 libmysql.dll
06/13/2012 06:31 PM34,304 php_mysql.dll
be aware when things go wrong with DLL's you have no
Unless your effort is to convert all text strings to Mainland Chinese only
...Dont forget 'Locale'
http://dev.mysql.com/doc/refman/5.5/en/locale-support.html
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Bonjour Raymond
Nous espérons que cela vaut votre temps
Bon chance!
Martin
__
Note de déni et de confidentialitéCe message est confidentiel et peut être
privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec
bonté que pour
Miguel..
i do not have VC2010 but as my memory recalls the
C runtime library (MSVCRT*.dll) would be the first library on %PATH% .. and all
missing functions *should* be located inside the dll (e.g. __CrtSetReportFile )
can you
1) locate MSVCRT*.dll on your %PATH%
2) dumpbin -exports
Hi Don
Your best solution is to setup your own Mail server (Preferably on SSL)
http://en.wikipedia.org/wiki/Comparison_of_mail_servers
Configure Open Relay to 'Off'
Martin
__
Jogi és Bizalmassági kinyilatkoztatás/Verzicht und
in the door
On the other hand if you've been a full blown nazi with illegal wiretaps, strip
searches and harassment you might wind up in the Hague for different
circumstances.
I am reminded of the platitude:
United we stand..Divided we fall
Bedankt,
Martin Gainty
Jan-
the upside is you dont have to look up a variable to know what type it is:
zVariable is Null termed string
bVariable is boolean
nVariable is an Integer
fVariable is a float
dVariable is a double..
cVariable is a char
Martin
__
easy
you will need the x86-64bit distro which contains the x86-64 bit distribution of
libatkmm-1.6.so.1RPMs are error prone because they are version unaware..navicat
should refactor their install to a version aware utility such as maven
IMHO
Martin
__
Rik and Crew
String values are always ticked VALUES('MYNAME') unless ANSI_QUOTES are enabled
Column names are never surrounded by ticks or double quotes so
TABLE table_name
FOO VARCHAR(30)
/snip
where the INSERT statement for table table_name column FOO would look like:
INSERT INTO table_name FOO
TRAN (or TRANSACTION) will apply an implicit lock on the table which remains
until the TRAN is commit or rollback
subsequent DML statements on that same table will be forced to wait UNTIL the
TRAN is commit or rollback
when the statement for the second update on the same table comes along
Harald-
could you re-iterate the details of the malady or error you are experiencing?
danke,
Martin
__
Verzicht und Vertraulichkeitanmerkung
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir
From: h.rei...@thelounge.net
To: mysql@lists.mysql.com
Subject: Re: Input needed...
Am 06.05.2011 13:26, schrieb J M:
Config:
Running on 8G Server.. Currently utilizing 7G.. running only mysql..
[mysqld]
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path =
connection leaks will occur because of code maladies
did you check your code to ensure:
you are closing Statement Handles when you have finished executing the
statement?
you are closing Connection Handles when you have finished DML and DDL
operations with the Database?
?
Martin
(ich spreche nicht Russen)
Martin
__
Verzicht und Vertraulichkeitanmerkung
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung
correct here is the output of INFORMATION_SCHEMA.COLUMNS
Create Table: CREATE TEMPORARY TABLE `COLUMNS` (
`TABLE_CATALOG` varchar(512) DEFAULT NULL,
`TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
`TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
`COLUMN_NAME` varchar(64) NOT NULL DEFAULT
i agree with harald
if you're using Java you should consider pooling your database connections with
DBCP
http://commons.apache.org/dbcp/
feel free to ping me for implementation details
takk,
Martin
__
Note de déni et de confidentialité
Ce
Vaz
lecture start
please do not insert bogus display names into the email display name (such as
Vaz when your real name is haidarpesebe)
most responsible mail-admins wont tolerate this type of spoofing or any type of
email spoofing
and if your name is VAZ use the email address created for VAZ
if your interval is 5 change:
sum(calls) from calls group by 5 * floor(seconds/5)
to
sum(calls) from calls group by floor(seconds/5)
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist
if your interval is 5 change:
sum(calls) from calls group by 5 * floor(seconds/5)
to
sum(calls) from calls group by floor(seconds/5)
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist
MySQL is written in C
if your requirement is to write extension packages for MySQL then use the OS
specific C compiler to write the functions
deferring to MySQL staff to handle your other questions
Martin Gainty
__
Verzicht und
ask
program coordinator gary his address is
sav...@champlain.edu
My understanding is that oracle may offer some DBA courses in the future
Keep us apprised
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Date: Wed, 14 Jul 2010 10:25:22 -0400
Subject: Select w/ group by question
From: smulle...@gmail.com
To: mysql@lists.mysql.com
I'm having trouble formulating a query to gather the following data. I can
do this via a script, but now it is more or less just bothering me if there
is
i would monitor the performance on outer-join to determine if your server
pegging cpu,disk i/o or memory when executing te outer-join
then perhaps populating a temp table (and deleting the non-matching
records..those records which will be considered in transaction) as joerg
suggested
i
|
+++-+
2 rows in set (0.00 sec)
hth
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine
In less technical terms, if the master goes faster than the slave, the slave
will puke.
MGthen the master will have to teach the slave
MGis the master the entrenched bureacucrat or is that the slave?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Good Morning Rob-
I agree with you that security is a very serious topic and should be addressed
as such
Please read security alert page listed at tech-resources
http://dev.mysql.com/tech-resources/articles/security_alert.html
I hope this addresses your question,
Martin Gainty
Hello Carl
MySQL advertises an encryption package using the ENCRYPT('hello') but to date i
have'nt find any information on where to download and configure the encrpytion
package
did you look at http://www.critotech.com
?
Martin Gainty
__
Verzicht
handshakes)
the PGP decrypter at the other end will decrypt the received rows and construct
import/update statements to MYSQL
?
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich
mgzoom down to walters question(s)
Hi Carl,
On Mon, May 24, 2010 at 13:42, Carl c...@etrak-plus.com wrote:
1. Is the data visible during transmission?
Not sure what you mean there?
mghe means if someone was sharking the line would they be able to see
Financial Information /
an alternate encryption algorithm with an
alternate keysize
RSA issues smart cards which contain sufficient biometric information to
authenticate you
(and pass the authentication token to the OS)
does this help?
Martin Gainty
__
Verzicht und
-schedule-for-glassfish-556/
Does this help?
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um
Tim-
if MYSQL attempts to insert more bytes than what is available on disk you will
get 28 ENOSPC No space left on device
http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html
does this help?
Martin Gainty
__
Verzicht und
Architectures
does this conform to your understanding?
Martin Gainty
__
Please do not alter/modify or disrupt this transmission. Thank You
Date: Fri, 21 May 2010 07:21:22 -0700
From: t...@soe.ucsc.edu
To: mgai...@hotmail.com
CC: mysql@lists.mysql.com
RGB encoding?
sorry..thats for graphic designers
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich
I am doing wrong with format string to produce desired
DD-MON-YY format?
Many Thanks,
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene
(Agradecimentos para o conselho)
Eu espero que o homem responsável parará a chuva e permitirá a todos nós a
oportunidade de dessecar e apreciar a luz do sol
Obrigado!
Martin Gainty
__
Por favor não altere/interrompa ou altere esta transmissão
Hi Carsten
thanks for providing mysql support at 846pm kobenhavn time (on a fridag no less)
I will DEFINITELY check this out
Takk!
Martin Gainty
__
Note de déni et de confidentialité
Ce message est confidentiel et peut être privilégié. Si
short of exxon there is no other entity that comes close to acquiring Oracle
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
i agree with jerry
put date/timestamps on each record..(that way you know when the record was
created/modified)
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten
Guten Tag/Bonjour/Hello Pete
Haben Sie ein gutes Weihnachten/Ayez bon Noël/Have a good Christmas
Staaten von Amerika/Etats Unis/United States of America
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
In file included from readline.c:54:
readline/readline.h:70:29: sys/ttydefaults.h: No such file or directory
any clue where i can locate?
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist
no i havent ..any clues as to location of kernel headers?
(apologies for the newbie question)
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der
-affectedrows($myquery);
}
http://www.tizag.com/perlT/perlmysqlquery.php
(notice the site is written in PHP)
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der
any column used in any group functions such as SUM needs to be requested in
select column e.g.
select foo from table where sum(foo)=1.00
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist
between tables should always
be unique
and may involve concatenated columns the most famous example is OrderLine Item
which consists of
OrderID from Order-Header and OrderLineItemID
i hope this addresses your requirement
Martin Gainty
__
Verzicht und
someone probably installed mysql for DHCP address e.g 192.168.fu.bar
then as luck would have it the IP address changed
if you pull all network connections everyone on that box should be able to
access mysql
Salutations de l'état du chômage
Martin Gainty
Grant
he is trying to login as that user
then drop the user he logged in as
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
user
MODIFY Host char(60) NOT NULL default '',
MODIFY User char(16) NOT NULL default '',
ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
# much better:
USE Database
SET character_set_client = utf8;
CREATE
Martin Gainty
__
Verzicht
URL.URL_ID
CATEGORY.CATEGORY_ID1---1CATEGORY_IDURL_TEXT
1
↓
1
SUBCAT.CATEGORY_ID
SUBCAT.SUBCAT_TEXT
this is labour-intensive work that every DBA must perform to create a Database
Martin Gainty
SELECT * FROM ORDER o INNER JOIN ORDER_LINE_ITEMS o_l
ON (o.id=o_l.id)
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene
its possible a single thread language such as PHP would'nt handle your
situation..have you tried to recode your application in Java?
in the meanwhile please post your stacktrace
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et
when my.ini has query-cache-type = 1 setting
the query results are placed in cache on first read
second and consequent reads reference resultset from cache
http://www.databasejournal.com/features/mysql/article.php/3110171/MySQLs-Query-Cache.htm
Martin Gainty
Confucius say Big Dog in door
run a quick df
df
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede
Nigel/Marcus/Johann
mghopefully quick answer
nigel wood wrote:
Here's a rough table stucture. The indexes in events tables would be
TargetId.
mgthere would be need to be a 1:1 correspondence between
mgTargetId index and Username..all of your other tables would need to know
mgthe
mghopefully quick comments
Date: Sun, 7 Jun 2009 04:41:20 -0600
Subject: Thread safe queries with multiple connections
From: buf...@biffco.net
To: mysql@lists.mysql.com
I think my question is whether the data in MYSQL_RES and MYSQL_ROW data
structures are sufficiently independent from
(ORDINAL_POSITION,23,18);
Shalom
Martin Gainty
__
Note de déni et de confidentialité
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le
destinataire prévu, nous te demandons avec bonté que pour satisfaire informez
l'expéditeur. N'importe
. A transaction that tries to
access a row that is locked by another
InnoDB transaction will hang for at most
this many seconds before issuing the following error:
//there are also driver specific timeouts available for ODBC/JDBC drivers
HTH
Martin Gainty
Maschinenbordbücher sind sicher, selbst
wenn die Vorrichtung, die das Verzeichnis enthält, verloren ist.
arbeitet dieses nicht für Nichtdämon?
(raten Sie bitte)
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung
Diese Nachricht ist vertraulich
mysql docs could use a translation to Swahili (if you speak/read and write
Swahili)
?
thanks!
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der
cannot help with implementation details unless we see your DB schema e.g.
mysqluse DB
mysqlshow tables
msqyldesc table1
mysqldesc table2
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist
|
+-+
| 2009-05-21 03:15:28 |
+-+
most of us have contacts in europe who dont use EDT,CDT,MDT or PDT so
i *was hoping* to get confirmation on CONVERT_TZ(date,from_tz,to_tz) works?
Thanks,
Martin Gainty
__
Verzicht und
only if you are implementing INNODB Transactional Storage Engine
MySQL uses table-level locking for MyISAM,
MEMORY and MERGE tables,
page-level locking for BDB tables, and
row-level locking for InnoDB tables.
no puedo ver la disposición atada del esquema de la exhibición de la
imagen. .please de la tabla relevante y crear la tabla, cree las
declaraciones del índice
Saludos Cordiales desde EEUU!
Martin
GMT+5(por la semana)
__
Verzicht und
mysql select sysdate() from DUAL;
+-+
| sysdate() |
+-+
| 2009-05-21 17:37:13 |
+-+
i would get the proprt format is
i could CONVERT_TZ to work
can you get CONVERT_TZ to work ?
Martin Gainty
Neil-
http://wiki.seas.harvard.edu/geos-chem/index.php/Floating_point_math_issues
so a value this large or small would only be true for 8byte double datatype
Curious as to what the original Table/Column datatype is
hth
Martin
__
Jogi és Bizalmassági
are linking to the server code and calling server
functions with libmysqld.a
(instead of linking in client code from libmysqlclient.a)
HTH
Martin Gainty
there is also a way to accomplish this with an Oracle Function calling external
methods but we should wait until after the merger
starting MYSQL
%MYSQL_HOME%\binmysqld --log-output=FILE --log-error=MySQL.log
--result-file=results.log
--perform some minor operation
mysql -u username -p root DBNAME
mysqlshow databases;
mysqluse database;
mysqlshow tables;
please display the results of these operations of
providing accurate information would've helped the op in this situation
i agree!
thanks,
Martin
__
Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung/Note de
déni et de confidentialité
This message is confidential. If you should
please follow my earlier suggestion and place
long_query_time=NumberOfSecs
min_examined_row_limit=MinNumberOfRowsToExamine
in my.cnf or my.ini
start mysqld --log-slow-queries[=file_name]
documentation available at
http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html
Shalom
Martin Gainty
that is one weird opening statement
select * from information_schema.tables where
table_name='DATABASE_NAME.TABLENAME';
Martin
May the Schwartz be with you -- Spaceballs
__
Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung/Note
Jörg
mgai...@martini ~
FGIN.sh 35 | fgrep errno
find: File system loop detected; `/usr/include/gnome-xml/libxml' is part of the
same file system loop as `/usr/include/gnome-xml'.
/usr/include/apr-1/apr_errno.h:806:#define SOCEWOULDBLOCK (SOCBASEERR+3
5)/* Operation would
in information_schema.tables
e.g.
SELECT AUTO_INCREMENT from information_schema.tables where
WHERE TABLE_NAME = Products AND TABLE_SCHEMA = bs3578;
Viel Gluck,
Martin
__
Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung
1 - 100 of 291 matches
Mail list logo