Re: Tool for shifting tables from Mysql to Postgresql

-character-set -- Jaime Crespo MySQL Java Instructor Software Developer Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Mysql to Postgresql

/mysqldump.html#option_mysqldump_compatible Anyway, most of the times you will need a more manual migration, with human intervention (custom scripts) and migrating the data through something like CSV (SELECT... INTO OUTFILE). -- Jaime Crespo MySQL Java Instructor Software Developer Warp Networks http

Re: contact gives empty result

/control-flow-functions.html#function_ifnull Anyway, you should get rid of misplaced NULL fields, as they also affect performance. -- Jaime Crespo MySQL Java Instructor Software Developer Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: CURRENT insert ID

) values ('test data'); Query OK, 1 row affected (0.00 sec) mysql select id from mytable where id is null; -- OMG!!! ++ | id | ++ | 1 | ++ 1 row in set (0.00 sec) --8--8--8--8--8--8--8--8--8--8--8-- -- Jaime Crespo MySQL Java Instructor

Re: Loading Unicode Data to mySQL

/connector-odbc-configuration-connection-parameters.html Charsets can be a mess if you have several layers and only one of them fails, but if you understand fully all of MySQL parameters is not so difficult. -- Jaime Crespo MySQL Java Instructor Software Developer Warp Networks http://warp.es

Re: How to unstall MySQL 5.1 on Ubuntu 8.04 LTS

the official guide: http://dev.mysql.com/doc/refman/5.1/en/installing-binary.html MySQL works flawlessly on Ubuntu. -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: RHEL Auto Start / stop mysql???

/5.1/en/automatic-start.html -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL Replication

: row and statement-based. Please, have a look at the manual page: http://dev.mysql.com/doc/refman/5.1/en/replication-formats.html -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: MySQL Replication

in the replication process, it stops. You have to solve the issues manually and then start the replication again. This usually occurs due to the synchronous/distributed nature of the replication. -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List

Re: MySQL Replication

if MySQL gives some support to handle this (auto-increment-offset, replicate-ignore-table), you should mostly handle it at business logic (application server) layer, not in the MySQL database. Alternatively, as Johan pointed, have a look at the semi-synchronous replication. -- Jaime Crespo MySQL

Re: Missing database file names

and the REPAIR command should be able to regenerate an MYI file from a .MYD and .frm files. After all, MDI file only contains the disk version of the indexes. Beware of possible issues if using different server version, though. -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL

Re: auto_increment without primary key in innodb?

) --8 Regards, -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: optimization

. There also exists a tool to get introduced into MySQL server variables tuning: Tuning primer - https://launchpad.net/mysql-tuning-primer It is also a very general tool, but it could be helpful for a starting point. Regards, -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es

Re: Table level locking when inserting auto-increment PK to InnoDB

there is a manual page discussing the changes done for the 5.1 version: http://dev.mysql.com/doc/refman/5.1/en/innodb-auto-increment-handling.html -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: mysql load balancing

between master writes and slaves see the data). I am sorry I cannot help you, but please, share here if you found something useful AND with good performance. Merry Xmas! -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http

Re: mysql load balancing

to coordinate the db servers (sharding, replication, ndb), the kind of applications you are going to deploy and how much scability you need. I hope that helps. Regards, -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http

Re: different 5.0 and 5.1 about long_query_time

, -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How normal mysql server 5.1 uses multiple cores

cluster on a single host? Anyway, I suppose performance loses on distributed joins and so on would outcome multiple-core benefits. And for most queries, the bottleneck is usually on disk access, not processor. Has anybody done any serious testing on this? -- Jaime Crespo MySQL Java Instructor

Re: OPTIMIZE TABLE

of load balancing while performing administrative tasks. If you could have a pre-production host to test these kind of operations it would be great! Each application is a world on its own. You can read more info here: url:http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html -- Jaime Crespo

Re: Find neighboring rows

. -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Choose certain columns in mysqldump?

] INTO OUTFILE '/var/www/folder/table_name.txt' FROM table_name WHERE [any, filter, you, want] ORDER BY [any, order, you, want] -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Using IF in a query to set a variable then sort on said variable

function is the way to go. Anyway, check for performance issues: in that case, precalculating and storing an aditional field would be the best way (it could be done with a trigger, for example). -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List

Re: Using IF in a query to set a variable then sort on said variable

to achieve similar results. -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MYSQL slow query log in table.

2009/10/7 Brown, Charles cbr...@bmi.com: Hello All. I would like to implement  MYSQL slow query log in table. Can someone kindly assist me with the table definition and implementation. SHOW CREATE TABLE mysql.slow_log; http://dev.mysql.com/doc/refman/5.1/en/log-tables.html -- Jaime Crespo

Re: troubles with complex UTF-8 characters

.). -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org