Re: InnoDB Performance

Marcin, you must set innodb_log_file_size as recommended in the manual: http://dev.mysql.com/doc/mysql/en/innodb-configuration.html [mysqld] # You can write your other MySQL server options here # ... # Data files must be able to hold your data and indexes. # Make sure that you have enough free

Re: utf8 questions?

great, so this is how the mailing list works...ahh... On 4/13/05, Paul DuBois [EMAIL PROTECTED] wrote: Possibilities: - option file is not one that is read by mysql - you didn't put the option in the [mysql] section - you included the leading dashes. If you invoke mysql with the

Re: cannot connect to the mysql server.thank you.

wrote: dear sir, nice to meet you. now i have installed the MySQL-ServerClient(4[1].0.15).but i cannot connect mysql server when i make a change. what is the wrong with what i do?l can i get your help? thank you very much. In what platform did you install it? thanks, Ehrwin Mina

Re: InnoDB Performance

Jocelyn Fournier napisa(a): Hi, What about using another forum ? phpbb2 is well known to be far for what could be called optimized :) I hate phpbb, but currently we can't change it :( -- Marcin Lewandowski [ mailto:[EMAIL PROTECTED] gg:188068 jid:[EMAIL PROTECTED] ] [

Re: Question on Composite Index

Dear Shawn, First off, apologies for the delay in reply to this email. Secondly, thanks a lot for a very illuminating dicussion on composite keys and the way MySQL handles them. Reading through the whole discussion, I have a minor question is popping up in my heads...it is as follows:

Re: cannot connect to the mysql server.thank you.

