Re: innodb defragmentation question

F. Heikki Tuuri wrote: Franky, since MySQL performs ALTER TABLE ... TYPE = InnoDB; by totally rebuilding the table, it is very normal that the space usage temporarily doubles in ibdata files. But if it doubles also after an immediate SECOND rebuild, then that must be a bug

innodb defragmentation question

the size of ibdata1 growing to almost double its size, and again it doubles if I try it again ... there's only 1 innodb table in my setup, so no other table can be causing this. Is this intentional/normal or is there something I should configure? I'm running mysql-4.0.16 on solaris 2.8. Franky

innodb defragmentation question

or is there something I should configure? I'm running mysql-4.0.16 on solaris 2.8. Franky -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Re: innodb and fragmentation

preserves FOREIGN KEY constraints. Please test it! It did the job just fine. Thanks. and it seems to be what I asked for as well, thanks! Franky -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump with innoDB

with 'set foreign_key_check=0;' at the top? Maybe we could have a switch for mysqldump that does this for us? quick solution: put the line SET FOREIGN_KEY_CHECKS = 0; in a file (eg.header.txt) and then: cat header.txt mysql.dump mysqlgood.dump should take about 5 secs. Franky -- MySQL General

Re: Round Robin Replication, Add a server; Renumber

Jeremy Zawodny wrote: On Tue, Sep 02, 2003 at 05:34:12PM -0500, Lewis Watson wrote: I currently have three mysql machines replication from A-B-C-A type fashion. I need to replace A. I am thinking that I could add D and have it pull from C. Then once A is removed restart D as A. Is this a good

optimize tables and innodb

Hi all, for myisam tables we have optimize table that can be cronned to run at night, but is there something like this for the innodb table type as well? Franky -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

some replication questions

, binary log, etc...), I would use the mysql-rotate-logs script (which does the sql command flush logs) and delete all logs more than 5 days old (if all slaves are up. Is this ok? tx for any responses already! Franky -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

give me a sample to print out to printer

when i click the icon client1(in end client, it's show up from php application) that the icon has link to mysql and the result directly print the out put to printer (share or local printer) by coulomb. there's anyone knows about this, please help me. Rgds, Franky Aniversarius

give me a sample to print out to printer

when i click the icon client1(in end client, it's show up from php application) that the icon has link to mysql and the result directly print the out put to printer (share or local printer) by coulomb. there's anyone knows about this, please help me. Rgds, Franky Aniversarius

DBD::mysql

/perl5/site_perl/5.6.1/i586-linux/auto/DBI Writing Makefile for DBD::mysql the problème is the libs?! but what can i do?! thanks! Franky [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Best choice for index

What is the best choice for my index on this query? SELECT id_team, sum(IF(m.id_visitor = t.id_team,m.visitor_score, m.home_score)) AS But_pour, sum(IF(m.id_visitor != t.id_team,m.visitor_score, m.home_score)) AS But_contre FROM

revoke privilege

I do: grant SELECT,alter,index,insert,update on SK_10.* to admin-ab-44 identified by ab-44; And : revoke all on SK_10.users_profiles from admin-ab-44; But the user cant always make a SELECT * from SK_10.users_profiles ; I want no acces to the table SK_10.users_profiles what can i do?

revoke privileges

Ok let me explain my problem: I do: grant SELECT,alter,index,insert,update on SK_10.* to admin-ab-44 identified by ab-44; -- So the use get all right... And : revoke all on SK_10.users_profiles from admin-ab-44; -- So now they have all right except in SK_10.users_profiles ... But the user

remove? revoke?

Can I remove the rigth for one user to see one specific table in database? for exemple: user: bob table: tab_secret database: Customer_service Bob can see any table in DB Customer_service except the table tab_secret. --=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-- François Boucher

conditional AND

Hi I want to make query like this Selectp.name fromtab_person p, tab_list l wherel.id_tab_list = 18 if (l.id_person != 0){ AND l.id_person = p.id_person } table person id_person,name,tel table list id_list,id_person,title how can i do?

Re: conditional AND

I write this: Select p.name From tab_person p, tab_list l Where l.id_tab_list = 18 And l.id_person = 0 Or l.id_person = p.id_person i will receve all name in person table! --=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-- François Boucher [EMAIL PROTECTED] ___ _ (

special select

Re: special select ( try 2)

Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply,

query in different DB

Can I do query like this: Select Database1.table1.field1, database2.table1.field1, database2.table2.field2 FROM database1.table1, database2.table1, database2.table2 François Boucher [EMAIL PROTECTED]