Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - artmedia

Pages: [1] 2 3
1
Discussion & Troubleshooting / Re: My site is down, help please!
« on: April 14, 2009, 05:29:34 PM »
By the way, I have these red information on my database Runtime Information: (I'm not a database expert, that's why I'll almost don't understand anything...)

Slow_queries     644      The number of queries that have taken more than long_query_time seconds.Documentation
Innodb_buffer_pool_reads     2,549     The number of logical reads that InnoDB could not satisfy from buffer pool and had to do a single-page read.
Innodb_log_waits     1     The number of waits we had because log buffer was too small and we had to wait for it to be flushed before continuing.
Innodb_row_lock_time_avg     18      The average time to acquire a row lock, in milliseconds.
Innodb_row_lock_waits     3      The number of times a row lock had to be waited for.
Handler_read_rnd     1,699 M     The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
Handler_read_rnd_next    1,029 M    The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.
Created_tmp_disk_tables     880 k     The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based.
Select_full_join     107 k     The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables.
Sort_merge_passes     3     The number of merge passes the sort algorithm has had to do. If this value is large, you should consider increasing the value of the sort_buffer_size system variable.
Opened_tables     74 k     The number of tables that have been opened. If opened tables is big, your table cache value is probably too small.
Table_locks_waited     53 k     The number of times that a table lock could not be acquired immediately and a wait was needed. If this is high, and you have performance problems, you should first optimize your queries, and then either split your table or tables or use replication. 

3
Discussion & Troubleshooting / Re: My site is down, help please!
« on: April 14, 2009, 05:15:32 PM »
V@no, atfer change the random values, they send me this email:

Hello,

We are still seeing the issue, though not as bad as it was before.  The database ticasc5_imga1 has queries copying to the tmp table, and executing for longer than they should be.  A normal MySQL query should take less than 2 seconds to execute, and most of yours are taking 5-20 seconds meaning that your database may be lacking optimization.  Adding indexes on search-able fields should help with this.


I have optimized every table throught phphmyadmin, but about indexes for search-able fields, is this gallery using that? It's to difficult create them?

Thanks for your help,

Note: can you suggest contact some programmer that created this gallery (the queries and DB part) in order to get some information?

4
it has to be this query

SELECT DISTINCT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords |

now, i don't know where is it, i'll remove it

5
Discussion & Troubleshooting / Re: Mysql Script High Load
« on: April 13, 2009, 06:50:29 PM »
remove random images

6
Discussion & Troubleshooting / Re: High server CPU use per request
« on: April 13, 2009, 06:49:49 PM »
random images

7
Discussion & Troubleshooting / Re: 4images 1.7.6 and server load
« on: April 13, 2009, 06:49:14 PM »
remove that random images

8
Discussion & Troubleshooting / Re: My site is down, help please!
« on: April 09, 2009, 07:06:54 PM »
vano, thank you so much, i have made that modification, now i have to wait the hosting answer, anyway where is executed that query? in what pages or sections? i think it was home, but now i have

define('SHOW_RANDOM_IMAGE', 0);
define('SHOW_RANDOM_CAT_IMAGE', 0);

and i still having the random for category in home page, kind of weird...

Is there any other query taking high processing in this gallery application?

i have around 2000 visitors per day, it this normal for this gallery?

Thanks again.

9
Discussion & Troubleshooting / My site is down, help please!
« on: April 09, 2009, 09:20:32 AM »
Hi, my site www.ticas.cr is down, i have received this email from hosting company, but I have moved to this one bcz the previous hosting was down too, now i don't know what to fix, seem it is a problem on my side, any help?

This the email from the hosting:

System administration has been tracking higher resource usage on the machine housing your account, and has traced some of these issues to longer running mysql queries related to your account.

Unfortunately, at this time it is not clear exactly what on your site is causing these issues, but we do need you to see if you can reduce the burden these queries cause on the server.

In the shared system, most queries should complete through the server in less than a second.  Some of the queries related to your account take a good deal longer than this to complete, and seem to be the source of some latency we are seeing in server response.

