Re: remote connection

Its a permissions thing on the server end. You have to have set up a user account on the server. Very important are hostnames. Curtis John Almberg said: > I'm trying to set up a remote connection to a mysql database using Perl > DBI. I have done this without problem on another database. I susp

how can i import/export data in an attribute of table from/to any file

can some one please tell me how to import data from any attribute of a table from any external file and how can i export data from any attribute of a table to any external file

Quick query on 'wait_timeout' parameter.

Hi, I have many Mysql connection threads sleeping which is taking a very good amount of memory so I am reducing 'wait_timeout' parameter from default 8 Hr to 1Hr. Will it have any side effects on My web application. I am concerned because I don't know why the default was kept so high as to 8Hr

left outer join query -- maybe?

Hello all, I have three queries that I need to join together and cannot figure out how. The first query returns 161 records and I want all these records with nulls in the fields added with queries 2 and 3. Any help will be greatly appreciated!!

Re: Ftp of Mysql Files

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Keith -- ...and then Keith Spiller said... % % Hello, hi! % % I already use phpmyadmin to dump the mysql data into sql files, Good. % but I would like to back up the original database files as well. OK. % % I found the actual database file

Re: select count(*) / select count(column) in innodb

At 15:41 -0800 11/6/03, Hsiu-Hui Tseng wrote: Hi, select count(*) is very slow in innodb (because it is a table scan). Is there any difference if I change it to select count(column). I did some test and some times select count(*) is really slow and some time select count(column) is slow. Could any

Re: aes encryption bug

At 15:29 -0800 11/6/03, Herb Rubin wrote: Paul, I did try VARCHAR(16) BINARY and it still failed to INSERT in a NOT NULL column. The encrypted string seems to be equivalent to the NULL value even though it visually looks like some kind of data. Herb Okay, I investigated this further and I believe

remote connection

I'm trying to set up a remote connection to a mysql database using Perl DBI. I have done this without problem on another database. I suspect the rights are set up differently on this one. I have root access. When I try to connect, I get the following error (hostname, username, password have been

RE: cardinality in SHOW INDEX

