ysql.com/doc/refman/5.5/en/mysqldump.html#option_mysqldump_default-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
oc/refman/5.0/en/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: h
c/refman/5.1/en/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 De
-- 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
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
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>
ficial 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/mysql?unsub=arch...@jab.org
n/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
w 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/mysq
en 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
ere is a conflict 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>
-
t;myisamchk" 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
of the server, among others.
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 I
| 2 |
+-+---+
2 rows in set (0,00 sec)
-->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
m asynchronous replication (lag 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 Genera
hp?id=16979>
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 lis
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 arc
2009/12/11 Yang Wang :
> Hi,All
>
> The version of 5.1 include microtime slow query patch?
"As of MySQL 5.1.21, the minimum value is 0, and a resolution of
microseconds is supported when logging to a file."
http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html
Regard
ster
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
way
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:
http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html>
--
ALL (
SELECT n
FROM names
WHERE n < @name
ORDER BY n DESC
LIMIT 2
) ORDER BY n;
Row has been named n; table: names. Unexpected results if @name does not exist.
If you expect a lot of records, expect also bad performance with this
query: add an index to speed up the orderings; also several
t;SELECT [any, column, you, want] 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
Yes, Case 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
CASE functions 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
2009/10/7 Brown, Charles :
> 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
elds (collation, etc.).
--
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
Benching
Somebody knows why 4.1 is faster than 5.0 mysql versions
Ing. Jaime Fuentes R.
997500459
2421905-2423252
Enviado desde mi BlackBerry de Claro.
-Original Message-
From: Brent Baisley
Date: Tue, 2 Jun 2009 12:32:39
To: Ray
Cc:
Subject: Re: Question about query - can this be
You have to use mysql 64bits on S.O. 64bits
--Mensaje original--
De: Martin Gainty
Para: Kinney, Gail
Para: 'mysql@lists.mysql.com'
Enviado: 19 Sep 2008 10:51
Asunto: RE: too many connections
in my.cnf configuration file try upping the number of connections
max_connections=3072
to
max_c
lease help me Urgent.
Jaime Fuentes R.
Peru
Arpotu escribió:
All,
I have a customer who has been on MySQL for about 8 years, but they are
moving their business elsewhere. They are moving their database into an
Oracle shop, and want me to export their MySQL data into a format that's
ea
Into my.ini the max_connection parameter is 2048.
what could be happened? and what to solve this ?
Jaime Fuentes R.
Hi
I am running mysql version 4.0.27 on Red Hat Enterprise Linux 3 i had a
myisam table with .frm, .MYD and .MYI files with no permissions for user
mysql. I inserted several rows without getting any error message, but
when i restarted mysqld, everything disapered and i get error message
/u
is OK for it,
mysql 4.01 is running on windows 2003 and the ibdata1of innodb is 20 GB
Thanks in advance
Jaime
070228 17:44:04 InnoDB: Page checksum 75769562, prior-to-4.0.14-form
checksum 3189442283
InnoDB: stored checksum 4088203197, prior-to-4.0.14-form stored checksum 0
InnoDB: Page lsn 0
L to even know where to begin looking
for what could have happened. Any thoughts/suggestions?
thanks,
Jaime
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
forcing
cursor sharing and dozens of other things enable our Oracle sites to run
as "fast" as MySQL.
We're running MySQL 4.0.18 and Oracle 8i and 9i at the latest patch
levels. Applying the appropriate patches on Oracle can make a big
difference too.
--Walt
> -Original Mess
Hi all!
I'm developing a system using both MySQL and Oracle for document processing. I issue a
series of queries to the database, depending on the document size. For big documents,
both databases behave in the same way but, when using small documents, MySQL finishes
quickly while Oracle consume
Hi all!
I'm using subqueries in MySQL 4.1.1 alpha. I use three subqueries and then want to get
those combinations matching a given constraints. It is a very simple task, but I get
less results than I expected. In fact, I tried to execute the same query in ORACLE and
I get 23 results (in MySQL I
ea how to\
make it work for my need.
hoping for your help.
Jaime
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
,
Jaime
-Original
Message-
From:
Sent: Wednesday, May 28, 2003 2:58
PM
To: [EMAIL PROTECTED]
Subject: How to perform the
following Query in MySQL
Hello,
I
am studying the possible migration of a system using another database engine to
MySQL for various reasons. However, I have
friendly way?
TIA
Jaime
-
Jaime
J. Maiz
630 979 2088
mailto:[EMAIL PROTECTED] IH 4F-310
FROM tablename WHERE detail LIKE '%pattern%';
However, this would produce several hits for a single account.
I'd like it to produce only one hit *per* account and give me
id where '%pattern%' was found and account where it was found on.
It should only return *one* result per
Hi,
How stable is the new MySQL 4.x?
I've read some really nice and powerful stuffs with MySQL 4.
x and surely like to use them.
Is this still in the 'use at your own risk' stage?
or is it stable enough for use already?
e query statement,
MySQL doesnot use index/keys?
Does this mean, that there is absolutely no way to improve
my query?
Hmm..
I read lots of good stuffs with MySQL 4.x; is this already
safe to use?
regards,
jaime
>
>Thomas
>
>On Mon, 11 Nov 2002 16:41:50 +0800 Jaime Teng <[EMAIL PROT
Y increases when
number is very low OR when
"select count(*) from eventlog where id < number;" would give a
small number.
Is there a way to increase the performance of my table/search?
jaime
-
Before p
.
thank for your time.
jaime
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsub
e
an INDEX on source, the search source='ERROR' should be fairly fast
at least faster than the first one. YET, I dont get any improvement
and it turned out even a lot slower.
Why was it this way?
thanks for your inputs.
jaime
have?
Jaime
# Example mysql config file.
# Copy this file to c:/my.cnf to set global options
#
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options
# This will be passed to all mysql clients
[client]
#password=my_password
option is workable.
PS. I did not know there was FULLTEXT; I was using and old PDF
manual.
Jaime
At 06:42 PM 2/24/02 -0800, Jeff Kilbride wrote:
>I'm about to try a full text index in a very similar situation, which has
>the potential to grow fairly big. I'd also be interested
kes about
30~60 seconds for an answer. (sometimes fairly fast <5 seconds).
SOMETIMES, searching through this crossref were actually slower.
I'd like to know how you people come up with a very good table and
search. Eventlog is currently 200MB in size.
Jaime
trying to open the
same database?
Jaime
At 11:03 AM 1/2/02 +0800, Kevin Chan wrote:
>Dear all,
>
>How I can set a different user to run MySQL (only root can run this program
>now) ?
>
>Error message when run the program from user:
>
>bash-2.03$ ./mysql --host=192.10.0.113
I would like
to know which sentence contains the words 'HELLO' and 'DAY' and 'WORLD'.
take note that the sentence SHOULD contain ALL the three words not just
one or two.
I think this is a 'JOIN'
mtable VALUES (unix_timestamp(now()),data here....);
jaime
At 11:25 PM 12/4/01 -0700, *Himerus* wrote:
>Can anyone give me a good link on how to put in a timestamp on a form
>that inserts directly into a sql database??? I keep trying it, but it's
>only coming thru as 00 ,
is kind of errors on Linux+Apache before and I solved it
via:
$sth=$DBH->prepare("SELECT ..LIMIT 1");
$sth->execute;
while ( $result = $sth->fetchrow ) {1};
It appeared to me that even if only one result is to be expected, mysql
would throw more than one. or is this a problem with
Hi,
I have the following queries:
SELECT account FROM user where username = 'george';
then using the result from this query,
i pass it onto the next:
SELECT * FROM record WHERE account = 'result from above';
I am new to 'JOIN' and dont know the corre
with 2.5 million records and
i want to change one of the field and sequence it and
am doing it the hard way of updating one at a time.
regards
Jaime
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
numbers were "1,20,22,25,40,45,47."
the new data will be "1,2,3,4,5,6,7,8,9." ?
Jaime
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
However, when I include "u.username = m.username" in
the WHERE field, it immediately produces the result
in 0.0x seconds.
Why does it hang on the 1st case? was it because there
were cases wherein a row in masterlist is not present
in user list that's causing it to croak?
Jai
all three words.
example:
search "tintin"
result = 1604, 1689
search "registers"
result = 1604, 1621, 1622, 1662
search "registers", "tintin"
result = 1604
thanks
jaime
-
Be
-+--+-+
SELECT e.* FROM eventlog e, indextable i WHERE
(i.keyword = 'word1' OR
i.keyword = 'word2' OR
i.keyword = 'word3')
AND e.id = i.id
ORDER by i.id DESC LIMIT 20;
I dont like doing the above workaround as it would take another
messy
Hi,
I have mysql on NT4 (soon to be win2000). one question is that the
database files all reside under drive c. NT does not have symbolic link
is there a way to tell mysql that a particular database is located on
a different folder? where is the documentation for this one?
jaime
Hi,
If I have a table:
create table messages (
id int unsigned not null unique,
datalongtext );
and I have a perl script:
1 $sth = $dbh->prepare( "SELECT data FROM messages WHERE id = ?;");
2 $sth->execute($id);
3 $data = $sth->fetchrow;
QUESTION:
will the script stop at line 3 unti
index (source,description) ?
Jaime
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
balistic.
Jaime
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe,
ablename where age > 30 and name = 'JOHN';
or do you suggest that I add the following on top of the
previous index?
alter table tablename add index (name,city);
alter table tablename add index (age,city);
alter table tablename add index (age,name);
etc...
thanks
Jaime
database,mysql
performance/speed in doing the following:
select * from tablename where name = 'bill';
select * from tablename where age > 30;
select * from tablename where city = 'new york';
thanks
jaime
database,mysql
-
BILL is in.
2. then get who are in the same room as BILL.
is it possible to do it in one single query?
jaime
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
ntelligent and either
communicate with two mysqld or use a backup database file you
know what i mean.
jaime
At 03:02 AM 6/9/01 -0230, Neil Zanella wrote:
>
>Sorry about this questions but why would you want to run two copies of
>mysqld when it is capable of hosting as many differen
f 'BILL' and then
perform another select of entries with the same account.
I already tried:
select * from user u, user r where r.account=u.account and r.name='BILL';
i got no result but no error.
jaime
database,sql
-
values on it. I wanted to fill it up based on
the "class" value found in table1.
I was trying to do something like this:
UPDATE table2 set class=table1.class
WHERE table1.username=table2.username
obviously wrong. what is the corre
columnname = unconcat(columnname, 'string');
will actually delete 'string' pattern from columnname?
thanks
Jaime
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.
I have to check to MySQL is able to support our requirements and I would
like to view a return of n columns like only one register, thats is posible
with MySQL?
For example i have 2 tables , 1 table have products and this table habe 3
colums ID , name, Id_price and the other table
69 matches
Mail list logo
