Thanks that worked.
I was trying -v from the help.
Gavin Towey gto...@ffn.com
10/02/2009 05:30 PM
To
Lucas CTR Heuman/ACT/CNTR/f...@faa, mysql@lists.mysql.com
mysql@lists.mysql.com
cc
Subject
RE: The Execute from the command line
Mysql -vv
See mysql --help for more info
Regards,
Thanks Liu, This type mismatch issue.
On 10/5/09, LIU YAN liuy...@live.com wrote:
hi,
I run your code , but worked propertly. I suggested to check the table USERS
, ROLES, is the column userid / roleid same data type (INT(10) UNSIGNED )
with your userroles table ?
After installing Apple's MAC Snow Leopard OS 10.6 I haven't been able to get my
DBD:mysql module to work. I am kind of beyond trying to fix that issue directly
so I am requesting assistance defining a compatible version set which is known
to work. Between various releases and 32/64 bit options
MySQL Server can be 32 or 64 bit and it shouldn't make a difference to PERL.
However, if you can run 64 bit, you should.
PERL and it's modules all need to be the same architecture. It doesn't matter
if they're 32 bit or 64 bit, as long as it's consistent with itself.
I see no reason why
Questions Folks:
(1) What do you about un-index searches. How can one report and monitor them?
(2) What do you do with the slow-query log. Are there any utilities or scripts
out there to filter and manage this log?
Thanks
This message is
See
log-queries-not-using-indexes
option in my.cnf, used with the slow log.
http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html
Regards,
Gavin Towey
-Original Message-
From: Brown, Charles [mailto:cbr...@bmi.com]
Sent: Monday, October 05, 2009 12:59 PM
To: Mysql List
Cc: John
Here is the error I am receiving ( I posted this issue in the recent past):
dyld: lazy symbol binding failed: Symbol not found: _mysql_init
Referenced from:
/Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle
Expected in: flat namespace
dyld: Symbol not found:
You were right about the % I'd forgotten. Still, I got the same error. So I
tried to change the command to this:
insert into products (ID, Name, Title, Description, Price, Bedrooms,
Bathrooms, Conditions, Acreage, Construction, Location, Estate, Address,
Furnished, pic1, pic2, pic3, pic4, pic5,
Same error :(
On Mon, Oct 5, 2009 at 4:26 PM, DaWiz da...@dawiz.net wrote:
Vic tor,
Try this instead:
insert into products (ID, Name, Title, Description, Price, Bedrooms,
Bathrooms, Conditions, Acreage, Construction, Location, Estate, Address,
Furnished, pic1, pic2, pic3, pic4, pic5,
Hi
I just did a new installation of Suse 11.2 and found that I couldn't
connect to mysql from a php script because mysql.sock was
in /var/run/mysql/mysql.sock rather than /var/lib/mysql/mysql.sock. I
changed all the lines in /etc/my.cnf for the socket
to /var/lib/mysql/mysql.sock. Now my php
And an answer to 2): http://www.maatkit.org/doc/mk-query-digest.html
On Tue, Oct 6, 2009 at 02:59, Brown, Charles cbr...@bmi.com wrote:
Questions Folks:
(1) What do you about un-index searches. How can one report and monitor them?
(2) What do you do with the slow-query log. Are there any
I'm using:
DBD::mysql 3.007
DBI 1.52
Perl 5.8.8
That output looks like missing shared library dependencies to me, but maybe
someone else has a better idea.
Try:
Ldconfig -p | grep mysql
And see if you see something like:
libmysqlclient.so (libc6,x86-64) = /usr/lib64/libmysqlclient.so
in
Hi Scott,
Change socket = path in the [client] section of your my.cnf as well.
Regards
Gavin Towey
-Original Message-
From: Scott Wagner [mailto:gildedp...@comcast.net]
Sent: Monday, October 05, 2009 3:21 PM
To: mysql@lists.mysql.com
Subject: mysql.socket location problem
Hi
I just did
I have Dell PE2950iii with 16GB of RAM, and 1 Quadcore processor @2.00G.
Installed with MySQL 5.075 on 64bit Ubuntu Jaunty. I have these
parameters in my.cnf:
[mysqld]
key_buffer = 512M
max_allowed_packet = 512M
thread_stack= 4096K
thread_cache_size = 256
On Mon, Oct 5, 2009 at 6:12 PM, sangprabv sangpr...@gmail.com wrote:
I have Dell PE2950iii with 16GB of RAM, and 1 Quadcore processor @2.00G.
Installed with MySQL 5.075 on 64bit Ubuntu Jaunty. I have these
parameters in my.cnf:
blah blah blah...
This heavily depends on workload. Are you
As you see on my my.cnf I skip innodb and federated. So I just use
myisam in this case. TIA.
Willy
On Mon, 2009-10-05 at 20:47 -0700, Rob Wultsch wrote:
On Mon, Oct 5, 2009 at 6:12 PM, sangprabv sangpr...@gmail.com wrote:
I have Dell PE2950iii with 16GB of RAM, and 1 Quadcore
16 matches
Mail list logo