List:Replication« Previous MessageNext Message »
From:Shawn Green (MySQL) Date:August 9 2011 4:04pm
Subject:Re: Problem creating temp tables during replication
View as plain text  
Hello anonymous,

On 8/9/2011 10:57, Database System wrote:
> Have you tested on 5.0 or 5.1?
> I did test on both 5.0 and 5.1 (Windows) before I said that.
>

I duplicated my results using a 5.0 server, too.... maybe you need to 
check your earlier test again, eh?

#### the server #####
110809 11:51:03  InnoDB: Started; log sequence number 0 45289
110809 11:51:03 [Note] mysqld-nt: ready for connections.
Version: '5.0.37-community-nt'  socket: ''  port: 3306  MySQL Community 
Edition (GPL)

#### the client session #####

localhost.(none)>use test
Database changed
localhost.test>show tables;
Empty set (0.00 sec)

localhost.test>show global variables like '%version%';
+-------------------------+-------------------------------+
| Variable_name           | Value                         |
+-------------------------+-------------------------------+
| protocol_version        | 10                            |
| version                 | 5.0.37-community-nt           |
| version_comment         | MySQL Community Edition (GPL) |
| version_compile_machine | ia32                          |
| version_compile_os      | Win32                         |
+-------------------------+-------------------------------+
5 rows in set (0.00 sec)

localhost.test>create temporary table temp2(b int) engine=memory;
Query OK, 0 rows affected (0.02 sec)

localhost.test>show tables;
Empty set (0.00 sec)

localhost.test>insert temp2 (b) values (1),(2),(3);
Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

##### the .frm file ##############

C:\DOCUME~1\shawn\LOCALS~1\Temp>dir *.frm
  Volume in drive C is System
  Volume Serial Number is 325B-0199

  Directory of C:\DOCUME~1\shawn\LOCALS~1\Temp

File Not Found

C:\DOCUME~1\shawn\LOCALS~1\Temp>dir *.frm
  Volume in drive C is System
  Volume Serial Number is 325B-0199

  Directory of C:\DOCUME~1\shawn\LOCALS~1\Temp

08/09/2011  11:53             8,554 #sql1574_1_0.frm
                1 File(s)          8,554 bytes

##########

I am sorry you decided to not post your test case for us to review. Is 
there some kind of flaw in my demonstration that you might care to point 
out?

Note: I took two directory listings. The first was to prove that the 
same temporary table .frm file was not there from the last test. The 
second was to show the presence from this test.  The timestamp on the 
new file indicates it was created AFTER I started the server. Unless I 
come to your machine and show you myself, I cannot seem to make this 
point any clearer:

** All MySQL tables will have a .frm file ***

You just need to know where to look. If you don't believe me, read the 
source.

-- 
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
Thread
Problem creating temp tables during replicationAlex Frangis5 Aug
  • Re: Problem creating temp tables during replicationDatabase System5 Aug
    • Re: Problem creating temp tables during replicationEric Bergen5 Aug
      • Re: Problem creating temp tables during replicationWagner Bianchi5 Aug
        • Re: Problem creating temp tables during replicationDatabase System5 Aug
          • Re: Problem creating temp tables during replicationRick James8 Aug
  • Re: Problem creating temp tables during replicationMySQL)8 Aug
    • Re: Problem creating temp tables during replicationDatabase System8 Aug
      • Re: Problem creating temp tables during replicationMySQL)9 Aug
        • Re: Problem creating temp tables during replicationDatabase System9 Aug
          • Re: Problem creating temp tables during replicationMySQL)9 Aug