|
More site info...
MySQL AB - MySQL Forums - www.mysql.com | Site profile
|
|
Site profile page for http://www.mysql.com.
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.mysql.com.
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.mysql.com is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.
|
|
Title:
|
 MySQL AB - MySQL Forums
|
|
Url:
|
http://www.mysql.com
|
|
Users activity:
|
0 posts per thread |
|
site activity:
|
0 active threads during last week |
|
Domain info for:
|
mysql.com
|
|
|
|
Posting activity table on MySQL AB - MySQL Forums:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
0
|
0
|
0
|
|
Post:
|
0
|
0
|
0
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for MySQL AB - MySQL Forums (http://www.mysql.com)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
MySQL AB - MySQL Forums posting activity graph:
|
|
http://www.mysql.com Alexa graph:
|
Top authors on MySQL AB - MySQL Forums during last week:
user's latest post:
Re: High load - queries take...
Published (2009-11-06 21:04:00)
This is possibly excessive: innodb_log_file_size = 1500M and may cause hiccups when it is flushing it. To assist in analyzing slow SELECTs, please provide * SHOW CREATE TABLE tbl\G -- engine, indexes -- works better than DESC * SHOW TABLE STATUS LIKE 'tbl'\G -- sizes * EXPLAIN SELECT ...\G -- clues of inefficiencies * SHOW VARIABLES LIKE '%buffer%'; -- cache size * SHOW VARIABLES LIKE 'innodb%'; -- various...
user's latest post:
Re: Pivot
Published (2009-11-06 18:01:00)
Ok ashr, Here it is... But first, let me again say that you should change your table design. This is horrible. It works, but for some reason when I run it more than once with different date ranges, it doesn't work right. If I open a new tab in Query Browser and run it again, it works fine. It may be some kind of caching problem in QB. Or the temporary table isn't being dropped. I have a drop statement in there, but I don't know....
user's latest post:
Multiple events Times
Published (2009-11-06 20:31:00)
what would be the parameters: 1>To launch an event every 20 minutes starting at 9:00am ending at 5:00pm every day. (? how do you define a time without a date) 2>To launch an event based on if statement.... Check if table updated, if table update, do nothing. If not, update. would run at 1 hour interval, between 00:00:00 to 00:00:10. 3>at 5:00pm, dump txt files. Again at 5:00pm, not date but time only.
user's latest post:
Re: Mysql Triggers
Published (2009-11-06 09:00:00)
Triggers cannot modify the same table. That is a trigger restriction. Try to update a table with another way, for example use a stored procedure like this: CREATE PROCEDURE proc_update(IN new_ip VARCHAR(255)) BEGIN DECLARE v VARCHAR(255); -- Get IP name from another table and store it to variable. SELECT ip_name INTO v FROM ip_names WHERE ip = new_ip LIMIT 1; -- Update IP address with name. IF v IS NOT NULL THEN UPDATE ip_addresses SET ip = v...
user's latest post:
Re: Error running mysql-proxy...
Published (2009-10-30 19:20:00)
Not sure if this will help, but you can use the pre-compiled "RHEL4" Proxy binaries on Ubuntu.
user's latest post:
Re: mysql cluster - mysqldump...
Published (2009-11-04 09:41:00)
MySQL error code 136: No more room in index file Show: ndb_mgm> ALL REPORT MemoryUsage shell$> ndb_config --type ndbd -q Id,MaxNoOfOrderedIndexes,MaxNoOfUniqueHashIndexes -r '' You should ensure that you have defined at least as many index slots as is suggested by ndb_size.pl See: http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-programs-ndb-size-pl.html
user's latest post:
Re: mysql cluster - mysqldump...
Published (2009-11-05 12:47:00)
I tried running the script, gave some perl error asking for DBI perl. I downloaded the latest one, does not work. Any idea which version of DBI it needs ? Will try and solve this, meanwhile if you know exactly what is needed, please let me know. Thanks a lot everyone, this forum has really helped achieve a lot with mysql.
user's latest post:
Re: Table or Arrays as...
Published (2009-11-06 13:37:00)
> if we can pass in an array or table as parameter to a stored procedure. No arrays in MySQL, nor is there a table datatype. Pass the name of a table for the sproc to query.
user's latest post:
Re: Performance impact of...
Published (2009-10-31 15:01:00)
All tables are InnoDB, so yes InnoDB is used a lot. Regarding connections: Number of connections is pretty constant, at the current level although it jumps to around 200 during peak hours. thread_cache_size is 8.
|
|
|
Top 10 active forums on MySQL AB - MySQL Forums during last week:
|
|
Top 10 forums on MySQL AB - MySQL Forums:
Stored Procedures
- 4,005 posts
|
Performance
- 2,729 posts
|
Cluster
- 2,279 posts
|
Replication
- 1,863 posts
|
InnoDB
- 1,844 posts
|
Triggers
- 1,055 posts
|
MySQL Proxy
- 1,025 posts
|
Source, Builds, Binaries
- 848 posts
|
Workbench - Newbie
- 739 posts
|
Character Sets, Collation, Unicode
- 712 posts
|
|
|
|
|
Latest active threads on MySQL AB - MySQL Forums:
Started 4 months ago (2009-07-07 02:36:00)
by Giovanni Scopel
Noone has the same problem?
Regards,
JS
Started 2 days, 9 hours ago (2009-11-06 22:27:00)
by Diego Medina
Hi Chris,
Try this one
http://forge.mysql.com/tools/tool.php?id=234
--
Diego Medina, QA Engineer
Enterprise Tools - Database Group, Sun Microsystems
Are you MySQL certified? http://www.mysql.com/certification
Started 3 days, 18 hours ago (2009-11-05 13:26:00)
by Prova Test
>>>>> CONTINUATION >>>>>
mysql> show processlist;
+----------+-----------------+------------------- --------+----------------------+---------+------+- ----------------------------+--------------------- -------------------------------------------------- -------------------------------+
| Id | User | Host | db | Command | Time | State...
Started 2 days, 21 hours ago (2009-11-06 11:15:00)
by m z
Does above make sense to everyone? Let me approach this in a more abstract way:
Given following table structures:
session table
+--------------+------------------+------+- ----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
...
Started 6 days, 19 hours ago (2009-11-02 12:52:00)
by Chad Bourque
ashr,
This link has a section on Pivot tables:
http://www.artfulsoftware.com/infotree/queries.php ?&bw=1108
HTH,
Chad
|
|
Hot threads for last week on MySQL AB - MySQL Forums:
Started 6 days, 19 hours ago (2009-11-02 12:52:00)
by Chad Bourque
ashr,
This link has a section on Pivot tables:
http://www.artfulsoftware.com/infotree/queries.php ?&bw=1108
HTH,
Chad
Started 1 week, 1 day ago (2009-10-31 12:00:00)
by Rick James
The optimizer chooses one of two main ways to fetch data:
* Use an index. This involves then reaching over to the data for each row that the index says might be useful
* Ignore the index; simply scan all the data.
The former is useful when a " small" number of rows are needed. The latter is actually more efficient when "most" of the rows are needed.
I think your "5 days" went ...
Started 1 week, 1 day ago (2009-10-31 11:06:00)
by Rick James
Sounds like it eventually started ok. Is it not running?
Did you free up some disk space? That was the original problem.
You may have lost some replications statements due to the crash.
Started 4 days, 16 hours ago (2009-11-04 15:49:00)
by Rick James
What is the server_id on each machine? Having them the same could lead to 1GB/8 minutes (all the data is in a loop).
Did you have a hard crash?
Started 4 days, 10 hours ago (2009-11-04 21:33:00)
by Eyrique Wong
Hi, i got an table that has about 60k rows of data is inserted DAILY, and the number of insertion is increasing by 1-200 daily.
The table now is very heavy when we are trying to do even some simple query.
And what I'm thinking of doing it is to do partitioning.
Is it possible to do partitioning on a table that already has data?
And how do i do the partitioning? I'm thinking ...
Started 1 week, 1 day ago (2009-10-31 10:19:00)
by Rick James
Executive summary:
* New index
* Increase cache size
* Shrink data
Details...
That particular query would benefit from either of these:
INDEX (client_id, cashin_ind, annual_flag, date_record),
INDEX (client_id, annual_flag, cashin_ind, date_record),
(There is not advantage in having both.) I don't think you can get much better than simply adding one of those.
INDEX ...
Started 6 days, 23 hours ago (2009-11-02 08:59:00)
by sarang. s
Started 6 days, 6 hours ago (2009-11-03 01:20:00)
by Devart Team
There is a variable FOREIGN_KEY_CHECKS that allows to enable/disable foreign key checks.
Examples:
SET FOREIGN_KEY_CHECKS=0;
-- Your code
SET FOREIGN_KEY_CHECKS=1;
Or
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */
-- Your code
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */
Devart Company,
Database development tools...
Started 6 days, 18 hours ago (2009-11-02 13:34:00)
by Sherif Elian
make sure that directory /usr/local/mysql/data exists in the machine you try to run ndbd at
Started 1 week, 1 day ago (2009-10-31 08:44:00)
by Matthew Montgomery
I'd be interested to see what the ndb_3_error.log and ndb_4_error.log look like along with any trace files the nodes generated when they crashed. This will tell us the real cause of the crash and weather it has been fixed in a later version. (7.0.8a)
|
|
Size: 64 bytes