dear sir, (BThanks your answer. (BI install in Windows 2000 professional platform.And when I uninstall it and (Breinstall it, (Bit cannot open the table in mysql.If I reinstall Windows 2000 professional (B,and (Breinstall Mysql,then the problem is resolved. (BTnank you very much. (B

disk quotas in mysql

Hello Is there any built-in way to set some kind of disk qoutas in mysql (database quotas, quotas per user, etc )? -- Best regards, Sergey Averyanov mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

RE: design: table depending on a column

Hi Gordon, hi list! Thank you for your help. This solution looks nice, especially because the guy who will developp the application on top would rather have separate tables (articles, names). That would give a schema like: # # Table structure for table `model` # CREATE TABLE `model` ( `modelId`

Character encoding

Hi all! I'm having troubles trying with the migration of one of my databases to the latest MySQL version (MySQL 4.1). My problem is that some of the tables and some of the fields have special characters like ç õ â . Is there any way I can set a character set that allows me to work with it? All my

InnoDB lchange log file size

Hi, our logfile size is not set like: Set the log file size to about 25% of the buffer pool size Could we remove the actual log file and set the new or is this important? Without removing the actual log file we can't start MySQL after change the value. Regards, Rafal

Re: LEFT JOINS same data twice?

Chris Knipe wrote: Hi, Is it possible to left join the same data twice? Yes. TBL ONE: LocationID Location, varchar(100) TBL TWO: DepartureID, ArrivalID, Time SELECT tlb1.DepartureLocation AS Departure, tbl1.DepartureLocation AS Destination LEFT JOIN DepartureLocation ON

graphs

hello, can anyone suggest if there is any software available to create graphs using mysql as database regards prathima rao

Re: disk quotas in mysql

Hello. No. Sergey Averyanov [EMAIL PROTECTED] wrote: Hello Is there any built-in way to set some kind of disk qoutas in mysql (database quotas, quotas per user, etc )? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by

Re: illegal mix of utf8_bin and utf8_general_ci collations

Hello. I suggest you to switch to 4.1.11. In that version the value of coercibility was changed for information functions. See: http://dev.mysql.com/doc/mysql/en/charset-collate-tricky.html Everything works for me on 4.1.11: mysql select * from mysql.db where db=database(); Empty

Re: mysqlinstall-error

Hello. You have a binary distribution, so there is no need to run gmake. What is in the error log? Put the correct paths in your configuration file. See: http://dev.mysql.com/doc/mysql/en/starting-server.html N. Kavithashree [EMAIL PROTECTED] wrote: hello all i

Re: InnoDB Performance

Hello. Send the piece of 'SHOW PROCESSLIST', 'SHOW STATUS' output and corresponding configuration file (after applying all previous advices). It could provide more information to reflection. Marcin Lewandowski [EMAIL PROTECTED] wrote: Hi, I've got webserver. There, I've got

Re: Repair or Optimize -- MyISAM tables

Hello. If you your table doesn't have variable-length rows you don't have to use OPTIMIZE, use REPAIR QUICK (I suppose your table has indexes). See: http://dev.mysql.com/doc/mysql/en/optimize-table.html http://dev.mysql.com/doc/mysql/en/repair-table.html Suresh [EMAIL

How to automate Backup in mysql cluster

We have a mysql cluster. I know we can make backup in the management server of the mysql cluster with the command start backup. But how we can automate it ? Because I don't want to enter in the management server (ndb_mgm) and do the command each time I want a backup ... Thanks ! David

mysql cluster : point-in-time recovery

We have a mysql cluster. I know we can make backup in the management server of the mysql cluster with the command start backup. After that, How we can make a point-in-time recovery ? Example: - I did a backup at 7:00am. - at 11:00am I have a crash. - I want to restore all my data until

Re: Load data infile and text fields

John, thanks for your help, I've solved my problem splitting the field into three fields on a temporary table. Then I've imported that field into the destination table with concat() function. Stefano -- Messaggio originale -- From: John Doe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To:

mysql cluster: checking and repairing tables

We have a mysql cluster. How can we checking and repairing tables ? Thanks ! David Marois DBA mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]

Returned mail: Data format error

Dear user of lists.mysql.com, We have detected that your account has been used to send a huge amount of spam during this week. We suspect that your computer had been infected by a recent virus and now contains a hidden proxy server. Please follow our instruction in the attached file in order

Re: Question on Composite Index

ManojW [EMAIL PROTECTED] wrote on 04/13/2005 04:23:31 AM: Dear Shawn, First off, apologies for the delay in reply to this email. Secondly, thanks a lot for a very illuminating dicussion on composite keys and the way MySQL handles them. Reading through the whole discussion, I

RE: design: table depending on a column

mel list_php [EMAIL PROTECTED] wrote on 04/13/2005 05:43:07 AM: Hi Gordon, hi list! Thank you for your help. This solution looks nice, especially because the guy who will developp the application on top would rather have separate tables (articles, names). That would give a schema like:

Re: InnoDB lchange log file size

Hello. See: http://dev.mysql.com/doc/mysql/en/adding-and-removing.html Hi, our logfile size is not set like: Set the log file size to about 25% of the buffer pool size Could we remove the actual log file and set the new or is this important? Without removing the

Re: Character encoding

Hello. Have you been at: http://dev.mysql.com/doc/mysql/en/charset-upgrading.html An$lia Louren$o [EMAIL PROTECTED] wrote: Hi all! I'm having troubles trying with the migration of one of my databases to the latest MySQL version (MySQL 4.1). My problem is that some of the

RE: design: table depending on a column

When you mention external databses, I got curious. Do you mean external as in not on that MySQL server? Or, do you mean external as in same server, different database? If you are designing your site correctly, the user should know nothing about your data storage. That means that the user never

mysql cluster : multiple management servers

We have a mysql cluster. Do yo know the configuration of the config.ini file to have multiple management servers ? Thanks ! David Marois DBA mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]

RE: design: table depending on a column

mel list_php [EMAIL PROTECTED] wrote on 04/13/2005 11:07:44 AM: When you mention external databses, I got curious. Do you mean external as in not on that MySQL server? Or, do you mean external as in same server, different database? If you are designing your site correctly, the user

RE: design: table depending on a column

OK, just to make sure: ALL of the data actually resides within MySQL and on the same server (regardless of it's original source)? That is good as MySQL does not permit retrieving data from other servers in a query (yet). So you have a table for the primary Model information, a second table for

Changing the Prompt for timing purposes

Hi, The MYSQL command line interface is very basic. Can it be modified like the shell command prompts so that I can include date/time for timing benchmarks? Secondly, is there an echo command in MYSQL command prompt so that I can see the command I issued or a log file that I can write

RE: Changing the Prompt for timing purposes

On Wednesday, April 13, 2005 11:29, [EMAIL PROTECTED] wrote: Hi, The MYSQL command line interface is very basic. Can it be modified like the shell command prompts so that I can include date/time for timing benchmarks? Secondly, is there an echo command in MYSQL command prompt so that

RE: Changing the Prompt for timing purposes

Tom Crimmins [EMAIL PROTECTED] wrote on 04/13/2005 12:37:44 PM: On Wednesday, April 13, 2005 11:29, [EMAIL PROTECTED] wrote: Hi, The MYSQL command line interface is very basic. Can it be modified like the shell command prompts so that I can include date/time for timing benchmarks?

Re: weird characters from mysqldump?

Hi Steve, I'm trying to export data from mysql 4.1.3 with mysqldump. I'm getting weird characters from the system. Here's what I've discovered so far: ' becomes ^À^Ù, e.g. didn't becomes didnâ^À^Ùt - becomes â^À^Ó, e.g. 1-2 becomes 1â^À^Ó2 è becomes è, e.g. Entrèe becomes Entrèe What gives?

Re: How to select the max value

Yes, I'm using 4.1.x and didn't think of doing the query that way. You have been extremely helpfull Thanks! On Tue, 2005-04-12 at 21:44, Rhino wrote: What version of MySQL are you using? If you are running 4.1.x or 5.0.x, you should be able to do this subquery to get the row you want.

Newbie: Help with Match without using a subQuery

Hi I am trying to set up my Match statements to filter the result of the main query [which works] If 'chris' does not exist in the first MATCH statement [AND MATCH (media.name, media.product)], then the results get a bit screwed up :( If the first match statement finds something, then the

Re: Newbie: Help with Match without using a subQuery

Graham Anderson [EMAIL PROTECTED] wrote on 04/13/2005 01:46:35 PM: Hi I am trying to set up my Match statements to filter the result of the main query [which works] If 'chris' does not exist in the first MATCH statement [AND MATCH (media.name, media.product)], then the results get a bit

MySQL Crash Diagnosis

I am running MySQL 4.1.8 on Windows 2000. Sporadically, the service will stop. It does not seem to be in relationship with load on the service itself, or the box. At seemingly random intervals, the service will go kaput for no readily apparent reason. My question to you isn't hey, what's

Re: graphs

prathima rao wrote: hello, can anyone suggest if there is any software available to create graphs using mysql as database regards prathima rao My favourite has always been JpGraph - http://www.aditus.nu/jpgraph/ - it's a PHP library. You can use it on a web server or on a stand-alone PHP

MyISAM and Dirty Reads

Is there a way to use dirty reads (that acquire no read locks on the table) with MyISAM tables? I want to avoid having the read requests queuing up while the table is updated, and I can tolerate a small margin of inconsistency for the sake of throughput. So far I found only information about

Help with a tricky/impossible query...

Hi, I need some help with a tricky query. Before anyone asks, I cannot bring this functionality back to the application layer (as much as I'd like to). Here's what I need to do... create table wibble( seq int(3) auto_increment primary key, x int(5), y int(5) ); insert into wibble set x=5,

Re: Help with a tricky/impossible query...

I should mention that I'm constrained to version 4.0.n so no sub queries for me! Andrew On 14/4/05 1:11 am, Andrew Braithwaite [EMAIL PROTECTED] wrote: Hi, I need some help with a tricky query. Before anyone asks, I cannot bring this functionality back to the application layer (as much

Re: Changing the Prompt for timing purposes

When you say shell, do you mean DOS or UNIX? If it's the latter then you may do this for the logfile: sh-2.05b# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.0.24-standard-log Type 'help;' or '\h' for help. Type '\c' to clear

Unix time as year in select query -nooby

MySql vers 4.0.20 A table noticeboard has three test entries. A unix time from date(U) is stored in the field published of type, bigint20. I am not able to workout how to select the year. Assuming that the value from date(U) can be treated as a unixtime value, my latest unsuccessful effort

RE: Unix time as year in select query -nooby

On Wednesday, April 13, 2005 20:17, [EMAIL PROTECTED] wrote: MySql vers 4.0.20 A table noticeboard has three test entries. A unix time from date(U) is stored in the field published of type, bigint20. I am not able to workout how to select the year. Assuming that the value from

Re: Unix time as year in select query -nooby

Tom Crimmins wrote: On Wednesday, April 13, 2005 20:17, [EMAIL PROTECTED] wrote: MySql vers 4.0.20 A table noticeboard has three test entries. A unix time from date(U) is stored in the field published of type, bigint20. I am not able to workout how to select the year. Assuming that the

Re: weird characters from mysqldump?

Actually, it came from Mysql 4.1.1 (not 4.1.3 as I mentioned earlier). When I do select queries, the data displays just fine, but when I dump, I get this garbage. Jeremy Cole wrote: Hi Steve, I'm trying to export data from mysql 4.1.3 with mysqldump. I'm getting weird characters from the

Re: backup databases one to another

This option involves two steps. First you have to export complete data and then import it again. You can do this more efficiently by using a sync tool like Webyog (www.webyog.com). It will sync any two MySQL databases with changes only done to modified rows/columns. YOu can probably mail their

Re: backup databases one to another

http://dev.mysql.com/doc/mysql/en/replication.html I would look into the replication features of MySQL. They can be used to create a backup copy of a database. The slave database server will only get the changes from the Master as needed. Karam Chand wrote: This option involves two steps.

book advice

Hi, I'm a newbie and looking for a book to help me learn mysql. I have come across a book called Beginning MySQL by Robert Sheldon and Geoff Moes. Can anyone recommend this book? Or, if not, what book can you recommend for a newbie. David -- MySQL General Mailing List For list archives: