RE: max packet size question

On Fri, 2005-10-21 at 21:40 -0700, Logg, Connie A. wrote: > The max packet size depends on the MTU your network and interface settings > allow. > The common packet size is 1500, however, if you can use 9000, you will get > much better performace. I believe Rob is talking about MySQL packet sizes

Running mysql on XP

Hello! I am trying to run mysql on XP. I have started the net start mysql. This service started without any error. My.ini file was there in c:\windows only. But i couldn't able to connect mysql. Can anyone please tell me where is the problem? regards uma -- MySQL General Mailing List For

RE: max packet size question

I forgot to mention that the buffer sizes, block sizes and window sizes you use can also make a big difference. You need to calibrate those for your systems and you need to understand the characteristics of your source and destination nodes. If you are desparate for performance, you may need to

RE: max packet size question

The max packet size depends on the MTU your network and interface settings allow. The common packet size is 1500, however, if you can use 9000, you will get much better performace. Connie Logg Network Analyst Stanford Linear Accelerator Center -Original Message- From: Rob Brooks [mailt

Re: Should I buy commercial license?

Hi Jim, Thanks for your clarification. I'm sorry, but I don't have enough understanding MySQL usage under GPL. If I use MySQL from web interface, like PHP, Perl, ASP .NET, Java, under GPL license, do I need to make my web-system GPL? I think, it's a topic about mysql client library within mysql

max packet size question

Is there a practical maximum for max packet size? Is it simply a function of the amount of memory that you have?

Re: source rpm for mysql 4.1.15

On Friday 21 October 2005 07:04 pm, Stever wrote: > Is there any reason why there isn't a source rpm for mysql 4.1.15? I > need to compile my own version since (annoyingly), there doesn't seem to > be a binary rpm version that works with glibc 2.2.5. > > Anyone out there created a source rpm for my

source rpm for mysql 4.1.15

Is there any reason why there isn't a source rpm for mysql 4.1.15? I need to compile my own version since (annoyingly), there doesn't seem to be a binary rpm version that works with glibc 2.2.5. Anyone out there created a source rpm for mysql? - Steve -- MySQL General Mailing List For list a

Re: Options --lock-tables, --lock-all-tables do not work in mysql-4.1.8

Slawomir Orlowski (CYMPAK) wrote: hello, I have mysql-4.1.8 compiled form source working on RH7.2. I have tried to backup my database with mysqldump. mysqldump --opt database_name > database_name.sql mysqldump --lock-tables database_name > database_name.sql mysqldump --skip-opt --lock-tables

Re: multiple commands to mysql from regular command line

Dustin Krysak wrote: > Hi there, I was wondering if it was possible to issue multiple commands > to mysql from a regular command line? For example i know you can issue > a single by the following: > > mysql -u${DB_USER} -p${DB_PASSWORD} -e 'show databases' e.g., -e 'show databases; use

Re: multiple commands to mysql from regular command line

On Fri, 2005-10-21 at 14:34 -0700, Dustin Krysak wrote: > Hi there, I was wondering if it was possible to issue multiple > commands to mysql from a regular command line? For example i know you > can issue a single by the following: > > mysql -u${DB_USER} -p${DB_PASSWORD} -e 'show databases' >

multiple commands to mysql from regular command line

Hi there, I was wondering if it was possible to issue multiple commands to mysql from a regular command line? For example i know you can issue a single by the following: mysql -u${DB_USER} -p${DB_PASSWORD} -e 'show databases' Now what if for example i needed to select a database, then run a

Question: java/struts, utf8, mysql413

Hi All, [I tried posting this in mysql/java list but didn't get a response, so trying here. Sorry, if OT] I recently started experimenting with storing utf8 data on mysql 413 database server. the character set and all on the db server are properly set. When I submit a html form with option set a

Options --lock-tables, --lock-all-tables do not work in mysql-4.1.8

hello, I have mysql-4.1.8 compiled form source working on RH7.2. I have tried to backup my database with mysqldump. > mysqldump --opt database_name > database_name.sql > mysqldump --lock-tables database_name > database_name.sql > mysqldump --skip-opt --lock-tables database_name > database_name.s

Re: implicit cast forces table scan?

Gleb Paharenko wrote: > Hello. > > I suggest you to check you query with MySQL 4.1.14 which might has a bit > clever optimizer. Did you read my earlier reply? This is neither an optimizer nor version issue. Consider: mysql> SELECT VERSION(); +---+ | VERSION() | +---+ | 4.1.15

RE: Input on Materialized Views

> Better, mark this view (or particular rows if it's not too > expensive) as "dirty" and recompute it only on access, you > may spare few cycles... That sort of depends on what you're going for. Typically materialized views are used for summarizations of hypercubes for OLAP systems (data marts

RE: implicit cast forces table scan?

Hi, You are correct; it was an error that the column was defined as a VARCHAR. I started out without quotes in the SELECT because the application that uses this db has been running successfully, so I believed the column types to be OK. Now I know better. Once I realized the problem was with the

Re: ssh connecting with a mysql client I get: ERROR 2013

Gleb Paharenko wrote: Hello. Can you connect using the mysql command line client program? "leegold" <[EMAIL PROTECTED]> wrote: ssh connecting with a mysql client gui I get: ERROR 2013 Lost connection to MySQL server during query I'm using mysqlyog and trying connect via the ssh

Re: Should I buy commercial license?

Hi Hirohama, Due to the fact that MySQL is licensed under a dual licensing system, you do not need to purchase a license of MySQL for using the database software for commercial use. You have a choice in the case that you don't like the terms of the GPL license[1], you can choose to license t

Re: Should I buy commercial license?

Kenji HIROHAMA wrote: (I've posted to forums, but also send to this ML.) Hi, I took a look at mysql.com, but I still have a question about commercial license. If we build and host a web-system with MySQL, which provide services to customers not for free. Customers pay for our services. In thi

Re: one product in more categories

Response intermixed: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote on 10/21/2005 09:19:41 AM: > Thanks Shawn. > See comments: > > [EMAIL PROTECTED] wrote: > > >Sorry I didn't get back to you earlier today. I have had a busy day. > >Comments embedded... > >"[EMAIL PROTECTED]" <[EMAIL PROTECTE

Re: one product in more categories

Thanks Shawn. See comments: [EMAIL PROTECTED] wrote: Sorry I didn't get back to you earlier today. I have had a busy day. Comments embedded... "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote on 10/20/2005 04:35:30 PM: Could you please tell me should this work? CREATE TABLE categories ( c

Problem Upgrading

I am attempting to upgrade using the source from 4.1.13 to 4.1.15 on a Redhat 7.2 machine and have been experiencing problems using the mysql client. I keep having to revert back to 4.1.13 as it installs just fine. # mysql -h localhost -u root Welcome to the MySQL monitor. Commands end wit

Re: Clarification required

[EMAIL PROTECTED] wrote on 21/10/2005 12:28:18: > Hi, > > I had installed a free version of mysql database software in one of the > servers that are available to me. I had installed the mysql in the c:/ > folder, is it possible for me to change the data storage location from > C:\mysql\data\

Re: Terrible MySQL Administrator

Hi Scott. Thanks for the reply. Saying that I deleted the crontab was incorrect. I should have said that I deleted the line where that crontab schedule was entered. Anyway, it hasn't shown up as I did a crontab -e, which would have reloaded it, so perhaps it worked. Cheers Scott Haneda: >

pgrep shows 2 processes!

Dear List, I have one mysql 4.1.11 running wich just shows 2 Processes. Other mysql environments I do have show more than 10 Processes. I don't have no clue where this difference comes from. The Only significant difference I see on `show variables` with thees two servers are: <10 PID`s Server

Should I buy commercial license?

(I've posted to forums, but also send to this ML.) Hi, I took a look at mysql.com, but I still have a question about commercial license. If we build and host a web-system with MySQL, which provide services to customers not for free. Customers pay for our services. In this case, we don't distrib

Clarification required

Hi, I had installed a free version of mysql database software in one of the servers that are available to me. I had installed the mysql in the c:/ folder, is it possible for me to change the data storage location from C:\mysql\data\ to D:\mysql\data. ( i.e., changing the drive location from c

Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1

Privet! It works in 5.0.13. But for a pity not in 4.1.14. I've reported a bug, you may want to add your comments at: http://bugs.mysql.com/bug.php?id=14153 [EMAIL PROTECTED] mysql-debug-5.0.13-rc-linux-i686-glibc23]$ lmysql Welcome to the MySQL monitor. Commands end with ; or \g. You

Re: can i replicating innodb table?

Hello. Have a look here: http://dev.mysql.com/doc/refman/5.0/en/innodb-and-mysql-replication.html Hiu Yen Onn <[EMAIL PROTECTED]> wrote: > can i replicating innoble tables? does the master db and the slave db > will having the same of information when they are doing replication? thank

Re: MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION' -- again

Hello. > MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) >and (utf8_general_ci,IMPLICIT) for operation 'UNION' -- again Check the character set of fields in you tables with 'SHOW CREATE TABLE' statement. I recommend you to test if the problem remains in 4.1.14 ve

Re: Repeated, occasional 2002 Connect errors/Aborted connections

Hello. Have a look here: http://dev.mysql.com/doc/mysql/en/Communication_errors.html Viktor Fougstedt wrote: > > Hi. > > We have a MySQL database as backend on our 15.000 user mailserver. This > MySQL instance receives a large amount of connections, each performing > just a sma

Re: implicit cast forces table scan?

Hello. I suggest you to check you query with MySQL 4.1.14 which might has a bit clever optimizer. Olaf Faaland wrote: > Hi, > > I am currently using mysql 4.0.18 as distributed with red hat Linux. I find > when I perform a select on a varchar(30) field, the index is used only if I >

Re: Temp tables

Hello. > Is there anything I can do to get this query to run - is there a size > limit for the temp tables that can be tweaked? Have a look here: http://dev.mysql.com/doc/refman/5.0/en/full-table.html Erich C. Beyrent wrote: > Hi all, > > I am running into a brick wall with a q

Re: reinstall mysql show innodb error

Hello. Check the correct values in your configuration file for the size of the log files. If you're sure that shutdown of the server was clean, you can remove log files, InnoDB will recreate them (I suggest you to make a backup of the old log files just in case something went wrong in the sh

Re: copy database other than mysqldump

Hello. Have a look here: http://dev.mysql.com/doc/refman/5.0/en/upgrading-to-arch.html http://dev.mysql.com/doc/mysql/en/Moving.html Luke Vanderfluit wrote: > Hi. > > I'm using 4.0.18 and for legacy reasons I can't upgrade that. > > However I'm upgrading the database to a new s

Re: load data infile

Hello. > my mysql version is 4.2.2 Are you sure that you have this version? I strongly recommend you to use the latest release (4.1.15 now). > The used command is not allowed with this MySQL version Have a look here: http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html '

Re: database won't load after machine reboot

Hello. > Is there any way I can reset the root password? (Ouch). See: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html Luke Vanderfluit wrote: > Hi David. > Thanks for your help. > > Logan, David (SST - Adelaide) wrote: > >> Hi Luke, >> >> Have you tried d

Re: delete with an offset?

Dobromir Velev wrote: delete from where to_uid=1 and read_timestamp>0 and timestamp<(select timestamp from messages where to_uid=1 and read_timestamp>0 order by timestamp desc limit 100,1) HTH Thanks for your answer, I guess i'll have to do with two queries, but it looked like such and ide

Re: delete with an offset?

I don't think it is possible at least not with one query. You can limit the numbers of record to delete, but at least until 4.1 there is no offset. Probably you can do it with a subselect like this delete from where to_uid=1 and read_timestamp>0 and timestamp<(select timestamp from messages wh

Re: restore of mysqldump-ed data is corrupted

Gleb Paharenko wrote: Are you able to get a correct data in some way (through PHP for example)? Or every method you have tried produces a wrong data? I know for one and only method: mysql -u root -p database < backup.sql. If you know for some other method, please share it with me. mysqldump

delete with an offset?

Hi, Is it possible to delete from a table with some sort of offset? I did the following select query, which selects a message from a message table. select id, subject from messages where to_uid=1 and read_timestamp>0 order by timestamp desc limit 3,1; The reason is I only want it to be 3 me

Re: Joined My Head to My Ass

G G wrote: I have two tables: Records: member_id - int question_id - int Questions: id - int I'm looking to select a random id from the questions table, given that there is no record of the user already answering that question. SELECT * FROM `Questions` AS t1 LEFT JOIN `Records` AS t2 ON t

Joined My Head to My Ass

Alright, I like to think I'm relatively competent with MySql, but I need a guru's help with this one as after hours of fooling with it the only thing I've joined is my head to my ass. Here's the deal. I have two tables: Records: member_id - int question_id - int Questions: id - int