Nice to meet you.
I am andou.
Slave DB : though is several-time re-synchronization. It is sure to have
entered the state that the process of the slave stops because of the same
error.
Excerpt from show slave status(a part of Fge)
Last_error: error 'unexpected success or fatal error' on query 'CRE
Nice to meet you.
My name is katakura.
I might want to ask the replication.
It is that whether the slave side has synchronized though show master
status is done
on the side of ..show slave status.. mastering on the slave side and
Read_Master_Log_
Pos and Position agree that Rows in the value of sh
Thanks (to) Brent and Alexey ...
The solution to speed up my query was the compound index on Hash+Year.
With this compound key the query time dropped dramatically.
From 30 minutes to 14 seconds !
Cor Vegelin
Business Explorer BV
- Original Message -
From: "Brent Baisley" <[EMAIL PROTE
I'm using MySQL Ver 14.7 Distrib 4.1.9, for pc-linux-gnu (i686) on
RedHat Linux 9
and found this weird thing
I create first table
CREATE TABLE `t_keycode` (
`keycode_id` int(11) NOT NULL auto_increment,
`keycode_val` varchar(255) NOT NULL default '',
`keycode_desc` varchar(255) NOT NULL default
I'm using MySQL Ver 14.7 Distrib 4.1.9, for pc-linux-gnu (i686) on
RedHat Linux 9
and found this weird thing
I create first table
CREATE TABLE `t_keycode` (
`keycode_id` int(11) NOT NULL auto_increment,
`keycode_val` varchar(255) NOT NULL default '',
`keycode_desc` varchar(255) NOT NULL defa
- Original Message -
From:
Ed
To: mysql@lists.mysql.com
Sent: Tuesday, October 25, 2005 6:40
PM
Subject: Problem with syntax 4 creating 1
table
Shawn green was very kindly helping me ouy trying to make mysql tables
and I thought I had go the hang of
OK. I thought about that earlier, but I wasn't sure if
I'd be able to adapt it to this particular problem.
Do you think the "automated tree traversal" method
described at the link you posted...
http://www.sitepoint.com/article/hierarchical-data-database/2
...is the only one that would work? I've
On Tue, Oct 25, 2005 at 04:22:01PM -0400, sheeri kritzer wrote:
> What you need is the table schemas and the data. Oracle doesn't have
> SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn't
The oracle-supplied DBMS_METADATA package can do this for you.
-Jason Martin
--
Silence is
David Blomstrom <[EMAIL PROTECTED]> wrote on 10/25/2005 06:23:52
PM:
> I hope this isn't too long-winded. It's kind of hard
> to explain.
>
> I'm trying to figure out a scheme that will display
> animal distribution information. First, I want to
> divide animal species by continents. Next, I wan
Since you want the setup with the least headache and because you are
thinking of writing a book about how to use MySQL, I recommend the Without
Installer version.
It's basically 4 steps:
1) unzip
2) edit config file
3) install as service
4) start the service
It can actually take you more time t
Ed wrote:
Shawn green was very kindly helping me ouy trying to make mysql tables
and I thought I had got the hang of it until I get this error-any ideas?
Thanks a lot
CREATE TABLE PurchasedProducts(
`int_saleCart` INT AUTO_INCREMENT NOT NULL ,
`int_ClientID` INT,
`int_ProductID` INT,
`int_Quan
More investigation shows that the query does make it to the slave, at
least into the relay log, yet it's still ignored. 'replicate-do-db' is set
and shows the correct DB in the slave status.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Thu, 20 Oct 2005, Atle Veka wrote:
> I ran in
From: "Tom Brown" <[EMAIL PROTECTED]>
(...)
> starting at say 1GB and then 'extending' to 25GB. So is it possible for
> all datafiles, rather than just the last one, be 'autoextending'
The short answer: no.
http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html states:
" The autoextend
Shawn green was very kindly helping me ouy trying to make mysql tables
and I thought I had go the hang of it until I get this error-any ideas? Thanks a
lot
CREATE TABLE PurchasedProducts(
`int_saleCart` INT AUTO_INCREMENT NOT NULL ,`int_ClientID` INT,`int_ProductID` INT,`int_Quantity` INT,`i
I hope this isn't too long-winded. It's kind of hard
to explain.
I'm trying to figure out a scheme that will display
animal distribution information. First, I want to
divide animal species by continents. Next, I want to
further identify species that live on islands that are
associated with contine
I was a database professor in a school of business until my retirement
last year. I taught Oracle SQL for several years and taught one class
in Uganda with MySQL so I am reasonably familiar with it from a user
standpoint. However, I am not a developer nor a programmer. A
professor in Uganda
Has anyone here successfully managed to install mysql
4.1.15 on a RedHat 7.3 box? RedHat 7.3 seems to be
using
the glibc 2.2.5 libraries and mysql seems to insist on
using glibc 2.3. Am I out of luck?
__
Yahoo! Mail - PC Magazine Edit
I'm not *certain* of this but I'm pretty sure that SQL will never give you
"zero rows" of the kind you want from a query on a single table. (Then
again, I'm not an SQL Genius so maybe someone else can suggest something
that would work.) However, you can probably accomplish what you want fairly
easi
On 10/25/05, Ziaul Mannan <[EMAIL PROTECTED]> wrote:
> ** Low Priority **
>
> Hello,
>
> I was able to install the following perl modules fine:
> DBI
> Data::Dumper
> Data::ShowTable
> DBI.pm
>
> Then,when I am try to install perl module called 'DBD::mysql' on AIX
> 5.2(64-bit) and 5.3. In both cas
What you need is the table schemas and the data. Oracle doesn't have
SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn't
have fun tools like AUTOINCREMENT -- you're going to want to know what
the code is for any triggers on the data, because in order to do
AUTOINCREMENT in oracle
that looks like a spool file from sqlplus. does it have the data too or just
a bunch of describes?
if this is what he gave you he is either severly clue-challenged or trying
to sabotage you (my $ on later though they're not mutually exclusive).
you could write a perl program to parse this into so
On Tue, 2005-10-25 at 15:39 -0300, James Sherwood wrote:
> Mysql 4.1 and 5 will NOT seem to play nice with french characters so I have
> tried to revert back to 4.0.
>
> I am trying to install 4.0 on a Win2003 Dell PowerEdge 2850 and when I run
> the service it uses a constant 25%cpu and seems l
This is probably a silly question, but here goes... I have a table that
logs access to web services, and I am looking to create a report to
track the number of times each service was accessed in a given month.
I know I can loop through the days in the month in PHP and do a seperate
query for
I have some data that has been "dumped" from Oracle into what appears to
be a proprietary text file... It is not delimited into a format that I
can just import into mysql (easily). The IT guy has provided me an
outline of the "dump"..
ie;
SQL> describe isup051024;
Name
Hello,
Mysql 4.1 and 5 will NOT seem to play nice with french characters so I have
tried to revert back to 4.0.
I am trying to install 4.0 on a Win2003 Dell PowerEdge 2850 and when I run the
service it uses a constant 25%cpu and seems locked up. I cannot even stop the
service I have to end th
Alastair Roy wrote:
> Greetings everyone, I am having a problem with PHP and mysql I have copied a
> script exactly off a website to open the database and insert a new user I
> try to access the mysql database using the root user, and enter information
> into the user table, this is the PHP I am us
Must be a bug of sorts:
If you add an ORDER BY clause to the view itself, then mysql allows
the caller to override with their own ORDER BY clause and it works as
expected. However; if no ORDER BY clause is present in the CREATE
VIEW statement, then the caller receives erroneous results if they
ca
Mysql seems to have a problem returning ordered lists from views.
ie, 'select * from myView order by column' does not return a properly
ordered list. (it does change the ordering sequence, but to an
erroneous list)
converting myView to be a Temporary Table using 'ALGORITHM=TEMPTABLE'
in the 'CRE
Hi
I need to have a single db that will have in excess of 100gb of data in
it - For this i will need to create more that 1 datafile as the max file
size of linux would be exceeded in this scenerio.
On Oracle you can say that a datafile is x mb in size and it can
autoextend to be x mb - Is th
Yes.
Whenever you have a problem, go back to basics. Can you login as root
on the commandline? What password do you use there? Once you're
there, check root's permissions, but I'd be willing to bet your
password is incorrect, or root is only allowed to logon from localhost
and not the machine t
[EMAIL PROTECTED] wrote:
Erich Beyrent <[EMAIL PROTECTED]> wrote on 10/25/2005 12:06:28 PM:
[EMAIL PROTECTED] wrote:
"Jim C." <[EMAIL PROTECTED]> wrote on 10/25/2005 11:10:50 AM:
Where can I get tips on how to manually set up MySQL for MythTV?
MythTV's site was not very helpful in this r
Hello,
I dumped a database from our 4.0 server to a .sql file.
When I try to input it back into the new 5.0 database, it gives me this error
(1406 data too long for column)
This works fine on 4.0 but will not work on 5.0.
I also tried modifying the mediumtext to longtext in the dumpfile but it
I won't translate all of it but I can show you the patterns. See comments
interspersed
"Ed" <[EMAIL PROTECTED]> wrote on 10/25/2005 11:57:21 AM:
> Hi all,
> I am doing a tutorial to make a shopping cart. I need to make a mysql db
or
> convert an sql db to mysql.
> Can anyone give me any po
Hello.
For example, the size of the field. DATETIME uses only 8 bytes. See:
http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html
Sinang, Danny wrote:
>Hello,
>
>Can anyone tell me what advantages there are in keeping dates and times
>in a MySQL
>DateTime field, as oppo
Hello.
> and restarted MySQL with /etc/init.d/mysql start, I get the following:
>
> Starting MySQL database server: mysqld.
> Checking for crashed MySQL tables in the background.
> /usr/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: '[EMAIL PROTECT
Hello.
May be this could be a bit helpful:
http://dev.mysql.com/doc/refman/5.0/en/access-denied.html
Alastair Roy wrote:
> Greetings everyone, I am having a problem with PHP and mysql I have copied a
> script exactly off a website to open the database and insert a new user I
> try to ac
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
T Uma Shankari wrote:
>
> Hello!
>
> I am trying to run mysql on XP. I have started the net start mysql.
> This service started without any error. My.ini file was there in
> c:\windows only. But i c
Hello.
Run ps -axm on the second server, and normally you should see a lot of
mysqld threads.
Edward David wrote:
> I just joined this list so I am hoping that this question is relevant to
> this group.
> I am running Linux AS4 Enterprise Server.
> I am running Mysql Ver 14.7 Distrib 4.
Hello.
> 051024 18:38:29 [ERROR] Fatal error: Can't open and lock privilege
> tables: Table 'mysql.host' doesn't exist
Have you launched mysql_install_db? See:
http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html
tom wible wrote:
>> Description:
>
>
> [EMAIL PRO
Hello.
Is it possible that you leave some variable blank? Your script doesn't
produce any error for me:
[EMAIL PROTECTED] mysql-debug-4.1.14-pc-linux-gnu-i686]$ mysql
--defaults-file=my.cnf -u${DB_NAME} -p${DB_PASSWORD} -e"GRANT select,
update, insert, delete ON $DBNAME.* TO [EMAIL PROTE
Hello.
MySQL allows you to find out the slow queries. Have a look here:
http://dev.mysql.com/doc/mysql/en/Slow_query_log.html
Luke Vanderfluit wrote:
> Hi.
>
> I have upgraded RT Request Tracker. I'm using Mysql 4.0.18, Apache 1.3.27
> (with static modperl module).
> The database we
SOLVED, sorry for the message.
It was a different error, will post on it shortly
James
- Original Message -
From: "James Sherwood" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, October 25, 2005 1:39 PM
Subject: Error 150 when inputing a dump
Hello,
I dumped a database from our 4.0 server
Hello,
I dumped a database from our 4.0 server to a .sql file.
When I try to input it back into the new 5.0 database, it gives me this error
which I beleive is a foreign key constraint error.
Normally I just put FOREIGN_KEY_CHECKS=0; and that solves it but it doesnt
accept that line in 5.0
An
Erich Beyrent <[EMAIL PROTECTED]> wrote on 10/25/2005 12:06:28 PM:
> [EMAIL PROTECTED] wrote:
> > "Jim C." <[EMAIL PROTECTED]> wrote on 10/25/2005 11:10:50 AM:
> >
> >
> >>Where can I get tips on how to manually set up MySQL for MythTV?
> >>MythTV's site was not very helpful in this regards.
>
[EMAIL PROTECTED] wrote:
"Jim C." <[EMAIL PROTECTED]> wrote on 10/25/2005 11:10:50 AM:
Where can I get tips on how to manually set up MySQL for MythTV?
MythTV's site was not very helpful in this regards.
Jim C.
[attachment "signature.asc" deleted by Shawn Green/Unimin]
I think they (Myth
Sorry I missed the explain part.
You are doing a full table scan on the Updates table. There really is
no way around speeding up reading a million rows. That's going to be
dependent mainly on the speed of your disks and then how much memory
you have.
MySQL is optimizing your query to select
Hi all,
I am doing a tutorial to make a shopping cart. I need to make a mysql db or
convert an sql db to mysql.
Can anyone give me any pointers as to how to make the following tables?
The Microsoft SQL Server 2000 creation script is below the tables. Thanks a
lot for any pointers to get me star
"Jim C." <[EMAIL PROTECTED]> wrote on 10/25/2005 11:10:50 AM:
> Where can I get tips on how to manually set up MySQL for MythTV?
> MythTV's site was not very helpful in this regards.
>
> Jim C.
> [attachment "signature.asc" deleted by Shawn Green/Unimin]
I think they (MythTV) probably know mor
Where can I get tips on how to manually set up MySQL for MythTV?
MythTV's site was not very helpful in this regards.
Jim C.
signature.asc
Description: OpenPGP digital signature
Adding compound (hash, years) index (or even better unique index if it
fits in your business logic) in both tables should speed up things.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Brent,
Well I did post an EXPLAIN before my query,
but it got squeezed at the end of my former email.
The EXPLAIN for my query says:
==
id:1
select-type: simple
table:Updates
type: ALL
possible_keys: Hash, Year
key:
I would check the slow query log. Queries that are taking a long time
(meaning slow) should be logged there. You can check your MySQL
configuration file to find out how long a query will run before it's
considered slow and where it is logging the info.
On Oct 25, 2005, at 3:16 AM, Luke Van
How about posting the explain for your query. Just put explain before
it, MySQL with then tell you how it will go about executing the
query, like which indexes it's using. I assume you have both columns
indexed?
On Oct 25, 2005, at 4:46 AM, C.R. Vegelin wrote:
Hi List,
I have a performan
"pedro mpa" <[EMAIL PROTECTED]> wrote on 10/24/2005 06:32:48 PM:
> Hi!
>
> I need help on implementing a query that performs a search for items
under
> nested categories. An example is on ebay search where you can restrict
your
> search by selecting a subcategory and you only get items under th
Claire McLister <[EMAIL PROTECTED]> wrote on 10/24/2005 05:19:18 PM:
> Hi,
>
> We've developed an automatic email mapping capability from Google Maps
> API.
>
> To try it out, we mapped origins of emails to this group from October
> 3 through October 14th.
>
> The result of this map is a
** Low Priority **
Hello,
I was able to install the following perl modules fine:
DBI
Data::Dumper
Data::ShowTable
DBI.pm
Then,when I am try to install perl module called 'DBD::mysql' on AIX
5.2(64-bit) and 5.3. In both cases I am getting following errors:
dogwood:mysql:/home/mysql/DBD-mysql
** Low Priority **
Hello,
I was able to install the following perl modules fine:
DBI
Data::Dumper
Data::ShowTable
DBI.pm
Then,when I am try to install perl module called 'DBD::mysql' on AIX
5.2(64-bit) and 5.3. In both cases I am getting following errors:
dogwood:mysql:/home/mysql/DBD-mysql
change the group
chown -R mysql.daemon /dir/name
try that
On Tuesday 25 October 2005 16:05, Michael McFadden wrote:
> Hi.
>
> Looks like the 'hosts' grant table is missing,
> corrupt, or does not have permissions set correctly.
>
> My examples come from version 4.1 I hope they apply,
> or
Hi.
Looks like the 'hosts' grant table is missing,
corrupt, or does not have permissions set correctly.
My examples come from version 4.1 I hope they apply,
or at least point you in the right direction.
My datadir is /var/lib/mysql - your's may be different
within the datadir there is another
Hi,
I think you could use something like
SELECT DISTINCT
(CASE p.ship_status
WHEN '1' THEN "shipping_now"
WHEN '2' THEN "shipping_soon"
ELSE 'unknow'
END) as status
FROM products AS p
INNER JOIN cart AS i
ON i.product_id = p.id
WHERE i.session_id = " & prepSQL(tConn, tSessionID);
If there a
Greetings everyone, I am having a problem with PHP and mysql I have copied a
script exactly off a website to open the database and insert a new user I
try to access the mysql database using the root user, and enter information
into the user table, this is the PHP I am using
When I try this
Hi List,
I have a performance problem I can't get solved.
I have 2 tables, called Updates (1 mln rows) and Data (5 mln rows).
Table Updates has 2 (non-unique) keys, defined as:
> Hash bigint(20) unsigned default NULL
> Year tinyint(4) NOT NULL default '0'
Table Data has the same 2 (non-unique) keys
Hi.
I have upgraded RT Request Tracker. I'm using Mysql 4.0.18, Apache 1.3.27
(with static modperl module).
The database we are using is quite large.
The main problem we are having is that certain processes can take quite
a long time.
This is due to mysql churning through data.
I'd like to find
63 matches
Mail list logo
