Re: Mysql tuning - server Crash 1

In my .err. file I have key_buffer_size=8388600 read_buffer_size=131072 max_used_connections=652 max_connections=1000 threads_connected=640 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 2184184 K bytes of memory

Re: Mysql tuning - server Crash 1

As for as I understand my server crashed with 640 concurrent connections - http://lists.mysql.com/mysql/180583 -. Am I wrong? I think it could be a problem in my variables (tuning required) Can you have a look at my variables http://lists.mysql.com/mysql/180581 I have 2GB ram, and the server is run

RE: ODD COUNT(*) Results on Self-Join (Bug?)

On Sunday, February 27, 2005 19:20, Van wrote: Hi Van, > Greetings: > > I've got a table that has the following fields that are relevant to my > self-join: > FileName | varchar(100) | | MUL | >| > Title | varchar(45) | | MUL | >| > Type | v

ODD COUNT(*) Results on Self-Join (Bug?)

Greetings: I've got a table that has the following fields that are relevant to my self-join: | FileName | varchar(100) | | MUL | || | Title | varchar(45) | | MUL | || | Type | varchar(20) | |

Re: Reading from Mysql & writting in PGsql

On Sun, 27 Feb 2005 15:27:48 -0800, Mohsen Pahlevanzadeh wrote: > Dears,I need to read 1 field with select command from mysql.Then Write it > to pgsql. Which programming environment? Java/php/perl/c/...? -- Greetings from Troels Arvin, Copenhagen, Denmark -- MySQL General Mailing List For l

RE: Mysql tuning - server Crash 1

Heikki, I sent this to a few friends of mine who work on fedora quite a bit. > As a general note, Fedora Cores are not considered stable. None of them wanted to officially comment, but just asked that you show proof. Especially since most of RH4 is Fedora. I know I've used FC1, FC2, and FC3.

Re: INSERT .. SELECT ... ON DUPLICATE KEY UPDATE

Thanks Shawn, Sergei. I'll get onto the new version as soon as I can. Tom. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: insert data

Am Sonntag, 27. Februar 2005 22.19 schrieb Gerald Preston: Hi Gerald > The object used: > > my $dbh=DBI->connect( 'DBI:mysql:database=club', 'xxx, 'x', { > PrintError => 0} ) or die $DBI::errstr; I didn't see this part in your first post :-) Hmm... I've never seen a '=' in the first argum

Reading from Mysql & writting in PGsql

Dears,I need to read 1 field with select command from mysql.Then Write it to pgsql. Please guide me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: insert data

