Good day all
I hope someone can assist me with this.
While doing the normal routine daily health checks on one of
our clients' servers I came across some strange behaviour from the slave
server. (two servers setup in master / slave replication)
Hi All
Just one other note on this issue experienced.
I used google to try and find some solutions / clues and all the
suggestions are to increase the innodb buffer pool size.
This was however recently done on the database to increase this to
4Gb already.
MySQL University: New features in Connector/NET 6.3
http://forge.mysql.com/wiki/New_Features_in_Connector/NET_6.3
This Thursday (June 3rd, 14:00 UTC), Reggie Burnett, head of
Connector/NET development, will present the New Features in
Connector/NET 6.3.
For MySQL University sessions, point your
Hi all,
do you guys know how to deal with the large tables?
here's my problem:
I have two web servers( running Nginx ) , two DB servers( running MySQL 5.1.35
) and a server for load balancing.
What I'm maintaining is a game data tracking system. There's a game_log table
which will record
Hi,
Can you please send us the query along with the explain .
Also , have u thought of partitioning the data.
regards
anandkl
2010/6/2 曹凯 tx...@hotmail.com
Hi all,
do you guys know how to deal with the large tables?
here's my problem:
I have two web servers( running Nginx ) , two DB
给我看看你的表的索引及你的慢查询的sql语句
在 2010-6-2,下午5:08, 曹凯 写道:
Hi all,
do you guys know how to deal with the large tables?
here's my problem:
I have two web servers( running Nginx ) , two DB servers( running MySQL
5.1.35 ) and a server for load balancing.
What I'm maintaining is a game data
hi huys,
here's the explain of a query on this table
EXPLAIN SELECT COUNT(game_log_id) AS sum2 FROM game_log AS g, player AS p WHERE
g.player_id = p.player_id AND g.game_id=p.game_id=27 AND p.type=1 AND
g.event_id = 32
- ;
Dear Venugopal,Here's theSample Java Code Which Calls
stored procedure :-//get the connection to databaseConnection dbConnection = getConnection();//create the call
for procedureString procedureCallStmtStr = "Call XYZ()";//create callable statement objectCallableStatement cs =
Hi,
MySQL Partitioning will help you a lot.
Try it.
Regards,
Krishna
2010/6/2 曹凯 tx...@hotmail.com
Hi all,
do you guys know how to deal with the large tables?
here's my problem:
I have two web servers( running Nginx ) , two DB servers( running MySQL
5.1.35 ) and a server for load
-Original Message-
From: machiel.richards [mailto:machiel.richa...@gmail.com]
Sent: Wednesday, June 02, 2010 3:56 AM
To: mysql@lists.mysql.com
Subject: RE: Strange errors / messages on slave server
Hi All
Just one other note on this issue experienced.
I used google to try
Thank you for the response...
My question now is, will I be able to set the innodb buffer pool size for
the slave server to be the same as the master server?
If so, can I only restart the slave server and keep the master server
running in order to cancel out the requirement for downtime?
On
In less technical terms, if the master goes faster than the slave, the slave
will puke.
MGthen the master will have to teach the slave
MGis the master the entrenched bureacucrat or is that the slave?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Just a note from a kibitzer: if you include an EXPLAIN, why not use \G so that
it is easier to read?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
-Original Message-
From: ??
Depending on your mysql version and environment, another solution might be
to switch to row-based binlogs. Make sure to read the documentation
thoroughly, though - there's a number of caveats.
On Wed, Jun 2, 2010 at 2:55 PM, Martin Gainty mgai...@hotmail.com wrote:
In less technical terms,
*hi*
*
*
*i have a reporting query which have 2 long sub-query*
SELECT r1.code_centre, r1.libelle_centre, r1.id_equipe, r1.equipe,
r1.id_file_attente,
r1.libelle_file_attente,r1.id_date, r1.tranche,
r1.id_granularite_de_periode,r1.granularite,
r1.ContactsTraites, r1.ContactsenParcage,
On Wed, Jun 2, 2010 at 10:28 AM, Lin Chun franks1...@gmail.com wrote:
*don't know it very clear, but i think is the problem of derived seems it
take full scaning*
Yes, it has no indexes so it isn't good for very large subqueries.
You should create them as temporary tables instead and give them
Perhaps someone has already accomplished this:
I have a simple table with 3 columns:
mytable(
myid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
myunixtime INT(11) NOT NULL DEFAULT 0,
myvalue BIGINT(20) UNSIGNED NOT NULL DEFAULT 0
)
It is collecting millions of rows.
The myunixtime column is a
MySQL doesn't support dynamic distribution of data among partitions. The usual
method is to create a partition for each fixed chunk of time, such as for each
month/week/hour/day or whatever time slice breaks your data up in the
manageable pieces. Note that a very large number of partitions (
I've heard that sub-queries aren't well-optimized, but this case seems
ridiculous.
First, a little setup:
SELECT pub_id FROM pub WHERE pub_code = 'GD' INTO @P;
=== Inner Query by Itself ===
us-gii SELECT prod_pub_prod_id FROM prod
- WHERE pub_id = @P
- AND prod_discont = 0
- GROUP
Hi,
I'd like to know if MySQL server supports http queries?
Thanks.
Kandy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
After a recent hard drive kerfluffle and the results of fsck, I'm left
with a slew of jumbled database files. The file command can tell me
the file types, like so:
#15901614: MySQL table definition file Version 10
#15901615: MySQL MISAM compressed data file Version 1
#15901617: MySQL table
MySQL is a tradition Relational DataBase System. It underlays
something like 80% (somebody correct me if I'm out-of-date here) of
the http applications populating the internet. While some RDBMSs
offer extensions for RESP-like HTTP implementations, MySQL does not
support this directly. It can be
22 matches
Mail list logo