|
| interactive_timeout | 120 |
| net_read_timeout | 5 |
| net_write_timeout| 5 |
| slave_net_timeout| 3600 |
| table_lock_wait_timeout | 50|
| wait_timeout | 3 |
+------+---+
Anybody has any ideas, or have encountered this before .
-Kishore Jalleda
http://kjalleda.googlepages.com
Yes I already did try adding an index on tag, but as you said it didn't work
as its using the primary key from the freetags table for the join , anyway I
will try adding an index on "object_type", and see if that helps ...
Thanks
Kishore Jalleda
http://kjalleda.googlepages.com
On
KEY (`id`),
KEY `raw_tag` (`raw_tag`(10))
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
Freetags table has like a million rows in it
MySQL version 4.1.11 , server has 16GB RAM ..
Kishore Jalleda
http://kjalleda.googlepages.com/mysqlprojects
.
Has anybody ever experienced such a thing or
know what could be the cause ..
Server info
4.1.11-Debian_4sarge3-log
32GB RAM
Max_connections : 400
Thanks
Kishore Jalleda
HB, MON, IPFail would work well for this , here is some info from my website
that I wrote very long ago, hope it helps
http://kjalleda.googlepages.com/mysqlfailover
http://kjalleda.googlepages.com/automatedmasterfailoverinmysql
Kishore Jalleda
On 2/7/07, Kevin Burton <[EMAIL PROTECTED]>
For a very fast reload of InnoDB tables you could try this
Mysqldump ...>dump.sql
Now edit the sql file so that these lines appear at the beginning
SET AUTOCOMMIT=0;
SET FOREIGN_KEY_CHECKS=0;
and add these at the end
SET FOREIGN_KEY_CHECKS=1; (re-enabled the checks)
COMMIT; (actual
look at
http://dev.mysql.com/doc/refman/5.0/en/merge-storage-engine.html
Kishore Jalleda
On 1/31/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]>
wrote:
I'm trying to wrap my head around a performance problem our institution is
having on our Mysql Server which hosts all of our logs from ar
Or you can do this to combine the two steps together
shell>mysqldump --all-databases -uuser -ppassword | gzip | ssh
[EMAIL PROTECTED] 'gunzip > dump.sql'
Kishore Jalleda
http://kjalleda.googlepages.com/mysqlprojects
On 9/12/06, Visolve DB Team <[EMAIL PROTECTED]
This might help you
http://kjalleda.googlepages.com/maxconnbymysql
Kishore Jalleda
On 8/2/06, Rithish Saralaya <[EMAIL PROTECTED]> wrote:
Hello folks.
How do I determine what is the safest value that I can set for
max_connections in my.cnf? The default value of 100 is proving t
put this in your my.cnf
"read_only"
this would put the DB in a read only mode, except for the slave threads and
the super users, which/who can still do writes, this option is mostly used
on slaves though .
see http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.htm
Look at this previous thread
http://forums.mysql.com/read.php?22,42721,42721
Kishore Jalleda
http://kjalleda.googlepages.com
On 6/15/06, Vitaliy Okulov <[EMAIL PROTECTED]> wrote:
Здравствуйте, .
Hi all. I try to increaseinnodb_buffer_pool_size
There is log file:
mysqld_safe
at this script from my website, and it should help you to get started right
away .
http://kjalleda.googlepages.com/checkingmysqlslavestatus
Kishore Jalleda
On 6/14/06, Jacek Becla <[EMAIL PROTECTED]> wrote:
Hi,
I'm trying to find how to split the output from SHOW SLAVE
RANT etc to make sure that the users have proper access to the
new database
sfgdump...
7) now you have a new database sfgdump !!!if thats not what you want then
just repeat your dump and restore on sfgdump freshly instead of sfg
Give this a try and see how it goes
Kishore Jalleda
http://kjalleda.googlepages.com/projects
on
with mysql CLT, which does not buffer sql statements/queries into memory
before flushing them, but if the dump itself consists of large rows of table
data flushed into one large sql statement, then mysql CLT would still treat
it as one query, so i am sure you have to change the way you dump yo
the
file is basically text, but its only understood by the innodb storage
engine ( as far as I know)
Kishore Jalleda
http://kjalleda.googlepages.com/mysqlprojects
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
in
Multi-Master replication any single instance of MySQL can have atmost
one master), but a Slave with Multiple Masters, which offcourse is not
possible unless he plans to run five different mysqld instances (diff
ports and diff data dirs...) on the same box,
Kishore Jalleda
--
MySQL
kind of duplicate errors occur due
Partial_Network_Outages.
Could you also let us know how the master is brought back online after
it crashes, and please explain us as to what happens during a crash
(OS lock, Mysql daemon crash, etc )
Kishore Jalleda
http://kjalleda.googlepages.com/my
I hope this answers your question...
Kishore Jalleda
http://kjalleda.googlepages.com/mysqlprojects
On 5/18/06, Kishore Jalleda <[EMAIL PROTECTED]> wrote:
On 5/18/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
> Hi -
>
> I'm trying to import some data into a MySQL database, which was dumped
> from mysqldump. Just looking at the .sql file generated, there's only
&
make this value "adaptive", as to avoid error?
Thanks!
-dant
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Check this
http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
Kishor
On 5/5/06, Sander Smeenk <[EMAIL PROTECTED]> wrote:
Quoting Kishore Jalleda ([EMAIL PROTECTED]):
> >Can anyone shed any light on this issue?
> This might shed more light into your problem
> http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
I've read that :)
But s
te a shell/perl script
to parse your error logs and count the errors for each host.
Kishore Jalleda
http://kjalleda.googlepages.com/projects
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
if you love peace and quiet.
| 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8 9BDB D463 7E41 08CE C94D
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This might shed more light into your problem
http
On 5/2/06, Atle Veka <[EMAIL PROTECTED]> wrote:
On Mon, 1 May 2006, Kishore Jalleda wrote:
> On 5/1/06, Robinson, Eric <[EMAIL PROTECTED]> wrote:
> > I ran mysqlcheck against a replication master database and it reported a
> > problem with a table, which it correct
My Sincere apologies, I intented to mean mysqlcheck but somehow came
out as myisamchk :)
Kishore Jalleda
On 5/2/06, Marciano <[EMAIL PROTECTED]> wrote:
How myisamchk can write to binlog if the server need to be down?
- Mensagem Original
De: "Kishore Jalle
Yes
On 5/1/06, Robinson, Eric <[EMAIL PROTECTED]> wrote:
I ran mysqlcheck, not myisamchk or REPAIR. Is what you said still true?
-Original Message-
From: Kishore Jalleda [mailto:[EMAIL PROTECTED]
Sent: Monday, May 01, 2006 1:56 PM
To: Robinson, Eric
Cc: mysql@lists.mysql.com
S
cial on the slave...
Kishore Jalleda
http://kjalleda.googlepages.com/projects
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
-
How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call
rates.
As I said earlier you will need the Mysql-Max Binary for the FEDERATED
engine to work, you can get what version you are running by logging into
mysql via the CLI, or with a SHOW VERSION();
Kishore Jalleda
r2 run
directly on it or is itpart of a replicated query from server1. This came to
my mind as u mentioned the two servers are geographically seperated ..
Kishore Jalleda
http://kjalleda.googlepages.com/projects
rse the output of
"show full processlist", get all the connections from a specific client IP,
and KILL them ...
Hope this helps
Kishore Jalleda
http://kjalleda.googlepages.com/projects
need the MySQL-Max Binary distribution for the engine..
http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html
Kishore Jalleda
http://kjalleda.googlepages.com/projects
t; To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
You can avoid duplicate rows with only one primary key, unless you have a
specific reason for having your primary key span on four columns.
Your query being slower depends on how you have indexed your columns
relati
= db_name.tbl_name
db_name
Kishore Jalleda
http://kjalleda.googlepages.com/
On 4/25/06, Philippe Poelvoorde <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I've read the manual, but it seems there is not the option I'm looking
> for.
> I would like to dump al
see, but
i guess one can live with it, just for the fact that mytop is so cool ...
Also just play with the code yourself, I might have missed something.
Kishore Jalleda
http://kjalleda.googlepages.com/projects
On 4/17/06, Mohammed Abdul Azeem <[EMAIL PROTECTED]> wrote:
>
> Hi,
It can also occur if the client connection was idle for longer than
wait_timeout, and the client has therefore exited ( may be the connection
was invoked from a script, and the script does not know how to connect again
)
Kishore Jalleda
http://kjalleda.googlepages.com/projects
On 4/9/06, Martin
2.2 Opterons with
12 gigs of ram. With that in mind how many mysql sessions can I be able to
support?
refer to http://kjalleda.googlepages.com/maxconnbymysql to calculate this
value
I would also advice you to have some kind of Failover or High Availabilty in
place for Mysql.
Box.
Kishore Jalleda
http://kjalleda.googlepages.com/projects
On 4/8/06, Yves Goergen <[EMAIL PROTECTED]> wrote:
>
> On 04.04.2006 23:17 (+0100), Eric Braswell wrote:
> > my.cnf:
> >
> > bind-address =
> >
> > Will probably do the trick.
>
> How can
You need to issue "FLUSH PRIVILEGES" or you must "RELOAD" Mysql for the
changes to come into effect after you have changed your settings ....
Kishore Jalleda
http://kjalleda.googlepages.com/
On 4/4/06, NanFei Wang <[EMAIL PROTECTED]> wrote:
>
> Hi,
> I want
I don't see anything abnormal in your show processlist, yes you can change
the max_connections global setting from the mysql CLI, but for it to survive
restarts/reboots it has to be defined in the my.cnf file ( I guess its
my.ini for windows) .....
Kishore Jalleda
http://kjalleda.googlepage
the
doc on mysql for the upgrade
http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html
http://dev.mysql.com/doc/refman/4.1/en/upgrading-to-arch.html
Kishore Jalleda
http://kjalleda.googlepages.com
On 4/3/06, murat . <[EMAIL PROTECTED]> wrote:
>
> Dear Sir,
>
> I h
;server1' identified by 'password'
That would solve it ...
You also asked
if port forwarded connections are really taken as local
> connections???
in this case a connection on server1 was port forwarded to server2 , so
server2 does not see this connection a
,
and it will happily run.
like this below
#mysqldump ... | mysql -u -p
Kishore Jalleda
http://kjalleda.googlepages.com/projects
On 4/1/06, Anton Statutov <[EMAIL PROTECTED]> wrote:
>
> On FreeBSD 5.3. MySQL 4.1.15 unix pipeline like "mysqldump ... | mysql
> ...&q
I am not sure if you can do this from the Mysql CLI, but a better way of
doing this would be to use an external script like PHP, PERL, BASH,
etc as they have a better way of error checking againest Mysql.
Kishore Jalleda
http://kjalleda.googlepages.com/projects
On 4/3/06, C.R.Vegelin <[EM
time..., also check SHOW FULL PROCESSLIST to see what state the query's are
in .....
Kishore Jalleda
http://kjalleda.googlepages.com/projects
On 3/29/06, Jacob, Raymond A Jr <[EMAIL PROTECTED]> wrote:
>
>
> After a 23days of running mysql, I have a 3GB database. When I
Just checking if this user has "RELOAD PRIVILEGES", as it is needed for the
--master-data option which is automatically enabled with
--delete-master-logs , does the error duplicate on subsequent attempts ??
Kishore Jalleda
http://kjalleda.googlepages.com/projects
On 3/31/06, Co
rebuild the table from a working/clean backup and start-over, if this is a
slave then thats very easy to do, if not it depends on your latest clean
backup available ..
Just my 2c
Kishore Jalleda
On 3/29/06, Sander Smeenk <[EMAIL PROTECTED]> wrote:
>
> Hello!
>
> I'm hav
unless it really
demands , in the worst case as Barry said its lot easier to shut down the
master (if you can afford some downtime) take a complete
snapshot/backup/dump ( varies for MYISAM and INNODB) and bring back the
failed server back online
Hope this helps
Kishore Jalleda
On 3/28/06, 古雷
"wait_timeout" setting would leave the connection/thread open for the
defined time even after the query has been executed..
Kishore Jalleda
On 3/22/06, Cory at SkyVantage <[EMAIL PROTECTED]> wrote:
>
> Is there anything I can put into the my.cnf file to buffer connectio
did u try restarting mysqld
Kishore Jalleda
On 3/14/06, Jon Miller <[EMAIL PROTECTED]> wrote:
>
> Is there a way to recreate the mysqld.sock file, it has gone missing from
> :/var/run/mysqld . Now MySQL will not run.
>
>
> Thanks
>
> Jon L. Miller, ASE, C
down for variables auto_increment_*)
Kishore Jalleda
On 3/13/06, Jeff <[EMAIL PROTECTED]> wrote:
>
> All,
>
> We are using circular replication now on db's that were originally stand
> alone. One problem we have is that all the primary index fields for
> most of
et
wait_timeout to a value that best fits your needs
Hope this clarifies your question ......
Kishore Jalleda
On 3/10/06, fbsd_user <[EMAIL PROTECTED]> wrote:
>
> In my reading of mysql tutorials I see many examples of mysql access
> with out first doing a connect. Comments
as you know mysql gives you an error to check your sql syntax when it
doesn't understand a query but does not log it , but you can have your
application (php, perl, etc ) accessing mysql to log any bad/malformed
queries...
Kishore Jalleda
On 3/10/06, ryan lwf <[EMAIL PROTECTED]> w
set the key buffer
size approx to that, so that all your keys are in memory also you can check
your key efficiency using mytop to make any changes...
Kishore Jalleda
On 3/9/06, Denis Solovyov <[EMAIL PROTECTED]> wrote:
>
>
> Please explain to me how mysqld's "key buffer
could you tell us if these 6 are in a cluster or in a replication set up,
and u also said the 3 linux bixes all crash at once, did u check the logs,
do they crash under load, what about the OS, is it stable when mysql
crashes
Kishore Jalleda
On 3/8/06, Dave Pullin <[EMAIL PROTECTED]>
to make the task easier.
---Also my soultion may not be any better than what you are doing currently,
except for the time saved in the rsync process instead of copying the whole
data folder to the slave ..
Hope this helps , just my 2 cents
Kishore Jalleda
On 3/7/06, Michael Jeung <[EM
tions to choose from...
Kishore Jalleda
On 3/8/06, Karl Schock <[EMAIL PROTECTED]> wrote:
>
> Am Mittwoch, den 08.03.2006, 12:22 +0200 schrieb Gabriel PREDA:
>
> Hello Gabriel,
>
> > mytop measures the overall performance of the server... it's not
> daatabase
> >
an "rsync" with the right options from the unaffected slave to the corrupt
one might prove to be an elegant technique
Kishore Jalleda
On 3/7/06, Michael Jeung <[EMAIL PROTECTED]> wrote:
>
> Hi Folks,
>
> We've got a Single Master/Multiple Slave environment.
>
May be the mysqld server has exceeded max-connections, and is therefore not
able to serve any clients ( but you should have a log for that), is this
your server, and does this happen at peak times, and what happens after the
circle, mysqld just dies
Kishore Jalleda
On 3/7/06, Karl Schock
am no SQL guru so can somebody kindly help me to optimize this query so
that it could run faster , as during peak times this slows the DB down a
lot..
Kishore Jalleda
did u start mysql with --skip-name-resolve ???
Kishore Jalleda
On 2/16/06, Ryan Stille <[EMAIL PROTECTED]> wrote:
>
> I am trying to connect to my MySQL 4.x server from a new machine. I am
> getting this error:
>
> Got error: 1045: Access denied for user 'user'@&
look to be the same (guessing replication threads), I am not a
mysql guru but these look pretty normal to me and nothing to worry about
....
Kishore Jalleda
On 2/8/06, Logg, Connie A. <[EMAIL PROTECTED]> wrote:
>
> Netstat -a shows the following:
>
> tcp0 0 iepm
-check your network configuration as this issue is most
likely a TCP/IP address bind problem
try an #lsof to see any open files floating around related to mysql
Kishore Jalleda
On 2/8/06, Michael Satterwhite <[EMAIL PROTECTED]> wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: S
if nothing works ...
Kishore Jalleda
On 2/8/06, Michael Satterwhite <[EMAIL PROTECTED]> wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> I use a local MySQL server (we're using 4.0) for development. It's been
> running cleanly for months -
report http://dev.mysql.com/doc/refman/5.0/en/replication-bugs.html
hope this helps .
Kishore Jalleda
On 2/8/06, Jan Kirchhoff <[EMAIL PROTECTED]> wrote:
>
> Kishore Jalleda schrieb:
> > Hi you may be having issues with the byte order on the opetron's and the
&g
e accessing the cluster's SQL nodes.
http://mysql.osuosl.org/doc/refman/5.0/en/mysql-cluster-limitations.html
So make sure both the opetron's and P4's are running with the same byte
order
Kishore Jalleda
On 2/7/06, Jan Kirchhoff <[EMAIL PROTECTED]> wrote:
>
> A neveren
, the 'show
processlist' only lists all the threads currently running..
JFYI
Socket: an end point for communication ( IP & Port)
Thread: quite similar to a process , a process can have multiple threads
....
Kishore Jalleda
On 2/1/06, Logg, Connie A. <[EMAIL PROTECTED]> wrote:
&
key checks for
the duration of the import session...
you could also may be tune your blk_insert_buffer_size
Kishore Jalleda
On 1/31/06, Vinay <[EMAIL PROTECTED]> wrote:
>
> I am using mysql5.0 on Hp-UX. IT took about 14 hours to insert 1.7 millin
> records. How do I mak
may be a good option, but you can also use
replication and have multiple slaves and distribute the load, if you
have the resources to do that ..
Kishore Jalleda
On 1/27/06, Jan Kirchhoff <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Did anybody ever benchmark heap-tables against a clus
ed on
max_connections, it will use/release RAM based on the current
connections
Kishore Jalleda
On 1/25/06, Asad Habib <[EMAIL PROTECTED]> wrote:
> Are there any statistics that I can use to determine how high or low I
> should set max_connections? I am using MySQL as the backend for a Java
, read_buffer_size to like 500K instead of the
default 2M
Kishore Jalleda
On 1/4/06, Jonathan Chong <[EMAIL PROTECTED]> wrote:
> Hi Alex
>
> There are over a hundred tables for the site, and those that are
> related to this query are probably about 15-30. Do you want the CREATE
That was an excellent reply, I always see you helping so many people, keep
the great work going ..
Sincerely,
Kishore Jalleda
On 10/13/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
>
> Kishore Jalleda <[EMAIL PROTECTED]> wrote on 10/13/2005 02:25:52 PM:
>
>
index on the columns valid
and sessiontype
id select_type table type possible_keys key key_len ref rows Extra 1
SIMPLE gamesessions ref valid_sess valid_sess 1 const 55003 Using where;
Using temporary; Using filesort
Can this be optimized to run faster
Appreciate your time
Kishore Jalleda
Using where
Thanks for the help
Kishore Jalleda
use a variable called max_connections( if its not there in my.cnf just add
it ) and restart mysql
eg . max_connections = 100
Kishore Jalleda
On 9/27/05, Octavian Rasnita <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I guess it is a stupid simple question:
>
> I have seen the fo
error number: 3
The permissions on the /tmp have not changed and are set properly, the user
mysql can create large files in the /tmp directory ( checked after su to
mysql ) , I tried to increase the sort_buffer_size to 1M from 0.5M,
surprisingly everything else works fine, did any of you guys have s
-4.1.14. mysql
start mysqld /usr/local/mysql/bin/mysqld_safe &
thats it you have version 4.1.14 running you can keep the old directory or
delete it
Kishore Jalleda
On 9/18/05, Joeffrey Betita <[EMAIL PROTECTED]> wrote:
>
> hi
> how can i uninstall mysql-standard-
doing reverse DNS lookups ..
Thanks
Kishore Jalleda
On 9/16/05, Chris Allen <[EMAIL PROTECTED]> wrote:
>
> I don't know if this is relevant to you - but I had exactly
> the same experience when upgrading to MySQL v4.1. It turned out
> that MySQL was trying to do rev
behaviour at startup( I am aware
that once the server is back online it is flooded with requests), the OS is
Redhat 7.3, the server currently does 200-400 qps quiet comfortably .
Any help would be appreciated, let me know if you need more info
Kishore Jalleda
long, also while mysql is waiting for a long
query( in the Writing to Net status) hundreds of other queries are
executed extrelmely fast.
I am not very familiar with how mysql handles network packets, and why
its holding back ...
Any help would be appreciated ..
Kishore Jalleda
--
MySQL
check the permissions on the mysql data dir, may be the user mysql or
who ever runs mysql does not have sufficient privileges
Kishore Jalleda
On 8/19/05, John Gonzales <[EMAIL PROTECTED]> wrote:
> i am creating my own little blog and i am trying to create a comments table
> that uses
as per
http://dev.mysql.com/doc/mysql/en/replication-compatibility.html
there should be no problems
Kishore Jalleda
On 8/17/05, Jeff <[EMAIL PROTECTED]> wrote:
> Does anyone know if there are any problems replicating from a master
> database on version 4.0.16 to a slave run
l for diagnosis, also see the slow query log, play around
with top and other OS tools, this should work if not switch to INNODB
Kishore Jalleda
On 8/11/05, Aaron <[EMAIL PROTECTED]> wrote:
> Hi all ,
>
> I have been experiencing intermittent locking issues with MYSQL. It
> appears that
full process list shows
that other queries are running just fine, infact in the time that this
query is running many similar queries are excecuted very fast
Thanks
Kishore Jalleda
On 8/9/05, Mike Wexler <[EMAIL PROTECTED]> wrote:
> Kishore Jalleda wrote:
>
> Try two things. Firs
ratio
for Created_tmp_disk_tables/Created_tmp_tables is close to 0.1, could
this be a reason, why is Mysql creating soo many temp tables on the
disk
Thanks a lot and any help would be appreciated ..
Kishore Jalleda
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Hi All,
I have a mysql query which takes 8 seconds to run ona dual
xeon 2.4, 3Gig ram box,
SELECT gamename, MAX(score) AS score, COUNT(valid=1) AS played FROM
gamesessions AS gamesessions
WHERE valid=1 AND sessiontype IN (1,2)
GROUP BY gamename;
Explain sel
u might want to check the permissions in the data directory, may be
the user under which mysql runs does not have the proper permissions
on the databases..
Kishore Jalleda
On 6/24/05, Ron Day <[EMAIL PROTECTED]> wrote:
> After I installed mysql 4.0.18 on Windows XP I could not use it
's of mysql...
http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html
Hope this helps,
Kishore Jalleda
On 6/24/05, mm <[EMAIL PROTECTED]> wrote:
>
> I have on my system, Fedora core 3, MySql 3.23.58
> Working with wikipedia database I get one error an one advise to upgrad
write_buffer = 2M
Key_Buffer* is always global, I guess in this case( myisamchk)
sort_buffer is also global , also you have couple of chapters which
might interest you from that book online at
http://dev.mysql.com/books/hpmysql-excerpts/ch06.html
http://dev.mysql.com/books/hpmysql-excerpts/ch07.html
Kish
_pool
innodb_log_buffer
innodb_additional_mem_pool
net_buffer
Hope thsi helps
Kishore Jalleda
On 6/23/05, erin oneill <[EMAIL PROTECTED]> wrote:
> I'm working on fine tuning the Server Parameters for a
> machine (with 2 GB of RAM). The database has a fair
> number of tables. Many
these users with:
SELECT * FROM mysql.user WHERE LEN(password) > 16;
http://dev.mysql.com/doc/mysql/en/password-hashing.html
Hope this helps
Kishore Jalleda
On 6/23/05, Elizabeth Bonifacio <[EMAIL PROTECTED]> wrote:
> Dear All,
>
> I'm new into mysql
if you are accessing mysql server using phpmyadmin
(http://sourceforge.net/projects/phpmyadmin/), then you have an option
to export the databases in many formats, I guess this should work in
your case...
Kishore Jalleda
On 6/21/05, Alex Aris <[EMAIL PROTECTED]> wrote:
> How do back
It is recommended that you upgrade to 4.0.x first from 3.23.xx,
because of any changes to the grant tables in the mysql database, make
sure you read the upgrade notes before upggrading, here's a good link
to upgrade,
http://dev.mysql.com/doc/mysql/en/upgrade.html
I find it very simple to zip all
Hi All,
Has anybody implemented Load Balancing Mysql with Foundry
Load Balancers, I know that the ServerIron series switches dont have a
way to do a Layer 7 health check for mysql, as it is not a default
port profile, any help from who has dome some work on foundry switches
would be grea
93 matches
Mail list logo