llions tables and it's all fine. The only
thing is that MySQL built table with a default of 4Gb maximum. It's
possible to go but you need to consider it if you think your table may
grow bigger than that (for MyISAM that is)!
--
Mathieu Bruneau
aka ROunofF
===
GPG keys available @
note that you probably want to use MyISAM table format and not the
old ISAM one :)
But with that database size and that amount of ram, you'll have
intensive IO unless it's almost always the same data that is accessed...
(Which doesn't make much sense if you keep that much!)
Jus
Hello everybody,
I use a table for caching, the table is quite simple there is "id"
field which is a md5 on some attributes of an object, a timestamp field
and a text field for storing the data.
| id char(32) | timestamp | data (text) |
We clean the table every 2 mins for data older that 10
ure which exactly is suppose to be faster but it's worth a try!
Is it possible that you are hitting some kind of limit on maximum join
number in your server ? I'm not even sure if a limit of that kind exists
(Just putting my tought on the table)
--
Mathieu Bruneau
aka ROunofF
===
GPG keys av
x27;t use with a
"like" but with a "match"
You could however use an typical index here, or even better an unique
index to ensure the validation!
Hope it helps you in you development!
See for all information about fulltext index in the manual
http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html
--
Mathieu Bruneau
aka ROunofF
===
GPG keys available @ http://rounoff.darktech.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
kalin mintchev a écrit :
> hi all...
>
> what's the best way to periodically back up mysql data?
> so that databases and tables can be still usable even after a mysql upgrade?
>
> thanks...
>
>
The only absolutely portable way is the dump in text file...
Good
error 11 before). I kept
this settings till I could upgrade to a 64 bits host.
--
Mathieu Bruneau
aka ROunofF
===
GPG keys available @ http://rounoff.darktech.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
or which I have no experience. The
documentation should provide the information needed however:
http://dev.mysql.com/doc/refman/5.0/en/instance-manager-command-options.html
Regards,
--
Mathieu Bruneau
aka ROunofF
===
GPG keys available @ http://rounoff.darktech.org
--
MySQL General Mailing Lis
de possiblity, you may want to consider other
solutions. This one for example has the advantage to allow you to store
more than 2 types of address along a user and keep all the address in
the same table instead of having 2 tables that store more or less the
same kind of information :)
R
would be efficient, depends of your application I guess :) Second you
could create the table with generous MAX_ROWS and AVG_ROW_LENGTH to tell
mysql to use bigger pointer. I don't know the real impact on performance
that will have but at least you won't be limited to 4G of data anymore!
Regar
You have many options like the people below just suggest...
1 - Use mysqldump
2 - Use mysqlhotcopy
or
3 - do the mysqlhotcopy/mysqldump yourself
Since I found that neither 1 nor 2 gives exactly a perfect result in
many backup scheme alone. I started working on something that complement
1 and 2 t
Dominik Klein a écrit :
>> Is there a way to allow the
>> SQL_THREAD to write while holding everything else ?
>
> iptables -A INPUT -p tcp --dport 3306 -s MASTER_IP -j ACCEPT
> iptables -A INPUT -p tcp --dport 3306 -j REJECT
>
Well technically that will refuse connection. Since the switch wo
ent format, newer one are much longer and start with
an * so you know which user uses the new and the old scheme)
3) No '%' means everything except localhost... That's a special case in
mysql :)
Regards,
--
Mathieu Bruneau
aka ROunofF
===
GPG keys available @ http://rounoff.dar
lock! (Prevent join between
the db but allow for tuning of param for each, and allow more memory to
be used than the 3-4G limit per process on 32bits architecture)
mysqld_multi allows easy management of those kind of setup!
--
Mathieu Bruneau
aka ROunofF
===
GPG keys available @ http://
akes much less cpu (but will give a bigger dump size)
Also about using the mysqldump 5.0 on a mysql 4.1 server... hmmm not
sure about which side effect that may have! I usually use the version
that comes with the server...
--
Mathieu Bruneau
aka ROunofF
===
GPG keys available @ http://rounoff.darkt
y for dumped db an tables.
> Somebody meet such type of mysqlbackup script?
>
It doesn't put the structure in a separate file (yet), but you may want
to have a look at ZRM (Zmanda Recovery Manager) for mysql here
http://www.zmanda.com/backup-mysql.html
This is the most complete free solution t
him to use the index but beware of that solution as it
may have an impact if you dataset change with time (growth)
Regards,
--
Mathieu Bruneau
aka ROunofF
===
GPG keys available @ http://rounoff.darktech.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Also which version of mysql are you using ?)
--
Mathieu Bruneau
aka ROunofF
===
GPG keys available @ http://rounoff.darktech.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ver came around to submit a bug or
investigate a reproducable case however.
But now that i'm thinking about it, I think it's when I use the revoke
command. Maybe other people had a similar experience ?
As a workaround, I always play it safe and use the flush privileges
after changing pr
uffer, and limit the
max_connection settings...
I'm sure you could find a lot more info around on the net! This
http://www.mysqlperformanceblog.com/2006/05/17/mysql-server-memory-usage/
also gives a few pertinent information.
If all the memory are needed and you wish to increase those est
ent of the position in the binlog you were in as a
comment inside your dump.
So 2 solutions, you looks at that line, which will tell you which binlog
was in use and which position and then you use:
For the first binlog:
mysqlbinlog binlog_to_start --start-position=pos_id | mysql
And simply for all oth
Ofer Inbar a écrit :
> Mathieu Bruneau <[EMAIL PROTECTED]> wrote:
>> Ofer Inbar a écrit :
>>> I can repeat the problem with this procedure on the test db:
>>> - Import a full mysqldump file from the prodution db
>>> - flush logs
>>> - run
es are consistent (and will still allow for select to go through the db)
Best luck
--
Mathieu Bruneau
aka ROunofF
===
GPG keys available @ http://rounoff.darktech.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
you want to know if your slave is really up-to-date. You
have to make sure, the IO_THREAD isn't constantly transferring and that
the SQL_THREAD has done playing everything in the relay log!
Maybe having a separate SQL_THREAD_LAG and IO_THREAD_LAG could be
something possible (Feature request?) Bu
e of the connection and that the webserver were trying
to communicate through it, he was reporting "Lost connection to mysql
server during query"
We adjust the setting of the persistent connection to 45 mins and the
problem went away.
This don't have anything to do with the versio
>|
> | thread_stack| 131072
>|
> | time_format | %H:%i:%s
>|
> | time_zone | SYST
igured right. You want to
> check the bind-address and skip-networking settings. You don't want
> skip-networking, and you want bind-address set to the machine's IP
> address. Now that I think of it, this is more likely to be the problem
> for you.
>
> Cheers
>
71 0.00 173.70 0 10424
>
> I've been running this for a few hours and it consistently shows lots
> of writes but no reads at all on sdb1, the partition where I have my
> binary logs and tmpdir. Is MySQL writing lots of tmp files and not
> reading
user that have "super" privilege and the replication thread.
Depending of your exact version to set it it's something in the line of
"set GLOBAL read_only=true;"
You can also remove it in case you need it.
Regards,
--
Mathieu Bruneau
aka ROunofF
===
GPG keys avai
you
# might be limited to 2-3.5G of user level memory per process, so do not
# set it too high.
innodb_buffer_pool_size=2G
Regards,
--
Mathieu Bruneau
aka ROunofF
===
GPG keys available @ http://rounoff.darktech.org
Justin a écrit :
Ok.. Straight to the point.. Here is what I currently have.
se it. Don't know if
falcon use file handle per table or not tough...
--
Mathieu Bruneau
aka ROunofF
===
GPG keys available @ http://rounoff.darktech.org
Mariella Petrini a écrit :
I have re-run and job and I was able to repeat the
problem.
Find attached the mysql server error log with all
Are you running on a 32 bits architecture ? I have seen case where 1.7G
is way too much for the total space mysql is allowed to use, especially
if you have innodb buffer set to bigger than default value(8MB). Also
you should check that the user is really allowed that size (ulimit).
The duplicat
32 matches
Mail list logo