At 5:38 -0600 2/27/05, Gerald Preston wrote: I just created a new table with the following: CREATE TABLE `wolfies` ( `group_name` VARCHAR( 38 ) NOT NULL, `me` VARCHAR( 3 ) NOT NULL, `daily` VARCHAR( 8 ) NOT NULL, `item` VARCHAR( 60 ) NOT NULL, `unit` VARCHAR( 38 ) NOT NUL

Fedora Core 2: upgrade mysql 3 to mysql 4

I want to upgrade mysql 3 to mysql 4. Operating System is Fedore Core 2. Is there any package dependency? How to remove mysql3 and install mysql 4? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: insert data

I'll repeat what I said earlier, can you SELECT from this database prior to the INSERT? I can't see where the problem is, have you read the DBI doco? That has a nice trace function which can be used in this circumstance. It allows you to see the SQL prior to it being sent to the server, the respons

RE: insert data

David, I just cannot believe what a pain this is. I got past the prepare with no errors by doing the following: my $dbh = DBI->connect( 'DBI:mysql:database=club', 'xxx', 'xxx', { PrintError => 0 } ) or die $DBI::errstr; my $sql = "insert into wolfies( group_name, me, daily, item, uni

Re: Upgrading to MySQL 4.1X Win32 Horror

zzapper wrote: None of your db apps will now run! It's something to do with a new password algorithm You are supposed to be able to fix this by specifying "old passwords" in your new my.ini You are also advised to upgrade Perl,PHP, Drivers etc This issue has been raised basically every day i

RE: insert data

Hi Gerald, The only thing I can think of is that you have a syntax error in your SQL that hasn't showed up in translation to email. Are you able to select from the database prior to the INSERT? This would confirm that your db has made a successful connection. The placeholders etc. work exactly as

RE: insert data

The object used: my $dbh=DBI->connect( 'DBI:mysql:database=club', 'xxx, 'x', { PrintError => 0} ) or die $DBI::errstr; Jerry -Original Message- From: John Doe [mailto:[EMAIL PROTECTED] Sent: Sunday, February 27, 2005 6:37 AM To: mysql@lists.mysql.com Subject: Re: insert data Hi G

Re: Mysql tuning - server Crash 1

Max, - Original Message - From: "Deluxe Web" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Sunday, February 27, 2005 2:17 PM Subject: Re: Mysql tuning - server Crash 1 Hi Heikki, http://lists.mysql.com/mysql/180583 http://lists.mysql.com/mysql/180581 Running fedora core1

mysqld got signal 11

Hey, Maybe, as a result of an attack, the number of threads_connected climbed suddenly to 1206, max_used_connections jumped to 1207 and the server died with the following message: "mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the librar

Re: mysql_query() crashes for certain statement

"Eric Lilja" wrote: > Hello, I'm using MySQL 4.1.10 on Windows XP Pro SP2 (+ all patches on > windowsupdate). I'm using the MySQL C api in a program compiled with > MSVC++ 7.1. > > My program crashes when I call mysql_query() with the following string: > "SELECT * FROM my_recipes WHERE enum_col=

mysql_query() crashes for certain statement

Hello, I'm using MySQL 4.1.10 on Windows XP Pro SP2 (+ all patches on windowsupdate). I'm using the MySQL C api in a program compiled with MSVC++ 7.1. My program crashes when I call mysql_query() with the following string: "SELECT * FROM my_recipes WHERE enum_col=0" Yes, the MYSQL object is vali

RE: select ... where bigint_col = 'big_value' doesn't work?

> -Original Message- > From: Ephraim Dan [mailto:[EMAIL PROTECTED] > Sent: 27 February 2005 15:44 > To: mysql@lists.mysql.com > Subject: select ... where bigint_col = 'big_value' doesn't work? > > > Hi, > > We are migrating to mysql 4.1 (from 4.0). We have lots of BIGINT > columns, and

select ... where bigint_col = 'big_value' doesn't work?

Hi, We are migrating to mysql 4.1 (from 4.0). We have lots of BIGINT columns, and lots of application code that have queries like the following: select ... where bigint_col = '64-bit int value' In 4.0, this worked fine. In 4.1 it does not work. The query only works if you take the single-quo

Upgrading to MySQL 4.1X Win32 Horror

Hi Yesterday upgraded from 4.0.2 to to 4.1.10 Stages of Horror 1) You have uninstall old version (does not delete your databases fortunately, but backup any way 2a) B4 installing Either also remove references to mysql in the registry OR during installation name choose Service name mysql41 (not

Re: insert data

Hi Gerald > I am trying to insert data for the first time using MySQL. In Oracle I > used the following: > > # my $sql = "insert into bar( group_name, me, daily, item, unit, qty, > amount, tax, total ) > > # values( ?, ?, ?, ?,?,?, ?, > ?, ? ) "; >

Re: Mysql tuning - server Crash 1

Hi Heikki, http://lists.mysql.com/mysql/180583 http://lists.mysql.com/mysql/180581 Running fedora core1 Mysql: 4.0.16-Max-log If you check http://lists.mysql.com/mysql/180583 (.err) you will see errors. Let me know if you have any questions. Thank you. I appreciate your help!! Max On Sun,

RE: insert data

David, Still the same error!. Jerry -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Sunday, February 27, 2005 5:49 AM To: Gerald Preston; mysql users Subject: RE: insert data Hi Gerald, Try something like my $sth = $dbh->prepare("insert into ba

problem with instalaion of DBD::mysql

Dear list, i have a problem installing DBD::mysql module. My built is FC3 on a P4 machine. i installed mysql database via Mysql-serever-5.1.10-0.i386.rpm also via a binary version of mysql-standard-4.1.10-pc-linux-gnu-i686. both the mysql servers are fine. And i could install DBI modules thru CPAN.

RE: insert data

Hi Gerald, Try something like my $sth = $dbh->prepare("insert into bar(group_name,me,daily,item,unit,qty,amount,tax,total) values(?,?,?,?,?,?,?,?,?)"); $sth->execute($group_name,$me,$daily,$item,$unit,$qty,$amount,$tax,$tota l) || die "Cannot execute FIRST Statement!!\n$DBI::errstr"; That

RE: insert data

I just created a new table with the following: CREATE TABLE `wolfies` ( `group_name` VARCHAR( 38 ) NOT NULL, `me` VARCHAR( 3 ) NOT NULL, `daily` VARCHAR( 8 ) NOT NULL, `item` VARCHAR( 60 ) NOT NULL, `unit` VARCHAR( 38 ) NOT NULL, `qty`int NOT NULL, `amo

RE: insert data

David, The actual code is uncommented: my $sql = "insert into bar( group_name, me, daily, item, unit, qty, amount, tax, total ) values( ?, ?, ?, ?,?,?, ?, ?, ? ) "; Sorry, Jerry -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL

RE: insert data

Hi Gerald, If this is copied out of your perl code then you haven't put anything into the $sql variable. Try uncommenting the 2 lines above. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobil

insert data

Hi! I am trying to insert data for the first time using MySQL. In Oracle I used the following: # my $sql = "insert into bar( group_name, me, daily, item, unit, qty, amount, tax, total ) # values( ?, ?, ?, ?,?,?, ?, ?, ? ) "; my $sth = $db

Re: InnoDB Rollback - 162 hrs remaining!?

John, Marko will add a commit at every 10 000 rows to CREATE INDEX in 4.1.11. Then this kind of a runaway rollback can not happen any more. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which als