great, so this is how the mailing list works...ahh...
On 4/13/05, Paul DuBois <[EMAIL PROTECTED]> wrote:
> Possibilities:
>
> - option file is not one that is read by mysql
> - you didn't put the option in the [mysql] section
> - you included the leading dashes.
>
> If you invoke mysql with the
Marcin,
you must set innodb_log_file_size as recommended in the manual:
http://dev.mysql.com/doc/mysql/en/innodb-configuration.html
[mysqld]
# You can write your other MySQL server options here
# ...
# Data files must be able to hold your data and indexes.
# Make sure that you have enough free disk
hello all
i installed red hat linux 9 in my home s/m and i tried to install mysql
mysql-standard-4.1.10a-pc-linux-gnu-i686.tar.gz
i have followed the steps for installation. the installation dir is
/usr/local/mysql
installation will go smoothly. but when i try to start, it stars and ends
sud
Hi
Try this query
select * from mysql.db where db = database() collate utf8_bin;
Jim Cramer wrote:
Hi,
With MySql 4.1.10a, I am using a commerial app (Advanced Query Tool)
to query and manage the server and databases in it.
While performing one of its functions, the app issues the query
" select *
I haven't actually tried left-joining the same tables multiple times in
MySQL but I'm almost certain it should work in principle.
However, the syntax of your query is definitely wrong. At the very least,
you need the word 'FROM' to designate which tables you are joining. The
manual has examples of
Chris,
Sure, you can join a table multiple times. You're missing a FROM clause
and you seem to put column names where table names or aliases ought to
be. Is this ...
SELECT
tlb1.DepartureLocation AS Departure,
tbl1.DepartureLocation AS Destination
FROM tbl1
LEFT JOIN tbl2 ON tbl2.DepartureID=t
In the last episode (Apr 12), Steve Lefevre said:
> Hey folks --
>
> I'm trying to export data from mysql 4.1.3 with mysqldump.
>
> I'm getting weird characters from the system. Here's what I've discovered
> so far:
>
> ' becomes ^`A^`U, e.g. didn't becomes didnÃ^`A^`Ut
>
> - becomes Ã^`A^'O, e
Hi,
Is it possible to left join the same data twice?
TBL ONE:
LocationID
Location, varchar(100)
TBL TWO:
DepartureID,
ArrivalID,
Time
SELECT tlb1.DepartureLocation AS Departure, tbl1.DepartureLocation AS
Destination LEFT JOIN DepartureLocation ON tlb2.DepartureID=tlb1.LocationID
LEFT JOIN Departu
At 9:59 +0800 4/13/05, D. wrote:
I don't know if this is the right way to get back to the thread,
hopefully this will be placed under the same thread. :)
Thank you for your input, Ligaya.
ahhh...mbstring, I tired that after i got your reply, but it didn't
help to solve the puzzle,
I did manage to f
I don't know if this is the right way to get back to the thread,
hopefully this will be placed under the same thread. :)
Thank you for your input, Ligaya.
ahhh...mbstring, I tired that after i got your reply, but it didn't
help to solve the puzzle,
I did manage to find myself a solution last nigh
Daniel Kasak wrote:
>Mauricio Pellegrini wrote:
>
>
>
>>Hi,
>>I need to select the max value from a set of records but I also need the
>>primary key for that record.
>>
>>The problem is that the record id may not be the same as the record max
>>value for the column as in the following example:
>
On 4/12/2005 8:43 PM Petr Chardin wrote:
Hi Jonh,
As I said, I couldn't find any error logs that seemed to relate (i.e,
had information newer than the upgrade and start failures). I looked
into the /etc/init.d/mysql script and tried running mysqlmanager
directly. It would not run because of err
What version of MySQL are you using?
If you are running 4.1.x or 5.0.x, you should be able to do this subquery to
get the row you want.
select id, col_x, date_col
from table_x
where date_col =
(select max date_col
from table_x)
The subquery gets the max (latest) date in the table, then t
have you altered your php.ini file in the mbstring section? I don't
know if it makes a difference but I have always changed my to:
; language for internal character representation.
mbstring.language = utf8
; internal/script encoding.
mbstring.internal_encoding = utf8
and have never had a problem
Mauricio Pellegrini wrote:
>Hi,
>I need to select the max value from a set of records but I also need the
>primary key for that record.
>
>The problem is that the record id may not be the same as the record max
>value for the column as in the following example:
>
>Table_x
>
>Id x_col date_co
Hello,
I am working on a web application (php) that will have a largish mysql
database (millions of rows, eventually), and for which high availability
will be important. I am wondering if anyone here can suggest options for
multi-master replication or clustering.
The application will be mostly
Hi Jonh,
> As I said, I couldn't find any error logs that seemed to relate (i.e,
> had information newer than the upgrade and start failures). I looked
> into the /etc/init.d/mysql script and tried running mysqlmanager
> directly. It would not run because of errors. From another message in
> t
Hi,
I need to select the max value from a set of records but I also need the
primary key for that record.
The problem is that the record id may not be the same as the record max
value for the column as in the following example:
Table_x
Id x_col date_col
1 1 2005-04-11
2
Hey folks --
I'm trying to export data from mysql 4.1.3 with mysqldump.
I'm getting weird characters from the system. Here's what I've discovered
so far:
' becomes ^À^Ù, e.g. didn't becomes didnâ^À^Ùt
- becomes â^À^Ó, e.g. 1-2 becomes 1â^À^Ó2
è becomes è, e.g. Entrèe becomes Entrèe
What giv
Marcin Lewandowski wrote:
> Hi,
>
> I've got webserver. There, I've got phpbb2 with circa 6000 users
> (average 70-100 users online). There was problems with locking or
> something else, when phpbb was using myisam tables. Yesterday, we have
> converted tables to innodb, because it should be more
> I've got IDE hdd. Is there simple way to check, if it's overloaded?
> Would RAID1 help? (I don't know if in raid1 there are parralel reads or
> maybe one disk is only a mirror)
If it's IDE, probably not. Moving the database to a different
subsystem would give more IO. You can use iostat to check
Gary Richardson napisał(a):
Hey,
How much load is system vs user? I found that when my company
converted some large tables on our old server, the concurrent disk IO
increased. Your database server is doing more in parallel and
accessing more from your disk at one time. That would be my guess.
One o
I've changed settings to:
innodb_data_file_path = ibdata1:128M:autoextend
innodb_buffer_pool_size=150M
innodb_additional_mem_pool_size = 50M
and system load is "only" 2 to 3.
kernel napisał(a):
What does the cpu % show when the machine has the high load avg ?
Now, there are about 50% of normal lo
I think that's because those databases render datetime values into their
"seconds from epoch" values (whichever epoch they use) when casting to a
numeric type (I know MS SQL does. I assume the others do, too.) It seems
that MySQL is the oddball on this issue.
Shawn Green
Database Administrator
Thanks for the detailed explanation which is what I assumed was
happening. Does
it make any sense though? Shouldn't we get some sort of warning for the
implicit cast? I could be wrong but I thought PostgreSQL, Oracle, and SQL
server handled avg(date/time values) correctly.
Quoting [EMAIL PROTE
James Nobis <[EMAIL PROTECTED]> wrote on 04/12/2005
10:19:33 AM:
> Hi all,
>
> Essentially I was asked to look into a problem with a query at the
> office which
> used AVG on a datetime column which produces incorrect results. (MySQL
4.1.10
> on RHEL 3 update 4) As you can see below the star
"B Wiley Snyder" <[EMAIL PROTECTED]> wrote on 04/11/2005 10:38:12 PM:
> Hello experts,
>
> I just need someone to please point me in the right direction on
retaining
> my "key" or id order in my table when I delete a row. So for example I
have
> 10 rows Id 1-10 that are created automatically
Hi, this might not be a mysql problem, but hopefully someone will be
able to answer, thanks in advance.
I notice a lot of people had asked the same question and the typical
response in the mailing list seemed to be, "make sure you encode the
data to utf-8 before insert into mysql...", or something
Here are two posts on list that you might find relevant:
http://lists.mysql.com/mysql/182017
http://lists.mysql.com/mysql/180889
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Tue, 12 Apr 2005, Luis Calero wrote:
> Hello, I've been discussing with a coworker if it's possible to
>
Marcin Lewandowski wrote:
Hi,
I've got webserver. There, I've got phpbb2 with circa 6000 users
(average 70-100 users online). There was problems with locking or
something else, when phpbb was using myisam tables. Yesterday, we have
converted tables to innodb, because it should be more effective.
Thanks again!
Dan Bolser <[EMAIL PROTECTED]> wrote:On Tue, 12 Apr 2005, Rich Carr wrote:
>Hi Dan,
> Thanks very much! First, I can't figure out how to reply to this so
>that it shows up in the MySQL list. How does one do it?
erm... if you hit 'reply all' or answer yes to 'reply to all' it should
On Tue, 12 Apr 2005, Rich Carr wrote:
>Hi Dan,
> Thanks very much! First, I can't figure out how to reply to this so
>that it shows up in the MySQL list. How does one do it?
erm... if you hit 'reply all' or answer yes to 'reply to all' it should
send mail to [EMAIL PROTECTED]
Ahhh...I see what
The MyIsam storage engine is a non transactional engine and InnoDb is a
transactional engine. That is the main difference. So I think the MyIsam
engine should be faster.
Try to adjust the "innodb_thread_concurrency" parameter when you have a
lot of users.
Reto
Marcin Lewandowski wrote:
Hi,
I'v
As long as articles.annotationID can be made distinct from
names.annotationID why not use 2 left joins.
You may have to test annotationType in the select section to map the fields.
Something like the following.
SELECT elements.annotationID,
CASE annotationType
WHEN 'names' T
Hello.
Similar questions are often asked in the list. Search in
archives about various solutions at http://lists.mysql.com/mysql.
See:
http://dev.mysql.com/doc/mysql/en/replication-faq.html
Luis Calero <[EMAIL PROTECTED]> wrote:
> Hello, I've been discussing with a coworker if it's
Hello.
Something like:
mysqldump -h 192.168.1.1 -uroot -p -A >backup.sql
See:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
"Abdul Aziz" <[EMAIL PROTECTED]> wrote:
>
>
> Dear All,
>
>
> I wish to backup all databases to my server(192.168.1.1) from my host(192.
> 1
Hi Team,
I would like to rebuild the tables which one will be suitable repair or
optimize. Please suggest.
Thanks in advance.
Thanks
Suresh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I've got webserver. There, I've got phpbb2 with circa 6000 users
(average 70-100 users online). There was problems with locking or
something else, when phpbb was using myisam tables. Yesterday, we have
converted tables to innodb, because it should be more effective. Since
then we have high
Hi all,
Essentially I was asked to look into a problem with a query at the office which
used AVG on a datetime column which produces incorrect results. (MySQL 4.1.10
on RHEL 3 update 4) As you can see below the stark difference between the
correct and incorrect results. Though, the incorrect re
Hi,
With MySql 4.1.10a, I am using a commerial app (Advanced Query Tool)
to query and manage the server and databases in it.
While performing one of its functions, the app issues the query
" select * from msql.db where db=database()
This query give the error:
"HYT00(1267) Illegal mix of collatio
Hi list,
I have a design problem, I'd like to know if there is a nice way to solve
it
I have elements that can be annotated, an annotation is basic info and a
link on an other database.
For example: my element id 3, called testElement, is annotated.
the annotation depends on the foreign data
Dear All,
I wish to backup all databases to my server(192.168.1.1) from my host(192.
168.1.5) with (mysqldump),how can we possible,plz tell me command or Script
with brief description.
Thanks in advance
aaziz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hello, I've been discussing with a coworker if it's possible to
setup the following replication scenario: We've got two boxes, machine
A that has machine B as his master, and machine B that has machine A
as his master (A->B B->A), both boxes are masters and slaves. Over
this two boxes there's an
Most of what I've read about temporal databases comes from Richard
Snodgrass. I've actually started reading one of his books I found online
(http://www.cs.arizona.edu/people/rts/tdbbook.pdf) which seems to be quite a
reference in this field judging by the people who contributed to it.
Using MySQL
Hello.
Such a problem often occurs when you had MySQL installation before and
didn't remove the service. Use another name for the service. Search
in archives at http://lists.mysql.com/mysql for solutions for similar
problems. See:
http://dev.mysql.com/doc/mysql/en/windows-troubleshooting
Hello.
Replication shouldn't die if one of the participants goes offline.
But unclean shutdowns of the master may cause inconsistencies between the
content of tables and the binary log in master; this can be avoided by
using InnoDB tables and the --innodb-safe-binlog option on the master.
> I just need someone to please point me in the right direction on retaining
> my "key" or id order in my table when I delete a row. So for example I
have
> 10 rows Id 1-10 that are created automatically when the record is
inserted.
>
> So if I delete record with id 5 my id's are not 1,2,3,4,6,7,8
Hi!
I have a table with the following fields:
varchar(200) title, varchar(200) link, text content
I made an index on the table, named "common", with type fulltext,
which contains the title, link, content fields.
When i execute the explain on the following select:
(SELECT *
FROM tdpages
wh
I think the suggestion posted here...
http://lists.mysql.com/mysql/182424
should get you going in the right direction.
You really need to know what you are doing to know if it is giving you the
correct answer or not.
It would be cool if their was something like a GROUP_ROW(cols, expr) to do
wh
49 matches
Mail list logo