Re: Any easier way to compare mysql schema of 50 databases?!

and can even mail you the results about mismatch. Btw Why don't you consider having a single database replicated across 50 diff machines/servers ? Or is it sharding/partitioning of data across different instances ? Regards, Ranjeet Walunj *Are there any tools available* to accomplish this task

Re: my.cnf optimization

of the default InnoDB settings are horribly wrong from high performance point of view. Can you post your complete my.cnf on pastebin or somewhere ? Regards, Ranjeet Walunj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: sync

Mad Unix wrote: I was wandering if anyone know a good way to sync 2mysql databases _one_way The mysql is alocated on a web php application Do they (DB) need to be identical ? Have you checked replication ? Regards, Ranjeet Walunj -- MySQL General Mailing List For list archives: http

Re: Table aliasing

mysqldump 2) mysqlhotcopy 3) use COPY TABLE command to create duplicated tables 4) Set up replication on another server/machine for taking backup And many other ways .. Regards, Ranjeet Walunj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Re-arranging fields

in following manner. a) Rename table to tablename_new b) create table Tablename (fieldnames and datatypes) Select field1,field2...fieldn from tablename_new; But why do you want to do it in first place ? Regards, Ranjeet Walunj -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: mysql on 32 bit pae linux with 16 GB of memory

Dominik Klein wrote: I have a new machine to put mysql onto. It has 16 GB of RAM. I don't have exactly the best experience with 64bit operating system, so I'd personally like to stick to 32 bit. Does it make sense to install it with a 32 bit PAE kernel? Will mysql be able to use the full

Re: Record Counting

for all red, and all blue etc Hi neil. I would use SELECT count(colour_field_name) AS Counter, DATE_FORMAT(datetimecol,'%y-%m-%d') as Date, colour_field_name FROM table_name GROUP BY Date, colour_field_name; Regards, Ranjeet Walunj -- MySQL General Mailing List For list archives: http

Re: Table crashes

. good application + DB design/descent HW sizing and great monitoring will help reduce the crashes If you do some more research on this topic you can figure out some reasons and some pointers to avoid failures. Regards, Ranjeet Walunj Hi Friends, I need a document on why tables crash