I know, all the shell command can do this. Thanks.
2010/8/25 Moon's Father yueliangdao0...@gmail.com
Hi.
For example, entering mysql command line client,
mysql pager more ( or pager md5sum and so on.)
I want to know how many command the 'pager' follows? Any reply will be
big
Hi.
For example, entering mysql command line client,
mysql pager more ( or pager md5sum and so on.)
I want to know how many command the 'pager' follows? Any reply will be
big appreciated.
Who can please tell me what is mean of The db storage is on fiber
channel.?
On Fri, Jun 26, 2009 at 1:05 AM, mos mo...@fastmail.fm wrote:
Mike,
I re-posted your Show Status to the group to see if anyone can offer a
way to speed up the indexing for you.
BTW, you are adding ALL of the
Login mysql client. Do the following commands.
tee ie.txt;
...
notee;
On Thu, Jun 25, 2009 at 10:29 PM, John Daisley
john.dais...@mypostoffice.co.uk wrote:
SELECT INTO OUTFILE does almost the same thing as spool in SQL*Plus
SELECT columnname from tablename into outfile
Could you tell me your detail statements?
On Wed, Jun 24, 2009 at 9:46 AM, sangprabv sangpr...@gmail.com wrote:
Hi,
I found every time I try to do multiple rows delete on replicated MySQL
is always failed. Is there any explanation regarding this issue and how
to solve it? TIA.
Willy
--
Hi.
I think you should create an index like this.
alter table user add index idx_tmp (key1,key2,key3,user_id)
2009/6/19 Darryle Steplight dstepli...@gmail.com
Select user_id from user where key1=value and
key2=value2 and key3=value2 GROUP BY user_id
is faster than
Select distinct
Hi.
I think innodb will split these into many small pieces and then merge them
to execute.
On Thu, Jun 18, 2009 at 1:52 PM, Krishna Chandra Prajapati
prajapat...@gmail.com wrote:
Hi guys,
On MIS (management information system) server we have 16GB of physical
memory. 10GB has been allocated
Hi.
Can you give me a flow of your master/slave?
On Wed, Jun 24, 2009 at 7:45 PM, 赵琦 tyzha...@gmail.com wrote:
hi all:
I have three mysql database,tow run as master and the other one runs as
slave.
Some tables in the database have an autoincreament field named as 'rowid'.
These
tables
Hi.
This is a good choice!
On Tue, Jun 23, 2009 at 5:53 PM, Janek Bogucki
janek.bogu...@studylink.comwrote:
Have you tried SQL Developer? It works great with Oracle and also
supports MySQL,
http://www.oracle.com/technology/products/database/sql_developer/files/what_is_sqldev.html
Hi.
If you know chinese, I advise that you should visit the website called
http://yueliangdao0608.cublog.cn
On Sat, Jun 20, 2009 at 10:44 AM, michel compu...@videotron.ca wrote:
I have MySQL set up and running, but I am under the impression that I am
unable to password protect it properly
Ok. I have already gotten the answer.
On Wed, Jun 3, 2009 at 4:15 PM, Moon's Father yueliangdao0...@gmail.comwrote:
Hi.
I want to know which lock method is used within MySQL?
For example, if I query the following statements within MySQL client.
mysql begin;
Query OK, 0 rows affected
Hi.
Here is the introduction.
http://www.oracle.com/technology/oramag/oracle/05-sep/o55security.html
I want to know whether MySQL has the same function as Oracle's?
Any reply is appreciated.
--
David Yeung,
MySQL Senior Support Engineer,
Sun Gold Partner.
My
As I know, IN sometimes invoke unmormal index.
On Thu, May 28, 2009 at 1:15 AM, Baron Schwartz ba...@xaprb.com wrote:
Simon,
On Wed, May 27, 2009 at 11:23 AM, Simon J Mudd sjm...@pobox.com wrote:
per...@elem.com (Perrin Harkins) writes:
On Wed, May 27, 2009 at 6:43 AM, Simon J Mudd
Thanks for your sincerely reply.
On Mon, May 11, 2009 at 11:04 PM, Baron Schwartz ba...@xaprb.com wrote:
On Sun, May 10, 2009 at 10:12 PM, Moon's Father
yueliangdao0...@gmail.com wrote:
Hi.
MySQL only has one datatype called bit, but its smallest storage is one
byte.
How to save
Here is the table structure.
CREATE TABLE `UP_UserEx` (
`UserId` INT(11) NOT NULL,
`UserNationality` CHAR(2) NOT NULL DEFAULT '',
`UserProvince` CHAR(2) NOT NULL DEFAULT '',
`UserCity` CHAR(4) NOT NULL DEFAULT '',
`HomePhone` VARCHAR(32) NOT NULL DEFAULT '',
`WorkPhone` VARCHAR(32)
Waiting for more interesting points.
On Tue, Apr 21, 2009 at 1:42 PM, Manish Gupta manish.in@gmail.comwrote:
http://www.sun.com/third-party/global/oracle/
anyone saw this ??
On Tue, Apr 21, 2009 at 2:54 AM, John Meyer john.l.me...@gmail.com
wrote:
Yep. In particular the anti-trust
Once your tables' engine are all of innodb, your configuration file has to
be changed to fit innodb's feature, not myisam.
On Tue, Apr 21, 2009 at 2:09 PM, living liquid | Christian Meisinger
c.meisin...@livingliquid.com wrote:
ah sorry... there are a few UPDATEs too but most is SELECTs...
going to happen to the performance of his
server?
With advice like that you could grind his server/s to a halt and cause
his site
To die a miserable swappy death.
Andrew
-Original Message-
From: Moon's Father [mailto:yueliangdao0...@gmail.com]
Sent: 17 April 2009 06:36
To: Manoj
Thanks for you reply.
I read the official document and found the variable called
thread_concurrency could only affect on solaris.
On Sat, Apr 11, 2009 at 5:04 AM, mos mo...@fastmail.fm wrote:
At 06:00 AM 4/10/2009, you wrote:
Hi.
If the server has 16 cores, how to set parameters to make
Innotop can satisfy you demand.
On Thu, Apr 16, 2009 at 4:36 PM, Hitesh Shah hrs...@gmail.com wrote:
Hello,
I'd like to know if there is a command line tool I can run to collect
vital health information for a remote mysql server (just like
mysqltop) for 5.0 - I often see mysql swapping to
Can you tell me which version of mysql you use in you test?
On Thu, Apr 16, 2009 at 12:43 AM, Pete Wilson p...@pwilson.net wrote:
Hi folks --
New to MySQL. I'm developing C-language connector software and, while
debugging, I often get the error message MySQL server has gone away if,
say,
Yeah, please show us the source code of yours.
On Wed, Apr 15, 2009 at 4:10 PM, Venu Gopal neo.v...@gmail.com wrote:
Hi guys,
I am using stored procedures and stored functions for the first time.
And currently stuck at a this point where. I am unable to retrieve
results returned by stored
Use temporary table can be a good idea. But I think you performance would be
boost so much if you can do something else to replace the temporary table.
On Wed, Apr 15, 2009 at 2:03 PM, Manoj Singh manojsingh2...@gmail.comwrote:
Hi All,
I have a query which returns the large number of ids
practically when implementing temporary tables.
Waiting for your suggestion.
Thanks,
Manoj
On Fri, Apr 17, 2009 at 8:21 AM, Moon's Father
yueliangdao0...@gmail.comwrote:
Use temporary table can be a good idea. But I think you performance would
be boost so much if you can do something
Thank you very much.
Could you tell me what is IIRC?
On Fri, Apr 10, 2009 at 8:24 PM, Uwe Kiewel m...@kiewel-online.ch wrote:
Moon's Father wrote:
Hi.
If the server has 16 cores, how to set parameters to make MySQL runs
well.
IIRC is mysqld multi threaded - so if you have parallel
or Object-Relational
DBMS.
Cheers
Claudio Nanni
Moon's Father wrote:
Hi.
Who could tell me when the MySQL support array datatype?
Any reply will be appreciated.
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
Thanks for your fast reply.
Do you know MySQL will support this feature in the future?
On Sun, Feb 15, 2009 at 12:59 AM, Baron Schwartz ba...@xaprb.com wrote:
Hello,
On Sat, Feb 14, 2009 at 11:15 AM, Moon's Father
yueliangdao0...@gmail.com wrote:
Here is my routine.
DELIMITER
This is because you didn't copy innodb ibdata and ib_log files togeter. Or
you forgot to stop mysqld when you remove its ib_log files.
On Sat, Feb 7, 2009 at 7:21 AM, my sql mysql.g...@gmail.com wrote:
WHY do I see this error when restoring my backup db :
InnoDB: Your database may be corrupt
Yeah, you're right.
On Fri, Jan 16, 2009 at 10:57 AM, Daevid Vincent dae...@daevid.com wrote:
you misunderstand me. I have three servers (dev, test, prod) that all
have maybe 3 databases EACH that have all these eventum* tables in them.
don't ask. a simple trickle won't do. I'm writing a
Yeah. You should use mk-heartbeat, it's the best tool for this situation
that I have seen before.
On Wed, Dec 24, 2008 at 10:06 PM, Baron Schwartz ba...@xaprb.com wrote:
On Wed, Dec 24, 2008 at 2:31 AM, Jake Maul jakem...@gmail.com wrote:
Slightly more complicated (and also probably more
I have solved this problem.
^_^
On Fri, Dec 12, 2008 at 10:54 AM, Moon's Father
yueliangdao0...@gmail.comwrote:
Hi.
I want to know how to connect mysqld with ssl encryption from windows or
linux system.
Any reply will be appreciated.
Here is my status.
mysql status
/apis.bml
http://tangent.org/index.pl?node_id=506
-Original Message-
From: Moon's Father [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 03, 2008 1:22 AM
To: MySql
Subject: Could somebody tell me how to use the memcache engine inside
mysql?
Although I set up memcache engine
Although I set up memcache engine successfully on my computer, I didn't know
how to use it?
I can not find where the document is.
Here is my result of engines.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.1.30 Source distribution
Type
Hi.
Here are some of my tests on Centos 5.0.
http://blog.chinaunix.net/u/29134/article_71956.html
On Fri, Nov 21, 2008 at 3:49 AM, Ronan Lucio [EMAIL PROTECTED] wrote:
Hi,
Does anybody has a tip to install a MySQL Cluster in a Linux CentOS-5?
Is it better from source or can it be from yum?
You may execute mysql_fix_privileges_table script to upgrade all of your
mysqld.
On Thu, Nov 20, 2008 at 7:54 PM, Ronan Lucio [EMAIL PROTECTED] wrote:
Hi,
I installed MySQL-5.0.67_1.
When I execute CHECK TABLE information_schema.COLUMNS FOR UPGRADE I get
the message:
I had done many instances on one machine before, the most important thing
is about the my.cnf.
And there are many individual my.cnf, which belonged to their own instance.
Since your total memory is 32GB, you can assign them properly.
On Fri, Nov 21, 2008 at 3:40 AM, Claudio Nanni [EMAIL
Try drop table if exists Tablex;
On Fri, Nov 21, 2008 at 9:53 AM, mos [EMAIL PROTECTED] wrote:
How can I determine if a temporary table exists? Normally I use something
like:
create temporary table Tablex like Table1;
show tables like Tablex;
but the Show Tables never displays any rows
What is your storage engine used?
On Fri, Nov 21, 2008 at 8:59 AM, Marten Lehmann [EMAIL PROTECTED] wrote:
Hello,
what do these errors mean:
mysqldump: Got error: 1030: Got error 1 from storage engine when using LOCK
TABLES
mysqldump: Couldn't execute 'show create table `Antrag`': Got
What is your storage engine used?
On Fri, Nov 21, 2008 at 8:59 AM, Marten Lehmann [EMAIL PROTECTED] wrote:
Hello,
what do these errors mean:
mysqldump: Got error: 1030: Got error 1 from storage engine when using LOCK
TABLES
mysqldump: Couldn't execute 'show create table `Antrag`': Got
Thanks for advice.
There're no environment for me to test the cluster again right now. Hope the
chance chooses me, then the english version will be done.
:)
On Fri, Nov 21, 2008 at 10:48 AM, steve grosz [EMAIL PROTECTED]wrote:
Hello Moon's Father,
That would be great..if it was in english
Yeah, it's really a nice tool for me.
Thanks.
On Tue, Nov 18, 2008 at 5:44 AM, Saravanan [EMAIL PROTECTED] wrote:
really nice tool.
Thanks,
Saravanan
--- On Mon, 11/17/08, lakshmi pathi [EMAIL PROTECTED] wrote:
From: lakshmi pathi [EMAIL PROTECTED]
Subject: A tool
To:
Maybe your tables were not properly designed.
On Tue, Nov 18, 2008 at 10:35 AM, sangprabv [EMAIL PROTECTED] wrote:
Thanks for the reply, does this overhead reduce performance? And is
there any tips to avoid this overhead? TIA.
WM
--
MySQL General Mailing List
For list archives:
I'm sorry to mistake the wrong storage engine.
On Wed, Nov 12, 2008 at 3:52 PM, Moon's Father [EMAIL PROTECTED]wrote:
Hi.
I got an error when I use alter statement to modify an innodb's table
structure. The error no is 1114 and the detail information is
ERROR 1114 (HY000): The table '#sql
Hi.
I got an error message when I adjust the system variable named
default-time-zone.I don't how to adjust this variable.
Hope to get help here.Thanks.
Here is my error log.
081113 15:24:43 InnoDB: Started; log sequence number 0 423199200
081113 15:24:43 [Note] Recovering after a crash using
Hi.
I got an error when I use alter statement to modify an innodb's table
structure. The error no is 1114 and the detail information is
ERROR 1114 (HY000): The table '#sql-4c0_1' is full.
Here is my table's structure.
mysql show create table t1;
it from the Proven Scaling mirror.
http://mirror.provenscaling.com/mysql/community/source/4.0/
-Eric
On Thu, Nov 6, 2008 at 1:58 AM, Joerg Bruehe [EMAIL PROTECTED] wrote:
Hi!
Moon's Father wrote:
Hi.
Where can I download a mysql 4.0.12? I found nowhere to download it.
You
Thanks for your patient reply.
Now I believe that the memory leak problem was generated by the program.
On Sat, Nov 1, 2008 at 5:31 PM, Ian Christian [EMAIL PROTECTED] wrote:
2008/10/31 Moon's Father [EMAIL PROTECTED]
*A prepared statement is also global to the connection. If you create
into... if the current index files for the
relevant tables on disk exceed 2GB, you might want to increase
myisam_max_sort_file_size. Otherwise, myisam_sort_buffer_size might be
better.
Jake
On Fri, Oct 31, 2008 at 12:20 AM, Moon's Father
[EMAIL PROTECTED] wrote:
Because alter table and repair table
alter table tablename modify id int not null auto_increment primary key;
On Sat, Oct 25, 2008 at 2:48 AM, Paul [EMAIL PROTECTED] wrote:
Anybody know if there's a way to change a primary key field that is not
auto-incremented, turning on auto-increment but preserving the values that
are
Hi,andy.
Can you show me the details about the options of mysqldump to be used ?
On Fri, Oct 31, 2008 at 1:25 AM, Andy Smith [EMAIL PROTECTED] wrote:
Hi,
Im having an issue using mysqldump to dump a DB from comercial app which
includes mysql 4.0.18-pro. It doesnt however include mysql
I think Claudio Nanni 's suggestion is the best!
On Thu, Oct 30, 2008 at 8:29 PM, Claudio Nanni [EMAIL PROTECTED]wrote:
Hi Mark,
from my experience I can tell you that you can easily migrate.
A quick and dirty way is to use the two(or more) different MySQL
installations
on same server (or
In my experiences, there're three reasons below.
1. Your network is not stable.
2. Your mysqld's parameter called max_allowed_packet is adjusted too small,
trying to increase it.
3. Your mysqld's parameter called connect_timeout is adjusted too small,
trying to increase it.
On Thu, Oct 30, 2008
Thanks.
On Tue, Oct 28, 2008 at 3:17 PM, Micah Stevens [EMAIL PROTECTED]wrote:
It's a package for Debian based systems, which include Ubuntu and a few
others..
It's like an RPM for Fedora/Redhat linux.
-Micah
On 10/27/2008 06:39 PM, Moon's Father wrote:
I'm sorry that if I can ask
Just use command line tools called fc on windows or diff on linux if you are
patient and perfer trouble.
On Tue, Oct 7, 2008 at 10:07 PM, Duzenbury, Rich [EMAIL PROTECTED]wrote:
I just used mysqldiff for a project, and was successful.
-Original Message-
From: Uma Bhat [mailto:[EMAIL
I also want to know the answer to this question.If it's for me.I'll scan all
the source code manually.But it's too complicated.
On Tue, Oct 7, 2008 at 1:02 AM, Olaf Stein
[EMAIL PROTECTED] wrote:
It specifies the query in the Info field.
In your case the connection is sleeping, nothing is
I advise that you should put your my.cnf in mysql installation location.
On Mon, Oct 6, 2008 at 11:06 PM, Varuna Seneviratna
[EMAIL PROTECTED] wrote:
Armin
I did what you said, now I understand what you say that there is no
sence in what I wanted to do.But I gave these commands as
I'm sorry that if I can ask a question.What is DEB?
On Fri, Oct 3, 2008 at 9:49 PM, US Data Export
[EMAIL PROTECTED]wrote:
-Original Message-
From: Ellison, David [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2008 2:35 AM
To: mysql@lists.mysql.com
Subject: RE: Deployment of
Setting is difficult but checking is simple.
On Thu, Oct 9, 2008 at 9:26 PM, Amit Sharma [EMAIL PROTECTED] wrote:
Hi Sudhir,
#show table status command will give you most of what all is required. Have
a look at the results post any further query if you have.
Regards,
Amit Sharma
On
There are some of backup scripts written by me.You can find it at:
http://blog.chinaunix.net/u/29134/article_71953.html
On Wed, Oct 22, 2008 at 4:52 PM, Mad Unix [EMAIL PROTECTED] wrote:
Any one tried the script from HowToForge
Just use another term will solve your problem.Or you can use pager more in
mysql command line client.
On Sun, Sep 28, 2008 at 12:44 AM, Dan Nelson [EMAIL PROTECTED]wrote:
In the last episode (Sep 27), Alex Katebi said:
Hi,
When selecting (example: select * from mysql.db ) some of the
Create an extra trigger on that table with delete event.Then the deleted
item will be recorded in the database.
On Fri, Oct 10, 2008 at 11:34 PM, Jerry Schwartz [EMAIL PROTECTED]
wrote:
Thanks.
Although I've been around SQL for quite a while, I've never really gotten
the hang of
Or you can create a temporary table including a auto_increment attribute and
fill it with continuous numbers.
Then simply use it to left join the original table.
On Sat, Oct 25, 2008 at 2:57 PM, Moon's Father [EMAIL PROTECTED]wrote:
Create an extra trigger on that table with delete event.Then
This is because either somebody is attacking your mysqld or your variable
named connect_timeout is very lower.
On Wed, Oct 22, 2008 at 9:55 PM, Krishna Chandra Prajapati
[EMAIL PROTECTED] wrote:
Hi list,
Aborted clients and connects are increasing very fast.
Aborted_clients
4934
Maybe you should set your old_passwords = on.
On Fri, Oct 17, 2008 at 4:36 PM, Sudhir Menon [EMAIL PROTECTED] wrote:
Hi Ujang
I could reproduce the same error mentioned by you in the actual post even
after having all of the packages for MySQL. Figuring out the what could be
the problem .
It's very nice!
But it's too simple.
On Mon, Oct 6, 2008 at 12:26 AM, Anders Karlsson [EMAIL PROTECTED] wrote:
Sorry for crossposting, but I think this is relevant both th general MySQL
and specifically to Win32 users.
MyQuery 2.3 has a lot of new features, a few bugfixes and some other
mrc_titles is a temp table?
On Wed, Oct 15, 2008 at 11:59 PM, Jerry Schwartz [EMAIL PROTECTED]
wrote:
I tried to make a query that joins to subqueries:
SELECT discontinued.b
FROM
(SELECT mrc_titles.title AS a
FROM mrc_titles JOIN prod ON mrc_titles.title =
If you want to choose the first one, then the flag' data type must be
enum.For int fill the disk with 4 byte and enum just 1 byte.
On Sat, Oct 4, 2008 at 2:15 AM, Alex K [EMAIL PROTECTED] wrote:
That seems like a nice trick. I suppose the flag would just be an int
and not an enum in this case.
There're an article about master to master replication at my blog.
On Thu, Oct 9, 2008 at 3:45 PM, Simon J Mudd [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] (Carl) writes:
I am running 5.0.24a on Slackware Linux. I would like to set up a
master-master replication process so that I can use
Hi.
I think you had a mistake for the server types.Mysql-nt.exe is the only
exexutable program on windows.So you just pay close attention about it.
On Mon, Oct 6, 2008 at 8:35 PM, Steven [EMAIL PROTECTED] wrote:
Steve
(n)
Martin!
if you want apache and mysql (and possibly PHP for
Show the details of your hardware us.
On Thu, Oct 2, 2008 at 3:02 PM, Krishna Chandra Prajapati
[EMAIL PROTECTED] wrote:
Hi,
Just try the below command on console. It will give that the error is
exactly related to what.
$perror 5
What is total ram in your box.
On Thu, Oct 2, 2008 at
You may see the section named group by optimization on the document.
On Tue, Sep 30, 2008 at 4:44 AM, Rob Wultsch [EMAIL PROTECTED] wrote:
Glancing over things I suggest:
ALTER TABLE browse_nodes_to_products ADD INDEX(browse_node_id,product_id);
(if product_id has greater cardinality put
Make sure your log_bin_trust_function_creator is on.
On Sun, Sep 28, 2008 at 3:04 AM, Jesse [EMAIL PROTECTED] wrote:
I'm trying to use existing functions from a restored database from 5.0xx to
5.1, and get an error about the mysql.proc table is missing or corrupt. The
mysql.proc table appears
Any additional tools will satisfy your demand.
On Mon, Oct 13, 2008 at 7:34 PM, Sudhir Menon [EMAIL PROTECTED] wrote:
My reply was with regards to the answer in this post.
http://lists.mysql.com/mysql/214827
Anyways thanks for the concern from your end.. Mike :) My query was
answered.
See the usage of the function named field.
On Mon, Jul 28, 2008 at 8:15 PM, Mr. Shawn H. Corey [EMAIL PROTECTED]wrote:
On Mon, 2008-07-28 at 07:32 -0400, Gary Josack wrote:
Andrew Martin wrote:
Hello,
Is it permissible to order a clause such that the search term is the
first item
Just staightly use ... in .. is ok.
On Fri, Oct 24, 2008 at 12:57 AM, Bill Newton
[EMAIL PROTECTED]wrote:
Pretty standard mysql function. Its been in mysql for a while.
http://dev.mysql.com/doc/refman/4.1/en/string-functions.html#function_field
Jim Lyons wrote:
I'm not familiar with
You're wrong.The new log file will be generated when you flush logs
manually.
On Fri, Oct 24, 2008 at 2:23 AM, Olaf Stein
[EMAIL PROTECTED] wrote:
And I assume you backup script also archives or removes the old log file,
because flush-logs does not start a new log file if there is still one
I know it.Thanks.
I'm sorry that I had a mistake to what you said.
On Thu, Oct 23, 2008 at 2:32 AM, Ian Christian [EMAIL PROTECTED] wrote:
2008/10/21 Moon's Father [EMAIL PROTECTED]:
Could you please give me an idea of how to manage the privileges inside
mysql?
http://www.google.co.uk
It didn't occured unless you manually changed your user's privilege.
On Wed, Oct 22, 2008 at 11:05 PM, kalin m [EMAIL PROTECTED] wrote:
hi all...
i had a weired thing happened
is it possible for a user privileges to expire?!
suddenly today an application stopped working and i was
Add skip-name-reslove in my.cnf and restart mysql immediately.
On Thu, Oct 23, 2008 at 12:37 AM, Richard S. Huntrods
[EMAIL PROTECTED]wrote:
Awesome! Thanks very much - exactly what I was looking for. I'm in the
field and was under the gun, otherwise would have checked the manuals first.
Maybe you can use mysql -e instead.
On Mon, Oct 20, 2008 at 12:51 AM, walter harms [EMAIL PROTECTED] wrote:
hi ronaldo i tried and failed.
it seems that mysql has no option to specify a select statement.
did i mis something ?
re,
wh
walter harms schrieb:
hi ronaldo,
iadmit i was
Timestamp is the best bridge between java and mysql,I think.
On Sun, Oct 19, 2008 at 4:48 PM, Rama [EMAIL PROTECTED] wrote:
DATE TIME ZONE SENSITIVE
DATETIME NOT SENSITIVE TO TIME ZONE
TIMESTAMP TIMEZONE SENSITIVE
iam getting the above problem as date is timezone sensitive.i resolved
Learnt!
On Wed, Oct 15, 2008 at 5:28 PM, philip [EMAIL PROTECTED] wrote:
Date: Tue, 14 Oct 2008 16:55:11 +0300
From: Olexandr Melnyk [EMAIL PROTECTED]
To: [EMAIL PROTECTED], mysql@lists.mysql.com
Subject: Re: Problem with GROUP BY
http://jan.kneschke.de/projects/mysql/groupwise-max
select * from
(
SELECT ID_number, count( CU_number ) AS CC
FROM MyTable
GROUP BY ID_number
) T
WHERE CC =
(
select max(cc) from
(
SELECT ID_number, count( CU_number ) AS CC
FROM MyTable
GROUP BY ID_number
) T2
)
On Wed, Oct 15, 2008 at 5:08 PM, dave aptiva [EMAIL PROTECTED]wrote:
Hello
You could create an extra table in order to record the max number of
widget,the the ID should alway be 1.
On Thu, Oct 16, 2008 at 2:04 AM, Rob Wultsch [EMAIL PROTECTED] wrote:
I would do a muli key PK with a after insert trigger to that would
change widget_number 1 to 1000. Just my HO...
I
Could you please give me an idea of how to manage the privileges inside
mysql?
Thank you very much.
On Wed, Oct 15, 2008 at 5:01 AM, Rob Wultsch [EMAIL PROTECTED] wrote:
On Tue, Oct 14, 2008 at 1:49 PM, Grant Peel [EMAIL PROTECTED] wrote:
Hi all,
I run a shared Apache, Perl, PHP, Mysql,
Maybe it's a bug.^___^
On Thu, Oct 9, 2008 at 1:37 PM, Andrew Garner [EMAIL PROTECTED]wrote:
On Wed, Oct 8, 2008 at 3:10 AM, Zbigniew Szalbot [EMAIL PROTECTED]
wrote:
Hi there,
I hope someone can help. Due to they way my HD has been sliced I had
to move mysql database to
Use mysqldump on the old version and import the data into new version in my
opinion.
On Fri, Aug 22, 2008 at 1:29 AM, Andy Shellam [EMAIL PROTECTED]wrote:
FYI the manual for 5.0 recommends upgrading to 4.1 first.
As a general rule, we recommend that when upgrading from one release
series to
Only increase max_allowed_packet is ok.
On Tue, Aug 19, 2008 at 5:49 PM, Warren Young [EMAIL PROTECTED] wrote:
Mad Unix wrote:
During the update of the MySQL DB (delete/insert), I keep getting the
following message
Lost connection to MySQL server during query...
By default, the MySQL
You should increase parameter named max_bulk_insert_buffer_size and
max_allowed_packet.
On 8/21/08, Ananda Kumar [EMAIL PROTECTED] wrote:
Mysql use tmpdir,
when ever there is any index creation.
regards
anandkl
On 8/21/08, jthorpe [EMAIL PROTECTED] wrote:
Hi,
I've been trying to
This is weird issue that I have never met.I think you should show us your
table's definition phrase and use flush tables to shut down all the open
tables.
On 8/21/08, Abdul Gomaa [EMAIL PROTECTED] wrote:
Hey everyone!
I really hope this is the right place to post this problem. I have have
If you're good at Chinese ,just visit here.
http://blog.chinaunix.net/u/29134/showart_375303.html
On Thu, Aug 7, 2008 at 10:34 PM, Magnus Smith
[EMAIL PROTECTED] wrote:
I think got it in the end by doing a union and a join.
delete AA, PA from ACCOUNTACTION AA, ACCOUNTPAYMENTACTION PA
where
Delete all your relay log ,restart mysqld and use a new change master to
statement to do a slave configuration.
On Sat, Aug 9, 2008 at 2:32 PM, Brown, Charles [EMAIL PROTECTED] wrote:
Could not initialize master info structure;
Can someone help me. I am getting the above message
Add additional option to my.cnf
[mysqld]
relay-log-purge=1
On Mon, Aug 11, 2008 at 2:21 AM, Brown, Charles [EMAIL PROTECTED] wrote:
Here is what I'm getting
mysql change master to master_host = 'naxbmisq01.bmi.com', master_user
= 'repl', master_password = 'repl';
ERROR 1201 (HY000): Could
Remove line contains naxbmisq02-relay-bin.000157 in your
naxbmisq02-relay-bin.index file.
On Fri, Aug 8, 2008 at 1:58 AM, Brown, Charles [EMAIL PROTECTED] wrote:
Please advise me on how to restart MYSQL slave instance.
All efforts have failed. When I issued the START SLAVE command it came
If you have the whole backup ,then you can simply use reset slave statement
to purge all the relay log on your slave machine and use change master to
statement to do a new slave configuration.
On Tue, Aug 12, 2008 at 2:59 AM, Michael Dykman [EMAIL PROTECTED] wrote:
The first thing that occurs
Check if your connections are too large to afford any other connections.
On Mon, Aug 11, 2008 at 8:54 PM, Krishna Chandra Prajapati
[EMAIL PROTECTED] wrote:
Hi All,
Connecting to mysql server is taking lot of time near around 4 to 5
seconds.
Its a pentium box with 512Mb ram
Now mysql's version is 5.0.45
Any reply is appreciated.
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
Hi.
There are 1 store procedures in my database,and prepared statement was
used within procedure's definition.
But when our concurrency is higher,mysqld's memory grows very fast.
PS:I have explicitly used drop prepare .. statement in procedure's
definition.
Anybody can tell me why this
failed attempt to purchase MySQL. That's why MySQL has been working on
their own storage engine as well as the pluggable storage system.
Curtis
David Giragosian wrote:
On 7/21/08, Moon's Father [EMAIL PROTECTED] wrote:
Any reply is appreciated .
--
I'm a MySQL DBA in china.
More about
mysql show global status like '%stmt%';
+-+-+
| Variable_name | Value |
+-+-+
| Com_stmt_close | 4875504 |
| Com_stmt_execute| 4875504 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare|
1 - 100 of 206 matches
Mail list logo
