MySQL Performance - www.mysqlperformanceblog.com | Site profile
|
|
 |
Atom |
RSS
|
|
Site profile page for http://www.mysqlperformanceblog.com.
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.mysqlperformanceblog.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.mysqlperformanceblog.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.
|
|
|
|
|
Posting activity table on MySQL Performance:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
19
|
82
|
241
|
|
Post:
|
25
|
122
|
347
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for MySQL Performance (http://www.mysqlperformanceblog.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 Performance posting activity graph:
|
|
http://www.mysqlperformanceblog.com Alexa graph:
|
Top authors on MySQL Performance during last week:
|
Name
|
Posts
|
|
debug
|
4
|
|
vgatto
|
3
|
|
ileh
|
3
|
|
bilboa
|
2
|
|
mdelatorre
|
2
|
|
newtomysql
|
2
|
|
mhnatiuk
|
2
|
|
mindfever
|
1
|
|
vetrib2w
|
1
|
|
admini
|
1
|
|
|
|
Top 10 active forums on MySQL Performance during last week:
|
|
Top 10 forums on MySQL Performance:
|
|
|
Latest active threads on MySQL Performance:
Started 2 days, 10 hours ago (2008-09-05 18:45:00)
by ylibrach
I am currently implementing a system that interfaces between retailers and wholesalers and needs to have logging capabilities. Problem is that there will be roughly 20,000 retailers accessing about 300 wholesalers. Obviously, a row will need to be entered into the table for each retailer accessing each wholesaler (or a potential 20,000 x 300 = 6,000,000 rows). Problem is that I need ... 
Started 7 months ago (2008-02-06 06:47:00)
by ilys
Hi, When will come new microslow patch for mysql-5.0.54? Report message to a moderator
Started 3 days, 20 hours ago (2008-09-04 08:49:00)
by sterma
hi guys, does it make sense to flush all open tables in scheduled times? (maybe crontab) the reason: our database got much statements from our CMS portal every 10min. the open_tables value (512) inreases very fast in a few days finally until to the limit. so mysql starting to use tmp. tables. I understand the mysql "open_table_cache" as follows: mysql try to hold tables ...
Started 1 week ago (2008-08-31 20:58:00)
by mdelatorre
I am using Ubuntu Server 8.04 and I will like to do some tunning to my MySQL database, but before I will like to get a descent benchmark tool. What options do I have? Thanks. Manuel. Report message to a moderator
Started 6 days, 13 hours ago (2008-09-01 16:22:00)
by bilboa
Hi, I didn't really find similar cases: I have 2 tables (in 2 different databases, if that makes a difference). These tables have an equal number of fields, named the same, eg: db1.table1: id, name, info1, info2 db2.table1: id, name, info1, info2 I need to match every field of every column with the other's table column. I need to find out which field is equal to ...
Started 1 week, 1 day ago (2008-08-30 13:56:00)
by newtomysql
Dear All, I am currently using the . net connector. So I would like to run distributed transaction meaning that I need to commit multiple database at one gone. Can .net connector support distributed transaction? Thanks. Report message to a moderator
Started 1 week, 1 day ago (2008-08-30 13:04:00)
by vetrib2w
hi, I need to know 1. How to create new user in mysql (im using WAMP )? 2. How to change username ? 3. Can i hide my databases for other user..... guide me plz.... thanks in advance............... Report message to a moderator
Started 6 days, 1 hour ago (2008-09-02 03:55:00)
by mindfever
Hi, I have a MySQL 4.1 database that has a number of tables. All up the tables and indexes take up 1.3 gig, but I have one table in there "user_events" that takes up 1.1 gig. This "user_events" table is an InnoDB table that records events that users do, so is mostly used to write new entries into and ocasionally is used to get a list of recent events for a user. Ideally I'd like...
Started 6 days, 8 hours ago (2008-09-01 20:57:00)
by tom123
Hi all! I'm new to this cool forum I have a DELL PowerEdge 1950, 2x 146GB SAS 15k RPM in hardware Raid1 and 4GB ram. This server is a mysql server only. Not other services on it. I have a database with an innodb table of more than 1.800.000 records growing up quickly and I have a website that has more than 1.500.000 page views per day. Each page view does a select on the ...
Started 1 week ago (2008-08-31 16:35:00)
by ileh
Hi, I have a few big tables but only a small portion is normally used for selects. However, it takes a long time to make the initial selects until the data is cached into memory (query cache or some other memory cache). I noticed that MySQL creates 1 file per table, I feel this is quite bad for performance? Is there any way to either move the most used rows into the start of the...
|
|
Hot threads for last week on MySQL Performance:
Started 1 week ago (2008-08-31 16:35:00)
by ileh
Hi, I have a few big tables but only a small portion is normally used for selects. However, it takes a long time to make the initial selects until the data is cached into memory (query cache or some other memory cache). I noticed that MySQL creates 1 file per table, I feel this is quite bad for performance? Is there any way to either move the most used rows into the start of the...
Started 1 week ago (2008-08-31 20:58:00)
by mdelatorre
I am using Ubuntu Server 8.04 and I will like to do some tunning to my MySQL database, but before I will like to get a descent benchmark tool. What options do I have? Thanks. Manuel. Report message to a moderator
Started 6 days, 13 hours ago (2008-09-01 16:22:00)
by bilboa
Hi, I didn't really find similar cases: I have 2 tables (in 2 different databases, if that makes a difference). These tables have an equal number of fields, named the same, eg: db1.table1: id, name, info1, info2 db2.table1: id, name, info1, info2 I need to match every field of every column with the other's table column. I need to find out which field is equal to ...
Started 1 week, 1 day ago (2008-08-30 13:56:00)
by newtomysql
Dear All, I am currently using the . net connector. So I would like to run distributed transaction meaning that I need to commit multiple database at one gone. Can .net connector support distributed transaction? Thanks. Report message to a moderator
Started 1 week, 1 day ago (2008-08-30 16:22:00)
by mhnatiuk
Hi, i have 3 tables from which i want to extract values to third table. im doing this using perl since I've no idea how to join all these queries into one. i want to extract user information from these three tables. The problem im experiencing concerns lines: count(posts.id) and count(comments.id) -> i want to query for information how many comments every blog has received and how many posts...
Started 1 week, 1 day ago (2008-08-30 13:04:00)
by vetrib2w
hi, I need to know 1. How to create new user in mysql (im using WAMP )? 2. How to change username ? 3. Can i hide my databases for other user..... guide me plz.... thanks in advance............... Report message to a moderator
Started 6 days, 8 hours ago (2008-09-01 20:57:00)
by tom123
Hi all! I'm new to this cool forum I have a DELL PowerEdge 1950, 2x 146GB SAS 15k RPM in hardware Raid1 and 4GB ram. This server is a mysql server only. Not other services on it. I have a database with an innodb table of more than 1.800.000 records growing up quickly and I have a website that has more than 1.500.000 page views per day. Each page view does a select on the ...
Started 1 week ago (2008-08-31 12:03:00)
by admini
my system: - MySQL Connector.NET 5.2, ASP.net 2 on Windows 2003 / IIS6 - MySQL 5.0.20 on Debian MySQL server has 2 Dual-Core CPUs, I thing 3GHz, 4GB RAM. I have a 2M rows table, with an ~500K rows/month. table: DROP TABLE IF EXISTS `a7`.`pb_im`; CREATE TABLE `a7`.`pb_im` ( `m_id` int(11) NOT NULL auto_increment, `m_date` bigint(14) NOT NULL, `m_from` int(...
Started 6 days, 1 hour ago (2008-09-02 03:55:00)
by mindfever
Hi, I have a MySQL 4.1 database that has a number of tables. All up the tables and indexes take up 1.3 gig, but I have one table in there "user_events" that takes up 1.1 gig. This "user_events" table is an InnoDB table that records events that users do, so is mostly used to write new entries into and ocasionally is used to get a list of recent events for a user. Ideally I'd like...
Started 7 months ago (2008-02-06 06:47:00)
by ilys
Hi, When will come new microslow patch for mysql-5.0.54? Report message to a moderator
|
|
![Customize "About 20 million rows, should I be worried? [message #3503] :: MySQL :: MySQL Performance"](/images/cust_r0.gif "Customize \"About 20 million rows, should I be worried? [message #3503] :: MySQL :: MySQL Performance\""){kind=small}