Here are examples of such queries:

| 389163 | ticasc5_imga1 | localhost | ticasc5_Hi5 | Query   | 0    | Copying to tmp table | SELECT DISTINCT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords |

In order to maintain stability and responsiveness in the shared environment, you will need to review the site to see if you can make any changes that can better the efficiency of these queries.

Thank you in advance for your cooperation, and feel free to let us know if you have any further questions or if we can be of assistance.

Best Regards,

Marco
InMotion Hosting
System Administration 

10
Chit Chat / Re: 4homepages website Top 10 Rated
« on: December 03, 2008, 11:23:37 PM »
Somebody knows who is on charge of 4homepages top sites page? http://www.4homepages.de/resources/Ratings/ Because I checked every date the ranking because I used to have two sites there, but now one of them has been deleted www.ticas.cr and the other one has been underrated www.ticas.co.cr (I always keep the 4homepages copyright information and everything), and non existing sites in that list have been overrated with more votes and ranking irregularly. this is really unfair and irregular, who can help me?

Thanks.


I think you little bit misunderstand what top10 is mean. Keeping all copyright information does n have anything to do with that. Today somebody like your site tomorrow not and its same with rating, personally I dont like your site and my rating would be 1 and really I dont see any reason why your site "must" be in TOP10. You dindt change anything on it and this top is for gallery not for photos what you upload in it.

Well, i'll be more clear, I give you this example:

Yesterday my site had 186 votes, but today it has just 88 votes, it doesn't matter if you vote 1 to my site, i will have at any case 186+1 votes = 187 votes, there is no reason to have the altered 88. The problem here is not that my site likes or not to somebody, the problem is that person on charge of that list is altering the correct results just to benefit some sites -i guess with less votes-, in this way those sites can be listed on that page of pagerank  5, and to get an important link for google.

Do you get it?

About Vano said, is true too, i have another site that was deleted without reason from "sites in action"

11
Chit Chat / Re: 4homepages website Top 10 Rated
« on: December 01, 2008, 04:48:23 PM »
Sure, i did it one month ago, but no answer yet :(
You can try:
http://www.4homepages.de/kontakt/

12
Chit Chat / 4homepages website Top 10 Rated
« on: November 28, 2008, 04:36:15 PM »
Somebody knows who is on charge of 4homepages top sites page? http://www.4homepages.de/resources/Ratings/ Because I checked every date the ranking because I used to have two sites there, but now one of them has been deleted www.ticas.cr and the other one has been underrated www.ticas.co.cr (I always keep the 4homepages copyright information and everything), and non existing sites in that list have been overrated with more votes and ranking irregularly. this is really unfair and irregular, who can help me?

Thanks.

13
Mods & Plugins (Releases & Support) / Re: [MOD] multiupload
« on: November 19, 2008, 06:13:58 PM »

- download the file from below and copy it to your template folder (of course rename to member_multiuploadform.html)


Sorry, from where? where is the link with the attachments?

14
Thanks V@no, i never thought teaching something to you, i have follow many of your MODs, and yes, this MOD have many issues:

Also I have a few issue to comment:
1) your code have no filter regarding visitor's permissions, which mean visitors might see categories they are not supposed to see.
2) since you don't use 4images built-in database class, its not compatible with integrated 4images or if someone uses non-mysql database.
That's because on my site everyone can see any photo, maybe finishing my first attempt  this can be fixed, someone want to help with code?

3) the code doesn't use template class for links, this will create problem for people using SEO mod
Actually I'm using the SEO mod, people just need to change

Example
<a href=categories.php?cat_id={$row['CAT_ID']}>
for
"<a href=modelos_mujeres_{$row['CAT_ID']}.htm>#" -with correspondig keywords-

This is not the best way, but it works


4) All data for each category is already loaded into $cat_cache array, you don't need query database for that. Because of that each of your database query can be simplified to query 4images_images table only.

Let me research about it

Thanks!

Pages: [1] 2 3