> Fredrik Carlsson:
>>
>> Hi,
>>
>> Yes I'm using the -q option with mysqldump, but the result is the same.
>>
>> This is a replicated environment and the master is running FreeBSD and
>> the slave NetBSD and on the master which only has InnoDB ta
n not
afford to run the dump there. The tables on the slave is mostly Myisam,
maybe there is some kind of memory buffer that I'm missing to tune on
NetBSD but i can't figure out what it can be, I've already increased the
ulimit values for the session running the dump.
// Fredr
owing command:
/usr/pkg/bin/mysqldump -h localhost -B theDatabase --skip-opt
--max_allowed_packet=1024M -q
Any tips on how to get the dump running? the dump should be about
15-20GB in size the fully dumped, but I never seems to get there.
// Fredrik Carlsson
--
MySQL General Mailing List
For
ormal?
// Fredrik Carlsson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all
I have problems getting MySQL autoboot on my RedHat installation. I have
tried to add the mysql.server start script from the install dir to the
system with chkconfig --add mysql (I copied it to /etc/init.d/) and then
trying to add mysql to the default boot order with chkconfig mysql on
but
ng to
do with it?
I'm using MySQL 4.1.11
// Fredrik Carlsson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
My original query was a UNION query :) and that one is really fast.
The problem i had was that every 8-12 day mysql sad that all of my
max_connections was in use. I think i will stick with my UNION query it
seems faster.
// Fredrik.
Bill Easton wrote:
Fredrik,
I haven't read a
L |
NULL | 542437 | Using filesort |
| B | eq_ref | PRIMARY,parent | PRIMARY | 4 |
mail_archive.A.id | 1 | Using where|
+---+++-+-+---+++
2 rows in set (0.00 sec)
// Fredrik
Donny Simon
ing index |
+---++--+-+-+---+--+--+
2 rows in set (0.00 sec)
The table and index structure are from the production database but the
query was executed on my test database (same structure but not the same
amount of rows)
// Fredrik
Donny Simonton w
a couple of days
ago and when i checked the server 14 hours later (16:00) it still said
that max_connections was full and mysqld was idling using 0% of the CPU,
if the queries was queued up would'nt mysql at least show some activity?
// Fredrik
Donny Simonton wrote:
Frederick,
What exactl
nst |1
| |
| art | ref | parent | parent | 5 | const |2
| Using where; Using filesort |
++---+--+-+-+---+--+-+
// Fredrik Carlsson
Donny Simonton w
mysql has about 50GB of temp space to work with so thats not the problem.
Its strange because the server is not that loaded and around 12-04 at
night no cronjobs that affects mysql or general server performance are
being run.
Is is possible to se how many queued up questions mysql has at the mom
ating upp all the connections.
// Fredrik Carlsson
# The MySQL server
[mysqld]
port= 3306
socket= /tmp/mysql.sock
skip-locking
key_buffer = 280M
max_allowed_packet = 32M
table_cache = 512
sort_buffer_size = 2M
read_buf
Roger Baklund wrote:
Fredrik Carlsson wrote:
Hi list,
I have a question regarding mysql and innodb.
My current setup uses myisam and the db size is about 1.6 GB with two
table that each have about 500k rows. I perform alot of fulltext
search on these tables and they can sometimes take along time
during the fulltext search everything else
stops working. I read at dev.mysql.com that myisam uses per table lock
and innodb per row lock so my question is if i convert my tables to
innodb will i be able to use the tables during a fulltext search?
// Fredrik Carlsson
--
MySQL General Mailing List
ing NetBSD 1.6.2 and mysql 4.0.21
What can cause these segfaults? and is there anything i can tune to get
rid of them?
// Fredrik Carlsson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have some questions regarding CHECK TABLE, OPTIMIZE TABLE. When i run
these commands on table1 mysql seems to lock up all other databases, is
it possible to run these things in the "background" so that other
databases can be accessible.
// Fredrik Carlsson.
--
MySQL General Ma
NetBSD 1.6.3, mysql 4.0.20.
The database contains about 300 000 rows and the size is ~1GB.
// Fredrik Carlsson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have two tables one is the gallery and the other one is table for
events so I can categorise the images.
Now I wan't to get all the rows from events (id, event, date) in
cronological order by date. But I also wan't a random row (id, , ext,
*_nail) from the gallery where gallery.event is equal
hy i'm seeing it.
Any thoughts
Cheers
Fredrik Högberg
This query was pretty fast avg. 1-3 s / search
SELECT m1.id FROM table1 AS t1 JOIN table AS t2 ON m1.textid=m2.id WHERE
match(t2.text) AGAINST('$searchString' IN BOOLEAN MODE);
I also added an index on table1.textid and table2.id.
Is there a way to optimize this query even more?
this query?
// Fredrik Carlsson
Egor Egorov <[EMAIL PROTECTED]> wrote:
>Something like:
>
>SELECT ... FROM one, two WHERE textid=two.id AND MATCH(text) AGAINST() ..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
x27; IN BOOLEAN MODE)
having relevance > 0.9 order by relevance DESC
But due to the split of the table i cant really figure out how to make
the question.
I want to search with fulltext on table2(text) and fetch all the
corresponding data from table1 where textid=(table2.id).
Any tips?
Best regar
Hello
I am developing a small program for a small computer firm.
Now I wonder when I have to buy the corporate licens?
And when to use the free GPL-licens one.
My application ´saves some data in the database and I have done NO change in the
cource code of the free version of MySQL.
Should I or
sock after reboot
and
Before I restart the computer MySQL works very OK both with rpm install and binary
install
What to do?
What do I do wrong?
Fredrik Lundgren
Norrköping
-
Before posting, please check:
http:/
vely new to MySQL, I don't know what to do about this.
Does anyone know?
Fredrik Tolf
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
've tried all this; even tried to install MySQL in "Safe mode" with an
absolute minimum of processes running. Same result.
I'm using an English version of Microsoft Windows XP [Version 5.1.2600] with
all available updates. It's a Dell laptop with 1,2GHz PIII and 512 MB. Th
is no
download available.
Is there a NT version of MySql 3.21?
Does anybody know where to get this?
Is there any other ways to read these databases?
Thanks
-
Fredrik Lunde /Webutvikler/webdesigner
Norwegiandesigne
or, and OR
operator. Is the best way to include ' in queries, or should I precheck the number to
verify that they really are number?
- Fredrik
-
Before posting, please check:
http://www.mysql.com/manual.php (the
and mySQL to attempt any more
organized fixes...
>Submitter-Id:
>Originator:Fredrik Viklund
>Organization:
>MySQL support: [none]
>Synopsis: mysql.server stop fails to stop mysqld and safe_mysqld
>Severity:
>Priority:
>Category: mysql
&
Hi There!
I have some trouble with a webaplication.
I used to run it with an Access dbase but have changed to a nice MySQL dbase and then
i got problems with the commands Addnew,Update,MoveFirst I use the samt locks and
cursors as I did earlyer.
Any good solution? Are there any parameters to s
must replicate themself with all the other servers.
Can this be done with mysql, or do I have to use Oracle? And what about
PostgreSQL?
- Fredrik
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
32 matches
Mail list logo