Use analyze table to calculate cardinality. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: Hsiu-Hui Tseng [mailto:[EMAIL PROTECTED] -->Sent: Thursday, November 06, 2003 4:46 PM -->To:

cardinality in SHOW INDEX

Hi, Some time I saw cardinality in SHOW INDEX is null. Why this happening? Then, I did a OPTIMIZE TABLE on the table and the number was getting back. We are going to switch all of our table to innodb. Will innodb has this problem? If it happend, how to fix it in innodb. Using OPTIMIZE TABLE? Is i

Re: practical MySQL database size limits

our database is about 20 Gb and growing daily. so far, I still see nearly constant time query performance on tables with ~10M rows. I don't think mysql is limited by file size per se. Ari Davidow wrote: > > We're talking about storing binary files (images) inside a MySQL database > to take advan

RE: select count(*) / select count(column) in innodb

- Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: Hsiu-Hui Tseng [mailto:[EMAIL PROTECTED] -->Sent: Thursday, November 06, 2003 3:41 PM -->To: [EMAIL PROTECTED] -->Subject: select count(*

Re: Too Many Columns ERROR 175..

I knew I'd sound like an idiot.BUT... The imported text consists of a 'customer' generated message with large arraysand since I haven't figured out how to generate arrays in mySQL4.0 each array entry is a record. Since I'm trying to BULK LOAD the message (with as little intervention as p

select count(*) / select count(column) in innodb

Hi, select count(*) is very slow in innodb (because it is a table scan). Is there any difference if I change it to select count(column). I did some test and some times select count(*) is really slow and some time select count(column) is slow. Could anyone help me? If I need do a select(*) in inn

Re: aes encryption bug

Paul, I did try VARCHAR(16) BINARY and it still failed to INSERT in a NOT NULL column. The encrypted string seems to be equivalent to the NULL value even though it visually looks like some kind of data. Herb > Please reply to the list, not to me directly, so that others can > follow this dis

Re: aes encryption bug

Please reply to the list, not to me directly, so that others can follow this discussion. Thanks. At 14:54 -0800 11/6/03, Herb Rubin wrote: Paul, Yes, I get the same, now try and decrypt it, it will turn out to be NULL. So, you cannot insert this into a NOT NULL column. It will reject it. Your mes

Re: so long I keep longing

On Fri, Nov 07, 2003 at 03:25:43AM +0800, Jon Hancock wrote: > for 4.1.1... > .anyone have a good guess for getting a build of 4.1.1 ??? I've been building it from source on FreeBSD and Linux on a daily basis. :-) -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <

Re: aes encryption bug

At 14:03 -0800 11/6/03, Herb Rubin wrote: Hi, I am trying to use aes_encrypt and I get a NULL value with a specific string: INSERT INTO test SET `id` = AES_ENCRYPT('551850040', '0bf251c9aaf007deaf1143ca1492b561'); my field 'id' is VARCHAR(16) NOT NULL If I change the value or the encryption strin

Re: Slow query log setting

Hi, I think log-slow-queries belongs in the [mysqld] section of my.cnf, not [mysqld_safe]. Hope that helps. Matt - Original Message - From: "MaFai" To: <[EMAIL PROTECTED]> Sent: Wednesday, November 05, 2003 9:00 PM Subject: Slow query log setting > Hello, mysql, > > I have set the

RE: ROWID

No. There is no physical address of a row in MySQL. >> On Thu, Nov 06, 2003 at 09:59:41AM -0800, Wan, Wenhua wrote:  >  >> Hi there,  > >> > Both Oracle and Informix use ROWID to uniquely represent the >> location of  > each row of data in a table.  ROWID is basically a >> hidden column or  > pse

Re: Problem with LIKE/REGEXP

Hi George, - Original Message - From: "George Moschovitis" To: <[EMAIL PROTECTED]> Sent: Thursday, November 06, 2003 9:03 AM Subject: RE: Problem with LIKE/REGEXP > > What are you actually trying to match with \017? As far as I know, > it's > > treating the \0 part as a NUL byte and try

Re: Issues with Mysql 4.0 and PHP in a production environment

On Thu, Nov 06, 2003 at 02:10:27PM -0600, Luis Lebron wrote: > Are there any issues with running PHP 4.3.X and Mysql 4.0 in a production > environment? What sort of "issues" are you looking for? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | h

Re: keep leading 000 -solved

Hi Bernd, I think you should be able to use a column type such as field FLOAT(10, 4) ZEROFILL NOT NULL You might want to change the numbers 10 and 4 depending on how many leading/trailing 0s you want. Matt - Original Message - From: "Bernd Tannenbaum" To: <[EMAIL PROTECTED]> Sent: Th

aes encryption bug

Hi, I am trying to use aes_encrypt and I get a NULL value with a specific string: INSERT INTO test SET `id` = AES_ENCRYPT('551850040', '0bf251c9aaf007deaf1143ca1492b561'); my field 'id' is VARCHAR(16) NOT NULL If I change the value or the encryption string it works. But this combination turn

Re: This is confusing..?

Hi Eric, The Cardinality of the datestamp column is only 76. That means it thinks there's only 76 unique values in all of your rows. In other words, there's a good chance that your WHERE matches more than ~30% of the rows, in which case the index won't be used. If you haven't run OPTIMIZE in year

Re: so long I keep longing

Hi Jon, I know, it's been sooo long! :-( But from what's been said on this list, and since it says "To be released soon" in the ChangeLog, I would expect it within the next 2 weeks. I'm hoping 4.1.2 or 4.1.3 will be upgraded to Beta status. :-) Matt - Original Message - From: "Jon Ha

Re: ROWID

> But that's not what a "ROWID" is compared to what I think the original poster > was looking for. In Oracle for example, a ROWID is the unique address of a row > in the database. Every row, unique key or not has a unique address. Is there > such a thing in MySQL? ROWIDs are extremely useful for gu

RE: Transaction

- Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: Arnoldus Th.J. Koeleman [mailto:[EMAIL PROTECTED] -->Sent: Thursday, November 06, 2003 1:24 PM -->To: [EMAIL PROTECTED] -->Subject: Trans

Re: Simple question about updating a table field

Yes it is correct, but please don't hijack someone else's thread. Admin-Stress wrote: I have a numeric table field, named "CREDIT". How can I add a number (+50) to that field for all the table record ? is this correct UPDATE ThisTable SET CREDIT=CREDIT+50 Please help, Thanks ___

Transaction

I am new in MySQL and am used to work with Oracle. If you work with MyISAM tables is it possible to rollback transaction. And what is a better way to install a production application with MyISAM tables or InnoDB?

practical MySQL database size limits

We're talking about storing binary files (images) inside a MySQL database to take advantage of the granularity and control we get over file access that way. But we already have 1.5GB, and that could lead to a very large database very quickly. What are people's experiences with large MySQL data

RE: ROWID

U could always use a PRIMARY key on an auto_increment column. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: Mike Brando [mailto:[EMAIL PROTECTED] -->Sent: Thursday, November 06, 2003

Data Migration between 2 different schemas

Hi !! I am new to My SQL. I have got a requirement where data existing in one schema has to be migrated to another. Both schemas look alike except some minor changes in the table definitions here and there. Does MySQL provide some kind of tools by default for these sort of things or we need to go

RE: ROWID

> -Original Message- > On Thu, Nov 06, 2003 at 09:59:41AM -0800, Wan, Wenhua wrote: > > Hi there, > > > > Both Oracle and Informix use ROWID to uniquely represent the location of > > each row of data in a table. ROWID is basically a hidden column or > > pseudocolumn for each table, and it

a different compile error

I am having some compile problems too: make[4]: Entering directory `/usr/src/mysql-4.1.0-alpha/sql' source='sql_lex.cc' object='sql_lex.o' libtool=no \ depfile='.deps/sql_lex.Po' tmpdepfile='.deps/sql_lex.TPo' \ depmode=gcc /bin/bash ../depcomp \ gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/lo

RE: so long I keep longing

On the list I thought I saw that they where expecting it to come out this month to mid December - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: Jon Hancock [mailto:[EMAIL PROTECTED] --

RE: Compiling MySQL 4

At 13:26 -0600 11/6/03, Luis Lebron wrote: True, but the compilation options stated --without-readline . So what is going on? That means it won't use the readline library in the source tree, i.e., it expects to find a readline system library. -Original Message- From: Jeremy Zawodny [mailto:

Issues with Mysql 4.0 and PHP in a production environment

Are there any issues with running PHP 4.3.X and Mysql 4.0 in a production environment? thanks, Luis R. Lebron Project Manager Sigmatech, Inc

RE: MySQL List Digest ???

Thanks. I tried that awhile back to no avail. Am I correct that I should be receiving only a single large e-mail each day? Thanks! -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 1:22 PM To: Paul Fine Cc: [EMAIL PROTECTED] Subject: Re: M

RE: relationships

What do you mean by relations? Like table relations such as with FK in innodb? - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: Robert Morgan [mailto:[EMAIL PROTECTED] -->Sent: Thursday

Re: relationships

* Robert Morgan > Hi, is there a way of showing relationships in mysql? > > such as. mysql> SHOW relationships No. The relationships are dynamic, defined by join statements on the fly. You can however show any defined foreign key constraints using "SHOW CREATE TABLE tablename". -- Roger -- MyS

RE: This is confusing..?

> Can you send show keys from campaign_t. > I bet you can solve your problem by running analyze table. mysql> show index from campaign_t\g +++---+--+-+---+-+--++-+ | Table | Non_unique | Key_na

RE: Compiling MySQL 4

True, but the compilation options stated --without-readline . So what is going on? -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 1:25 PM To: Luis Lebron Cc: Mysql (E-mail) Subject: Re: Compiling MySQL 4 On Thu, Nov 06, 2003 at 01:01:4

Re: ROWID

On Thu, Nov 06, 2003 at 09:59:41AM -0800, Wan, Wenhua wrote: > Hi there, > > Both Oracle and Informix use ROWID to uniquely represent the location of > each row of data in a table. ROWID is basically a hidden column or > pseudocolumn for each table, and it is the fastest way to retrive a row from

so long I keep longing

for 4.1.1... .anyone have a good guess for getting a build of 4.1.1 ??? thanks, Jon

Re: Compiling MySQL 4

On Thu, Nov 06, 2003 at 01:01:47PM -0600, Luis Lebron wrote: > I am trying to compile MySQL 4.x on a Red Hat 8.0 but I'm getting the > following error > > /usr/bin/ld: cannot find -lreadline > collect2: ld returned 1 exit status > make[2]: *** [mysql] Error 1 > make[2]: Leaving directory `/usr/src

Re: This is confusing..?

On Thu, Nov 06, 2003 at 11:08:03AM -0800, Eric Anderson wrote: > > Given the following table: > > CREATE TABLE campaign_t ( > acct_id int(11) unsigned NOT NULL default '0', > site_id tinyint(3) unsigned NOT NULL default '0', > ref_id int(11) unsigned NOT NULL default '0', > datestamp char

Re: This is confusing..?

> Possibly because datestamp and 20041105 have different datatypes. > There's an implicit data conversion required for the comparison, which > in some cases prevents use of an index. Try writing '20041105' rather > than 20041105 and see if that makes a difference. Nope.. :-/ mysql> explain SELECT

Re: MySQL List Digest ???

On Thu, Nov 06, 2003 at 12:52:21PM -0600, Paul Fine wrote: > Greetings. I have posted a few times to no avail on this matter. > > Choosing to receive a message digest should send me the daily posts in a > single e-mail instead of getting individual e-mails every time someone > posts? > > I cannot

Re: This is confusing..?

> mysql> explain SELECT * FROM campaign_t WHERE datestamp < 20041105\g Try surrounding the value with quotes, i.e.: explain SELECT * FROM campaign_t WHERE datestamp < '20041105' -- Eric Jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:htt

Re: Benchmark differences: Mac OS X - Linux

On Thu, Nov 06, 2003 at 07:36:55PM +0100, Jan Pieter Kunst wrote: > Jeremy D. Zawodny: > > > > I was wondering if there is something I can do, configuration-wise, to > >> do something about those very slow 'inserts' (and 'updates') on the Mac? > >> > >> Thanks in advance for any insight, > > >

RE: This is confusing..?

> Can you send show keys from campaign_t. > I bet you can solve your problem by running analyze table. What's the syntax for 'show keys'? -- -- Eric Anderson - ICQ: 3849549 - San Diego, CA [EMAIL PROTECTED] | Mac and Bumbl

Re: This is confusing..?

At 11:08 -0800 11/6/03, Eric Anderson wrote: Given the following table: CREATE TABLE campaign_t ( acct_id int(11) unsigned NOT NULL default '0', site_id tinyint(3) unsigned NOT NULL default '0', ref_id int(11) unsigned NOT NULL default '0', datestamp char(10) NOT NULL default '', raws in

relationships

Hi, is there a way of showing relationships in mysql? such as. mysql> SHOW relationships Bob

RE: This is confusing..?

Can you send show keys from campaign_t. I bet you can solve your problem by running analyze table. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: Eric Anderson [mailto:[EMAIL PROTECTED

RE: This is confusing..?

I seem to remember someone saying that if a query would end up returning more than x% of a table (I think it was either 30% or 50%), then mysql just ends up doing a full scan regardless... > -Original Message- > From: Eric Anderson [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 06,

Re: [jp] connection from MSSQL

Hi Jorge, Hum! you should use MySQL Control Center (AKA mysqlcc)? You will not have to worry about configuring (I do not think it is feasible) openrowset fo connect to MySQL. Regards, Bernard On Thursday 06 November 2003 13:43, Jorge Paiva (f2) wrote: > Hi everybody.! > > can i use openrowset

Compiling MySQL 4

I am trying to compile MySQL 4.x on a Red Hat 8.0 but I'm getting the following error /usr/bin/ld: cannot find -lreadline collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory `/usr/src/mysql/mysql-4.0.16/client' make[1]: *** [all-recursive] Error 1 make[1]: L

Re: select statement with multiple databases

On Thu, Nov 06, 2003 at 10:36:08AM -0800, Jay Frumkin wrote: > Hello all, > > I am fairly new to MySQL. I have a problem, that I have not been able to > figure out. I've tried searching the net and reading the manual, but all to > no avail. > > I have two databases (A and B) which have the sa

This is confusing..?

Given the following table: CREATE TABLE campaign_t ( acct_id int(11) unsigned NOT NULL default '0', site_id tinyint(3) unsigned NOT NULL default '0', ref_id int(11) unsigned NOT NULL default '0', datestamp char(10) NOT NULL default '', raws int(11) unsigned NOT NULL default '0', uniqu

MySQL List Digest ???

Greetings. I have posted a few times to no avail on this matter. Choosing to receive a message digest should send me the daily posts in a single e-mail instead of getting individual e-mails every time someone posts? I cannot get it to happen. I have cancelled my sub and re-sub'd choosing the dige

Processes Closed, but max_connections exceeded...

Ladies and Gents; I've got a question for you. I've got a MySQL db running in FreeBSD 4.8, and have encountered the following problem. When I try to connect to a database by a specific user, I get the following response : #mysql -p -u comet Enter password: ERROR 1226: User 'comet' has exceede

[jp] connection from MSSQL

Hi everybody.! can i use openrowset from MS-SQL SERVER to connect to mysql server ??? how can i doing it? pls. thank you. pta: my english is poor... sorry. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECT

ROWID

Hi there, Both Oracle and Informix use ROWID to uniquely represent the location of each row of data in a table. ROWID is basically a hidden column or pseudocolumn for each table, and it is the fastest way to retrive a row from a table. Does MySql have similar field? If is, what's the name and h

Re: Benchmark differences: Mac OS X - Linux

I just installed Panther on my G5 at home. Unfortunately, for some reason I can't get the Perl module DBD::mysql to install (using CPAN, had no problems doing this in Jaguar) so I can't run the benchmark suite for now. JP I had similar issues, but I was also using a custom build of MySQL, wh

Re: Benchmark differences: Mac OS X - Linux

Jeremy D. Zawodny: > I was wondering if there is something I can do, configuration-wise, to do something about those very slow 'inserts' (and 'updates') on the Mac? Thanks in advance for any insight, Did it appear to be disk or CPU bound? Sorry, newbie here. I don't know how I can tell. The RU

Re: Benchmark differences: Mac OS X - Linux

On Thursday, November 6, 2003, at 11:38 AM, Jan Pieter Kunst wrote: I'd be curious what kind of numbers Panther shows. Once I get my xServe setup, just arrived, I'll try running some tests myself. I just installed Panther on my G5 at home. Unfortunately, for some reason I can't get the Perl mod

select statement with multiple databases

Hello all, I am fairly new to MySQL. I have a problem, that I have not been able to figure out. I've tried searching the net and reading the manual, but all to no avail. I have two databases (A and B) which have the same structure but different field names. The code from mysqldump follows (c

Simple question about updating a table field

I have a numeric table field, named "CREDIT". How can I add a number (+50) to that field for all the table record ? is this correct? UPDATE ThisTable SET CREDIT=CREDIT+50 Please help, Thanks __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuar

Re: mysql network security

Well, you would only need to setup a single ssh tunnel. All your different apps could then use the single tunnel. You could even setup RSA authentication so that it could start manually with no password entering required. Have it automatically come up on boot, etc. MySQL has no encryption built

Re: mysql network security

On Thu, Nov 06, 2003 at 11:41:54AM -0600, Andrew Falgout wrote: > > Does anyone know of a method for encrypting the network traffic to > and from a mysql database running on Redhat ES 2.1? At the moment, > only perl automation and php web pages are accessing the database. MySQL 4.0 and up have na

Re: mysql network security

Thanks for the quick response. I've never setup an ipsec before. I have been toying with the idea of using cipe to create a PPTP virtual network for the server to talk on. But the time to work on this project has not presented itself as of yet. I was wondering if there was an interface within m

Re: Benchmark differences: Mac OS X - Linux

On Thu, Nov 06, 2003 at 10:19:59AM -0700, Van wrote: > > Jeremy: > > I believe that's what I was attempting to convey. My suggestion was that the > G4 should not be disk bound (limited by disk bandwidth). The CPU on my DEC > Alpha is a meagerly 300, but the disk can stream faster than my PIII t

Re: mysql network security

On Thu, Nov 06, 2003 at 11:41:54AM -0600, Andrew Falgout wrote: > Does anyone know of a method for encrypting the network traffic to and from a mysql > database running on Redhat ES 2.1? At the moment, only perl automation and php web > pages are accessing the database. You could tunnel your co

Re: Table Creation

In the last episode (Nov 06), Arnoldus Th.J. Koeleman said: > What is wrong with this table creation > > > CREATE TABLE `spid_1__0` ( > `recordname` varchar(255) NOT NULL default '', > `data` enum NOT NULL, You didn't specify the values for your enum type. When you post questions like this,

Re: Table Creation

> What is wrong with this table creation > CREATE TABLE `spid_1__0` ( > `recordname` varchar(255) NOT NULL default '', > `data` enum NOT NULL, > PRIMARY KEY (`recordname`,`data`) > ) TYPE=MyISAM ROW_FORMAT=DYNAMIC; What is the specific error you are getting? W/o knowing that information, I

Table Creation

What is wrong with this table creation CREATE TABLE `spid_1__0` ( `recordname` varchar(255) NOT NULL default '', `data` enum NOT NULL, PRIMARY KEY (`recordname`,`data`) ) TYPE=MyISAM ROW_FORMAT=DYNAMIC; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To uns

mysql network security

Does anyone know of a method for encrypting the network traffic to and from a mysql database running on Redhat ES 2.1? At the moment, only perl automation and php web pages are accessing the database. Many Thanks, ./Andrew

Re: Benchmark differences: Mac OS X - Linux

Jeremy: I believe that's what I was attempting to convey. My suggestion was that the G4 should not be disk bound (limited by disk bandwidth). The CPU on my DEC Alpha is a meagerly 300, but the disk can stream faster than my PIII true Intel 733MHz. That's why I suggested he look at the disk / c

RE: INNODB flush holdup

I am running FLUSH TABLES manually. I am doing it each hour to generate a bin file, for incremental backups. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 10:05 AM To: Nihal Cc: [EMAIL PROTECTED] Subject: Re: INNODB flush holdup On T

Re: Benchmark differences: Mac OS X - Linux

On Thu, Nov 06, 2003 at 09:56:22AM -0700, Van wrote: > > I can't imagine a G4 would be disk bound relative to an Intel machine, unless > there is something very wrong with the disk or controller. Also, you might want > to defrag your disk on the Mac. > > G4s have much more disk bandwidth than an

Re: INNODB flush holdup

On Thu, Nov 06, 2003 at 09:40:41AM -0700, Nihal wrote: > Is there anything that can be done to increase the speed of a flush? > Can it be run while other queries are running? Are you actually running the FLUSH TABLES command? If so, why? > The problem I'm having is that every time a flush is wai

Re: Connection speed

On Thu, Nov 06, 2003 at 09:23:50AM -0700, Nihal wrote: > I think my mysql is resolving host names, and I would prefer it to not, > where do I set skip-name-resolve to prevent it? In the [mysqld] section of my.cnf. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTEC

Re: Newbie - How to determine hardware requirements?

On Thu, Nov 06, 2003 at 10:44:04AM -0600, Paul Fine wrote: > Greetings. > > Does anyone have any suggestions besides trial and error for determining how > resource intensive my database is going to be? > > Is this just something the a developer just gets a feel for after developing > a number of

Re: need a quick answer about myisamchk!!!

On Thu, Nov 06, 2003 at 08:33:55AM -0800, Henry Hank wrote: > > Very simple question: > > Can I use myisamchk version 2.6 (from mysql 4.0.15) to fix/repair a table from > mysql version 3.23.41 (which includes myisamchk version 1.49)?? It should be safe, yes. -- Jeremy D. Zawodny | Perl, We

Re: Mysql on panther

Thanks to all the help...I got it working!!! Basically, as recommended, I created a my.cnf I also chown my /var/mysql directory to user 'mysql' and I am cooking now Thanks again!! Nestor :-) Nestor A. Florez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Benchmark differences: Mac OS X - Linux

I can't imagine a G4 would be disk bound relative to an Intel machine, unless there is something very wrong with the disk or controller. Also, you might want to defrag your disk on the Mac. G4s have much more disk bandwidth than any Intel I've ever seen. Almost as much as my DEC Alpha. >:) Va

Re: strange OS X (Panther) & MySql 4.0.16 behaviour!!! HELP!!!

Is the live site also running Apache 2? Are they both using the same version of PHP? Panther upgrades the version of php installed as well as overwriting your httpd.conf file. I'm pretty sure Apple renames the existing copy to httpd.conf.applesaved. If you are using PEAR to handle your pagi

Newbie - How to determine hardware requirements?

Greetings. Does anyone have any suggestions besides trial and error for determining how resource intensive my database is going to be? Is this just something the a developer just gets a feel for after developing a number of databases or are there some guidelines I can use? Thanks for any help!

RE: INNODB flush holdup

Is there anything that can be done to increase the speed of a flush? Can it be run while other queries are running? The problem I'm having is that every time a flush is waiting to happen no new connections can be initiated and all my queries are on hold. If there is something long running before i

Re: Mysql on panther

[MySQL won't start] Maybe this knowledge base article is useful: JP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Benchmark differences: Mac OS X - Linux

I'd be curious what kind of numbers Panther shows. Once I get my xServe setup, just arrived, I'll try running some tests myself. I just installed Panther on my G5 at home. Unfortunately, for some reason I can't get the Perl module DBD::mysql to install (using CPAN, had no problems doing this in

need a quick answer about myisamchk!!!

Very simple question: Can I use myisamchk version 2.6 (from mysql 4.0.15) to fix/repair a table from mysql version 3.23.41 (which includes myisamchk version 1.49)?? The reason is that I have more disk space and processing power on a machine with 4.0.15 installed, but I'd like to rebuild some tab

Re: Mysql on panther

There is no my.cnf by default on OS X. Unless you want to override default compiled settings, it's not really needed. But you usually do, so you need to create your own. MySQL comes with some samples you can use. As for your problems. Your directories where everything is located look like wher

RE: strange OS X (Panther) & MySql 4.0.16 behaviour!!! HELP!!!

Jason, The possiblity exists that the issue is Apache. I only use 1.3 so I cannot give specific feedback. Is the PHP.ini file the same in production and as in development? Regards, Adam -Original Message- From: g4 [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 11:20 AM To: [

RE: Connection speed

I think my mysql is resolving host names, and I would prefer it to not, where do I set skip-name-resolve to prevent it? Thanks. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 8:43 AM To: Daniel Kiss Cc: [EMAIL PROTECTED] Subject: Re: C

strange OS X (Panther) & MySql 4.0.16 behaviour!!! HELP!!!

Hi list, I'm still trying to ascertain if this is in fact an MySql problem, here goes. I'm developing locally on My G4 box running Apache 2 + MySql 4.0.16, I have a live site on a FreeBSD box running Apache 1.3 + MySql 3.x. The site is an e-commerce site (PHP 4.3). When I try and access a p

Re: Mysql on panther

At 8:04 -0800 11/6/03, Nestor Florez wrote: Egor, Where is the datadir locate? :-) The message below says: > Starting mysqld daemon with databases from /var/mysql Which indicates that /var/mysql is the datadir. Change location into the directory and have a look around. Try "ls -la ." to see w

Re: Mysql Connection Problems

On Wed, Nov 05, 2003 at 03:39:03PM +1030, John wrote: > HI All > > I was wondering if anyone could tell me how to get around this problems > > Error: could not connect to the database. > It's possible the database itself is just not working at the moment. > The admin should also check that the d

UPDATE TABLE with > 32 MB string corrupts ISAM

>Description: When inserting large strings into ISAM table in an UPDATE TABLE command, my perl script generates an "Out of memory error". I tracked this down using an SQL script (below). It seems that a 32777225 character string is tolerated, but a string one character larger is not. >How-To-Re

  1   2   >