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 @

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? e

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 myisa

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 ne

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

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 > s

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 scri

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(

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

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_

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 M

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

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

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

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 ? > > > >

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 Messag