I have a problem with PDO returns incomplete result. Specific query executed in phpmyadmin returns 6000 rows. Same query executed by PDO returns only first 1160 rows. Seems like some kind of limitation or something. This setting
$pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
did not help.
Thx for answer
Edit
SELECT
T1.`column1`,
MONTH( FROM_UNIXTIME( T1.`column2` ) ) AS month,
YEAR( FROM_UNIXTIME( T1.`column2` ) ) AS year,
(SELECT CONCAT(T2.`column1`,';',T2.`column2`,';',T3.`column1`) FROM `table2` T2 WHERE
T2.`column8` = T1.`column8` AND T2.`column1` LIKE '%new%') AS news,
(SELECT CONCAT(T2.`column1`,';',T2.`column2`,';',T3.`column1`) FROM `table2` T2 WHERE
T2.`column8` = T1.`column8` AND T2.`column1` LIKE '%old%') AS oldies,
FROM table1 T1
LEFT JOIN table3 T3 ON T1.column9 = T3.column2
WHERE T1.`column2` > 1388534400
It will be one-time execution so optimalization not needed
Try increasing your max_input_vars to 10000 in your php.ini and see if anything changes.
At the moment it is 1000 i guess and may you run into memory errors.