Re: innodb defragmentation question

0.74 reads/s END OF INNODB MONITOR OUTPUT 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

innodb defragmentation question

b;") I see 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.

innodb defragmentation question

entional/normal 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

does the defragmentation with just one build of the table. And I think it >> also 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

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.

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 way

Re: mysqldump with innoDB

e end of a file 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 t

some replication questions

letion (like the replication log, 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 Mail

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 An

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 An

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 (the

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 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

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?

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

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] ___ _

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: 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, yo

special select

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]