RE: The Execute from the command line
Thanks that worked. I was trying -v from the help. Gavin Towey 10/02/2009 05:30 PM To Lucas CTR Heuman/ACT/CNTR/f...@faa, "mysql@lists.mysql.com" cc Subject RE: The Execute from the command line Mysql -vv See mysql --help for more info Regards, Gavin Towey -Original Message- From: lucas.ctr.heu...@faa.gov [mailto:lucas.ctr.heu...@faa.gov] Sent: Friday, October 02, 2009 2:20 PM To: mysql@lists.mysql.com Subject: The Execute from the command line I am using linuxmachine:/var/wwwdev/lucas# mysql -udatabase -ppassword -e "LOAD DATA LOCAL INFILE '/var/wwwdev/lucas/cardreaderimport/update.csv' into table Project.testtest fields terminated by ',' lines terminated by '\n' (Id,LastName,MiddleName,FirstName,TimeStamp,Ext,Status,Location,Expire,BadgeNum);" and it works great, I just get no verification that anything has been loaded in.. if I login it gives me back a little message saying it was completed and how many are duplicated. How can I get this information from the command line? Wishing you the best you know you deserve, The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
Re: error creating table
Thanks Liu, This type mismatch issue. On 10/5/09, LIU YAN 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 ? > > > > == > > mysql> create table users (userid INT(10) UNSIGNED primary key); > Query OK, 0 rows affected (0.06 sec) > > mysql> create table roles (roleid INT(10) UNSIGNED primary key); > Query OK, 0 rows affected (0.06 sec) > > mysql> CREATE TABLE `userroles` ( > -> `roleid` INT(10) UNSIGNED NOT NULL DEFAULT '0', > -> `userid` INT(10) UNSIGNED NOT NULL DEFAULT '0', > -> PRIMARY KEY (`roleid`, `userid`), > -> INDEX `FK1_user` (`userid`), > -> CONSTRAINT `fk_userid` FOREIGN KEY (`userid`) REFERENCES `users` > -> (`userid`) ON UPDATE CASCADE ON DELETE CASCADE, > -> CONSTRAINT `fk_roleid` FOREIGN KEY (`roleid`) REFERENCES `roles` > -> (`roleid`) ON UPDATE CASCADE ON DELETE CASCADE > -> ) > -> COLLATE=utf8_general_ci > -> ENGINE=InnoDB > -> ROW_FORMAT=COMPACT > -> AVG_ROW_LENGTH=0; > Query OK, 0 rows affected (0.08 sec) > > mysql> > > == > > > > best regards > > liuyann > > > >> Date: Sun, 4 Oct 2009 23:47:54 +0530 >> Subject: error creating table >> From: saf...@gmail.com >> To: mysql@lists.mysql.com >> >> Hi, >> I'm trying to create a table with 2 columns both are primary key >> (combined) and both are foreign key as well. I'm getting error cannot >> create table. Here is the sql >> >> CREATE TABLE `userroles` ( >> `roleid` INT(10) UNSIGNED NOT NULL DEFAULT '0', >> `userid` INT(10) UNSIGNED NOT NULL DEFAULT '0', >> PRIMARY KEY (`roleid`, `userid`), >> INDEX `FK1_user` (`userid`), >> CONSTRAINT `fk_userid` FOREIGN KEY (`userid`) REFERENCES `users` >> (`userid`) ON UPDATE CASCADE ON DELETE CASCADE, >> CONSTRAINT `fk_roleid` FOREIGN KEY (`roleid`) REFERENCES `roles` >> (`roleid`) ON UPDATE CASCADE ON DELETE CASCADE >> ) >> COLLATE=utf8_general_ci >> ENGINE=InnoDB >> ROW_FORMAT=COMPACT >> AVG_ROW_LENGTH=0 >> >> -- >> Sharique uddin Ahmed Farooqui >> (C++/C# Developer, IT Consultant) >> http://safknw.blogspot.com/ >> "Peace" is the Ultimate thing we want. >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql?unsub=liuy...@live.com >> > > _ > Windows Live: Keep your friends up to date with what you do online. > http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_1:092010 -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot.com/ "Peace" is the Ultimate thing we want. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Mysql Perl DBI DBD Version Compatability for MAC OS 10.6
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 I have to confess there are too many choices and not enough information on how to choose for me to trust my own judgment anymore. Currently, I am running: 1. mysql Server Version 5.4.1-beta MySQL Community Server 2. perl version 5.8.9 built for Darwin 2level 3. perl DBI version 1.609 4. perl DBD:mysql 4.012 I am not positive which of the above are 32 or 64 bit but help discerning which 32/64 versions are required would also be appreciated. I am happy ;-( to uninstall and reinstall any of the above to get to a working configuration. Thanks in advance. Hagen Finley Boulder, CO -- 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 Perl DBI DBD Version Compatability for MAC OS 10.6
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 those versions should have a problem interacting; what are you trying, and what is the error you get? Regards Gavin Towey -Original Message- From: Hagen [mailto:finha...@comcast.net] Sent: Monday, October 05, 2009 11:58 AM To: mysql@lists.mysql.com Cc: finha...@comcast.net Subject: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6 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 I have to confess there are too many choices and not enough information on how to choose for me to trust my own judgment anymore. Currently, I am running: 1. mysql Server Version 5.4.1-beta MySQL Community Server 2. perl version 5.8.9 built for Darwin 2level 3. perl DBI version 1.609 4. perl DBD:mysql 4.012 I am not positive which of the above are 32 or 64 bit but help discerning which 32/64 versions are required would also be appreciated. I am happy ;-( to uninstall and reinstall any of the above to get to a working configuration. Thanks in advance. Hagen Finley Boulder, CO -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
Questions on un-index searches and slow-query-log
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 intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Questions on un-index searches and slow-query-log
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 Meyer; Mark Phillips Subject: Questions on un-index searches and slow-query-log 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 intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- 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 Perl DBI DBD Version Compatability for MAC OS 10.6
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: _mysql_init Referenced from: /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle Expected in: flat namespace Trace/BPT trap Could you send me the versions of Perl, DBD & DBI you are using? Hagen On 10/5/09 1:16 PM, "Gavin Towey" wrote: > 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 those versions should have a problem interacting; what are > you trying, and what is the error you get? > > Regards > Gavin Towey > > -Original Message- > From: Hagen [mailto:finha...@comcast.net] > Sent: Monday, October 05, 2009 11:58 AM > To: mysql@lists.mysql.com > Cc: finha...@comcast.net > Subject: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6 > > 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 I have to > confess there are too many choices and not enough information on how to choose > for me to trust my own judgment anymore. > > Currently, I am running: > > 1. mysql Server Version 5.4.1-beta MySQL Community Server > > 2. perl version 5.8.9 built for Darwin 2level > > 3. perl DBI version 1.609 > > 4. perl DBD:mysql 4.012 > > I am not positive which of the above are 32 or 64 bit but help discerning > which 32/64 versions are required would also be appreciated. I am happy ;-( to > uninstall and reinstall any of the above to get to a working configuration. > Thanks in advance. > > Hagen Finley > Boulder, CO > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com > > > The information contained in this transmission may contain privileged and > confidential information. It is intended only for the use of the person(s) > named above. If you are not the intended recipient, you are hereby notified > that any review, dissemination, distribution or duplication of this > communication is strictly prohibited. If you are not the intended recipient, > please contact the sender by reply email and destroy all copies of the > original message. -- 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 tuples, but AttributeError about tuple!
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, pic6) values("1", "name1", "title1", "descr1", "1.1", "2", "1", "New", "1.5", "new", "princesse", "princesse", "123 princesse", "Not furnished", "", "", "", "", "", ""); Here's the table description: ( ID int(3) unsigned primary key auto_increment, Name varchar(40), Title varchar(3), Description varchar(512), Price float(10,2), Bedrooms int(1) unsigned, Bathrooms int(1) unsigned, Conditions varchar(255), Acreage float(5,2), Construction set('New','Existing'), Location varchar(256), Estate varchar(60), Address varchar(100), Furnished set('Furnished','Unfurnished'), pic1 blob, pic2 blob, pic3 blob, pic4 blob, pic5 blob, pic6 blob ) Now I get this error: [Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler mod_python.cgihandler: Traceback (most recent call last):, referer: http://13gems.com/stxresort/cart/iud.py [Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler mod_python.cgihandler: File "/usr/lib64/python2.4/site-packages/mod_python/apache.py", line 299, in HandlerDispatch\n result = object(req), referer: http://13gems.com/stxresort/cart/iud.py [Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler mod_python.cgihandler: File "/usr/lib64/python2.4/site-packages/mod_python/cgihandler.py", line 96, in handler\n imp.load_module(module_name, fd, path, desc), referer: http://13gems.com/stxresort/cart/iud.py [Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler mod_python.cgihandler: File "/var/www/vhosts/ 13gems.com/httpdocs/stxresort/cart/add_edit.py", line 360, in ?\n add_edit(), referer: http://13gems.com/stxresort/cart/iud.py [Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler mod_python.cgihandler: File "/var/www/vhosts/ 13gems.com/httpdocs/stxresort/cart/add_edit.py", line 314, in add_edit\n cursor.execute(sql), referer: http://13gems.com/stxresort/cart/iud.py [Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler mod_python.cgihandler: File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute\n self.errorhandler(self, exc, value), referer: http://13gems.com/stxresort/cart/iud.py [Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler mod_python.cgihandler: File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler\n raise errorclass, errorvalue, referer: http://13gems.com/stxresort/cart/iud.py [Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler mod_python.cgihandler: OperationalError: (1054, "Unknown column 'Name' in 'field list'"), referer: http://13gems.com/stxresort/cart/iud.py Is it me, or does this actually make sense? TIA, V On Sun, Oct 4, 2009 at 7:20 PM, Michael Dykman wrote: > I assume you are using MySQLdb. > > to clarify, I trust you know that this is a tuple: > (id, name, title, > description, price, bedrooms, bathrooms, conditions, acreage, > construction, > location, estate, address, furnished, pic1, pic2, pic3, pic4, pic5, pic6) > > .. > > I'm not exactly an expert in python but I don't follow this statement: > > > sql = 'insert into products values(%s, %s, %s, %s, %s, %s, %s, %s, > %s, > > %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);', (id, name, title, > > description, price, bedrooms, bathrooms, conditions, acreage, > construction, > > location, estate, address, furnished, pic1, pic2, pic3, pic4, pic5, pic6) > which is constructed as a = b,c and doesn't do what you think it does > > .. if you were looking to do a text sprintf thing, it would be more > commonly > sql = 'insert into products values(%s, %s, %s, %s, %s, %s, %s, %s, > %s, > %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);' % (id, name, title, > description, price, bedrooms, bathrooms, conditions, acreage, > construction, > location, estate, address, furnished, pic1, pic2, pic3, pic4, pic5, pic6) > > which will not enquote your values. note the '%' operator between the > string and the tuple. > > what you want, I think is the 2 param form of cursor.execute() which > takes a string statement and a tuple of arguments: > > cursor.execute('insert into products values(%s, %s, %s, %s, %s, %s, %s, %s, > %s, > %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' , (id, name, title, > description, price, bedrooms, bathrooms, conditions, acreage, > construction, > location, estate, address, furnished, pic1, pic2, pic3, pic4, pic5, pic6)) > conn.commit() > > execute knows how to address the various data types in the tuple and > will escape/enquote as necessary. > > - michael > > Since you are > > On Sun, Oct 4, 2009 at 2:04 PM, Victor Subervi > wrote: > > Hi; > > I have the following python code: > > sql = 'in
Re: No tuples, but AttributeError about tuple!
Same error :( On Mon, Oct 5, 2009 at 4:26 PM, DaWiz 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, pic6) values('1', 'name1', > 'title1', 'descr1', '1.1', '2', '1', 'New', '1.5', 'new', 'princesse', > 'princesse', '123 princesse', 'Not furnished', '', '', '', '', '', ''); > > Values are enclosed in single quotes for SQL. > > - Original Message - From: "Victor Subervi" < > victorsube...@gmail.com> > To: "Michael Dykman" ; > Sent: Monday, October 05, 2009 2:33 PM > Subject: Re: No tuples, but AttributeError about tuple! > > > > 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, pic6) values("1", "name1", > "title1", "descr1", "1.1", "2", "1", "New", "1.5", "new", "princesse", > "princesse", "123 princesse", "Not furnished", "", "", "", "", "", ""); > > Here's the table description: > > ( > ID int(3) unsigned primary key auto_increment, > Name varchar(40), > Title varchar(3), > Description varchar(512), > Price float(10,2), > Bedrooms int(1) unsigned, > Bathrooms int(1) unsigned, > Conditions varchar(255), > Acreage float(5,2), > Construction set('New','Existing'), > Location varchar(256), > Estate varchar(60), > Address varchar(100), > Furnished set('Furnished','Unfurnished'), > pic1 blob, > pic2 blob, > pic3 blob, > pic4 blob, > pic5 blob, > pic6 blob > ) > > Now I get this error: > > [Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler > mod_python.cgihandler: Traceback (most recent call last):, referer: > http://13gems.com/stxresort/cart/iud.py > [Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler > mod_python.cgihandler: File > "/usr/lib64/python2.4/site-packages/mod_python/apache.py", line 299, in > HandlerDispatch\n result = object(req), referer: > http://13gems.com/stxresort/cart/iud.py > [Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler > mod_python.cgihandler: File > "/usr/lib64/python2.4/site-packages/mod_python/cgihandler.py", line 96, in > handler\n imp.load_module(module_name, fd, path, desc), referer: > http://13gems.com/stxresort/cart/iud.py > [Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler > mod_python.cgihandler: File "/var/www/vhosts/ > 13gems.com/httpdocs/stxresort/cart/add_edit.py", line 360, in ?\n > add_edit(), referer: http://13gems.com/stxresort/cart/iud.py > [Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler > mod_python.cgihandler: File "/var/www/vhosts/ > 13gems.com/httpdocs/stxresort/cart/add_edit.py", line 314, in add_edit\n > cursor.execute(sql), referer: http://13gems.com/stxresort/cart/iud.py > [Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler > mod_python.cgihandler: File > "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line 163, in > execute\n self.errorhandler(self, exc, value), referer: > http://13gems.com/stxresort/cart/iud.py > [Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler > mod_python.cgihandler: File > "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py", line 35, in > defaulterrorhandler\n raise errorclass, errorvalue, referer: > http://13gems.com/stxresort/cart/iud.py > [Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler > mod_python.cgihandler: OperationalError: (1054, "Unknown column 'Name' in > 'field list'"), referer: http://13gems.com/stxresort/cart/iud.py > > Is it me, or does this actually make sense? > TIA, > V > > > On Sun, Oct 4, 2009 at 7:20 PM, Michael Dykman wrote: > > I assume you are using MySQLdb. >> >> to clarify, I trust you know that this is a tuple: >> (id, name, title, >> description, price, bedrooms, bathrooms, conditions, acreage, >> construction, >> location, estate, address, furnished, pic1, pic2, pic3, pic4, pic5, pic6) >> >> .. >> >> I'm not exactly an expert in python but I don't follow this statement: >> >> > sql = 'insert into products values(%s, %s, %s, %s, %s, %s, %s, %s, >> %s, >> > %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);', (id, name, title, >> > description, price, bedrooms, bathrooms, conditions, acreage, >> construction, >> > location, estate, address, furnished, pic1, pic2, pic3, pic4, pic5, > >> pic6) >> which is constructed as a = b,c and doesn't do what you think it does >> >> .. if you were looking to do a text sprintf thing, it would be more >> commonly >> sql = 'insert into products values(%s, %s, %s, %s, %s, %s, %s, %s, >> %s, >> %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);' % (id, name, title, >> description, price, bedrooms, bathrooms, conditions, acreage, >> constru
mysql.socket location problem
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 scripts connect but I can't connect to mysql from the command line. I get the error can't connect through socket /var/run/mysql/mysql.sock. What do I have to change to make the konsole use /var/lib/mysql/mysql.sock? Thanks, Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Questions on un-index searches and slow-query-log
And an answer to 2): http://www.maatkit.org/doc/mk-query-digest.html On Tue, Oct 6, 2009 at 02:59, Brown, Charles 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 utilities or > scripts out there to filter and manage this log? > > Thanks > > > > > This message is intended only for the use of the Addressee and > may contain information that is PRIVILEGED and CONFIDENTIAL. > > If you are not the intended recipient, you are hereby notified > that any dissemination of this communication is strictly prohibited. > > If you have received this communication in error, please erase > all copies of the message and its attachments and notify us > immediately. > > Thank you. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.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: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6
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 the output. If not you may have to find it and make sure ldconfig knows about it. You should also be able to use ldd to check shared lib dependencies. Regards, Gavin Towey -Original Message- From: Hagen Finley [mailto:finha...@comcast.net] Sent: Monday, October 05, 2009 1:30 PM To: Gavin Towey Cc: mysql@lists.mysql.com Subject: Re: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6 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: _mysql_init Referenced from: /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle Expected in: flat namespace Trace/BPT trap Could you send me the versions of Perl, DBD & DBI you are using? Hagen On 10/5/09 1:16 PM, "Gavin Towey" wrote: > 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 those versions should have a problem interacting; what are > you trying, and what is the error you get? > > Regards > Gavin Towey > > -Original Message- > From: Hagen [mailto:finha...@comcast.net] > Sent: Monday, October 05, 2009 11:58 AM > To: mysql@lists.mysql.com > Cc: finha...@comcast.net > Subject: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6 > > 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 I have to > confess there are too many choices and not enough information on how to choose > for me to trust my own judgment anymore. > > Currently, I am running: > > 1. mysql Server Version 5.4.1-beta MySQL Community Server > > 2. perl version 5.8.9 built for Darwin 2level > > 3. perl DBI version 1.609 > > 4. perl DBD:mysql 4.012 > > I am not positive which of the above are 32 or 64 bit but help discerning > which 32/64 versions are required would also be appreciated. I am happy ;-( to > uninstall and reinstall any of the above to get to a working configuration. > Thanks in advance. > > Hagen Finley > Boulder, CO > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com > > > The information contained in this transmission may contain privileged and > confidential information. It is intended only for the use of the person(s) > named above. If you are not the intended recipient, you are hereby notified > that any review, dissemination, distribution or duplication of this > communication is strictly prohibited. If you are not the intended recipient, > please contact the sender by reply email and destroy all copies of the > original message. The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- 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.socket location problem
Hi Scott, Change socket = 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 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 scripts connect but I can't connect to mysql from the command line. I get the error can't connect through socket /var/run/mysql/mysql.sock. What do I have to change to make the konsole use /var/lib/mysql/mysql.sock? Thanks, Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Optimizing my.cnf
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 myisam-recover = BACKUP max_connections= 999 table_cache= 2048 thread_concurrency = 100 query_cache_limit = 32M query_cache_size= 512M expire_logs_days= 10 max_binlog_size = 100M skip-innodb skip-federated [mysqldump] quick quote-names max_allowed_packet = 512M [isamchk] key_buffer = 512M Is it optimized enough for a high load MySQL server machine? Is there any suggestion to get more speed and response? TIA Willy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Optimizing my.cnf
On Mon, Oct 5, 2009 at 6:12 PM, sangprabv 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 using innodb? etc... -- Rob Wultsch wult...@gmail.com
Re: Optimizing my.cnf
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 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 using innodb? etc... > > -- > Rob Wultsch > wult...@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