SOLVED: Problem with *very* slow replication, FreeBSD 6.2

An update for those actually paying attention. I have been fighing unusual performance issues with replication between FreeBSD 6.2 machines. The unusual part is that while replication would never top 10 writes per second (even while the master was taking hundres of writes per second), the

Re: append on insert

This one time, at band camp, "Martin Gainty" <[EMAIL PROTECTED]> wrote: > Kevin- > > Declare the column AUTO_INCREMENT > http://lists.mysql.com/mysql/161930 You can auto increment a non INT field? Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

append on insert

I have a table of item I wish to have the value of the item incremented if there is a duplicate. I looked at ON DUPLICATE KEY UPDATE but this modifies the exsisting value. If the item is my-item and this already exists, I need to make it my-item-2 or even my-item-123 where 123 is the key. Kind reg

Re: sporadic error 13 on windows

Kristen G. Thorson wrote: -Original Message- From: Artem Kuchin [mailto:[EMAIL PROTECTED] Sent: Friday, November 02, 2007 9:23 AM To: Baron Schwartz Cc: mysql@lists.mysql.com Subject: Re: sporadic error 13 on windows DBD::mysql::st execute failed: Can't create/write to file '#sql_948_0.M

Re: Table Size

There's a bitmap of which columns in the table allow NULL. This contains as many bits as there are NULL-able columns in the table, rounded up to the nearest byte. When a column is NULL, the bit is set to 1. That said, I'm not sure whether the CHAR's storage space is still present in the row

Re: Table Size

Thanks for all of your help/information. One additional question... do NULL values take up any space? For example, if I have a column defined as: repAccess char(1) default null When a user should have access to run a particular report, repAccess will be set to 'T'. If not, it is left null.

Re: grouping

Hi, Octavian Rasnita wrote: Hi, I have a table with the following columns: symbol date value I want to select all the symbols (grouping by symbols) between 2 specified dates, and calculate the percent of change for each symbol. The percent of change is (the value from the last date of the

Bounty on MySQL Table Sync features

Many of you have used MySQL Table Sync (or other tools from the MySQL Toolkit I maintain). It has become increasingly complicated and time-consuming to develop these tools, and I can't keep up with them in my spare time anymore. I am willing to take some time off work to fix bugs and add feat

RE: sporadic error 13 on windows

-Original Message- From: Artem Kuchin [mailto:[EMAIL PROTECTED] Sent: Friday, November 02, 2007 9:23 AM To: Baron Schwartz Cc: mysql@lists.mysql.com Subject: Re: sporadic error 13 on windows DBD::mysql::st execute failed: Can't create/write to file '#sql_948_0.MYD' (Errcode: 13) at clea

Re: sporadic error 13 on windows

Baron Schwartz wrote: What do you get from the following: mysql> show variables like '%tmp%'; 1) if i set tmpdir=C:/temp it shows: mysql> show variables like '%tmp%'; +---+---+ | Variable_name | Value | +---+---+ | max_tmp_tables| 32

Re: sporadic error 13 on windows

What do you get from the following: mysql> show variables like '%tmp%'; Artem Kuchin wrote: anyone any idea on this ? On 10/31/07, Artem Kuchin <[EMAIL PROTECTED]> wrote: I am running Server version: 5.0.45-community-nt MySQL Community Edition (GPL) on WIndows 2003 R2 Service Pack 2 Standar

Re: sporadic error 13 on windows

anyone any idea on this ? On 10/31/07, Artem Kuchin <[EMAIL PROTECTED]> wrote: I am running Server version: 5.0.45-community-nt MySQL Community Edition (GPL) on WIndows 2003 R2 Service Pack 2 Standard Edition I have a database dig perl script with basically does a lot of SELECT [somefield] as

Re: corrupted query cache?

Hi Max, Max Thayer wrote: What's your question? Heh, yah that might be important... Has anyone experienced this? Does it look like anything in the my.cnf could be altered to alleviate or assist me in diagnosing the problem? I do not get an indication of any problems in the log files or the b

grouping

Hi, I have a table with the following columns: symbol date value I want to select all the symbols (grouping by symbols) between 2 specified dates, and calculate the percent of change for each symbol. The percent of change is (the value from the last date of the symbol - the value from the f

Errors management

Hi All, I have this question... I send a INSERT from client to server, the server write the row and send the result "ok" to the client. Due to a network failure the client doesn't receive the result and an error is reported to the user. How can I manage this error? -- Ciao Mirko -- MySQL G